SUMMARY:

• Over 5+ years of experience as Oracle Database Administrator, have hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle Software 12c/11g/10g/9i on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows platform
• 2+ years of experience as SQL database administrator handling the SQL database installations for SQL 2003, 2005, 2008 databases, database backups and restores and handling disk space alerts.
• Expertise level experience in both production and development environments involving 9i/10g/11g/12c databases on multiple platforms like, HP-UX, Sun Solaris, IBM-AIX, Red Hat Linux and Windows platforms
• Experience in backup & recovery, disaster recovery options and Oracle Recovery Manager (RMAN)
• Expertise in installing and configuring ASM and RAC for high availability databases.
• Experience in handling PostgreSQL databases.
• Performed strategic planning, logical and physical data modeling & application tuning
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Excellent knowledge in hot/cold backup and recovery and cloning of databases using RMAN.
• Involved in designing of disaster recovery using Data Guard, High Availability on multiple RAC systems.
• Solid experience on Oracle Enterprise Manager (OEM 12c and OEM 13c), Grid Control, Configuring OEM 12c and OEM 13c agents, Upgrading OEM agents from OEM 12c to OEM 13c.
• Experience in proprietary change management processes to prevent production disruptions and outages, following the ITIL processes.
• Cloned database from production to test and development and from development to production
• Experience in migration of Oracle database to higher version and installing patches. Experience in Data Migration for Oracle databases from 12c/11g/10g to other versions.
• Experience in SQL tuning and base line tuning
• Experience in working with Oracle Virtual Machine
• Experience in quality support and delivery to the end-user
• Exporting and importing of dumps using expdp and impdp commands.
• Experience on handling databases sized 800 GB to a max of 5.8 TB
• Experience in performance tuning issues using AWR and ADDM Reports
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10g OEM Grid Monitoring custom scripts troubleshooting Oracle databases using SQLTrace utilities
• Data loading using SQL*LOADER, Logical backups using full export and data pump.
• Responsible for interacting with business partners to identify information needs and business requirements.
• Worked on different types of storage structures (SAN/NAS)
• Possess technical ability and self-initiative to learn and implement new concepts in short duration

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 2.x/8/9/10, HP-UX 10.x/11.x, Red Hat Linux, RHEL 2.1, 3.x, 4.x, 5.x, UNIX, MS-DOS, Windows 95/98/XP/7.

RDBMS: Oracle 12c/11g/10g/ 9i. SQL Server 2003/2005/2008.

Applications: Toad, SQL Developer, VERITAS Net Backup.

Oracle Tools: SQL *PLUS, OEM, RMAN, SQL *LOADER, Import/Export, Data pump, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

Replication Tools: Delphix, Golden Gate, Snap Management Utility, RMAN

Languages: SQL, PL/SQL, Shell Scripting, PERL, C

PROFESSIONAL EXPERIENCE:

Confidential, Coppell, TX

IT Operations Analyst II

• Create and administer Oracle databases (both RAC and non-RAC).
• Work with Linux, kernel parameters, OS packages, shell scripting, etc.
• Investigate, troubleshoot and solve performance issues.
• Extensive knowledge of physical database design.
• Strong knowledge of Oracle Real Application Clusters on Linux. Knowledgeable in tuning and debugging and be able to generate reports.
• Perform backup/restore using export/import and RMAN.
• Perform Installs, Security Patching, and Database Upgrades.
• Work with the existing DBAs and other IT teams to debug and resolve critical issues and proactively communicate status to management.
• Work with Oracle Support Services to resolve issues and become familiar with Oracle’s escalation procedures to use as needed.
• Administration of Oracle Enterprise Manager Grid Control.
• Experience with PL/SQL, SQL Plus, CRON, stored procedures/packages, import/export, database administration and replication, shell scripting. Linux experience. SAN / NAS experience. Grid control experience. Virtualization experience (VMware).
• Golden Gate Deployment, Administration, and Support.
• Expertise in Shell scripting/RMAN Scripting
• Worked on few PostgreSQL databases and supported their maintenance activities.
• Design an effective test plan for any new / changed customer-servicing infrastructure.
• Develop full suite of documentation as it relates to the customer-servicing database infrastructure (Work Plans, Standards, policies and procedures, etc.).
• Support identification and collection of metrics and performance reporting processes.
• Identify process improvement areas and develop the improvement initiatives.
• Delphix Replication, Maintenance, Administration and Support.
• Develop database and system performance tools and integrate them into the existing infrastructure.
• Snap Management Utility Setup, Maintenance, Administration and Support.
• Experience in Index and Query tuning and performance tuning in general.
• Conduct ongoing capacity planning for production database environment to include growth projections and disk space reclamation; query performance tuning of existing applications, etc.
• Follow defined ITIL processes for Change, Incident, and Problem Management.
• Participate in on call rotation with the team.

