PROFESSIONAL SUMMARY:

• Database Administrator wif Oracle Certified Professional, Oracle Cloud Certified Expert, Microsoft Azure experience in a wide range ofmission critical technologies, specializing in database administration best practices for backup, recovery and migration, patching, HA solutions.
• I have hands - on experience wif real-world Production environments, System Design, Data Migration, Performance Tuning, Data Replication, Data warehouse & Reporting and Database Modeling & Development. DBA Skills include:
• Senior Oracle Database Administration
• Database Administrator ORACLE
• Database Automation Engineer
• Database Lead
• Terraform and Pipelines
• Oracle RAC & ASM Administration/Installation
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Data Guard Administration.
• Oracle Gloden Gate Administration

TECHNICAL SKILLS:

Databases: - Oracle RDBMS 8,9i,10g,11g,12c,18c,19c, Mongo DB databases.

Cloud: - Microsoft Azure,Oracle Cloud

Operating Systems: - RHEL 4.x/5.x/6.x/7.x, Sun SPARC Solaris 2.x, CentOS, SUSE, Linux Red Hat

Advanced server, HP: UNIX, IBM AIX Unix Windows 2000 advanced server Windows XP, Windows 2003 and Windows 2008

Languages: - SQL, PL/SQL, C, C++, Perl, shell script, python 3

Replication: -Gloden Gate, Data Guard (Physical, Snapshot Standby), Hot standby streaming

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Support all production and non production database,
• Provide roadmap and migration methodology for cloud migration for databases.
• Managing 100+ Oracle 11g, 12c, 18c,19c DBs ODA & providing on-call support.
• Install 11g/12c/18c/19c binaries and apply the latest patches.
• Migrating Non-RAC and RAC databases 11g and 12c to New DC and set up DR site (LDR/RDR).
• Install and configure Oracle Glodengate on new DC.
• Applying patches to the Glodengate software, upgrade GlodenGate from classic to integrated.
• Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Log dump / discard file analysis etc...
• Install 19c Grid Infrastructure.
• Upgrade the DBs from v 11204/ c wif physical standby & GlodenGate.
• Design and Implement Oracle Disaster Recovery Solutions wif 11g/12c Data Guard, Active Data Guard using DG Broker and Real-Time apply.
• Install 13c EM Grid control, Install EM agents& Enable monitoring.
• Hands on in OEM Grid Control, Explain Plan, Tkprof, AWR, ADDM, ASH and SQL Tuning Advisor (sqltrpt) utilities to find and tune the top wait events, top sql’s by elapsed time, CPU and IO Creating index, Sql profile and SPM to improve the query performance.
• Development / testing environment baseline backup and restore, develop and maintain administration scripts by using Perl/Korn shell.
• Implemented Database Hardening as per industry standard to have secure environment
• Find the bottlenecks, analyze the root cause, and optimize databases on Exadata machine.
• Worked on Databases upgrade POCs from 11gR2, 12cR2 to 18c and 19c DBs in Data guard & RAC.
• Tested all DigiCert’s existing environment scripts on 18c and 19c environment before upgrade.
• Enhanced new features of Oracle 18c, and 19c including Clear flashback logs periodically & Automatically .
• Working wif Development and Engineering team to troubleshoot day to day database related issues.

Senior Oracle Database Administrato, Azure Cloud

Confidential

Responsibilities:

• Finone Application migration from legacy system.
• Installation and configuration of Oracle RAC on 12cR2 wif v11204, v12102 RDBMS.
• Upgrade 12R1 Grid Infrastructure to v12201 Grid Infrastructure.
• Upgrade v 204, v12102 databases.
• Configure Oracle connection manager (OCM 121204) on Oracle 12.2.0.1 client release.
• Installation, configuration of Oracle 12.2.0.1 (Non-CDB/CDB) databases.
• Gloden Gate deployment, monitoring, troubleshooting.
• Manage the database performance issues through SQL tuning using AWR, ASH, ADDM.
• Enhanced the monitoring process writing advance shell scripts.
• Working wif Development and Engineering team to troubleshoot day to day database related issues.

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Installation, configuration and maintenance: Oracle 10g,11g,12c databases software & related products, Data Guard, Active Data Guard, ADG wif observers and RAC, Data Domain libraries for v10205, v11203, v11204, v12101, v12201, Recovery catalog for 10g,11g,12c, RMAN.
• Managed RAC cluster: Monitor RAC Services, Grid infrastructure services.
• Support Database and migration in SAP databases.
• Configure RMAN backup for RAC databases and registered in recovery catalog schema.
• Clone the RAC database wif single instance database using RMAN.
• Oracle patching: Apply Quarterly PSU patches, one-off patch, Oracle JVM, Oracle JDBC, merge patches on v10.x.x.x, v11.x.x.x, v12.x.x.x Oracle Homes. Apply patch on OID, Audit vault, OEM Oracle home servers. Apply patch using flip method. Apply Oracle quarterly PSU patches through OEM.
• Prepare plan and co-ordinate wif Business partner, team members during quarterly PSU patching.
• Performance Tuning: Database, SQL tuning using AWR, ASH, ADDM,SQL Access Advisor, SQL performance Analyzer, STATSPACK, TKPROF, OEM.
• Tracing, troubleshooting wif database performance and tuning issues.
• Experience on Database Tuning and SQL Tuning & interpret AWR & ADDM.
• Experience on Oracle Performance monitoring and tuning tools/packs.
• Implement Oracle 12c: Installation, configuration, maintenance, Container, pluggable databases, Data guard wif far sync instance, cloning, upgrade, patching, Table level recovery, Backup/recovery policy, In-memory.
• Upgradation, migration Oracle 10g, 11g and 12c Oracle databases.
• Oracle database cloning for 10g, 11g, 12c databases on oracle RAC, Data Guard.
• Backup migration from disk to Data Domain boost for standalone, Data Guard and RAC env.
• Converting Oracle Data guard databases to Active data guard.
• Write, modify shell script to automate process.
• Prepare and execute plan for upgrade, migrate Oracle 10g, 11g, 12c databases.

Senior Oracle Database Administrator

Confidential

Responsibilities:

• Environment: Oracle11g/10g, RMAN,Linux and Win 2000 server, TOAD, and Tivoli, RAC, Data Guard, crontab, BMC Remedy.
• Installation, configuration and maintenance: Oracle 10g,11g databases software & related products, Data Guard, Active Data Guard, RAC, v10.x.x.x, v11.x.x.x, Recovery catalog for 10g,11g, RMAN.
• RAC cluster maintenance: Monitor ASM disk group, ASM & RAC instances, OCR & Voting Disk files.
• Configure RMAN for the backup of RAC database using a catalog repository database.
• Clone the RAC database to single instance database using RMAN.
• Oracle patching: Apply Quarterly PSU patches, one-off patch, merge patches on v10.x.x.x, v11.x.x.x Oracle Homes.
• Performance Tuning: Database, SQL tuning using AWR, ASH, ADDM, STATSPACK, TKPROF, OEM.
• Tracing, troubleshooting wif database performance and tuning issues.
• Experience on Oracle Performance monitoring and tuning tools/packs.
• Upgrading, migrating Oracle 10g,11g Oracle databases.
• Oracle database cloning for 10g,11g databases on oracle RAC, Data Guard.
• Backup migration from disk to Data Domain boost for standalone, Data Guard and RAC ENV.
• Write, modify shell script to automate process.
• Prepare and execute plan for upgrade, migrate Oracle 10g,11g databases.

Senior Oracle DBA

Confidential

Responsibilities:

