Lead App Dba Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- Senior Oracle Enterprise Architect with proven track record of managing Oracle Databases and Oracle Applications supporting mission critical systems.
- I am a performance focused Oracle Applications administrator / Technical Solution Architect with proven expertise in implementing large scale projects based on Oracle Applications (E Business Suite - Multi-Currency, Multi Language), Oracle 10gAS, Single-Sign-on.
- I am well versed in different areas of infrastructure such as Hardware Platforms, Storage technologies, Cloud Computing & Network topologies to design highly scalable architectures for Oracle products.
- I have strong hands on experience writing complex Unix shell scripts in Solaris, Linux environment.
- I have expert level skills in performance tuning and troubleshooting complex issues in database management and Oracle applications.
TECHNICAL STRENGTHS:
Oracle Database 10g/11g * Oracle Applications R12 * 10gAS * Single Sign-on Oracle Internet Directory * AWS * Patch Analysis * Auto Config Cloning * Shell scripting * Database upgrades * TomCat Apache configuration * Reverse Proxy * Oracle using AWS * WebLogic * Backup and Recovery * SQL & PL/SQL * Oracle Demantra * Linux admin AWS EC2 * DMZ Setup for Oracle Apps * Oracle Data Guard * RMAN OpenVPN * Vertex (load balanced) * MWA * OBIEENOTABLE ACHIEVEMENTS:
Lead App DBA
Confidential
Responsibilities:
- Performed deep dive analysis of system architecture, provided recommendations to bring system to optimal performance and stability and implemented the strategy successfully.
- Also implemented Data Archiving process to keep system’s performance to a predictable level.
- Tuned Oracle processes and brought down I/O load by 70%.
Lead App DBA
Confidential
Responsibilities:
- The highly complex project with 25 third party integrations was executed with 7 unique inline upgrades, 5 testing cycles and a total of 14 non-production instances.
- As a part of the R12.2.4 project also upgraded Oracle Database (11.2.0.4), Discoverer (11.1.1.7), Demantra (12.2.4), Noetix (v6.4.1), iLink and GLWand (Excel4Apps)
Lead App DBA
Confidential
Responsibilities:
- Lead Apps DBA through all phases of 11i implementation.
- With thorough study of current system, compiled a list of tasks need for separation of system and executed the steps flawlessly.
- Completed the project on time, meeting the tight timeline.
- No outage after the go live
Lead App DBA
Confidential
Responsibilities:
- Lead App DBA through all phases, from sizing and installation through go-live and support, of Confidential ’s Global Confidential r12, Fusion Middleware, and OBIEE implementations.
- Participated as an App DBA and Load Tester for a proof of performance of Oracle Confidential and Fusion Middleware running on a quarter rack of Exadata and quarter rack of Exalogic.
- Performance tuned the SQL code in pl/sql packages, DW queries.
- Server tuning by having memory parameters changes. Instance tuning by having init.ora parameters changed.
- Hardware / storage upgrade to meet the expected performance.
- Tuned E-Business processes i.e. Vertex, WF background process, XML gateway to make the system stable.
- Created custom indexes on Oracle tables for performance improvements.
- Introduced changes in some standard packages to drastically improve the performance.
Confidential
Lead Oracle Apps DBAResponsibilities:
- Implemented Virtual private cloud for Confidential USA using Confidential ’s EC2 web services (AWS) architecture with a no upfront cost and pay as you go model.
- Configured automated backups using EC2 snapshots.
- Developed scripts to provision ec2 instances and clone an Confidential instance.
- Setup up network security using firewall and site to site VPN.
- Attained 99.95% uptime, availability for Confidential ’s Oracle ERP and CRM systems.
- Instrumented and Implemented strategic plan to include systems management processes, monitoring and 24*7*365 operations support.
- Migrated all the development, test environments for Oracle E-Business suite to the Confidential ’s cloud computing platform.
- This led to direct cost savings of over $1 Million.
- Set up “Follow the Sun” support for business critical application by setting up DBA, Application admin remote teams in India.
- Worked with SOX team and IT leads to define policy and procedure for SOX controls.
- Developed a migration tool in a short period of time, that fully complies with the controls defined in SOX policies.
- Implemented Single Sign-on for Oracle E-Business Suite 11i by setting up policies and procedures for new login process and user account management and working with Active Directory administrator to make sure that AD and OID are in sync.
- Configured nodes in DMZ area along with Apache reverse proxy configuration and SSL to provide a secure way to allow external users to use E-Business applications.
- Worked with SOX team and IT leads to define policy and procedure for SOX controls.
- Developed a migration tool in a short period of time that fully complies with the controls defined in SOX policies.
- Developed UNIX shell script based tool for daily refresh of the E-Business Suite stack with complex built-in workflow.
Confidential
Lead Oracle Apps DBA
Responsibilities:
- Providing Apps DBA support with managing stability and performance of R12.0.6 instance having 10+ TB database.
- Working closely with hosting provider DBA team to resolve day to day support issues.
- Implemented Informatica Data Archive and archived 50% of data to improve performance and system stability.
- Implemented IBM’s OPTIM solution for sun setting Oracle 11i instance.
- Performance tuned data pull from Oracle database to AWS’s Hadoop file system.
- Provided Oracle Configurator performance improvements through browser configuration and switching Oracle users to Firefox.
- Providing technical advice to Confidential management.
- Extensive performance tuning exercise to fine tune the SQL code, programs logic and setting up SQL execution plans.
- Configured optimal performance for concurrent managers and concurrent requests.
- Administration of R12 (12.0.6) with multi-tier architecture with multiple languages.
- Supporting modules i.e MRP, OE, iSupplier, GL, AP, AR, WMS, OM, ConnectShip, EDI, Inventory, Workflow administration,
- Responsible for designing the technical architecture, conducting reviews and meetings with management, developers and team leads.
- Helping developers with performance tuning and troubleshooting technical issues.
- Developed alerts and scripts for proactive monitoring.
Confidential
Lead Oracle Apps DBA
Responsibilities:
- Successfully upgraded Confidential from 11.5.10.2 to R12.2.4 on a new hardware (Sun T5-4, T5-2s, T5-1Bs).
- As a part of the R12.2.4 project also upgraded Oracle Database (11.2.0.4), Discoverer (11.1.1.7), Demantra (12.2.4), Noetix (v6.4.1), iLink and GLWand (Excel4Apps).
- Designed and implemented separation 11.5.10 instance of Confidential ERP system from Confidential ’s corporate ERP system.
- Provided Apps DBA support for separation of Confidential ERP system.
- Managing Oracle Discoverer, Oracle Demantra, Vertex and Confidential system.
- Extensive performance tuning exercise to fine tune the SQL code.
- Designing database and application patch strategy involving different DEV / TEST & PATCH instances
- Writing shell scripts / sql scripts to automate DBA maintenance and monitoring jobs
- Helping developers with performance tuning and troubleshooting technical issues.
- Developed alerts and scripts for proactive monitoring.
- Applying Confidential patches and quarterly security patches from Oracle.
Confidential
EC2 architect / Oracle DBA
Responsibilities:
- Designed and implemented Virtual private cloud for Confidential using Confidential ’s EC2 web services (AWS) architecture.
- Provided Linux admin/Apps DBA support to Oracle R12 implementation project.
- Setup site to site VPN between AWS cloud and Confidential .
- Setup standby database in AWS Cloud.
- Setup non-prod cloning of Oracle ERP databases from Standby using snapshot technology of AWS.
- Developed scripts to automate the Oracle instance clones using AWS APIs.
- Setup backups in AWS cloud using periodic snapshots.
- Setup monitoring scripts for instances in Confidential cloud.
Confidential
Lead Oracle Apps DBA
Responsibilities:
- Providing Apps DBA support to Oracle R12 implementation project.
- Implemented RAC specific solutions for R12.
- Implemented security fixes in 10g database, R12 application nodes.
- Providing technical advice to Confidential management.
- Designing Confidential ’s databases and systems architecture hosted at AT&T.
- Managing SOA Suite supporting Confidential ’s business processes.
- Extensive performance tuning exercise to fine tune the SQL code.
- Designing database and application patch strategy involving different DEV / TEST & PATCH instances.
- Administration of R12 (12.0.6) with multi-tier architecture with multiple languages.
- Supporting modules i.e MRP, OE, iSupplier, GL, AP, AR, WMS, OM, ConnectShip, EDI, Inventory, Workflow administration,
- Responsible for the configuration and tuning of Vertex O-Series with Oracle R12.
- Responsible for designing the technical architecture, conducting reviews and meetings with management, developers and team leads.
- Writing shell scripts / sql scripts to automate DBA maintenance and monitoring jobs.
- Helping developers with performance tuning and troubleshooting technical issues.
- Developed alerts and scripts for proactive monitoring.
- Participated in POV of Exadata / Exalogic.
- Implemented reverse proxy apache with SSL and user certificate for mobile app project.
- Setup Oracle MWA with dispatcher load balanced to support 100s of telnet clients seamlessly.
- Applying Confidential patches and quarterly security patches from Oracle.
- Involved in migrating Confidential ’s databases/applications from one datacenter to another.
- Supported Confidential views and Confidential search installation and configuration.
Confidential
AWS Architect
Responsibilities:
- Implemented Virtual private cloud for Confidential using Confidential ’s EC2 web services (AWS) architecture.
- Setup standby database in AWS Cloud.
- Setup scripts to automatically spin up servers to support monthly reporting instances and automatically cloned from production server.
- Setup non-prod cloning of Oracle ERP databases from Standby using snapshot technology of AWS.
- Developed scripts to automate the Oracle instance clones using AWS APIs.
- Setup backups in AWS cloud using periodic snapshots.
Confidential
Manager, Database
Responsibilities:
- Implemented cloud computing strategy for dev / test systems using Confidential ’s cloud computing services (EC2). Participated in Confidential ’s beta programs for cloud computing and provided them feedback and advice towards solutions for enterprise level computing.
- Supported implementation of Oracle CRM module, DMZ setup for world wide users.
- Designed Confidential ’s databases’ and systems architecture for hosting with Datapipe. Aggressively negotiated the pricing to keep the numbers under budget.
- Efficiently handled dealings with vendors for softwares, hardware, IT consultants etc.
- Managed temporary consultants and a team of 4 DBAs. (Two in US and two in India).
- Developed and automated daily refresh/cloning scripts for E-Business Suite.
- Administration of ERP Application in Oracle Apps 11i. (11.5.10) with two tier architecture having one database server, two internal application servers and two external application servers.
- Maintained ERP application modules i.e GL, AP, AR, Manufacturing, OM, Advance Planning, Demantra, ADI, EDI, Logical Apps, Inventory, CRM.
- Performed upgrade to Oracle E-Business R12 (12.0.6) along with enabling multi language feature.
- Migrated from Solaris to Oracle Unbreakable Linux, version 5.
- Administration of Oracle Databases with 7/24 support.
- Responsible for designing the technical architecture, conducting reviews and meetings with management, developers and team leads.
- Ensuring recoverability by setting up backup and recovery procedures using RMAN and home grown backup tools.
- Writing shell scripts / sql scripts to automate DBA monitoring jobs.
- Setup and managed Oracle data guard / Standby databases all of oracle databases.
- Developed Backup monitoring tools, so that DBAs are notified if backup to tape is missed or failed.
- Re-organizing growing database objects and performing pro-active monitoring.