Environment: Oracle 9i, 10g, 11g, 12c, Oracle RAC, PL/SQL, SQL*Loader, TOAD, OEM, Shell Scripting, Golden Gate, Data Pump Import / Export, Oracle Enterprise Manager OEM 11g and OEM 12c, RMAN Backup, Snap Management Utility SMU, AWR Reports, Delphix and PostgreSQL.

Confidential, Louisville, KY

Sr. Database Admin

• Create and administer Oracle databases (both RAC and non-RAC).
• Work with Linux, kernel parameters, OS packages, shell scripting, etc.
• Responsible for implementing Oracle standards and design of physical data storage, maintenance, access and security administration
• Investigate and solve performance issues.
• Proficiency with Data Guard, ASM, RMAN, and Enterprise Manager preferred
• Strong SQL skills including the ability to rewrite complex queries to improve performance
• Perform backup/restore using export/import and RMAN.
• Serves as SME in all aspects of Oracle data management and physical database design.
• Define and manage processes to proactively monitor & identify database performance, capacity & resiliency issues and develop database resource optimization & growth projections and recommendations.
• Responsible for implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also using RMAN. Developed, tested & implemented strong backup and recovery strategy. Also responsible for monitoring backups.
• Perform Installs, Security Patching, and Database Upgrades.
• Administration of Oracle Enterprise Manager Grid Control.
• Golden Gate Deployment, Administration, and Support.
• Analyzing existing database applications for improvements, database tuning and monitoring
• Follow defined ITIL processes for Change, Incident, and Problem Management.
• Participate in on call rotation with the team.

Environment: Oracle 9i, 10g, 11g, 12c, Oracle RAC, PL/SQL, SQL*Loader, TOAD, OEM, Shell Scripting, Golden Gate, Data Pump Import / Export, Oracle Enterprise Manager OEM 11g and OEM 12c, RMAN Backup, Snap Management Utility SMU, AWR Reports.

Confidential, Memphis, TN

Database Administrator

• Configuration, installation and maintenance of Oracle 11g RAC databases including ASM and CRS.
• Perform upgrades from Oracle 10g to 11g and applied patches.
• Work on project as Oracle Core DBA. Planning and scheduling backups, database recovery, taking logical backups (with export /import), and database backup (hot & cold).
• Responsible for DBA functions and ETL development in data warehousing.
• Design reports and perform various DBA roles in data warehousing.
• Work on features: Data Pump, ASM and RMAN. Data Base Recovery (complete & incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Perform production change requests for PRD major DB changes. New DB creation, existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC on a test basis.
• Administration of all database objects, including tables, indexes, views, sequences, packages and procedures.
• Experience in planning database, sizing table space, create database, scripts, monitor databases, interact with developers, Oracle install, Upgrade, 24/7 production support.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Adding the required user logins, groups and users, granting and revoking permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in performance and tuning databases using various techniques. Collect performance statistics memory usage, data storage.
• Experience in data migration with Oracle 10g and 11g.
• Experience in proprietary change management processes to prevent production disruptions and outages.
• Experience in implement a variety of solutions for improving the availability, accessibility, performance, and integration of critical data across the enterprise with Golden Gate.
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers.
• Created cluster database, cloning of cluster database on Linux, start and stop cluster database services.
• Experience to continuous availability and disaster tolerance of critical data systems is more than “after-the-fact” data recovery by using Golden Gate.
• Experience in quality support and delivery to the end-user.
• Design and develop database structures (database triggers, procedures, functions to implement business rules). Loaded data into database using external tables.
• Exposure to Oracle utilities and tools such as OEM, Import-Export, Auditing, RMAN.

Environment: Operating Systems: IBM-AIX, SunSparcSolaris64bit, and Red Hat Linux.

RDBMS: Oracle Database Server 10g/11g, Golden Gate, Programming Language/Tools: TOAD, PL/SQL.

Confidential, Memphis, TN

Database Administrator

• Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).
• Implemented Grid based monitoring solution for large databases and installation of cluster ware, configuring public, private and VIP.
• Worked with a team of DBAs to migrate multiple corporate databases & application from 10g to 11gR2, with post go-live stabilization.
• Involved in implementing load balancing and testing failover on 3 node RAC Database.
• Created materialized views on big tables and enabled the auditing on few tables in production.
• Created physical standby database using Data guard. Implemented switch the standby to read only mode for reporting purpose during business hours and switch to recovery mode at night to apply the logs.
• Extensively worked in various areas of Data guard i.e. installation, recovery, RTA (Real Time Apply), patching, tuning, switchover, switchback and failover.
• Implemented, and configured 10g grid control and 11g grid control on RHEL.
• Implemented flashback recovery for Oracle 11g databases to help recover data in many systems.
• Performed logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs ( Cron Jobs).
• Responsible for creating RMAN catalog database and registering the databases in catalog database and cloned production RAC instances to development and QA systems using RMAN duplication.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using basic replication using materialized views.
• Experience in using 10g features such as data pump, flash back recovery, ASM, AWR, and ADDM.
• Implemented partitioned tables for regional data in centralized data warehouse for better performance.
• Applied patches to Oracle databases accessed by various applications.
• Performed database cloning to setup test and development database.
• Wrote and modified Shell Scripts, Perl Scripts to manage Oracle environments and for Backend Oracle Processes.
• Used Impdp / Expdp and SQL- loader to load data into tables.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Provided support to Application Database Administrators in designing the database.
• Implemented stored procedures and triggers based on business plans using PL/SQL.
• Responsible for all database activities such as User management, space management, database security management.
• Configuring TNSNAMES.ORA, LISTENER.ORA for SQL *NET connectivity.
• Troubleshoot errors that occur on a daily basis and resolved problems quickly and efficiently and giving suggestions to developers when they are required for tuning the code to maximize performance of the database.
• On-call support regarding production - related database problems is performed.

