SUMMARY

• 8 years of experience managing and supporting 24x7 production and development environments as an Oracle Database Administrator
• 6 years of experience with Python
• Familiarity with Tornado, Robot test framework, Continuous Integration environment (Jenkins), SDN, network switches/routers and DevOps a plus
• Implement or leads the implementation of complex solutions with minimal technical debt. Develop solutions that are easy to deploy, maintain, and are bug free
• Experience in Oracle software installation, configuration and patch application
• Experience in upgrading Oracle software to higher versions 9i à 10g à 11g à 12cà 19c
• Excellent DB2 LUW System/Application DBA skills including HADR, DB2 LUW internals
• Experience as DB2 DBA on Linux or AIX, especially with large multi - terabyte databases with DPF.
• Good knowledge of Oracle Architecture.
• Experience in Design, Build, Configuration, Operational Support for SQL Databases.
• Expert in Developing Installation Plans according to Site Specific Work.
• Expert in Maintenance and Troubleshooting Databases to make System Operational.
• Implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions.
• Experience with database tools like OEM, TOAD, SQL*Plus, Explain Plan, AWR, STATSPACK, ADDM, SQL*Loader, Export/Import, Data Pump
• Implementation of 10g OEM Control for database monitoring and alert notification
• Excellent knowledge in Component-based Development (CBD) and Commercial Off-the-shelf (COTS).
• Apply oracle recommended patches on Exadata and Other database servers.
• Sound knowledge of PL/SQL i.e., writing packages, procedures, functions and triggers.
• Lead engineering effort, implementation, tuning and support of Oracle 10g RAC/Data guard upgrades to Oracle 12c RAC/Data guard.
• Implemented, documented and support builds of new clusters to use Oracle 12c/19c RAC on HP-UX and Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Implementation of 19c OEM Control for database monitoring and alert notification
• Apply oracle recommended patches on Exadata and Other database servers.
• Sound knowledge of PL/SQL i.e., writing packages, procedures, functions and triggers.
• Experience with Data Guard setup and configuration with RAC
• Experience with database backup, cloning and schema refresh
• Expertize in database Migration and Consolidation
• Remote database connectivity management using tnsnames, OID LDAP and Names Server
• Good understanding of UNIX Kernel parameters
• Generate and analyze Oracle STATSPACK, AWR, ADDM, ASH Reports
• Automation of day-to-day DBA tasks using SHELL scripts and CRON jobs
• Expertise in troubleshooting the problems related to databases and applications
• Good working knowledge of RMAN and Oracle Golden Gate setup
• Expert in Conducting DR activities
• Good Knowledge of working On Call Shifts.

TECHNICAL SKILLS

• Sun Solaris
• HP - UX 11.0
• LINUX
• Tru-64
• Windows
• Oracle 19c 12c 11g 10g 9i 8i TOAD
• PL/SQL Developer
• 10g OEM Console
• SQL*Plus
• Explain Plan
• TKPROF
• STATSPACK
• ADDM
• ASH
• AWR
• OLAP RMAN
• SQL*Loader
• Export/Import
• Data Pump UNIX Shell Programming
• Python
• Java

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential, Houston, TX

Responsibilities:

• Provide support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation, cluster and system management.
• Unit testing of reports by executing the manually written quires against database using TOAD.
• Well established background in database security, backup, recovery and archiving, data and system conversion and migration and third-party product installation.
• Experienced in DB2 to oracle conversion for Peoplesoft application.
• Implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions.
• Implemented, documented and support builds of new clusters to use Oracle 12c/19c RAC on HP-UX and Linux. Including installing clusterware, ASM (and shared disks) and creating new databases.
• Installation, upgradation, configuration and troubleshooting golden Gate 12c software.
• Experience in performance tuning of Oracle Golden Gate Processes to achieve zero lag times.
• Lead engineering effort, implementation, tuning and support of Oracle 10g RAC/Dataguard upgrades to Oracle 12c RAC/Dataguard.
• Implemented Oracle Golden Gate integrated with Oracle Active Data Guard set up on Production database
• Served as SME for designing, developing, and delivering high performing Microsoft SQL Server Analysis Services (2008) OLAP cubes using industry best practices.
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance.
• Extensive PL/SQL scripts writing for Batch processing using Procedures, Packages, functions, triggers
• Oracle Installation, Data Warehouse Installation CPU Patches, Cloning, Upgrading and interim patches on (10g,10g RAC,11.5.9,11.5.10,12c,19c)
• Writing Functions, Packages, Procedures, Sql statements for ad hoc reports.
• Loaded Data into Database using Sql*Loader and import export
• Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
• Database refresh from Prod to lower environments and vice versa.
• Database deployments and Dimensional data modeling
• Database upgrades and applying Patches
• Cloning and restoring databases using hot and cold backup.
• Application and SQL query tuning and Applying Oracle PSU Patches.
• Generate AWR, ADDM and ASH reports
• Cloning Database from production to development and Applying Quarterly CPU Patches.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Writing Functions, Packages, Procedures, Sql statements for ad hoc reports.
• Loading Data into Database using Sql*Loader and import export
• Dimensional data modeling
• Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
• Database deployments
• Database upgrades and applying Patches
• Cloning and restoring databases using hot and cold backup.
• Application and SQL query tuning.
• Applying Oracle PSU Patches.
• Handled client escalations and Bridge Calls related to database activities

Oracle DBA

Confidential, Houston, TX

Responsibilities:

• Worked extensively to resolve Help Desk Tickets.
• Setting up SAP databases on Unix Servers.
• Tuned sql statements, Suggested and Implemented indexes for faster retrieval of data in various procedures/packages as per business requirements.
• Troubleshoot Issues with help desk based on user requirements.
• Scheduled Cron jobs as per business requirements.
• Wrote, Modified and troubleshooting the existing stored procedures/packages based on user requirement.
• Loaded data using cron jobs and scheduling procedures/packages as per business requirements.
• Experience in 11G RAC database to setup, configuration, operations, and maintenance in a RHEL5.
• Resolving Production severity Issues in time.
• Database Refresh for Dev/QA environments.
• Involved in lower environments deployments (DEV/QA/PERF)
• Support for Production deployment.
• Understanding complicated performance issues and worked with DBA's to suggest valuable ways to fix the problem.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Developed procedures using Dynamic SQL.
• Provided on call support, solved the user and production issues.
• Adding Meta data information to the database.
• Interacting with the business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Setting up weekly cron jobs for schema refresh from one database to another and backups.
• Documented Capacity planning for 100k concurrent users.
• Developing the Code as per the requirements.
• Hands on experience in using Tomcat, Jboss servers.
• Hands on experience in using Eclipse, Jboss Developer Studio and Toad.
• Drawn flow diagrams as per business requirements.
• Migrating 10g databases to 11g
• Developing procedures and functions in 11g
• Copying Schemas to new environments as required by developers.
• Applying Patches.
• Managed the Banner software code tree
• Writing PL/SQL code (Functions, Packages, Procedures)
• Using OEM to setup jobs.

Oracle DBA

Confidential

Responsibilities:

• Writing Korn Shell Scripting setting Crontab jobs to monitor the database Setting up jobs through OEM
• Applying new schema changes
• Tuning Scripts
• Cloning and Restoring Databases using hot and cold backups.
• Writing functions, packages, procedures extensively.
• Refreshing the database.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Involved in all phases of the SDLC for Designing, development, version control for major database deployment release.
• Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.

Oracle DBA

Confidential, Atlanta, GA

Responsibilities:

• Daily Backups (hot and cold backups) of the database using Veritas
• Migration of the database to new versions.
• Applying Patches to the database.
• Writing tons of Adhoc queries
• Cloning and Restoring Databases using hot and cold backups.
• Performance tuning.
• Extensive use of OEM and PL/SQL Developer.
• Used functions, packages, procedures extensively.
• Writing complex queries using PL/SQL for the generation of the reports, created tables, triggers, indexes, synonyms, sequences, writing control files, exports, imports, RMAN
• Loading huge sets of data using SQL*loader.
• Multi-node installation.
• Installing oracle 11g, upgrades, patches.