15 years of extensive experience on oracle Database Administration, EXADATA, datacenter migrations using Datapump;TTS;Golden Gate, Upgrades, Setting up Disaster Recoveries, Dataguard, Building Infrastructure, Shell Scripting, Performance Tuning, Automations, Security implementations, Configuration management, Capacity Management, Providing BAU Support.
Having rich experience in ASM, RAC, Datpump, Performance Tuning, RMAN, Shell scripting, Implementing Security Features.
Leading the Oracle DBA Support team for the performance & availability of all the Customer/Vendors Facing applications with Database Administration experience providing support of both development and Production systems on various platforms and database sizes.
Proficient in infrastructure builds, database installation, creation, sizing, backup & recovery, performance tuning and capacity planning.
Working closely with the solution architects to prepare and finalize PTM’s .
Performed upgrades, patching of Production systems to be in sync with Oracle Crop support matrix.
Experience in Installation, configuration and performance tuning of Oracle database application.
Extensively worked on Oracle Tools like OEM 12c, SQL* Plus, SQL* Loader, SQL*Net, Datapump, RMAN, SQL Developer.
As Associate Manager, Application delivery I am responsible for managing and working along with a team for providing quality database management services to the clients. This includes Production support for all their applications along with on-call support @ 24x7 with immediate response. Accountable for database availability with high performance.
Also responsible for taking initiatives and providing value additions to the client year on year and reduce the cost of DBA efforts to the client.
Provide weekly / monthly metrics to IT Governance management team to keep track of all the major milestones on the Support.
Performed Proof Of concept of Oracle VLDB Database migrations to EXADATA and IBM P8, and submitted analysis to management for decision.
Database migrations of a complete landscape to EXADATA. This project is to migrate all the oracle databases from the existing AIX / HP and Linux environments to ORACLE EXADATA machines which are on Oracle enterprise Linux. The project involved of moving approximately 300 oracle databases using migrating tools like DATAPUMP, RMAN and GOLDEN GATE.
New Client taking into support. This project is to migrate all the oracle databases from one datacenter to CSC datacenter using Lift and Shift method after an existing Client (already supported by CSC) has acquired it. The project involved of moving around 80 oracle databases including 3 RAC infrastructures environments using ASM.
Infrastructure builds right and migrating the database for a client which involved building, 10g RAC and Database migrations using RMAN Transportable Trablespace.
Infrastructure and database build for a client, which involved building the whole land scape on 11g RAC for their Production Test and development and migrating their databases using Datapump, RMAN and Dataguard.
Siebel Performance tuning project, Worked with the Siebel application team closely and tuned the databases and implemented Configuration management and Capacity management and standardized the whole environment.
Implemented various security features including for various databases.
Automations including writing shell scripts for database refreshes, Database monitoring, Housekeeping, database Reporting and database backup reports.
Performing day to day support to the client and meeting the SLA’s.
Good experience on Delphix.
Performed many Oracle Disaster Recovery Testing projects for the clients using RMAN, Dataguard, Datapump and SAN replications.
Generating EXADATA health reports using exacheck and many CellCLI commands.
Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using Export. Testing of Backup’s and Documenting backup strategies. Created scripts for automating online daily backup for eight databases and for automating data loading from flat files.
Monitored regularly whether primary and standby databases are in sync and clearing the backed up archive log files after confirming that they are applied on the standby database.
Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
Shell scripting in Korn and Borne Shell for monitoring health of database and sending email for any errors logged in alert log file, monitoring file system space availability, checking and alerting for availability of next extent size, scheduling to analyze jobs based on the size of the objects.
Configured RMAN with Veritas Netbackup Server and implemented backup strategies for most of the clients supported.
Team member of Strategic planning team was responsible for Developing backup and recovery strategy, database tuning strategies, capacity planning etc.
Configured standby with data guard and backup with RMAN.
Cloning of production database to the test environment using Recovery Manager (RMAN).
Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups,Database security, OS space monitoring etc.
Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup.
Worked on DATAPUMP in exporting and importing the large databases.
Worked on the Retirement plan for the production databases.
Used UNIX shell programs & CRON jobs for automating the process to refresh the data periodically.
Documentation of Data Base Setup and administration of Server Environment
Experience on database performance features like RAT, Oracle Plan Management, AWR,AWR Diff, ASH reports.
Experience in database security features like Vault, Data Masking, Wallet, TDE, Data Redaciton.
Involved in upgrading databases to 10g,11g.
Good Knowledge on oracle 12c new features and architecture. Container and Pluggable databases.
Managing a team of 32 DBA’s support multiple accounts.
Environment: EXADATA, GOLDEN Gate, RMAN, ASM, RAC Oracle 11g/10g/9i,8i running on AIX/HP UNIX, Linux and Windows platform, Shell Scripting, SQL*Loader, OEM, Oracle Expert, Diagnostic Pack and SQL*Plus, Remedy, Jira, Toad.
As and Oracle DBA Software Engineer I was responsibilities for providing support to the testing team. I was responsible for providing various application versions of oracle databases which were used for testing.
Working closely with the Testing team, facilitating them with the databases of various application versions for their testing.
Daily Logical Backups and weekly Cold Physical Backup.
Having good experience on Export/Import utilities.
Good experience in using various GUI tools like OEM, TOAD, PLSql Developer, Putty, CuteFTP and Schema Manager.
Scheduling Jobs to be fired using Crontab.
SQL Statement Tuning, using SQL TRACE/TKPROF, Explain Plan and Auto Trace
Responsible for monitoring, diagnosing and tuning the database using various diagnostic tools like STATSPACK and querying Performance Dictionary Views.
Worked extensively on Database Cloning and Creating Databases for the Development Department on Unix and WinNT environment.
Good experience on Database comparison tools.
Strong Problem solving background.
Role: Software Engineer – Oracle DBA.
Executive, Networks. Gati Ltd. Secunderabad, India 10/1999 – 10/2004
As an Executive, Networks I was responsible for managing the oracle databases. Backup and recovery, Database reorganization using export and import. Managing day to day support activities. Managing the standby databases.
Managing 24/7 OLTP Production Databases with more than 900 End users connecting through multiple application servers.
Database Cloning on Test server from Cold and Hot backups of Production Database.