SUMMARY:

• Leverage 15+ years of IT experience which include nearly 5 plus years as Lead DBA (Database Admin Team & Infrastructure Team) and spanning IT infrastructure, Database/System 24 X 7 production database Support, Service management, Database Security/Compliance, Enterprise Data Center consolidation, Azure/Oracle Cloud migrations and disaster recovery.
• Experienced in Installation, configuration & Administration oracle databases since Oracle 7.3 to oracle 12c, Oracle 18c (Autonomous database), & Golden Gate 12.3, OEM (12c & 13c)
• Experience in Oracle Enterprise Management (OEM 12c & 13c) implementation for enterprise monitoring. Excellent experience in Performance tuning and troubleshooting using, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, SQT, SQLHC and OEM Cloud monitoring (12c & 13g)
• Implementation experience of Logical and Physical backups on critical DW & OLTP databases using RMAN which integrated with various software’s like NetBackup, Commvault etc.,
• Implemented and maintained HA (Data Guard) and Geo - graphic failover on HP Service Guard clusters environment.
• RAC/RAC One Node: Installations, adding/deleting nodes, Upgrade, create/delete databases, Administration, troubleshooting and Patching.
• ASM: Administration, maintenance, troubleshooting, Storage Migrations.
• Strong exposure to multiple DR exercise (Disaster Recovery) tests and scenarios and Lead Critical Response Team during Sev 1 issues.
• Strong knowledge in process-oriented environments like Banking sectors, Pharmaceutical, Health care, GxP, IAPP, SOX, ITIL / ITSM environments.
• Goldengate: Installation, Setup & Configurations, Administration, troubleshooting, Patching and migrations.
• Very strong knowledge in database upgrades, Migrations using data pump, RMAN duplicate & Golden Gate technology with less down time.
• Experienced on Shell scripting for automation of DB start-up & shutdown, Database Refreshes (Weekly/monthly) & Stats Gather jobs for DW databases, Tablespace Monitoring etc.,
• Successfully lead database (L1, L2, L3) operations teams for larger engagements (5000 Plus databases support).
• IT Infrastructure Management
• Datacenter Consolidation and Migration
• Data Security, Backup, and Recovery
• Standard Operating Procedure Creation
• Database System Cloning and Patching
• Data Guard Build and Support
• Application Upgrade and Maintenance
• Software Installation and Configuration
• Server Development and Troubleshooting
• Performance Evaluation
• Strategic Planning and Implementation
• Golden Gate Implementation

TECHNICAL SKILLS:

TechnicalL: Oracle12c/11g& Oracle 18c | Oracle/RHEL Linux 7.1 | HP - UX 11/10.0 | AIX | RMAN| Oracle E-Business Suite | OEM12g/13c | Oracle/AWS/AZURE Cloud | MySQL | HP-UNIX | Windows

PROFESSIONAL EXPERIENCE:

Confidential, Camden, NJ

Database Support Service Lead

Responsibilities:

• Lead the DBA and Enterprise Monitoring teams in managing database projects and programs, including delivery of operations support in North America; Europe, the Middle East and Africa (EMEA); and Asia-Pacific regions
• Formulated recommendations about optimal storage configurations for databases to Cloud Infrastructure Operations Team to get better performance throughput.
• Owned and developed a detailed database creation process and related documentation to improve the quality of new Oracle system deployments
• Applying quarterly CPU patches on all the supported databases
• Leading the effort to build QA and Production HA solutions (Physical Standby - Oracle Data Guard) and DR solution on Azure.
• Drive all efforts of the team in upgrading all < 12c databases using various methods such as Data pump, RMAN, TTS (Less down time)
• Identified and reduced/eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits to improve the Datawarehouse ETL Batch performance.
• Automating cronjobs with required Shell scripts to do Automatic jobs like Hot Backups, Cold Backups, EXP/IMP, tablespace monitoring & long running queries etc.,
• Analyzing customers’ technical needs/escalations and suggesting solutions, troubleshooting and provide possible workarounds for any kind of database problems.
• Cloning, Diagnosis, analyzing and recovering from the database from corruption problems, Installation of Oracle 12c/18c with backup and recovery setup, performing database upgrades, DB Performance troubleshooting, Disaster Recovery works using Data Guard
• Understanding environments architecture, providing support and participation in architectural review meetings, providing suggestions.
• Working on to migrate Oracle Gen1 DW databases to Gen2 Autonomous DW database on 18c on Oracle Cloud.
• Successfully migrated DW databases from on-premises to Azure cloud (20 TB, 12TB & 1 TB) using Golden Gate with less than 6 hours of down time during cutover/Go-live
• Made significant contribution to a team in completing successful migration of IBM data center to Wipro DCs
• Implemented enterprise monitoring solutions using UIM & xMatters interface which included software as a service (SaaS) solution
• Pioneered the execution of enterprise-wide set of database standards, which delivered vital consistency
• Optimized SQL queries and stored procedure, which resulted in increasing application effectiveness without elevating memory requirement & Improved overall DW Batch completion.
• Demonstrated proficiency in providing crisis management on production incidents across mission critical external and internal clients facing systems.
• Migrated DW databases from On-premises to on premises Exadata and Cloud DBaas service Exadata servers. Maintained and supporting those multitenant databases as container DBA on ASM storage.

