SUMMARY:

• Proficient in DBA activities such as plan, install, configure, creation, sizing, backup & recovery, security best practices and capacity planning on various platforms.
• Hands on experience in building Oracle RAC 11g/12c clusters/d atabase systems, maintenance, and Expdp/Impdp using Datapump and RMAN backup/recovery strategy.
• Extensive experience on Oracle 12c GI installation and Oracle database upgrades and patch updates.
• Expertise in setting up and configure Logical Standby, Physical Standby Active Data Guard Databases.
• Expertise in logical backups, RMAN Backups, Recovery & Cloning of databases.
• Experience in writing shell scripts to backup databases using RMAN and automate daily database activities.
• Developed/deployed unix scripts to send an email alerts for disk free space maintenance, crontab jobs, RMAN backups scripts, log file cleanup and critical state management.
• Extensive experience as Oracle Database Administrator, application/database performance tuner, data warehouse/transaction databases and system architecture specialist in Oracle 11g/12c.
• Automated database health check, backup maintenance and reports using UNIX scripts.
• Installed and administrate OEM Grid Control for DB monitoring / performance / diagnostics.
• Extensive experience in Oracle PL/SQL, Unix Shell Script, Clear Case, Clear Quest tools.
• Provided 24/7 on - call production support and monitoring databases.
• A result-oriented, reliable and competent DB administration with years of hands-on experience.
• Solid skills/knowledge on data modeling, ability to understand complex data relationships and proficient in writing PL/SQL Stored Procedures, Packages and performance tuning, debugging.
• Ability to work and manage projects independently, with a proven ability to meet and exceed set goals and deadlines.
• More than 16 years of IT experience that includes database administration (DBA), full life cycle development in high-end commercial and mission critical financial systems.

TECHNICAL SKILLS:

Database systems: Oracle RAC v12c/11g, OEM Grid Control, Sybase ASE v12.5.

Database tools: ASM, Data Guard, RMAN, Expdp/Impdp, SQL*Loader, Oracle Security, Oracle Net,SQL*NET, TOAD v9.5, SQL Developer, Datastage v7.5.

OS Platforms: Sun Solaris OS v11, RHEL Linux v7, Oracle Linux v7, Windows 2014 server.

Languages: UNIX (BASH/Ksh) Shell Scripting, PL/SQL, Transact SQL and XML Parsing.

Software: ERWin v7.3, S-Designor, Autosys v4.5, Java 2, PowerBuilder v7.x.

Enterprise Platform: J2EE, Oracle Web Logic, Jakarta Struts.

PROFESSIONAL EXPERIENCE:

Confidential

Consultant

Responsibilities:

• Installed, configured and maintained Oracle RAC clusters/databases in v11g/12c on Sun Solaris based servers, monitored and provided technical support for all supported user database systems.
• Established database backup/recovery strategy for different databases using RMAN scripts.
• Performed multiple RMAN database restores in all environments to meet customer requirements.
• Configured logical standby and e stablished physical standby databases using Active Data Guard for database disaster recovery (DR).
• Resolved database performance, database capacity issues, replication and other distributed data issues in multiple database environments.
• Performed database tuning by using Oracle OEM and AWR/ADDM, SQL Tuning Adviser tools.
• Provided solid technical solutions and support for the implementation and integration of a multiple systems.
• Setup standby databases using RMAN backup and restore in DR environment.
• Managed ETL, data conversion and migration as required achieving business objectives.
• Provided 24/7 DBA support to production database systems and applications.

Environment: Oracle RAC v12c/11g, ASM, Data Guard, RMAN scripts, Expdp/Impdp, Grid Control, Sun Solaris 10, AIX, RHEL v5.3, Bash-Shell (BASH), Toad v9.5.

Consultant

Responsibilities:

• Analyzed the data volume and created database schemas in the lower environments and worked closely with development team to create database deployment scripts.
• Refreshed data from production to test/development environment using import/export dump.
• Tuned the database using server parameters and analyzed the application SQL using explain plan, including table fragmentation tuning, partitioning the large table by date.
• Automated the statistics gathering using DBMS STATS package as a nightly jobs.
• Written data loader script, including ones to import data, transform and load using SQL*Loader as well as validation code using PL/SQL for data integrity.
• Designed and developed scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc
• Wrote SQL Queries and stored procedures. Worked on UNIX scripts to validate, schedule and run the jobs in Autosys environment.
• Created shell scripts to monitor the space utilization in UNIX as well as database.
• Provided 24/7 on-call support regarding production-related database problems.

Environment: Oracle 10g, RMAN, expdp/impdp, exp/imp, K-Shell (KSH), Clear Case and Clear Quest, Autosys v4.5, Sybase v12.5, Toad v9.5, Rapid SQL, Sun Solaris OS 5.8.

Technical Analyst

Responsibilities:

• Installed, configured and maintained Oracle database 10g, and upgraded Oracle 9i to Oracle 10g.
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Completed export and import of different databases using Oracle Export/Import utilities.
• Provided DBA support to development teams to various applications.
• Patched Oracle Database Server 9i and 10g using OPatch.
• Established database backup/recovery strategy for different databases.
• Developed scripts to monitor the storage usage, object status for daily job.

Environment: Oracle 9i/10g, Sun Solaris, K-Shell (KSH), Datastage v7.5, Sybase v12.5, Rapid SQL, Autosys, Clear Case, Clear Quest, Java J2EE, Windows XP/2000.