Professional Summary

• Total IT experience – Around 11 Years of which 10 years as a DBA,1 year as a Java Developer
• Provide leadership in supporting Oracle production database environments (7x24) including designing, installing, patching, tuning, maintaining, upgrading Oracle Databases (8i/9i/10g/11g).
• Proficiency in RAC, ASM administration, Oracle partitioning, Data Encryption, Data Guard, Replicationon Linux, AIX, HP-UX, Solaris, Windows Operating systems.
• Design, and implement Backup & Recovery strategies, and BCP, DR, HA solutions.
• Leads architecture discussions around design, data integration, recoverability, resiliency, capacity planning and availability.
• Leads the diagnosis of database-related issues and serve as an expert (SME).
• Proficiency in Installation and configuring OEM with various databases, nodes, instances and server monitoring through Grid Control.
• Experience in Database design, logical & physical models with ER diagrams.
• Proficiency in database refreshes using Data pump, and RMAN cloning methods.
• Experience in implementing SOX regulatory compliances, and complying with applicable enterprise database standards, procedures, and best practices for Oracle databases.
• Analyze complex queries tuning, statistics, and performance of CPU, IO, and memory.
• Analyze trending data and provide performance recommendations addressing specific application/system performance issues.
• Evaluate and recommend new database software, utilities, and tools and set the strategy for implementing new technologies.
• Coordinate the use of DMBS vendors and others to assist in the analysis and resolution of database problems/issues.
• Experience in Oracle AACG, CCG applications install/configuration/path/administrate activities on Web logic/Tomcat servers.
• Experience in PLM products administration for Oracle AGILE, Team Center Enterprise.
• Exposure to R12 e-business applications suite (EBS, VCP, OAM, OIM, FMW).
• Certifications
• Oracle Certified Professional (OCP) for Oracle 8i DBA.
• Sun Certified Programmer for JAVA2.0
• Education
• Master of Computer Applications (M.C.A) from Confidential University
• Bachelors of Science (B.Sc) from Confidential University

Technical Skills

Database Admin: ORACLE 11g/10g/9i/8i

High Availability:11g,10g RAC, ASM, Data Guard, Replication

Database Tools / Utilities:TOAD, RMAN, OEM, SQL developer, TOAD for Data Analyst, Fog light, SQL Optimizer, SQL Loader, expdp, impdp, awr, ash reports, Explain Plan, ADDM, ERwin

Languages:SQL,PL-SQL, SHELL scripting, Java, JSP

Operating Systems: Widows 95/NT/2000/XP,  Solaris 8.0/9, HP-UX 11.0, AIX 5L/6L, Red Hat Linux e5

Applications/ Other Software’s/Tools:Oracle AGILE, GRCC apps (AACG 8.6.3 & CCG 5.5.1), BMC- Remedy, Team Center Enterprise-PLM, Web logic 10.3, Tomcat 5.5

WORK EXPERIENCE:

Confidential., Chicago, USA: March 2012 to Till date

Job Role: Database Technical Lead (contract)
Technical Environment : Oracle 11G,10G RAC, Grid Control 11g, RMAN, Oracle 11g, 10g, 9i and 8.1.7 Unix (Solaris, AIX, Linux , windows), OIM, Oracle AGILE, GRCC applications
Responsibilities/Implementations:

• Managed a team of 8 DBA’s for production support services (24X7) with SLA.
• Installs, configures, trouble-shoot, Upgrade, Security patch Oracle DB products.
• Performance tuning using ADDM & advisories for production databases.
• Implement/Test the HA (High availability), DR (Disaster Recovery) solutions.
• Upgrade from 10.2 to 11gr2
• Installed and configured the RAC-4 nodes, RAC-One-Node environments with ASM for development, test and production and scan listener technology.
• Monitoring, Tuning ETL data loads for data warehousing environments.
• Responsible for refreshing and cloning of databases using RMAN, Data Pump.
• Database provisioning with OIM (Oracle Identify Management) tool.
• Implementation & validation of SOX requirements for production databases.
• Work closely with Technology teams to help them with DB related operations.
• Installed and configured Web logic, Tomcat & patching for GRCC applications.

Confidential., NJ, USA & Hyderabad, India: July 2011 to February 2012

Job Role: Database Technical Lead (contract)
Technical Environment : Oracle 11G,10G RAC, RMAN, Oracle 11g, 10g, 9i and 8.1.7 Unix (Solaris, AIX, Linux , windows), Oracle Database upgrades.
Responsibilities/Implementations:

• Managed a team of 8 DBA’s for AXA databases upgrades/migrations.
• Database Upgrades from 10.2 to 11gr2, from 8.1.7 to 11gr2, from 9i to 11gr2.
• Database migrations from HP-UX, Solaris to Linux e4.
• Installs, configures, trouble-shoot, Upgrade, Security patch Oracle DB products.
• Responsible for ensuring high availability and performance of the databases.
• Design & implementation of the RMAN backups, HA (High availability), DR (Disaster Recovery) solutions & perform mock tests.
• Setup and configured RAC-2 nodes environments with ASM for development, test and production and scan listener technology.
• Implementation & validation of AXA security requirements for databases.
• Work closely with Technology teams to help them with DB related operations.

Confidential: January 2010 to June 2011

Job Role: Database Technical Lead (contract)
Technical Environment : Oracle 11G,10G RAC, RMAN, Oracle 11g, 10g, 9i and 8.1.7 Unix (Solaris, AIX, Linux , windows), Oracle Database upgrades, Erwin, Logical/Physical Data Models
Responsibilities/Implementations:

