PROFESSIONAL SUMMARY

• Highly accomplished, deeply driven, database engineer with a successful 9 years track record of success in Oracle database administration. Strong infrastructure background includes logical and physical database installation, upgradation, patches, replication, and performance optimization, managing and developing backup and recovery plans of oracle databases. Experienced in production support and development activities. Very detailed oriented with focus on minimizing risks and system down-time. Record to keep the project on track with effective use of resources. Exceed ongoing and overlapping deadlined in fast-paced environments, handle multiple assignments simultaneously and deliverables with key stakeholders in cross-functional groups.
• Over 9 Years of experience as Oracle DBA on 9i, 10g,11g 12c database servers with RAC, ASM Grid Control experience with Database implementation on UNIX Solaris, IBM-AIX, HP-UX, Linux Windows.
• Involved in DBA activities for 24/7 Production Support on all environments and ensure high availability.
• Monitoring day-to-day in-house Oracle databases with regards to availability, performance and space management.
• Proficient in Oracle RDBMS-Including SQL and all areas of database administration.
• Conduct basic health checks, management of Schemas, Objects Partitioning the Tables Indexes.
• Installation, upgradation, configuration, administration and maintenance of Oracle databases 12c, 11g, 10g, 9i . Managed different sizes of database ranging from 100GB up to 13TB.
• Oracle Backup and Recovery Hot Backup / Cold Backup / RMAN Backup Excellent command in creating backup recovery procedures and implementing strategies for hot and cold backups.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Planning and scheduling Backups, Database Recovery, taking Logical Backups Export/Import .
• Experienced in implementation of Disaster Recovery site Physical Standby Databases Dataguard .
• Proficient in performance monitoring and analyzing the database using AWR, ADDM and Explain Plan.
• Installation of Oracle 11g 12c and Oracle11g Grid Infrastructure for Cluster Database RAC .

• Strong knowledge in implementation of RAC databases on VMware Workstation and Oracle VM VirtualBox for development and testing activities for the developers.

• Experience in database replication using Oracle Streams and Oracle GoldenGate.
• Migrated large amount of data from 10g to 11g using GoldenGate.
• Performed Migrating Oracle 10g/11g Environments from Windows Server Enterprise to RHEL 5.
• Experience in data transfer utilities like SQL loader, Export/Import Data Pump.
• Extensive experience in providing solutions to developer/user requests, in resolving issues and bugs related to databases.
• Experience in Toad Tool for Oracle Application Developers for database maintenance tasks.
• Experience in Application tuning using session trace file and TKPROF utility.
• Strong experience in OEM Oracle Enterprise Manager , SQL Net, SQL Loader and SQL PLUS.

PROJECT DETAILS

Confidential

Senior Oracle DBA Ddeveloper

Environment: RHEL Linux Windows, Oracle 11g, 12c, Dataguard, RAC

Responsibilities

• Worked in Standalone, RAC and ASM environments.
• Converted single instance to RAC in UNIX.
• Created and configured Dataguard.
• Installed and Configured Golden Gate for replication purposes.
• Configured and maintained replication of data using Golden gate in Production and Non-Production environments for reporting.
• Performed cross-platform migrations Oracle 10g - 11gR2 from multiple databases using Oracle GoldenGate.
• Designed and implemented database schema logical and physical data models .
• Created new 10g Database and performed regular RMAN backups for all the databases.
• Worked with different application teams to carry out different Migration and provided warranty support for 2 weeks after handing it over to app team.
• 24x7 production support DBA working on a primary/ secondary pager rotation and supported on holidays, weekends and beyond regular hours.
• Created Procedure, Function, Triggers using PL/SQL.
• Loading data using SQL Loader and Data Pump utilities.
• Documented instructions for migrating upgrading databases.
• Handled Service Requests raised by application development teams.
• Refreshed schemas from Production environment to DEV/TEST environment using exp/imp and expdp/impdp utilities.
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements
• Updated Table, schema and Database statistics using DBMS STATS.
• Maintained Checklist for monitoring Production and Test systems.
• Wrote various UNIX shell scripts to monitor databases, automate tasks, etc.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files.
• Created schema tables, Indexes, views, sequences, synonyms, packages .
• Setup database auditing, granted privileges to users through system/object roles.
• Monitoring and Maintaining standby databases.
• Managed databases of various sizes ranging from 1 GB to 2 TB.
• Taking hot, cold and RMAN backups.
• Creating and managing partitioned tables and indexes.
• Monitored and tuned database performance using STATSPACK, AWR and ADDM.

