PROFESSIONAL SUMMARY:

• More than 14+ years of IT Experience and consists of 11+ years of extensive experience as Oracle DBA with 10g, 11g, 12c, RAC.
• Experience in Implementation and Upgrading.
• Oracle high availability implementation for Database & Applications.
• Production 24X7 Support for multiple clients as Oracle DBA on 10g, 11g and 12c.
• Patching and maintenance applications using AD Utilities.
• Oracle 10g, 11g RAC Implementation with ASM, NFS and SAN. Oracle Data Guard for failover, switchover.
• Profound experience in analysis, design, development, tuning and use of Oracle Database development tools.
• Strong knowledge in Performance Tuning Database.
• Good working knowledge with RMAN setup and Configuration.
• Outstanding team player with extensive experience in project planning and implementation.
• Strong communication and interpersonal skills.

TECHNICAL SKILLS:

Operating System: Red Hat Linux ES 4 & 5; Sun Solaris 5.8, 5.9 & 5.10; Oracle Enterperise Linux 6 & 7; IBM AIX 5, 6 & 7;

Databases: Oracle 10g, 11g, 12c, Cassandra NOSQL database

Middleware:

Oracle WebLogic 11gOracle E: business suite 11g, R12

Tools: SQL Loader, SQL Plus, TKPROF, TOAD, SQL Developer, OEM 12c

Programming Languages: SQL, PL/SQL, Shell Scripting, Python programming.

WORK EXPERIENCE:

Confidential, Jersey City, NJ

Responsibilities:

• Planned and performed the upgrade of Oracle WebLogic from 10g to 11g.
• Configured the Oracle Access Manager (OAM) services to talk to Enterprise LDAP services for user’s authentication.
• Configured reporting services to pick users reports and generate them.
• Configured High Availability (HA) Services on reporting services to increase the availability of reports even in case of a node failure.
• Installed and configured DR servers with a similar setup so that services can be switched from primary site to DR site in the event of a disaster.
• Interacted with clients and helped them resolve their problems which they were facing during the course of testing.
• Have imported the SSL certifications so that the web route is secured.
• Configured scheduled jobs and re - wrote some of the legacy code so that it can work on Oracle 11g.
• Successfully made the project live with zero defects and no P1 tickets.
• Demonstrated the sustainability of the environment by performing following tests post go-live.
• High Availability (HA) test, where in services on one of the node are brought down to ensure that the services are still functioning from another node.
• Sustain Resilience (SR) test, where in services are switched over from Primary site to DR site and left the system running from DR site for full business week.
• Disaster Recovery (DR) test, where in DR was announced and services were quickly switched over to DR site to meet business RTO of 2 hours timelines.

Confidential

Responsibilities:

• Was part of migrating databases from one Data Center with older hardware to a new data center with new hardware.
• Involved in the planning and execution of the database migrations.
• Coordinated in configuration of all access routes and user’s creation with AIX team on new servers.
• Worked with Application Developers (AD) teams to test the access routes and fix any defects.
• Worked with Control-M admin teams to have the agents installed so that scheduled jobs can be triggered from databases running from new servers.
• Implemented filesystem level RSYNC script to copy the data/file between primary and DR sites respectively.
• Restored databases from backup on newer DC for applications teams to test the setup before setup the Data Guards on the newer datacenters so that the database can be synced.
• Worked with application teams to have the applications tested both for connections and performance.
• Systematically migrated the database starting from Lower environment until production with very minimal difficulties.
• Demonstrated the sustainability of the environment by performing following tests post go-live.
• High Availability (HA) test, where in services on one of the node are brought down to ensure that the services are still functioning from another node.
• Sustain Resilience (SR) test, where in services are switched over from Primary site to DR site and left the system running from DR site for full business week.
• Disaster Recovery (DR) test, where in DR was announced and services were quickly switched over to DR site to meet respective RTO timelines of Line of Business (LOB).

Confidential, Denver, CO

Lead Database Administrator

Environment: Oracle 10g on RHEL 5, MS SQL Server 2208 and 2012.

Responsibilities:

