SUMMARY:

• Oracle & MongoDB certified database professional with 10 years of Oracle DBA,5 years of MySQL DBA and 2 year of MongoDB DBA experience in production and development environments.
• Managed multiple multi terabytes (45 TB) databases. Expertise in Oracle 9i - 12cR1 RAC,ASM,CLUSTERWARE (GRID),DATA GUARD,GOLDEN GATE, STREAMS,RMAN and PERFORMANCE TUNING.
• Excellent understanding of Oracle database architecture and database internals.
• Oracle Clusterware (GRID), Oracle RAC and Oracle ASM installation, configuration and administration in UNIX and Linux environments.
• Excellent understand of Oracle RAC database internals and working.
• Performance tuning of Oracle memory components, physical/logical database components, database objects and PLSQL/SQL statements.
• Online and Offline RMAN and user Managed backup, restore and recovery.
• Oracle Golden Gate installation, configuration and management.
• Oracle Streams Configuration, troubleshooting and management.
• Zero downtime database upgrade (9i/10g -11g/12c) and application of Oracle patches.
• Database conversion from single instance to RAC using different tool & methods like RCONFIG & DBCA.
• Creation and monitoring of standby database for data protection/high availability (DATA GUARD).
• Oracle Grid Control 11g/12c (OEM) Installation, configuration and administration.
• MySQL installation,configuration and administration.
• MySQL replication setup (Uni & Bi directional).
• MySQL backup,recovery and performance tuning.
• MongoDB installation, configuration and administration.
• MongoDB replica set & shard setup.
• Rolling upgrade of Mongodb clusters.
• MongoDB backup,recovery & performance tuning (configuration parameters).
• Data Modeling and capacity planning.
• Shell/python scripting.

TECHNICAL SKILLS:

Hardware: IBM P7, P5-50, Sunv480, Sun Sparc, RHEL 5 Server, Pentium 4

Operating System: AIX, Sun Solaris, Red Hat Linux, Oracle Linux, Windows

Tools: Erwin Data Model, Oracle Enterprise Manager, Toad, PLSQL Developer, Control M, Enterprise Manager Grid Control 12c, Veritas Netbackup and Tivoli Storage manager.

PROFESSIONAL EXPERIENCE:

Confidential, New York

SR. DBA

Responsibilities:

• Oracle 12c/11g/10g GRID,ASM and RAC database Installation,configuration and management.
• Oracle Grid Control 11g/12c (OEM) Installation,configuration and management.
• Designing High availability architecture using RAC,RMAN,GOLDEN GATE and DATA GUARD.
• Disaster Recovery (DR) site setup though Data Guard.
• DataGuard broker Switchover & Failover configuration.
• Golden Gate installation, configuration and management. One way & Bi directional replication setup.
• Converting single instance database to RAC (2/3/4) node database.
• Designing and tuning logical/physical structures and database objects.
• Oracle Memory/physical/logical components & Sql tuning.
• Datacenter migration.
• Zero down database upgrade from 10g to 11g/12c (Golden Gate).
• Database Character set migration to UTF8 to support multiple countries.
• Writing RMAN database & archivelog backup scripts and configuring RMAN backup to TAPE (TSM) and disk, restore and recovery.
• Implementation of partitioning strategy and managing partitioned tables and indexes.
• Database security - setup complex user password policy, written complex database VERIFY FUNCTION. Auditing user’s privileges.
• Created capacity planning and sizing documents for Oracle/MySQL/MongoDB databases.
• Analysis of Oracle AWR/ADDM/ASH reports for proactive monitoring and potential issue resolutions.
• Working with development team in tuning database objects,SQL and PL/SQL statements.
• Analyzing query plans and tune queries with Sql plan management (SPM),TKPROF, Oracle trace (like 10053), Explain Plan, Optimizer hints, indexes and query rewrite.
• MySQL Installation,configuration and management.
• MySQL replication setup & performance tuning.
• MySQL backup,recovery & performance tuning.
• MySQL upgrade.
• MongoDB Installation,configuration and management.
• MongoDB replica set & shard setup.
• MongoDB backup,recovery & performance tuning.
• Rolling upgrade of MongoDB clusters.
• Wrote shell/python scripts.
• Working with Oracle/MySQL/MongoDB Support Services to resolve issues.

Confidential, Belmont, MA

SR. DBA

Responsibilities:

• Oracle 11g/10g CLUSTERWARE (GRID), ASM, RAC database installation, configuration and management.
• Oracle Grid Control 11g (OEM) Installation.
• Designing and tuning logical/physical structures and database objects.
• Oracle Memory components tuning.
• Physical standby (DATA GUARD) database setup and monitoring.
• DG broker Switchover & Failover configuration.
• Golden Gate installation, configuration and management.
• Oracle load balancing through database Services configuration.
• Database upgrade from 10g to 11g.
• Database conversion from single instance to RAC (2/3/4/5) node database.
• Database security - setup complex user password policy, written complex database VERIFY FUNCTION. Auditing user’s actions/privileges.
• Review capacity planning and sizing documents and provide recommendations for capacity planning and tending reviews of all oracle databases.
• Analyzing query plans and tune queries with Sql plan management (SPM),TKPROF, Oracle trace (like 10053), Explain Plan, Optimizer hints, indexes and query rewrite.
• QA & Development database refresh from Production database.
• Analysis of AWR/ADDM/ASH reports for proactive monitoring and potential issue resolutions.
• Implemented Backup and Recovery on large systems with different backup strategy using Recover Manager (RMAN) and recover Catalog
• Database objects re-organization.
• Working with Oracle Support Services to resolve issues.
• Application of Oracle patches like Patchset, PSU.
• User Creations and assigning privileges.
• Export Datapump,Import Datapump and SQL loader utilities.
• MySQL Installation,configuration and management.
• MySQL Uni/BI directional replication setup
• MySQL backup,recovery & performance tuning.
• MySQL upgrade.
• Wrote custom database objects statistics collection script.
• Wrote shell/python scripts that proactively monitored database and server space usage, alert log for Oracle errors, database activity and server load.

Confidential, Edison, NJ

Sr. Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 11g/10g.
• Oracle CLUSTERWARE (GRID) installation, configuration and administration.
• Oracle RAC database installation, configuration and administration.
• Oracle ASM installation, configuration and administration.
• Oracle STREAMS configuration and administration.
• Administration of several RAC databases. Database size ranging from 22 TB to 800 GB.
• Oracle Grid Control (OEM) Installation.
• Working closely with Business Analyst to understand the requirements.
• Designing and developing Logical and Physical Data Model.
• Managing Production, Performance Testing and POC databases.
• Utilized Oracle Flashback technology with Oracle Stream. Achieved Apply rate of 12000+ LCRs per/sec in a heavy workload environment. Best in Industry.
• Database migration and upgrade.
• Developing Database sizing sheets.
• Tuning logical and Physical structures of the Database.
• Tuning Oracle SGA, PGA and database objects.
• Analysis of AWR/ASH/ADDM and Statspack reports for proactive monitoring and potential issue resolutions.
• Working closely with Application developer in identifying requirements, evaluating feasible solutions and providing optimize solutions.
• Analysis of the test running in Performance Testing (PT) environment to identity potential bottle neck and provide solutions.
• Analyzing query plans and Query Tuning with TKPROF, Oracle trace (like 10053), Explain Plan, Optimizer hints, indexing, Inline views, materialized views and bulk techniques.
• Performance tuning of Batch jobs, packages, stored procedures, functions and PL/SQL scripts.
• Implementation of partitioning strategy and managing partitioned tables and indexes.
• Application of Oracle one-off, merge, CPU,PSU patches
• RMAN online and offline backups, restoration & recovery.
• User managed backups (hot & cold backups), restoration & Recovery.
• Creation and monitoring of STANDBY database for high availability (DATA GUARD).
• Database Cloning.
• Export Datapump and Import Datapump utilities.
• Loading data from flat file in database through SQL loader.
• Wrote PL/SQL objects like Package, Procedures, and Functions.
• MySQL Installation,configuration and management.
• MySQL backup,recovery & performance tuning.
• Wrote Scripts to automate monitoring process and scheduling them.
• Wrote numerous shell Scripts.
• Worked with Oracle/MySQL Support Services to resolve issues.

Confidential

Oracle DBA

Responsibilities:

• Oracle 10g/9i installation, configuration and administration.
• Oracle ASM installation, configuration and administration.
• Managed production, QA, UAT and DEV databases.
• Database Sizing.
• Performance tuning of logical and Physical structures of the Database.
• Oracle Memory structures Tuning.
• Providing feasible and optimal solution to Application developer.
• Analyzing query plans and Query Tuning with TKPROF, Explain Plan, Optimizer Hints, Indexing, Inline views, materialized views and Bulk techniques.
• Performance tuning of packages, stored procedures, functions and PL/SQL scripts.
• Partitioning Tables and Indexes for performance and manageability.
• Analysis of AWR and Statspack reports for potential bottleneck and resolving them.
• Table re-organization and Index rebuild.
• Database upgrade and application of Oracle Patches.
• Migration of Oracle 9i databases to Oracle 10G.
• Database RMAN (online & offline) backups, restoration & recovery.
• Database backups (hot & cold backups), restoration & Recovery.
• Refreshing Test databases with latest production backups.
• Conventional Export/Import and Export Datapump and Import Datapump utilities.
• Wrote PL/SQL objects like Package, Procedures, and Functions.
• Wrote Scripts to automate monitoring process and scheduling them.
• Wrote several shell Scripts.
• Using SQL loader to load data from flat file into Database.