SUMMARY

• Overall 8 plus years of experience as Oracle DBA.
• Worked on 9i, 10g, 11g, R2, 12c Oracle databases.
• Worked on SQL Server 2008 & 2012 databases.
• Build 11g and 12c RAC.
• Worked very closely with SAN team for ASM.
• Worked on setting up DR with RMAN and Data Guard.
• Worked on Oracle GoldenGate for Uni and Bi - Directional Replication.
• Build 10g Grid Control and administer 12c Grid Control.
• Worked on Windows Server 2008, 2012.
• Worked on different flavors of UNIX, HPUX, AIX and Sun Solaris.
• Possess strong Administrative skills on RHEL.
• Installed and deployed RHEL from scratch.
• Worked with Developers to help tune databases.
• ASH / AWR ADDM / Stats pack / SQL Trace / tkprof / SQL Advisor.
• Performance Dashboard /Explain Plan /SQL Access Advisor Invisible Indexes.
• Automatic Memory Management / Good Understanding of Indexes.
• Worked on Back and Recovery using RMAN and User Managed Backups.
• Worked on Databases ranging from 100GB to 2.5 TB.
• Experience in on-call support and 24x7 DBA for production environment.
• Extensive experience on providing solutions to developer/user requests.
• Extensive experience in resolving issues and bugs related to databases.
• Proficient in performance and maintaining large volume of data.
• Setting up High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2 RAC environments with Back-end Exadata.
• Implement Oracle Goldengate replication.
• Performed database upgrades.
• Excellent command in creating Backups & Recovery procedures and Implementing BACKUP and RECOVERY strategies for hot and cold Backups.
• Migrated and Managed Databases on AWS.
• Migrated 12c to AWS RDS.
• Worked on AWS EC2 Servers.
• Build uni-directional GoldenGate replication.
• Hands on experience of database Backup and Recovery using RMAN.
• Strong experience in OEM Oracle Data Guard, SQL* Net, SQL Loader and SQL*PLUS, STATSPACK, Explain Plan and TOAD.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Experience in Application tuning using session trace file and TKPROF utility.
• Created and managed remote server for Materialize Views.
• Team Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists.

TECHNICAL SKILLS

Operating Systems: Linux, Windows, Solaris, AIX

RDBMS: Oracle 10g, 11g and 12c, SQL Server 2008 & 2012

High Availability: RAC, Data Guard, ASM, GoldenGate, Materialize Views, RAID

Languages: SQL, PL/SQL, Shell Scripts

Tools: RMAN, OEM, SQL*Loader, exp, imp, expdp, impdp, ERWIN, TOAD

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, SQL Advisor

Database Modeling: Erwin 4.0, TOAD

Web Server/Tools: IIS, WebSphere, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Oracle DBA

Responsibilities:

• Upgrade Database to 11g to 12c.
• Migrate database from 12c standalone servers to 4-node RAC.
• Maintained and centralize inventory of all databases / servers.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Performed schema and table refreshes from production using data pump.
• Responsible for new Installations of 11g R2 Oracle RAC, ASM.
• Managed 40 TB databases.
• Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective management of Locally Managed Tablespaces.
• Administered and managed GoldenGate.
• Data compression, Block level, table level, RMAN level compression.
• Using Data Pump to copy data across different platform.
• Improved performance of replicat process using Range functions in GoldenGate.
• Database backup using RMAN for hot backup and through scripts for cold backup.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for higher to lower environment.
• Installed, migrated and tested Oracle 11gdatabases in various environments.
• Worked on Active Data Guard and managed Standby with Data Broker.
• Written and modified scripts to automate cron jobs.
• Provided 24/7 support.
• Used Data Pump to refresh databases.
• Used Export Import to refresh schema objects.
• Managed database on SQL Server.
• Restored and recover databases on SQL Server.

Confidential, Hartford, CT

Oracle DBA

Responsibilities:

• Supported more than 30 databases including development/production.
• Designed, Installed and configured the Oracle server software and related products. Upgraded 30+ databases from 9.2.0.6 to 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL and AIX.
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Primary DBA for 1GB - 2.5TB database for 24/7 support.
• Upgrade Data warehouse Database from 8K block size to 32K block size to optimize performance.
• Worked on OLTP and Data warehouse farms.
• Refreshed multiple databases for Development and Testing upon short request.
• Served as part of a 7 member DBA team which was involved in the maintenance of the Oracle 9i/10g database for the Production as well as the development environments.
• Actively involved in designing/Testing of Disaster Crash recovery.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on 9i and on 10g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery through RMAN.

Confidential, CA

Jr. Oracle DBA

Responsibilities:

• Run scripts
• Install databases
• Troubleshoot network issues.
• Help developers
• Write scripts
• Write documentation
• User creation
• User management
• Automate jobs
• Install agents
• Worked on 9i and 10g databases
• User deletion
• CPU Patching
• Work on backups using user managed and RMAN