SUMMARY:

• Certified Oracle Professional having more than 13 years of experience with proven expertise in installing, creating, configuring and optimizing databases in version 8i/9i/10g/11g and 12c.
• Experience supporting High Availability solutions like RAC, Data Guard, ASM, OEM, backup and recovery Solution (RMAN),
• Installation and configuration of Oracle Server (12c, 11g, 10g, 9i, 8i) on IBM AIX, HP - UX, Sun Solaris, Linux and Windows servers in production and development.
• Installation and configuration of SQL Server (2008R2, 2012 and 2014)
• Install and configure of MySql database for OLTP applications.
• Archival of data using transportable tablespace
• Supported multiple Datacenter Migrations of production, test and development oracle databases.
• Migrating Non-ASM Instance to ASM Instance.
• Supporting Data Warehouse Databases, implement features like partitioning, compression, parallel processing, sql hints, outlines, block change tracking and monitor ETL jobs.
• Proficiency in handling Very Large Database (VLDB of around 70 Tb) and OLTP environment supporting Siebel and Weblogic applications.
• Implemented data security controls using fine grained auditing and data encryptions
• Proficiency in space management and capacity planning.
• Developed Shell Scripts to Automate RMAN Backups, Hot/Cold backups, Imp/Exp, Datapump, Dump and Schema Refresh, and Production to Dev/Stage Sync up, SQL*Loader calls etc and scheduling on crontab/dbms scheduler.
• Expertise in Database Performance Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Created PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in configuring and managing Oracle GoldenGate Replication environment.
• Ability to Work in 24x7 production environment and provide on-call and day-to-day support.
• Excellent communication, organizational, time management and support skills.
• Good Team player with a willingness to learn new concepts and ability to work individually and work as part of a team.
• Industry Experience: Telecommunication and Child Support.

TECHNICAL SKILLS:

Database Tools: Toad, Erwin, SQL Developer, SQL*Plus, SQL*Loader, OEM, RMAN, exp/imp, expdp/impdp, CRSCTL, SRVCTL, OCRCONFIG, OCRDUMP, DBCA, netMgr, ASMCA, TKProf

Languages: SQL, PL/SQL, T-Sql, Unix Shell Script, Sed, AWK, Powershell

Databases: Oracle 12c/11g/10g/9i/8i, RAC, Data Guard, ASM, SQL Server 2014/2012/2008 R2, MySql, GoldenGate Replication.

Operating Systems: Solaris, HP-Unix, AIX, Linux and Windows

Software: MS Word, MS Excel, MS Visual SourceSafe, MS Visio, MS Outlook, SVN, TFS

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Install, Update and configure Oracle 11g and 12c environments.
• Support Oracle 11g and 12c RAC Databases on ASM
• Install and configure Microsoft SQL Server 2008 R2, 2012 and 2014 environments
• Performance Tuning of Sql, Pl/Sql and T-Sql code
• Install and configure MySql database for online applications
• Setup Physical Standby Database for testing environment
• Setup SQL Server 2014 Always On
• Complete ownership of the development, test and production Oracle Forms and Reports Application
• Perform code deployment and application maintenance for Development, Testing and Production region.
• Upgrade and apply Oracle/SQL Server Patches.
• Implement partition techniques to improve job performance
• Secure databases by implementing TDE
• Backup and Recovery using RMAN and Data Pump exports/imports
• Data load automation using SQL Loader and bcp loads
• Setup Open LDAP for centralized TNS configuration
• Develop Unix shell script and Powershell script for automating tasks.

Environment: Oracle Forms and Report 11G, Oracle RAC Database 11g, SQL Server 2008R2/2012/2014, MySql v5.7, Data Guard, Always On, Red Hat Linux, Windows XP, Korn Shell, SQL, PLSQL Confidential - POH

Sr. Oracle DBA

Responsibilities:

• Migrate from single instance to 3 node Oracle 11G RAC database using ASM storage
• Support production installation of release changes.
• Capacity planning and Storage maintenance.
• Adding additional disks, creating diskgroups and allocating space to RAC database.
• Participate in the release cycle. Prepare design document. Review code and implementation steps.
• Support OS patch install.
• Develop data archival job using pl/sql and schedule them in database using dbms scheduler.
• Create partitions to archive historical data.
• Support the Migration of over 400 million Boost pins to POH database, requiring development in Pl/Sql and shell script.
• Implementation of logon triggers for logging db access.
• Tuning sql and pl/sql code. Using dynamic sql, bulk insert/update and collections.
• Capture session trace, analyze tkprof output and provide tuning recommendations.
• Configure GoldenGate Replication
• 24/7 on call support for the production server issues.