Confidential

Senior Oracle DBA

Environment: RHEL Linux Windows, Oracle 11g, 12c, Dataguard, RAC, Oracle Goldengate, OEM Grid Control

Responsibilities

• Configure and build Golden Gate Extracts/replicate for multiple databases.
• Configure and build heartbeat monitoring in Golden Gate.
• Configure error handling for restart, logging, production support and status reporting in GG.
• Identify and produce documentation of best practices.
• Trouble shooting and performance tuning golden gate replications.
• Implementing necessary monitoring scripts for Golden gate in Unix scripting
• Routine proactive maintenance of Oracle Database using shell scripts and standard data collection mechanisms
• Working with team on production issues and escalate the issues to appropriate team if required.
• Installed, configured and maintained Oracle 10g,9i and 8i Databases on UNIX Platform
• Reclaiming Physical disk space sizes after purging of unwanted data in the database thus saving storage space, reducing the backup time and improving performance of the queries as well
• Taking HOT and COLD backups using RMAN and shell scripts
• Responsible for capacity planning by collecting data regarding DB growth, application usage
• Proactive monitoring and health checking of all DEV/TESTING/PROD databases
• Connectivity and locking issues.
• Monitoring Users access, Tablespace usage, CPU usage on server.
• Recover / Restore the database if required.
• Applied database patches using OPatch utility.
• Installed statspack in the database to monitor the database
• Logical Backup of Databases using EXP / IMP Utility.
• Monitoring the Database size and add/resize datafiles when required.
• Granting specific privileges and roles to the users.
• Attending daily, weekly and bi-weekly calls with Customer IT divisions for discussing on-going activities and upcoming projects.
• Clones/Refreshes.
• Trouble shooting Cloning and Patching issues.
• Quarterly password changes as per Client audit.
• Implemented Data Guard setup in production environment

Confidential

Senior Oracle DBA

Environment: Linux, Solaris Windows, Oracle 11g, Dataguard, RAC, TOAD, Oracle OEM Grid Control

Responsibilities

• Involved in implementing and managing Oracle 10g RAC with ASM databases to deliver leading multi-OLTP and, enabled load balancing client-server, server-server as transparent application failover TAF .
• Configuring database entries and Monitoring of all the databases using Oracle Enterprise Manager OEM 10g grid control.
• Installation and configuration of Oracle Database Software 11g. Creation and configuration of databases in 11g.
• Upgrading database from Oracle version 10g to 11g.
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.
• Performed logical backup using export/import and data pump remote export utilities.
• Database refreshes based on Application requirements.
• Wrote shell script to perform backup and schedule it with crontab.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Optimize SQL queries for better performance.
• Carried out Optimizing performance and Query tuning using Statspack, Tkprof, and OEM.
• Use Explain Plan for monitoring the query execution.
• Troubleshoot Database performance issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM ..
• Installation and configuration of Oracle Client software and Tools.
• Provided Production DBA support, as needed, on a 24/7 basis.

Confidential

Senior Oracle DBA

Environment Oracle 10g, Oracle 9i, AIX, HP, Sun, Linux, Windows

Responsibilities

• Involved in performance tuning and SQL tuning effort. Expert in making use of explain plan, Tkprof, AWR reports, OEM and Toad.
• Tuned several environments and improved the results to many folds. Re-wrote several stored procedures and packages in PL/SQL for developers.
• Managed Oracle Grid Control.
• Responsible for day to day trouble shooting, and maintenance.
• Responsible for automating database monitoring using OEM and shell scripts.
• Implemented backup and recovery strategy.
• Responsible for managing multiple databases of more than 15 terabytes, taking advantage of ASM and RMAN features using FRA. The setup included DR site with Physical Standby using DG broker.
• Heavily involved in performance tuning and SQL tuning effort. Helped developers to code efficiently in PL/SQL. Expert in making use of explain plan, Tkprof, AWR reports, OEM and Toad. Tuned several environments and improved the results to many folds.
• Responsible for migration / upgrade design for databases. Designed / tested and implemented backup and recovery methods and procedures including full, incremental and FRA image backups, using RMAN and Net backup.
• Responsible for day to day trouble shooting, and maintenance. Responsible for automating database monitoring using OEM and shell scripts.