PROFESSIONAL SUMMARY:

• Over 13 + years of experience as an Oracle DBA in Production and development environment and strong understanding of Oracle 12c/11gR2/10g/9i on various flavours of Unix and NT/2000
• Installation of Oracle 9i/10g/11g/12c on Redhat Linux, Solaris, AIX & Windows NT and 2000.
• Expert with the technical aspects of DBA such as Installation (RAC /Non RAC), Data guard, Upgradation, applying patches, Data - Pump, Import/Export, RMAN.
• Dexterously implemented Oracle 11gR2 RAC (Nodes ranging from 2 to 8) on Sun Solaris10, RHEL and AIX and Upgrade 10.2.0.4 to 11.2.0.3.
• Worked on Upgrades from Oracle 9i/10gR2 to 10gR2/11gR2. Applied Oracle Quarterly PSU / Critical Patches and version upgrades when needed for Linux, Sun and AIX OS.
• Participated in Exadata database migration, Extensively used Oracle Exadata in many projects
• Had experience of managing Oracle Databases which runs in Oracle Exadata, Exposure in doing POC for Oracle Database Appliance(ODA) and Cloud Technologies
• Managing RMAN Disk/Tape backups and ensuring the disk/tape backup being performed onto tape using NetBackup, EMC and Hitachi. Involved in restoring huge databases using RMAN.
• Successfully headed the team and worked on storage migrations from EMC Clarion to Hitachi.
• Expert in Architecting and Implementing High Availability solution, designed and implementation of database and application disaster recovery (DR) plans using Physical standby database, 2 nodes RAC and SRDF storage technology.
• Expert in performing database refreshes (RMAN cloning) from Production to UAT, Test and DEV environments based on the requirements for testing and development.
• Experienced in upporting databases of Datawarehousing, OLTP and OLAP environments
• Performing export/import of databases, schema or tables. Loading the data into the tables using SQL* Loader or import.
• Periodic validation of oversized indexes and index rebuild when required
• Setup and managed objects to objects replication with Oracle streams.
• Performed/managed enterprise databases installation RAC, Data Guard, ASM on Linux, Sun OS.
• Proficient in Delivering Oracle Database performance-tuning services for customers with Explain Plan, TKPROF, STATSPACK, SQL TRACE, AWR, ASH, Tuning Advisor, custom scripts and wait interface.
• Database Sizing, Tablespace Management and Security Administration.
• Oracle Database Objects re-organization and co-ordinate with UNIX administrators for space managements on various servers
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views
• Working knowledge of various Oracle access tools like Toad, SQL Navigator, OEM-Grid Control, SQL-Developer
• Having knowledge on shell scripts. Written and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks. File or data transfer using tools like SFTP, FTP and SCP.
• Had expereince in Banking domain and implemented end to end database solution for various banks across the globe, Successfully headed various Go Live for the Banks and Financial institutions
• Handled various Oracle Financial application Database like PeopleSoft, Oracle OBIEE, Oracle Flexcube etc
• Knowledge of the Oracle Golden Gate, Exadata and Oracle Database Appliances
• Strong experience on different flavours of UNIX like Linux, Sun Solaris, IBM AIX, Window NT and Windows 2000.
• Worked on implementing cost saving ideas in Database environment using Six Sigma
• Having excellent verbal and communication skills.
• Good Team Builder and Mentor, worked with offshore/onshore team while managing them and written several technical SOP’s to guide the team.

TECHNICAL SKILLS:

Operating System: Red Hat Linux, Solaris, HP-UX, AIX, Windows

Databases: Oracle 9i/10g/11g/12c, RAC

Languages: SQL, PLSQL, Java, C, UNIX shell scripting.

Tools: and Utilities(ORACLE): Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF, Golden Gate, Streams

Other Tools: ERWIN, DB Visualizer, Microsoft Visio, Use cases, SQL Developer, OEM, VM ware, putty, TOAD, Query Builder, VNC, WINSCP.

Others: Exadata, ODA, Greent Belt in Six Sigma

PROFESSIONAL EXPERIENCE:

Confidential, AZ

Tech Lead DBA

Responibilities:

• Performing database health checks, evaluating & troubleshooting Database performance and capacity related issues. Monitor, review and resolve database space management and capacity issues for all monitored environments.
• Managed/Monitored various Datacentre of Honeywell and various sizes from 1TB up to 40TB with OEM, customized monitoring system and Remedy ticketing tool.
• Installation and managing enterprise databases with RAC, Data Guard, ASM for high availability and scalability.
• Capacity planning: Involved in adding Tablespaces, data files, monitoring space growth, tuning of memory
• Successfully upgraded/migrated the databases from 10g/11g versions to 12c.
• Successfully applied, oracle quarterly released CPU/PSU Critical Patches and version upgrades when needed for Linux, AIX and Solaris.
• Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
• Involved in design and implementation of database and application disaster recovery (DR) 11gR2 Physical Standby Database.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Performed Performance Tuning, ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code with reference to the application helped to running faster.
• Recommendations for SQL statement tuning for SQL statements that are identified as impacting production performance.
• Management of production databases in Primary/standby database environment and ensuring high availability. Also worked on replication tools like Golden Gate, Oracle Streams and Standby Database.
• Setup and managed Oracle Streams replication for the SIEBEL application tables.
• Managing RMAN Tape backups and ensuring the tape backup being performed onto tape. Worked extensively in restoring and recovering huge business critical databases using RMAN.
• Carried out disk space maintenance on various UNIX servers. Provided suitable mount points for each database and additional disk space for testing purposes
• Monitor and review all errors and events found in the database logs, trace files, and event logs as per the monitoring tool.
• Customer facing role with end to end delivery, accountable for managing Honeywell’s enterprise Production, Cloud Database Environment as Technical Lead DBA.
• Managing the team of Oracle, MS-SQL, MY-SQL and Mongo DB.
• Responsible for the delivery for Oracle Database support as single point of contact for all escalation or issues related to project and work across various Data centres.
• Managed all outstanding help desk tickets to ensure timely resolution and coordinate all technical activities regarding and covered databases.
• Primary contact for communication of any technical activities or problems, ensure the quality and timeliness of deliverables, and organize and conduct weekly status meetings with the vendors/customers.
• Advise the client on any Hardware or Software issues that prevent from fulfilling the responsibilities.
• Participation in DB operational architectural review and Infrastructure upgrade reviews/evaluation on a monthly basis.
• Communicating with Client on the progress of various task items. Production Support Management, SLA tracking
• Involved in doing POC for Oracle Database Appliances(ODA) and Cloud Technologies
• Review of Project documentation (e.g. solution design documents)
• Mentoring and Managing the team of DBA’s

Environment: 12c,11gR2 RAC, RMAN, Data guard, ASM, Oracle Streams, Golden Gate (GG), EM Grid Control, MS-SQL,MY-SQL, Shell Scripting, Solaris, Linux and AIX, SIEBEL, OBIEE, Peoplesoft

Confidential

Senior Oracle DBA

Responsibilities:

• Performed Build the Bank and Run the Bank environment for Leading Banks/Financial institutions across the globe which involves Oracle Database end to end design, implementation from the scratch to go live of Oracle 11gR2 RAC nodes ranging from 2 to 8.
• Successfully Managed Oracle databases which runs in Oracle Exadata and co-ordinate with Oracle engineer when required
• Performing database health checks, evaluating & troubleshooting Database performance and capacity related issues.
• Monitor and review all errors and events found in the database logs, trace files, and event logs as per the monitoring tool for various sized DB’s.
• Performed performance Tuning using ADDM, AWR and ASH. Performing SQL tuning and advising the developers. Creating indexes on tables and revising the PL/SQL code helped to running faster with reference to Oracle Flexcube
• Ran various AWR, ASH reports and 10046, 10053 trace files to identify potential performance problems
• Performing database refreshes (RMAN cloning) and replication from Production to Test/UAT for analysis, reporting, testing and development as per the request.
• Patches: Applying oracle patches on databases and version upgrades when needed for Solaris and Linux OS.
• Managing RMAN backup and restore when required.
• Closely monitoring and administering log transport services and log apply services in physical databases
• Co-ordinate with developers on data partitioning for the large tables in Oracle Flexcube
• Part of Database Engineering team who works on benchmarking by applying best practices to the databases
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required capacity planning & benchmarking using analysis from STATSPACK reports
• Interacting with the vendors - under critical situations for oracle technology.
• Installation and managing databases on RAC, Data Guard, ASM for high availability and scalability.
• Accountable for managing Oracle Flexcube databases for various Banking customers
• Provide Root Cause Analysis reports and the problem resolution recommendations for all severity issues.