• Played the role as Database Tower Lead and Change Manager.
• Fully responsible for all the deliverables of the Database Tower which comprise of Oracle and MSSQL databases.
• Stabilize the environment so as to ensure smooth processing of the scheduled jobs.
• Ensure that all scheduled jobs are completed on time without any delay and in case of any failures quickly address them to ensure that the reruns are successful.
• Perform Database Administration for Oracle and MSSQL databases Daily activities include Database Administration of Oracle 10g, 11g, 12c RDBMS versions and MSSQL 2005, 2008, 2012 versions.
• Involve in incident management change management, problem/release management, database capacity planning etc.
• Involve in Data Centre Migration
• Installation & Configuration of Oracle databases and upgrading to latest versions when applicable.
• Handling data related issues
• Performing database optimizations, managing large production databases with proper security, Setup and maintain high end data loads.
• Attend meetings in person at client site, manage escalations and ensure that the DBA services are in adherence to the SLAs agreed with the client
• Train the fresh talent pool of the team by shadowing, instructing and guiding them.
• Following ITSM process framework such as incident management, problem management and change management.
• Database design and implemented database security.
• Upgraded Oracle 10g to 11g versions.
• Cloned prod environment to lower environments to provide developers with latest datasets to work on newer projects.
• Applying quarterly released security patch.
• Working closely with Oracle support to resolve issues by creating SR’s.
• Preparation of documentation and defining a standard process of upgrading Scheduling and Maintenance of Interface processes and concurrent manager processes for production.
• Setup notification daemon for mailer through UNIX send mail.
• Developed and executed UNIX shell scripts for frequent cloning.
• Independently configured and maintained machines running Redhat Linux and Oracle applications.
• Worked on table Partitioning.
• Assessed Oracle database security requirements and implemented Oracle recommended security protocol and procedures to provide secure access to users
• Multi-node installation and configuration on Solaris machines for production purposes.
• Used Data pump and transportable tablespaces.
• Good Knowledge on Database & Applications tuning.
• Tuning SGA and dealing with locking issues.
• Data Guard Configuration on Database.
• Worked on ASM instances.
• RMAN Scripts for Duplicate database, Backup & Recovery.
• Working on RDA Reports from server and database level.
• Performed the POC to migrate oracle database from local data center to AWS cloud.

Confidential, Wilmington, DE

Responsibilities:

• Installed and Configured Oracle 11g RAC instances.
• Upgradation of databases from Oracle 10g to 11g
• Automation of some of the critical jobs which are time sensitive to eliminate human errors.
• Performed Database Stress tests and analysis.
• Troubleshooted issues with patches.
• Installed and configured 11g grid infrastructure.
• Configured virtual ips for rac databases.
• Perform Database Administration for Oracle databases Daily activities include Database Administration of Oracle 9i, 10g, 11g, 12c RDBMS versions
• Involve in incident management change management, problem/release management, database capacity planning etc.
• Involve in Data Centre Migration
• Installation & Configuration of Oracle databases
• Handling data related issues
• Performing database optimizations, managing large production databases with proper security, Setup and maintain high end data loads.
• Troubleshooting any SQL related issues as a part of Middleware Database Run Service support
• Engagement with client Architects and Business Analysts to gather requirements for database administration
• Attend meetings in person at client site, manage escalations and ensure that the DBA services are in adherence to the SLAs agreed with the client
• Drive Service Improvement and Transformation programs for Middleware Database Services etc.
• Train the fresh talent pool of the team by shadowing, instructing and guiding them
• Following ITSM process framework such as incident management, problem management and change management.
• Prepared technical documentation for cloning procedures.
• Configured RMAN backups.
• Monitoring tablespaces and database objects.
• Handled sysadmin tasks like creating users and assigning roles and responsibilities.
• Used Data pump and transportable tablespaces.
• Good Knowledge on Database & Applications tuning.
• Tuning SGA and dealing with locking issues.
• Data Guard Configuration on Database.
• Worked on ASM instances.
• RMAN Scripts for Duplicate database, Backup & Recovery.
• Working on RDA Reports from server and database level.

Confidential

Oracle Database Administrator

Responsibilities:

