SUMMARY

• More than 9 years of Technical experience in database administrator, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management and database security on Oracle databases on SLES 11, Red Hat Linux, IBM - AIX and Sun Solaris.
• Experienced in Installation, Migration and Administration of the Oracle database12c/11g/10g/9i and performing Pre-installation and Post-installation tasks.
• Experienced with Oracle Cluster ware, ASM and RAC.
• Database migration from Non-RAC database to RAC database.
• Data guard setup in RAC Environment. Physical Stand By database using Data Guard for Disaster Recovery.
• Expertise in Database migration to new version.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Experience on AWS Cloud computing - RDS, EC2, RedShift and S3. Experience in Oracle database installation and migration in AWS cloud.
• Experience in Oracle GoldenGate installation & configuration, and troubleshooting GoldenGate performance issues.
• Good experience in SQL skills and PL/SQL programming
• Created DB objects like Tables, Index, Constraints, Synonyms, Sequences, views, Functions, Procedures, Triggers, Stored Procedures and Packages.
• Experience in User Management and Database Security such as creating Users, Roles, Profiles and granting Roles and Privileges
• Flashback technologies-Flashback Table, Flashback Query & Flashback Database to recover from user errors and minimize the Full/Incomplete database recoveries.
• Experience in RMAN Hot/Cold Backup, RMAN Recovery and Cloning of databases.
• Proficient in using various database Utilities like EXPORT/IMPORT and Data pump for logical backup.
• Additional responsibilities- contacting Oracle for Technical Support and creating SR, handling day to day Incident Tickets, assisting developers and other users.

TECHNICAL SKILLS

Certifications: Oracle 12c OCP, Oracle 9i OCA, ITIL Foundation V.3

RDBMS: Oracle Database 12c/11g/10g/9i, MS SQL Server2012/2014

AWS: EC2, RDS, S3,RedShift,DynamoDB,ElastiCache

Operating System: SLES 10/11, Red Hat 4/5/6, Solaris 8/ 9/ 10, IBM AIX 5.2/6.1

Performance Tuning: AWR, ASH, ADDM, SQL Tuning, Explain Plan, SQL Trace, STATSPACK, TkProf

Tool: & DB Utilities: OEM, Toad, Putty, SQL*Plus, SQL Developer, Data Pump, SQL * Loader, RMAN,DBCA, Export/Import, EXPDP/IMPDP, Exadata, GoldenGate 12.2

Languages: Shell Scripting, SQL skills and PL/SQL programming

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Oracle/SQL Database Admin

Responsibilities:

• Provide core DBA support on Oracle/SQL Server platforms for all production and non-production environments.
• Install and create Oracle 12 RAC database, perform the administration tasks on Oracle RAC, Manage backup and recovery in Oracle RAC.
• Monitor and tune Oracle RAC databases, Manage dynamic database services. Implement load balancing, TAF, FAN, and application continuity.
• Apply patch sets on Oracle RAC, Upgrade Oracle RAC environment.
• Create and manage the following - Oracle RAC One Node databases, Oracle RAC CDB databases, Oracle Policy-managed RAC databases.
• Monitor and tune Oracle database environments for improved system performance, ensure integrity and recoverability of Oracle database structures.
• Set up a Goldengate unidirectional and bidirectional replication, Perform data filtering and manipulation, Implementing DDL Replication.
• Implement integrated processes, Implementing Coordinated Replicate, Monitor and troubleshoot an Oracle GoldenGate configuration.
• Implement the security options, Apply Oracle GoldenGate patches.
• Review periodic patches and new releases of Oracle software and implement the same in CMS environment.
• Prepare and update documents of database standards, user manual, procedures and processes, records, evaluations, schedule, project plans, reports, reviews, etc.
• Responsible for undertaking and leading DBA actions during DR exercises and real DR scenario.

Environment: Oracle 12C, ASM, Solaris, TOAD 9.0, MS SQL Server2012/2014, Oracle EM Grid Control, RMAN, RAC, Advanced Data Guard, GoldenGate, Linux Shell Scripting, SQL Performance Tuning, STATSPACK, TkProf, AWR Report usage, MS Office, SharePoint

Confidential, Parsippany, NJ