Environment: Oracle 11G RAC, ASM, SQL Developer, AIX, Windows XP, Korn Shell, SQL, Plsql, HP Service Manager

Confidential

DBA Lead

Responsibilities:

• Complete ownership of the Development, Test and Production Databases providing 24X7 on call rotation support.
• Upgrading database from Oracle 10G to Oracle 11G
• Apply PSU and one off patches as recommended by Oracle.
• Capacity Planning, user management, monitor ETL jobs, dbms jobs, mview refreshes, identify and tune sql’s
• Frequent review of AWR's to identify potential bottlenecks and take appropriate actions.
• Participate in the development release cycle.
• Review code and implementation steps, provide tuning recommendations.
• Support Server Upgrade and migration of Databases to new server.
• Create new databases as part of the project.
• Support the Migration of 9 Million customer accounts from Confidential to Confidential .
• Lead and Support the team in data center migration of databases from IBM Boulder data center to Confidential data center.
• Decommission the databases post data center migration.
• Participate in the Audits and compliance activities
• Work on production tickets created on HP Service Manager and ensure they are addressed within SLA.
• Perform RCA for critical production issues.
• Work with Oracle Support for resolving any issues using Oracle SR.

Environment: Oracle 9i, 10g, 11G, Oracle 9i RAC, Toad, Solaris, AIX, Windows XP, Korn Shell, SQL, Plsql, HP Service Manager

Confidential

DBA Lead

Responsibilities:

• As part of IT contract between IBM and Confidential, support the transition of DBA activities from Confidential to IBM Team Confidential US and India.
• Support data center migration of all Databases and Applications from Tulsa and Rancho to IBM data center Confidential Boulder.
• Responsible for all end to end technical activities starting with day-to-day ETL job monitoring, user management, space management, database creations, backup and recovery, migration, upgrade etc.
• Performing monthly maintenance activities such analyzing data growth and setting up data archival, creating partitions for the month, analyzing the performance using AWR and planning for the future improvements.
• Work on production tickets created on Maximo and ensure they are addressed within SLA.
• Perform RCA for critical production issues.
• Upgrading database from Oracle 10G to Oracle 11G.
• Apply PSU and one off patches as recommended by Oracle.
• Participate in project discussions, review application code, and provide tuning suggestions, review release implementation plans and support production implementation of application release.
• Participate in weekly data meeting with the client for addressing the business data related issues raised by the client and business users.
• Develop and automate regular DBA tasks like archival, exports, stats capture etc; using Pl/Sql and Shell script.
• Participate in the Audits and compliance activities
• Work with Oracle Support for resolving any issues using Oracle SR.
• Mentor/Train DBA team members, both onsite and offshore.

Environment: Oracle 9i, 10g, 11G, Oracle 9i RAC, Toad, Solaris, AIX, Windows XP, Korn Shell, SQL, Plsql, Maximo.

Confidential

Pl/Sql Developer

Responsibilities:

• Attend project discussions and code using Pl/Sql
• Develop sqlldr and shell script to automate the DBA tasks
• Prepare and perform Unit Testing
• Participate in weekly team meeting
• Work closely with testing team during system/integration testing.
• Performance tuning of Pl/Sql code

Environment: Oracle 10g, Solaris, Windows XP, Korn Shell, SQL, Plsql

Confidential

DBA

Responsibilities:

• Complete ownership of the Development and Test Database.
• Performance tuning and Shell scripting for monitoring database.
• Migration of Database from 9.2.0.4 to 9.2.0.7
• Implemented Basic replication through Materialized Views
• Upgrading the database from Oracle 8.1.7 to Oracle 9.2.0.7.
• Upgrade from Oracle 9i RAC to Oracle 10G RAC
• Implementation of triggers to maintain history of the data updates.
• Support OS patch install.
• Work with Oracle Support for resolving any issues using Oracle SR.
• Participate in weekly team meeting

Environment: Oracle 8i, 9i, 10G. Oracle RAC 9i, 10G, Solaris, Windows XP, Korn Shell, SQL, Plsql