Environment: 11gR2 RAC, RMAN, Data guard, ASM, Oracle Flexcube, Oracle Weblogic EM Grid Control, Shell Scripting, Solaris, Linux and AIX

Confidential, Boise, ID

Senior Oracle DBA

Responsibilities:

• Performing day-to-day database monitoring, troubleshooting space and memory issues as per the OEM monitoring tool and customised shell scripts and resolved all the issues for the monitored environments of various sized DB’s from 30GB up to 27TB’s
• Database upgrade from 9i to 10g, Successful CRS upgrade 10.2.0.3 to 10.2.04 in rolling manner without cluster wide downtime
• Expertise in creating and managing Oracle 10g ASM instance, Migrating the database from file system to ASM.
• Successfully Configured, implemented 10G RAC with ASM disk on Linux and Solaris
• Automation of repeated complex tasks like Schema/Data Refreshes, database creation and Health Checks for the databases
• Expertise in patch management (CPU and one-off) for Oracle single instance & RAC
• Setting up DR Physical standby database/Data guard and managing the same.
• Closely monitoring and administering log transport services and log apply services in physical/logical databases
• Documenting all the new processes implemented (Like EM agent build, 11gR2 upgrade, Replicaton setup, etc.).
• Expertise in handling tuning advisors to tune, reorganizing DB objects and tablespaces
• Involved various recovery drills conducted by Intel Micron - USA and performed the database recovery on time
• Deep dive to resolve complex prod issues and perform the root cause analysis
• Interacting with the vendors - under critical situations for oracle technology, Working with Oracle Support for Critical Production issues and maintaining the log of number of bugs faced and patches applied
• Successfully headed the team for Storage migration from EMC Clarion to Hitachi
• Ascertaining adherence to transition process and smooth transition of all Oracle related activities.

Environment: 10g RAC, RMAN, Data guard, ASM, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Cloning, Critical DB Recoveries, Storage Migrations, shell Scripting, Solaris, Linux, Unix and AIX.

Confidential

Oracle DBA

Responsibilities:

• Monitor/Resolve the issues assigned through Confidential ticketing system.
• Managed/monitored around 100+ DB’s of various sizes from 5GB up to 10TB.
• Installed 9i/10g RAC, Standalone Databases for various requirements. Built over 12+ databases.
• Involved in design and implementation of disaster recovery (DR) and successfully setup the DR (Disaster Recovery) using Physical and Logical Standby DB’s as per the client requirement.
• Involved in setting up and testing the RMAN Backups for new Project builds.
• Performed QA refreshes for databases before the database go live.
• Worked on tables re-organization to reclaim the space and for performance improvement
• Involved in proactive and reactive Performance Tuning using ADDM, AWR and ASH. Performed SQL tuning and advised the developers.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Registering the EM agent with Repository and Troubleshoot / fix EM agent related issues.
• Created / reviewed the Run Book or Tech plan for any change to be implemented on Prod.
• Work with the vendors - under critical situations for oracle technology, Working with Oracle Support for Critical Production issues and maintaining the log of number of bugs faced and patches applied
• Expertise in different flavours of UNIX like IBM AIX, HP Unix, Sun Solaris, Linux.

Environment: 9i/10g RAC, RMAN, Data guard, Performance tuning, Auditing, PSU/CPU Patching, Upgradation, Database Refresh, Shell Scripting, Solaris, Linux, Unix.

Confidential

Jr Oracle DBA

Responsibilities:

• Proactive database monitoring with DB health checks, performance management through analyzing the Statspack, AWR reports.
• Setting up DB servers and Maintenance
• Scaling down the response time of queries below the targets set (as per Organizational standards)
• Involved in proactive and reactive Performance Tuning using ADDM, AWR . Performed SQL tuning and advised the developers.
• Code review for any code deployment in Prod/UAT and Work with application for deploying the code in required environment.
• Provide Root Cause Analysis reports and the problem resolution recommendations for all Sev1/P1 issues.
• Developed and customized the shell/SQL scripts to monitor the database activity and also to automate the database tasks.
• Designed and implemented the Manual, RMAN backup strategies as per client requirements and monitoring the same.
• Performed routine checks of space utilization and free space in table spaces. Expanded table spaces by adding data files when needed
• Proactively analyzed fragmentation and oversized indexes and performed reorganization of same
• Involved periodic database maintenance like table defragmentation, index rebuilding

Environment: Oracle 9i, VB 6, TOAD, Windows