Environment: Oracle 9i/10g/11g, Red Hat Linux 5.5, Sun Solaris, AIX, HP-UX, OEM GC, TOAD, RAC, ASM, RMAN, VERITAS, Explain Plan (10046), Data Pump, STATSPACK, AWR, ADDM, TKPROF, Oracle Replication, Data Guard, Golden Gate, PL/SQL, T-SQL, SQL*Loader, SQL Server 2005, HPDP, Erwin, SFTP.

Confidential, NJ

Oracle DBA

• 24/7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installation, maintenance and tuning of RAC and standby databases OLTP, DSS and data warehousing using customized Shell Scripts and Stepwise.
• Involved in designing of disaster recovery using Data Guard, High Availability using 10g RAC.
• Migration of Oracle databases from Windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgrade development and production databases to Oracle 10g.
• Proactive database monitoring using 10g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Extensive performance tuning, memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed hot, cold and logical backups and performed backup validations using RMAN.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn Shell Scripting and SQL*Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Performed other DBA activities including space management and performance monitoring.
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN .
• Configured Oracle Data Guard and Streams.

Environment: Windows 2000/2003/XP Oracle 10gRAC, 9i,Dataguard, RMAN, SQL Server 2005, Red Hat Linux 5.0, Sun Solaris 9,10, UNIX Scripting, PL/SQL, ASM, TKPROF, Explain plan, AWR, ADDM Partitioning, Grid Control/OEM, Bugzilla.

Confidential

Oracle DBA

• Ensuring the database is running at optimum speed and efficiency
• Responding quickly to refresh data; verifying implementation of correct backup strategy
• Developing recovery procedures
• Supporting recovery from loss of data caused by user or system error
• Automating procedures at regular intervals
• Using tools to reorganize or defragment database table spaces, tables and indexes
• Providing efficient database environment to maximize productivity and improve performance
• Refreshing data from one environment to another at the request of the application development staff
• Providing application development staff optimal development environment with current data
• Researching and recommending optimal design criteria
• Publishing standards and working with development staff
• Standardizing environment and improve efficiency
• Monitoring file system space, database allocation, etc.
• Verifying efficient use of disk storage
• Reclaiming dead space
• Optimizing space allocation and avoiding out-of-space conditions
• Following rules, procedures and standards for the access and maintenance of shared data resources
• Communicating complex technical information in a concise and articulate manner
• Participating in the evaluation and recommendation of DBA tools and new DBMS technologies
• Being responsible for the integrity of production test and QA database environments
• Developing utilities for monitoring and evaluating data quality
• Assisting in the definition and development of database documentation and standards
• Conducting application transaction volume and traffic analysis and interpreting impact on database and network performance

Environment: Windows 2000/2003/XP Oracle 10gRAC, 9i,Dataguard, RMAN, SQL Server 2005, Red Hat Linux 5.0, Sun Solaris 9,10, UNIX Scripting, PL/SQL, ASM, TKPROF, Explain plan, AWR, ADDM Partitioning, Grid Control/OEM, Bugzilla.