• Providing 24 X 7 troubleshooting and support for over 400+ Oracle databases.
• Carried activities of creating new non-prod databases from production copy to allow users to test and implement the new feature.
• Applied Oracle patches on Production and Non-production: for fixing the user issues and for security reasons.
• Backed up the databases whenever there is a major implementation happening.
• Through ticketing system have provided the support in resolving the issues faced by the customers and have implemented the user requested changes.
• Monitoring the hot backups, cold backups and troubleshoot the failed ones.
• Monitoring the space requirements of the database and adding files or increasing the size of the existing once when required.
• Creating, altering and dropping users/roles/profiles as per the requirements. Clone/refresh of the non-production databases from production.
• Standby database monitoring and management.
• Fixing the standby database issues and if required re-syncing it with production in case of any issue.
• Doing housekeeping activities on both database so that files and directories which are not required and cleaned to release the space to the file system.
• Coordinating with UNIX team for any problem related to the server’s access/availability and during the server maintenance time.
• Handling data related issues
• Performing database optimizations, managing large production databases with proper security, Setup and maintain high end data loads.
• Troubleshooting any SQL related issues as a part of Middleware Database Run Service support
• Engagement with client Architects and Business Analysts to gather requirements for database administration
• Attend meetings in person at client site, manage escalations and ensure that the DBA services are in adherence to the SLAs agreed with the client
• Drive Service Improvement and Transformation programs for Middleware Database Services etc.
• Train the fresh talent pool of the team by shadowing, instructing and guiding them
• Used Data pump and transportable tablespaces.
• Good Knowledge on Database & Applications tuning.
• Tuning SGA and dealing with locking issues.
• Data Guard Configuration on Database.
• Worked on ASM instances.
• RMAN Scripts for Duplicate database, Backup & Recovery.
• Working on RDA Reports from server and database level.

Confidential

Responsibilities:

• R11 (11.1.5.9) Installation and database Upgrade.
• Applying latest RUP (12.1.1) on r12 instance.
• Installed and configured Discoverer 11g.
• Oracle Streams Implementation and Configuration for Rolling Upgrade.
• Working with Oracle Product Team to validate Confidential streams setup.
• Using Oracle Data guard for switchover and failover.
• Physical /Snapshot standby database configuration.
• Configured active dataguard in EBS environment.
• Database Upgrades with standby database.
• Flashback database configuration.
• Working with Oracle Production team to validate Streams Configuration.

Confidential

Responsibilities:

• Providing 24 X 7 troubleshooting and support for over 400+ Oracle databases.
• Carried activities of creating new non-prod databases from production copy to allow users to test and implement the new feature.
• Applied Oracle patches on Production and Non-production: for fixing the user issues and for security reasons.
• Backed up the databases whenever there is a major implementation happening.
• Through ticketing system have provided the support in resolving the issues faced by the customers and have implemented the user requested changes.
• Monitoring the hot backups, cold backups and troubleshoot the failed ones.
• Monitoring the space requirements of the database and adding files or increasing the size of the existing once when required.
• Creating, altering and dropping users/roles/profiles as per the requirements. Clone/refresh of the non-production databases from production.
• Standby database monitoring and management.
• Fixing the standby database issues and if required re-syncing it with production in case of any issue.
• Doing housekeeping activities on both database so that files and directories which are not required and cleaned to release the space to the file system.
• Coordinating with UNIX team for any problem related to the server’s access/availability and during the server maintenance time.
• Handling data related issues
• Performing database optimizations, managing large production databases with proper security, Setup and maintain high end data loads.
• Troubleshooting any SQL related issues as a part of Middleware Database Run Service support
• Engagement with client Architects and Business Analysts to gather requirements for database administration
• Attend meetings in person at client site, manage escalations and ensure that the DBA services are in adherence to the SLAs agreed with the client
• Drive Service Improvement and Transformation programs for Middleware Database Services etc.
• Train the fresh talent pool of the team by shadowing, instructing and guiding them
• Used Data pump and transportable tablespaces.
• Good Knowledge on Database & Applications tuning.
• Tuning SGA and dealing with locking issues.
• Data Guard Configuration on Database.
• Worked on ASM instances.
• RMAN Scripts for Duplicate database, Backup & Recovery.
• Working on RDA Reports from server and database levelR12 installation on dev servers
• Responsible for Raising TAR using the Oracle Metalink for key Issues related to Applications
• Customer support over phone on 24x7 basis
• Discoverer EUL management.
• Installed and configured 10g Discoverer with EBS 11i .
• Trouble shooting regarding to Patching issues
• Performed Sysadmin tasks like assigning responsibilities and creating new responsibilities
• Performed Queue overlap analysis for Concurrent managers for better utilization of resources.
• Performed daily health checks.
• Monitored all running instances to ensure everything working
• Monitored CPU utilizations and checked for long running/runaway processes.