SUMMARY

• Over 10+ years of IT industry experience in administrating Oracle Database, Oracle Certified Professional (OCP) and AWS Solution Architect.
• Experience in various Oracle consulting practices and procedures in database administration which includes Installation, Configuration, Upgradation, Cloning, and Backup/Recovery on different Operating systems in various cycles of Development, Testing and Production.
• Configured ASM Disks, ASM Disk groups & ASM Instances.
• Configure physical& logical standby databases using Oracle Dataguard.
• Involved in User Management, creating Roles and assigning privileges and roles to database users.
• Exporting and Importing database backups using Export & Import and Data pump utilities. Experience in Cloning production databases using RMAN.
• Involved in SQL tuning by generating explain plan, ADDM, AWR. Using TKPROF utility performed SQL tracing on session/user level and converting trace files to text files.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Tune the new databases for Maximum performance.
• Experience with handling of medium to large Oracle OLTP (Online transaction processing).
• Administered databases on Linux (RHEL), Cent os and Solaris.
• Experience in upgrading database using DBUA and manual methods.
• Experience in upgrading the databases from Oracle 9i to 10g and Oracle 10g to 11g using DBUA and Manual Upgrade methods.
• Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
• Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
• Configured Unidirectional and bi-directional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
• Experience in Design, Creating and maintaining the Oracle Database.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Oracle Golden Gate with very large Data bases.
• Experience in data filtering using Oracle Golden Gate.
• Implemented conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
• Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat and Oracle Enterprise Linux with ASM and non-ASM.
• Regular checking of Alert log and Trace files.
• Good experience in solving performance related issues on production databases.
• Experience in managing the team, mentoring and resource allocation.
• Involved in applying the CPU and PSU patches in non-prod and prod environments.
• Liaison with Oracle Support to resolve various application and database issues.
• Supported and worked on Priority 1 SR’s with Oracle Support during Go-Live period.
• Excellent analytical and communication skills combined with interpersonal skills and ability to work cohesively in a team. At ease in interacting with people at all levels, able to work under pressure.

TECHNICAL SKILLS

Oracle Databases: Oracle 10g, 11g and 12c

Operating Systems: HP-UX, RedHat Enterprise Linux, Oracle Enterprise Linux and Windows

Database Utilities: Export/Import, Data Pump, DBCA. DBUA, OUI, RMAN, SQL*Plus, SQL Loader, OEM 12c GRID Control, Data Guard, RAC, ASM, Golden Gate

Tools: Putty, Toad, SQL Developer, cronjob (Unix), WinSCP and Filezilla

Domains: Banking, eCommerce and Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Lead Oracle DBA

Responsibilities:

• Enforce best practices in all areas of database administration and architecture.
• Creation and Maintenance of database storage structures such as Tablespace, Data files etc.
• Monitoring the usage and growth of Tablespace, Data files and whole database using automated monitoring alerts.
• Review and implement database changes.
• Performing regular Oracle database maintenance like clearing Flashback, archive logs on various instances.
• Installing and Configuring ASM with various Disk Groups to create Oracle Database Instances.
• Worked in Planning and implementing the Backup strategy using RMAN, Hot backup, Cold Backup, Logical backup.
• Regular RMAN backup and recovery activities based on requests.
• Proficient in use of tools like SQL Developer, Toad.
• Upgraded the Oracle Databases from 11.2.0.1 to 11.2.0.3 and 10.2.0.5 to 12.1.0.2.
• Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
• Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
• Configured Unidirectional and bi-directional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
• Experience in Oracle Golden Gate with very large Data bases.
• Experience in data filtering using Oracle Golden Gate.
• Implemented conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
• Experience in handling out of sync data issues with Oracle Golden Gate.
• Experience in performance tuning for Oracle Golden Gate Extract and Replicates
• Involved in SQL tuning by generating explain plan, ADDM, AWR. Using TKPROF utility performed SQL tracing on session/user level and converting trace files to text files.
• Monitored and tuned long running jobs by working with the application and development team and analysing objects, create or rebuild indexes. Using SQL TRACE, Explain plan.
• Generated AWR reports on Oracle 11g database and analyzed the reports for Oracle waitevents, time-consuming SQL queries, tablespace growth, and database growth.
• Involved in applying the CPU and PSU patches in non-prod and prod environments.
• Regular checking of Alert log and Trace files.
• Participate in 24x7 on-call rotation for production databases.
• Experience in upgrading database using DBUA and manual methods.
• Good experience in solving performance related issues on production databases.
• Documenting Oracle Database design, creation and other database features for reference purposes.

