SUMMARY

• Experienced in Performance Tuning & Capacity Planning, Pro - active and Re-active actions for optimal performance complying with business SLA’s
• Professional and highly qualified with around 15 years of experience and possess 11 years as Oracle Database Administrator (9i, 10g,11g and 12c).
• Extensive experience in design, development, maintenance, upgrade and migration of Oracle Database.
• Extensive experience in Production Support of databases, backups, recovery and restoration.
• Proficient in Oracle 11g/10g/9i/8i Database Design, Installation of Oracle software on various platforms, implementing, Administration, Performance tuning and troubleshooting 24x7 Production environments.
• Having good knowledge in Oracle E-Business Suite R12 Application Database. Installed and supported Oracle EBS 12.1.3.
• Proficient in "Oracle Real Application Clusters" (10G RAC) and Oracle11g.
• Created Dev, UAT and Prod instances by cloning and refreshed instances as required by project schedule.
• Configured and Implemented Golden Gate.
• Extensive experience in all phases of database development, right from needs assessment to QA/QC, design and post development support.
• Proficient in Tuning of SQL Queries ( usually takes long time/hung state to process a request using "Explain Plan" which will help to reduce the response time).
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, MTTR Advisor, EXPLAIN PLAN, TK PROF, and DBV.
• Excellent understanding of Oracle Internals, Architecture, Data Dictionary, Data Management, Automatic Storage Management (ASM) and System Management
• Implemented Industry level Backup strategies, Configured the backups in an optimal way so the load will be manageable and overcome backup hung scenarios.
• Implemented RMAN and created RMAN Scripts for Backup, Recovery and Cloning Strategies.
• Created and maintained "database refresh" for Test/QA environments by using Logical and Physical backups.
• Configured various types of DATAGUARD Modes to ensure high availability of database.
• Having good knowledge in UNIX shell scripting to prepare Database monitoring scripts and scheduling Jobs (backups) at scheduled intervals and various other jobs.
• Maintaining healthy working relationship with customers (UNIX, Storage, Team Leads and Development Team) and create team work environment.
• Well organized, versatile, self-motivated team player with strong analytical, relationship management & people management skills with effective written and oral communication skills.
• Ability to understand client’s business requirements and provide practical solutions within the timeframes and implement them to achieve the organization goals.

TECHNICAL SKILLS:

Databases: Oracle 8i / Oracle 9i / Oracle 10g / Oracle 11g / Oracle 12c & Oracle E-Business Suite R12

Operating systems: LINUX Platforms RHEL 6, 5.x, AIX 5.1,5.2,Sun Solaris, HP-UX 10.x, 11.x & Windows

HighAvailability: RAC and Data Guard (Physical and logical standby setup)

Tools: Golden Gate, DBArtisan, TOAD, DBverify, RMAN, Export & Import, Data Pump, TKProf, Explain Plan, SQL Advisor, SQL* Loader, Clearcase and KintanaReporting Tools AWR, ADDM, DBA Pool-Analyzer, Statspack, ASH

Utilities: PuTTY & JIRA

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr Oracle DBA/Project Lead

Responsibilities:

• Handling over 400 databases, which includes production and RAC (Real Application Cluster) databases.
• Proactively identify issues and make sure services are meeting SLAs (service level agreements).
• Designed and implemented high availability solutions such as Data Guard and Real Application Clusters (RAC with 3 nodes) on Linux Platforms.
• Configuring and preparing the environment for oracle Goldengate, configuring change capture and change delivery
• Experience in RAC on Linux (RHEL6, 5 AS), AIX 5.3L, Sun Solaris and Linux environments for High Availability with ASM
• Managed the full database deployment life cycle including development, testing (including UAT), and pre and post-production environments as per quality standards.
• Extensive experience in data center configuration and migration.
• Conduct and lead Performance Tuning & Capacity Planning, Pro-active and Re-active actions for optimal performance complying with business SLA’s at regular intervals.
• Implemented Change Control/ Change Management Procedures for effective performance of High Availability Databases (in Highly Qualified Environment).
• Prepared validation documents for database setup (installation, configuration, operation, etc.).
• Provide support to Development Team with their SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.
• Conduct weekly meetings and tele/video conference with clients, development teams both onsite and off-shore.
• Performed Data Centre Migrations from Linux to AIX.
• Configured and Implemented Golden Gate Tool and provide continuous support to the database.
• Perform logical and physical backups for recovery by using exp/imp,OS backups and RMAN tool.
• Migrating single Instance Databases to 2 Node RAC environment
• Raising TAR and consulting with Oracle Corporation as and when ever required.

ENVIRONMENT: Oracle 11g/10g RAC/9i on Windows, LINUX Platforms RHEL 6, 5.x, AIX 5.1,5.2,Sun Solaris, IBM AIX,RMAN, OEM Grid Control 11g

Confidential, New York, NY.

Sr. Oracle DBA / Project Lead

Responsibilities:

• Provide 24x7 support to Production Environment and Manage Database Servers and its availability.
• Performing installation, up-gradation and patching of Oracle Server software.
• Resolving the Issues and updating the Tickets status to the client from time to time.
• Perform day-to-day operations like troubleshooting client connectivity, user / application errors, monitoring database growth, review of alert, listener, alert log on time base for ORA errors and other logs, monitoring scheduled jobs that include statistics gathering, backups, snapshot refreshes etc.
• Generate Reports, Monitor Disk Usage and up-keep of the systems for the continuous production environment.
• Created several databases manually and also by using DBCA tool for supporting Production/QA/Test and Development environments.
• Tuning of the SQL Queries, which takes long time to process the request using Explain Plan,Hints to reduce the response time.
• Working on UNIX shell scripting for monitoring and scheduling backups at scheduled intervals and other jobs.
• Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
• Installation of RAC and Managing RAC Environment efficiently.
• Working on database application and performance tuning.
• Implementing and maintaining database security (create and maintain users, roles and assign privileges).
• Troubleshooting database problems faced by the application developers/users.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored system resource availability and responded to system memory and data issues.
• Creating technical documentation and imparting knowledge sharing within the team.

ENVIRONMENT: Oracle 11g/10g RAC/9i on Windows, LINUX Platforms RHEL 6, 5.x, AIX 5.1,5.2,Sun Solaris, IBM AIX,RMAN, OEM Grid Control 11g

Confidential, New York, NY.

SR. ORACLE DBA

Responsibilities:

• Supported over 200 databases and over 75 Production databases (24 X 7) which includes RAC databases.
• Supported various Oracle Database for various applications viz., SAP, PeopleSoft, JD Edwards and other in-house application and various other Data Warehouse Applications at NBC Universal.
• Migrated the Database from Non-ASM to ASM.
• Applied Security Patches for DEV, QA, TEST and PROD.
• Performed Cloning and database refreshes as and when requested by users.
• Having good knowledge in UNIX shell scripting to prepare Database monitoring scripts and scheduling backups at scheduled intervals and various other jobs.
• Took back-up of database using Logical (Export and Import), Physical (Hot and cold) Backups and RMAN.
• Performed performance tuning from time to time.
• Implemented DATA GUARD (Physical Standby) for high availability/disaster recovery purpose
• Monitored the production Oracle alert logs for database errors.
• Implemented and maintained database security (create and maintain users, roles and assign privileges).
• Handled database change request from the application developers on need basis.
• Performed "trouble shooting" of the problems faced by Application Developers and End Users.
• Coordinate and Monitored Application Outage Activities.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases on Vmware environment.
• Created technical documentation and KT with the team.
• Raised Service Requests through TAR and coordinated with Oracle Corporation as and when required.

ENVIRONMENT: Linux, UNIX, Solaris, HPUX, AIX, Windows and Oracle 11g/10g/9i.

Confidential

Oracle DBA

Responsibilities:

• Installed oracle 8i/9i/10g on Linux/Windows.
• Performed database refreshes using cold and hot backup.
• Involved in database cloning.
• Checked database health and ensured the database availability and monitored the database and User requests/Tickets.
• Worked on Oracle software installation, created database creation and applied patches.
• Took logical and physical backup.
• Handled overall database activities such as creation of table space; users, schema, objects, defining role and access privilege for users.
• Created technical documentation and thus imparted knowledge sharing within the team.

ENVIRONMENT: Linux, Win 2000 and ORACLE 8.x/9.x/10g.

Confidential

Oracle DBA

Responsibilities:

• Managed and executed database change requests .
• Handled database Refresh from production to development and support databases.
• Performed Data transfer using Oracle transportable table space feature.
• Involved in DBCC requests handling, batch job monitoring, database health checking, ensuring the database availability and monitoring the database.
• Created roles and profiles.
• Created the users with necessary privileges, roles, profiles and space quota.
• Worked on Table space creation and maintenance support such as adding data files to the production, development and support and test databases.
• Maintained redo log and archived log files.
• Involved in index creation and rebuilding to improve the query performance.
• Resolved row chaining and migration.
• Handled Application level tuning (TKPROF/Explain Plan/SQL Trace).
• Monitored the CPU usage and IO statistics to identify any OS level Performance killers.
• Involved in Space management on temp, data and index table spaces in all the production, support, development and test instances.
• Handled Database change request from the application developers as when required.
• Monitored and scheduled jobs.
• Performed Troubleshooting of database problems faced by the application developers/users.

ENVIRONMENT: Linux and ORACLE 8.x/9.x/9i

Confidential

Oracle DBA

Responsibilities:

• Created users and gave specific roles and privileges.
• Monitored the database performance.
• Designed Table spaces/Tables/Indexes.
• Monitored the database growth and increased the table space size.
• Performed logical backup (exports and imports).
• Collected statistics and analyzed the trend of database.

ENVIRONMENT: Linux, Oracle 9i/8.x/7.x and Microsoft Windows NT 4.0

Confidential

Oracle Developer

Responsibilities:

• Set up and maintained documentation and standards.
• Checking alert logs and user logs.
• Installing Oracle clients on user machines.
• Setting up the network for the users
• Export / Import of Tables and Full Database.
• Frequent analysis of objects or schemas to improve the speed of the database.
• Installed and configured Oracle 8/ 8i on Windows NT Server, personal Oracle 8 on Windows95.
• Worked on stored procedures, packages and PL/SQL block coding.
• Migrated user profiles from oracle 7.3 to oracle 8i and security management for 8i.
• Created and maintained database objects.

ENVIRONMENT: Windows NT/2000, Windows Advanced Server and Oracle 8.x/7.3