Confidential, Boston, MA

Senior Database Consultant

Responsibilities:

• Took charge of migrating and upgrading 2 node RAC databases from Oracle Database 11g R1 to the latest Oracle Database 11g R2, as well as Oracle Cluster ware and Grid Infrastructure to Oracle Database 11g R2
• Led the implementation of Oracle Grid Infrastructures 12c and migration of Oracle Enterprise Manager (OEM) metadata repository to Oracle Database 12c
• Performed the installation of critical patch on newly created binaries
• Pioneered the development of new recovery catalog, additional instance of reporting database on new VMware, and logical standby for reporting purpose
• Made use of Oracle Recovery Manager (RMAN) to arrange the schedule of backups

Confidential, Raritan, NJ

Lead DBA, Database Managed Services

Responsibilities:

• Administered IT projects and technical activities across multiple operating company databases to assist the large update and new implementation projects
• Supervised high-performing technical team of onsite operations database administrators and application database administrator, as well as offshore DBA team, including Critical Response Team (CRT)
• Initiated the creation of the key process to ensure reliability and efficiency of organization-wide technical services
• Efficiently interfaced with client director regarding performance reports of the System and Operations Team
• Presided over the offshore and onsite status meetings, including participation in quarterly business review meetings with customer management
• Spearheaded the evaluation and audit of key performance indicators (KPIs) and service level agreements (SLAs)
• Worked with client executive management in creating and executing repeatable communications and escalation message process
• Displayed competencies in providing expert technical consultations and support to operations team on critical issues of DBAs and application
• Guided a team on new G2 platform architecture to provide high availability database environment with lower cost
• Health Insurance portability and Accountability Act (HIPAA)- compliant database security structure in auditing and resolving all issues within couple of months due to audit findings.
• Accomplished the coordination of smooth knowledge transfer of database support (L1/L2/L3) from existing vendor to Cognizant at onsite location in USA (3000 oracle Databases & 1000 SQL instances)
• Oversaw continuous improvement initiatives on existing infrastructure, databases, systems, and software support that led to optimal operations and functions
• Carried out various critical application support and upgrades with minimum disruption of services. Successfully transitioned all level support from HCL to Cognizant
• Spearheaded the development and support of all information technology services (ITS) and operating company databases across the globe
• Implemented factory model database build process on G2 platform which reduced the database delivery turnaround time to less than day from 10 days.

Confidential, Raritan, NJ

Database Administrator, Global Services Team

Responsibilities:

• Offered administrative supports to SDLC migration of BRAVO application, such as Oracle ERP R12 upgrade
• Rendered L3 support to more than 100 databases, including over 35 business-critical global applications, as well as SOX and GxP compliance databases
• Maintained active involvement in various annual DR exercises to analyze backup strategies at DR site
• Demonstrated proficiency in identifying and resolving various performance problems on database and input/output hardware
• Provided oversight to 5 other customer projects and more than 10 RFS activities
• Determined consolidation candidates in accordance with analysis of various inventory data, server performance matrix, and hardware details
• Succeeded in completing and implementing consolidation method through collaboration with various ITS supported group
• Generated checklist for Oracle version upgrades and security patch application
• Managed the installation of Oracle 11g with various modes, as well as the configuration of data guard.

Confidential

Oracle DBA Lead

Responsibilities:

• Supporting RAC ASM (3 nodes) on Oracle 10g in Linux environment
• Troubleshooting various issues in RAC/ASM environment.
• Handling Oracle/SQL Server, Postgress databases in Linux/AIX/Windows environment
• Setting up managing Oracle data Guard for 9i and 10g production databases.
• Tuning the performance of the databases and troubleshooting the issues
• Taking Oracle DataPump, traditional Export/Import and RMAN backups