Senior Oracle Database Admin

Responsibilities:

• Administrating Oracle databases, Troubleshooting performance issues.
• Designed and Build Oracle RAC infrastructure for new Oracle retail foundation project.
• Designed and supported ORACLE database systems for an international retail sales organization
• Promoted Oracle RDBMS architectural initiatives that drive revenue and improve efficiency aligned with business strategy.
• Establishes ORACLE database infrastructure technology standards and governance. Create scalable and reusable database implementation patterns.
• Develop new programs and enhancements to existing programs at all levels of complexity and integration.
• Installed GoldenGate software in Test and dev instances. Configured GoldenGate on production servers
• Implemented replication sites for Oracle migration project using GoldenGate Software, to migrate
• Oracle 11.2 to Oracle 11.4 databases of 14TB size of JDE application on AIX platform with minimal downtime
• Configured new Oracle RMAN backup for all Oracle Databases using EMC DD boost
• Performed Oracle Database disaster recovery drill for 10 critical DB at SunGard off site.

Environment: Oracle 11g& 12C, ASM, AIX 7, TOAD 9.0, MS SQL Server2012/2014, Oracle EM Grid Control, RMAN, RAC, Advanced Data Guard, GoldenGate, Linux Shell Scripting, SQL Performance Tuning, STATSPACK, TkProf, AWR Report usage, MS Office, SharePoint

Confidential, Roseland, NJ

Senior Oracle DBA

Responsibilities:

• Migration of Oracle RAC 70 databases from M2 servers to HP blade servers using EXPDP/IMPDP or RMAN
• Upgrade of Oracle database version from 11.2.0.2 and 11.2.0.3 to 11.2.0.4
• Build New database with RAC in new cluster
• Plan and Build DR database for recovery purpose.
• This includes RMAN backup restoration of RAC database to Non-RAC database on new host.
• Design and document database architecture for mapping of old database to new server farm
• Storage migration from EMC to Hitachi which included the steps of shutdown of cluster and databases
• Oracle High availability testing on RAC environment. Oracle old Database decommissioning

Environment: Oracle 10g and 11g, TOAD 9.0, Oracle Grid Control, Oracle Enterprise Manager, RMAN, RAC, GoldenGate, Data Guard, Advanced Data Guard, Linux Shell Scripting, SQL Performance Tuning, AWR Report usage, MS Office, SharePoint, Zlinux, Solaris

Confidential, Novi, MI

Senior Oracle DBA

Responsibilities:

• Installing, Configuring and Upgrading Oracle 11gdatabase server software and related product in existing database
• Installation, configuration and monitoring of 2-3 RAC nodes in Oracle 11g RAC environment using Grid Software and ASM
• Configuration and Implementation of Oracle GoldenGate on New Oracle 11g databases
• Implemented Data guard, creating Physical Standby databases in 11g RAC environment for the Production databases
• Implementing automated backup strategy, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes using the UNIX shell script CRON UTILITY
• Conducting & preparing Application, DB, O/S Baselines, Security documents as per the SOX guidelines.

Confidential, Denver, Colorado

Oracle DBA

Responsibilities:

• Managed multiple 24*7 production databases as well as development and test databases
• Involved in the installation and configuration of Oracle database on Linux and Windows server
• Implemented GoldenGate 10g/11g replication for 25+ databases, 10 different applications, in three data centers across the SIT, Pre-Prod and Production environments.
• Checked errors logs of daily Autosys flow (End of day Automatic flow) and troubleshoot the issue
• Coordinated with application vendor and BPRG team for any major changes in application DB like version upgrade or implementation of utility.
• Performed task like creating Users, Roles, Tablespace, addressing alert triggered by monitoring tools.

Confidential

Team Leader/Oracle DBA

Responsibilities:

• Installed, configured, maintained and tuning of Oracle 10g on Solaris 5 & IBM-AIX 6.1
• Installed, configured and monitored RAC nodes in Oracle 10g RAC environment using Grid Software and ASM
• Resolved common oracle wait events in memory using AWR and ADDM
• Supported application admin and developer groups to define SLA’s, Incident Management and Dashboard reports
• Configured monitoring rule set to receive alerts and notification like Tablespace size reaching threshold.