• Environment: Oracle11g/10g/9i/8i, RMAN, Linux server, TOAD, Data Guard, crontab.
• Installation, configuration and maintenance: Oracle 8i,9i,10g,11g databases software & related products, Data Guard, Active Data Guard, RAC, v8.x.x.x, v9.x.x.x, v10.x.x.x, Recovery catalog for 10g,11g, RMAN. SQL server -2002, 2005.
• Performance Tuning: Database, SQL tuning using AWR, ASH, ADDM, STATSPACK, TKprof, OEM.
• Tracing, troubleshooting wif database performance and tuning issues.
• Experience on Oracle Performance monitoring and tuning tools/packs.
• Installation, configuration and creation of instances in Linux and Windows Environments Of oracle 9i,10g & Oracle 11g database.
• Managing over all day to day Administration Oracle 10g,11g RAC database.
• Configuring and Installing Oracle Internet Directory.
• Configuring OEM for Standalone / OMS.
• Monitoring & performing backup, restoration of Oracle 24X7 Database by RMAN.
• Tuning from offshore client's SQL, Procedure, I/O etc.
• To check & validate database file as well as segment using DBVERIFY utility.
• Cloning Oracle 9i database to make test database server.
• Upgrading Oracle 9.x.x.x. database to Oracle 10.x.x.x. using DBUA utility.
• Restoring databases wif RMAN for refresh purposes,
• Recover and Restore the database through RMAN standards
• Using RMAN Scripts to schedule the hot/cold backups.
• Tablespace and datafiles additions in databases
• Data Guard Switching over roles, rebuilding physical standby
• Patching, upgrading the database
• Tracing, troubleshooting wif database performance and tuning issues.
• Tuning SQL queries

Oracle Database Ad ministrator

Confidential

Responsibilities:

• Environment: Oracle 10g/9i/8i, RMAN, Linux Windows server, TOAD, crontab
• Installation, configuration and maintenance: Oracle 8i, 9i, 10g databases software & related products, Data Guard, v8x.x.x, v9.x.x.x, v10.x.x.x, Recovery catalog for 10g, RMAN.
• Performance Tuning: Database, SQL tuning using AWR, ASH, ADDM, stats pack, TKPROF, OEM.
• Tracing, troubleshooting wif database performance and tuning issues.
• Experience on Oracle Performance monitoring and tuning tools/packs.
• Perform database administration and maintenance for Oracle products.
• Process change controls and install database upgrades and patches.
• Assist in design and development of Oracle databases.
• Develop schemas, tables, triggers, indexes, sequences, constraints, functions and procedures.
• Develop shell scripts and data management scripts.
• Determine capacity analysis and perform database tuning to improve efficiency.
• Take regular backup and restore corrupted databases.
• Handle data clustering, mirroring, replication and failover promptly.
• Analyze and troubleshoot technical issues in a timely fashion.
• Enforce best practices for optimal performance.
• Communicate technical teams about recent changes made in databases.
• Address customer queries and build positive working relationships wif customers and co-workers.
• Write complex codes and queries and participate in code reviews
• Understand project requirements and develop design specifications.
• Basic administration of oracle database administration.
• Handling database management and change requests in the form of export and import.
• Using RMAN Scripts to schedule the hot/cold backups.
• Tablespace and datafiles additions in databases
• Data Guard Switching over roles, rebuilding physical standby
• Providing connectivity and troubleshooting of connectivity problems.
• Export/Import of oracle databases.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.

Oracle Database Administrator

Confidential

Responsibilities:

• Installation, configuration and maintenance: Oracle 8i, 9i, 10g databases software & related products, Data Guard, v8x.x.x, v9.x.x.x, v10.x.x.x, Recovery catalog for 10g, RMAN.
• Performance Tuning: Database, SQL tuning using AWR, ASH, ADDM, stats pack, TKPROF, OEM.
• Tracing, troubleshooting wif database performance and tuning issues.
• Experience on Oracle Performance monitoring and tuning tools/packs.
• Perform database administration and maintenance for Oracle products.
• Process change controls and install database upgrades and patches.
• Assist in design and development of Oracle databases.
• Develop schemas, tables, triggers, indexes, sequences, constraints, functions and procedures.
• Develop shell scripts and data management scripts.
• Determine capacity analysis and perform database tuning to improve efficiency.
• Take regular backup and restore corrupted databases.
• Handle data clustering, mirroring, replication and failover promptly.
• Analyze and troubleshoot technical issues in a timely fashion.
• Enforce best practices for optimal performance.
• Communicate technical teams about recent changes made in databases.
• Address customer queries and build positive working relationships wif customers and co-workers.
• Write complex codes and queries and participate in code reviews
• Understand project requirements and develop design specifications.
• Basic administration of oracle database administration.
• Handling database management and change requests in the form of export and import.
• Using RMAN Scripts to schedule the hot/cold backups.
• Tablespace and datafiles additions in databases
• Data Guard Switching over roles, rebuilding physical standby
• Providing connectivity and troubleshooting of connectivity problems.
• Export/Import of oracle databases.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.