SUMMARY

• 8 years of experience in Database Administration using Oracle & PostgreSQL Databases.
• Expertise on Deploying Real Application Clusters technology for high availability configurations.
• Excellent experience in Installation, configuration and administration of Oracle 19c,12c,11g.
• Performed Database migrations/upgrades from 11g to 12g, 12g to 19c
• Experience in Setup configure & manage standby databases using Active Data Guard in Oracle 11g/12c.
• Managing Oracle Databases on AWS on EC2 and RDS services
• Hands on experience in all backups & recoveries like export/import, manual and RMAN backup.
• Configuration & maintenance of Oracle Recovery Manager - RMAN
• Configuration of Oracle Management Servers for Database monitoring.
• Experienced in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
• Performing Oracle database administration tasks like software installation, database setup, database upgrade, database patching, database cloning, performance tuning, SQL tuning, backup & recovery.
• Experience in Oracle Database performance-tuning using EXPLAIN PLAN, TKPROF, Sqltrace utilities.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Strong ability with UNIX shell scripting to automate tasks and in Cron jobs and dbms scheduler for scheduling jobs.
• Proficient in using AWR and ADDM for performance tuning like SQL tuning, Memory tuning, I/O tuning.
• Supporting 24x7 operational database in critical production environment
• Excellent communication, presentation and interpersonal, team building skills, versatile team player, highly motivated and will be able to achieve results in a fast paced team environment.

TECHNICAL SKILLS

RDBMS: Oracle 19c/12c/11g, PostgreSQL

Tools: & Utilities: SQL Loader, Export/Import, TOAD, Data pump & Oracle EM, Real Application Clusters.

Languages: SQL, PL/SQL and Shell scripts

Operating System: HP-UX, Linux and Windows

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle /PostgreSQL DBA

Responsibilities:

• Install configure Oracle RAC 19c/12c/11g on Linux with ASM storage.
• Providing support to Oracle 11g, 12c, 19c RAC databases.
• Monitor troubleshoots databases using Oracle 11g Grid control.
• Setup Backup/Recovery strategy thru RMAN.
• Install and configure of new PostgreSQL databases in on EC2 instances.
• Install, configure, test, monitor, upgrade, and tune PostgreSQL databases.
• Configure and setup PostgreSQL replication for Hot Standby and Streaming Replication
• Perform backups and restore using PgDump, hot backups.
• Troubleshoot performance issues in Production and development database.
• Setup Oracle physical Data Guard solutions for DR solution.
• Monitoring and Sync up of Oracle Standby databases.
• Upgrading the databases from lower version to higher versions.
• Creating health monitoring Unix shell scripts and scheduling the health scripts using crontab, mailx.
• Performing cloning databases regularly for the reporting databases and stage environments.
• Performed SQL tuning on various reports/SQLs and implemented SQL profiles or hints to get better execution plans.
• Taking AWR reports and analyzing them periodically for better performance.
• Monitor and manage database indexes for optimal performance.
• Applying regular quarterly CPU/PSU patches and keeping the databases up to date with the Oracle.
• Creating DB links to heterogeneous environments for the data warehouse
• Periodic index management, index rebuilding.

Confidential

Oracle DBA

Responsibilities:

• Supported and maintained Oracle 10g/11g databases.
• Installed and created databases for Prod, Dev and ITG environments.
• Installed OEM agents on several databases
• Configured databases and monitored of all the databases using
• Oracle Enterprise Manager (OEM) 11g grid control.
• Production support for Oracle databases 10g/11g
• Created scripts for the daily regular monitoring of the databases
• Created shell scripts to automate different database jobs
• Performed logical backup using export/import and data pump utilities Configured the RMAN backup
• Carried out hot backup, cold backup and RMAN backup
• Creation and configuration of Standby Database (Data Guard)
• Loaded the different formats of data into Oracle using SQL Loader.
• Performance Turing via OEM, AWR for 10g/11g
• SQL Tuning using Explain Plan, TKProf with SQL trace, SQL Tuning Advisor I/O tuning Via OEM,

Confidential

Oracle DBA

Responsibilities:

• Installing, Creating and Migrating the Oracle database on 10g R2 in Oracle Grid environment.
• Created databases on RAC for Production, Development and ITG environments.
• Performed migration from Oracle 8i, 9i, 10g to Oracle 10g Release2 RAC database.
• Migrated 30+ databases (10gR2, R1, 9i, 8i) from Legacy environment to Oracle 10g R2 on RAC DCC environment using Export/Import, Loader, Database links, Data pump.
• Configuring database entries and Monitoring of all the databases using ORACLE ENTERPRISE MANAGER (O.E.M.) 10g grid control.
• Production support for Oracle database 8i/9i/10g/10g RAC
• Troubleshooting on the Tickets for Oracle database related issues.
• Upgrading and Patching the 9i/10g/10g RAC
• Performed logical backup using export/import and data pump (remote export) utilities
• Configured the RMAN backup, carried out hot backup, cold backup and RMAN backup
• Creation and configuration of Standby Database (Data Guard)
• Carried out the Binary Installs in the Oracle 10g RAC environment
• Done the Migration Review required before the database migration and QA after the database is migrated.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Provided full technical support to various application teams before the databases go to production
• Experience in interaction with the top management and escalations of the complex issues
• Performed entries capacity planning (CAPMAN) required creating and maintaining the Databases.
• Perform Backups and Recovery, maintain 24 hours uptime for the database
• Managed the databases of various sizes ranging from 50GB to 2 TB.