Environment: Oracle Database 10g, 11g Oracle Enterprise Manager (OEM), RedHat Enterprise Linux, Database Upgrade Assistant (DBUA), Database Configuration Assistant (DBCA), Oracle Universal Installer (OUI), WinSCP, Putty, RAC, Golden Gate, RMAN, Data Pump, Export/Import.

Confidential, Tampa, FL

Senior Oracle DBA

Responsibilities:

• Providing 24*7 Oracle Database Production Support.
• Planning and creating databases manually as well as with DBCA on Test and Production boxes.
• Creation and Maintenance of database storage structures such as Tablespace, Data files etc
• Database cloning from Production to Test and Development environments
• Space management- free space check on the server, monitoring data growth and add free space in required tablespaces.
• Daily and weekly database backup (Cold backup / Export).
• Experience in upgrading database using DBUA and manual methods. Upgraded the Oracle Databases from 10.2.0.5 to 11.2.0.3.
• Installation and administration of replicating Golden Gate.
• Checking the process Extract jobs as the part of Golden Gate.
• Maintain the manager at both sides physical replicated Golden Gate.
• Help developers to install Oracle Client, troubleshoot and inform about any database performance issue of their application.
• Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat and Oracle Enterprise Linux with ASM and non-ASM.
• Experience in using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, AWR and ADDM reports for performance tuning.
• Involved in applying the CPU and PSU patches in non-prod and prod environments.
• Send weekly database health check-up report to the client.
• Regular checking of Alert log and Trace files.
• Proactively work with client and other technical support staff to resolve production issues.
• Analyzed & solved performance issues on production data within stipulated time span for which received appreciation from client.

Environment: Oracle Database 10g and 11g,Oracle Enterprise Linux, Windows 2003, HP-UX, Oracle Enterprise Manager (OEM), WinScp, Putty, RAC, RMAN, Golden Gate, Data Pump.

Confidential

Jr. Oracle DBA

Responsibilities:

• Installed various versions of databases as per requirement and worked on the same.
• Experience in performing regular database activities, backups monitoring and issues resolving.
• Performed cold and hot backup and used them for cloning of databases.
• Successfully apply new patches/version upgrades.
• Management of User schema and database objects. Creation of user accounts and granting privileges to users.
• Regular checking of Alert log and Trace files.
• Tuning of databases using AWR and ADDM. Maintained Security of Database and applications through roles, profiles and responsibilities.
• Managing internal databases, from planning and testing stages through implementation and support.
• Experience in Deployment process in all phases from Development to production.
• Modified various shell scripts for monitoring of databases. Good Understanding of SHELL scripts.

Environment: Oracle Database 10g, SQL Loader, TOAD, Putty, Oracle Enterprise Linux, Windows 2003.

Confidential

Jr Oracle DBA

Responsibilities:

• Involved in supporting Dev and Test environment in UNIX and Windows platforms
• Performed Database Cloning from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Applying database patches using Opatch Utility.
• An active member in the team of upgradation.
• Managing Oracle user management, like creating/dropping assigning roles and privileges.
• Creating Logical and Physical database structure, Creating and altering Table spaces, Managing Users and Resources, Granting and Revoking privileges through Roles.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 10g and Oracle 9i on operating system RHEL.
• Maintaining Archive logs and their spaces for routine administration, alert and trace monitoring.

Environment: Oracle 9i,10g, RMAN, Oracle Enterprise Linux, Windows 2000.