• Managed a team of 10 for Canada Life database upgrades & respective applications.
• Database Upgrades from 8.1.7 to 10gR2.
• Database migrations from Solaris to Linux e4.
• Installs, configures, trouble-shoot, Upgrade, Security patch Oracle DB products.
• Responsible for ensuring high availability and performance of the databases.
• Prepare a detailed high level plan to roll-out the complete Infrastructure upgrade.
• Develop and implement test plans for DB/applications & risk mitigation.
• Design and implementation of the RMAN backups, HA (High availability), DR (Disaster Recovery) solutions and perform mock tests.
• Implementation and validation of client security Standards for databases/applications.

Confidential: April 2008 to Dec 2010

Job Role: Senior Oracle DBA (contract)
Technical Environment: Oracle 10G, 9i, RMAN, UNIX SHELL scripting, HP-UX, TOAD, OEM, Logical & Physical Data Models, ER Diagrams
Responsibilities/Implementations:

• Production/QA/Dev databases support for Travel Impressions databases (24x7).
• Database Upgrades from 9i to 10g.
• Installs, configures, trouble-shoot, Upgrade, Security patch Oracle DB products.
• Deployment of high availability solutions with Data Guard.
• Configured OEM grid control for production monitoring.
• Creation of physical data model from Logical Data models.
• Responsible for ensuring high availability and performance of the databases (24X7).
• Implementation & validation of client security Standards for databases.

Confidential, MI, USA: July 2006 to March 2008

Job Role: Senior Oracle DBA (contract)
Technical Environment: Oracle 10G, 9i, RMAN, UNIX SHELL scripting, HP-UX, TOAD, OEM
Responsibilities/Implementations:

• Production/QA/Dev databases support for Delphi GES databases (24x7).
• Installs, configures, trouble-shoot, Upgrade, Security patch Oracle DB products.
• Deployment of high availability solutions with Data Guard.
• Configured OEM grid control for production monitoring.
• Performance and tuning with AWR reports for GES application issues.
• Responsible for ensuring high availability and performance of the databases.
• Implementation & validation of client security Standards for databases.
• Database refreshes from Production, and TeamCenter Enterprise adminitration.

Confidential: February 2005 to June 2006

Job Role: Oracle DBA (contract)
Technical Environment: Oracle 10G, 9i, RMAN, UNIX SHELL scripting, AIX, Remedy-BMC, TOAD, OEM, Multi-Master Replication, Table Partitioning Responsibilities/Implementations:

• Configure and monitor the replication activity for materialized view replication and multi-master replication setups for high availability of databases.
• Decommissioned the production database servers without any application services impact.
• Implement the database fail-over/disaster strategies as per the business continuity plans (BCP) with complaining the Deutsche Bank standards.
• Partitioned larger tables for performance improvement in production.
• Migrate/Upgrade the databases from Oracle 8.1.7.4 to Oracle 9.2.0.6
• Responsible for the change management processes as per defined standards for all database change requests (CR) for UAT and production databases.
• Monitoring scheduled scripts and outages for the databases.
• Provide first line support for Enterprise applications, troubleshoot and resolve the Oracle Database and application issues.
• Manage the Production, UAT, development database environments.
• Co-ordinating the development and testing of projects and migrating new software releases into Production.
• Participate in weekly users group meetings to provide recommendations/guidance regarding the database infrastructure details.
• Implements the disaster recovery tests for all mission critical applications and business continuity plans.
• Implements database security consistent with Deutsche Bank* security guidelines.

Confidential: January 2004 to January 2005

Job Role: Oracle DBA (contract)
Technical Environment: Oracle 9i, 8i, RMAN, UNIX SHELL scripting, Solaris, TOAD, OEM
Responsibilities/Implementations:

• Design & implement the backup strategy of hot backup
• Upgrade of databases from Oracle 8.1.7.4 to Oracle 9.2.0.6
• SQL query tuning based on stats-pack reports, and tuning memory structures.
• Index Maintenance – rebuilding indexes and stats collection for database / schema / object / partition level and scheduled during non-peak load hours.
• Restoration of test DB environment with latest hot backup available on production environment and automate the refresh process on weekly basis.
• Design the disaster recovery test strategy and execution of test plan.
• Creation of range partitions and splitting the tables.
• Monitor the database with alert management system.
• Implemented the data purge strategy on daily basis through UNIX shell scripts.
• Monitoring scheduled jobs and outages for databases.

Confidential: March 2003 to December 2003

Job Role: Jr Oracle DBA (contract)
Technical Environment: Oracle 9i, 8i, RMAN, UNIX SHELL scripting, Solaris, TOAD, OEM
Responsibilities/Implementations:

• Create users, objects, table spaces, data files for Oracle databases.
• Install/Configure Oracle 8i databases on Windows/UNIX environments.
• SQL query tuning based on stats-pack reports.
• Index Maintenance – rebuilding indexes and stats collection for database / schema / object / partition level and scheduled during non-peak load hours.
• Monitoring scheduled jobs and outages for databases.
• Tracking the Change Management, Release management processes.

Confidential: August 2001 to February 2003

Job Role: Jr Oracle DBA (contract)
Technical Environment: Oracle 9i, 8i, RMAN, UNIX SHELL scripting, Solaris, TOAD, OEM
Responsibilities/Implementations:

• Create users, objects, table spaces, data files for Oracle databases.
• Install/Configure Oracle 8i databases on Windows/UNIX environments.
• SQL query tuning based on stats-pack reports.
• Monitoring scheduled jobs and outages for databases.
• Optimising the queries by interacting with developers
• Tracking the Change Management, Release management processes.

Confidential: September 2000 to July 2001

Job Role: Java Programmer (contract)
Technical Environment: Oracle 8.0, Java, JSP Java, Servlets 
Responsibilities/Implementations:

• Development of java application using Java Technologies & Oracle database.