SUMMARY

• Results oriented Certified Oracle DBA having over 10 years of experience in database administration, system maintenance, production support, RAC, performance tuning, standby, replication, space management installation, migration, backup recovery, cloning and database security.
• Worked as a dedicated team member responsible for monitoring/support of Oracle databases performing release upgrades including overall performance tuning/patch management.
• Documented all technical details including operations, maintenance and end user application issues.
• Expertise in Redhat Linux server support.
• Upgrading Exadata environment
• Maintaining Exadata hardware
• Configure, Maintaining and troubleshooting Exadata Cell disk/Grid Disks
• Troubleshooting Exadata smartscan/offloading issues
• Excellent experience in installation and configuration of Oracle 9i, 10g, 11g on Sun Solaris AIX, UNIX/LINUX, HP - UX and Windows environment.
• Synch up database environments (Development, QA) after each major release or production change.
• Implemented a 2 node 10g RAC cluster on a Linux platform.
• Co-ordinate with UNIX Administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers.
• Excellent knowledge in hot/cold backup and recovery and cloning of databases using RMAN.
• Utilized new features with oracle 12c, especially multi-tenancy, ASM and data guard.
• Installation and configuration, maintenance for Oracle Golden Gate.
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Resolved replication issues in Golden Gate.
• Upgraded Oracle Golden gate v10 to v11
• Troubleshooting and fixing Golden gate errors in a 2 node RAC production environment
• Prepare Golden Gate parameter files for Extraction and Replication
• Established standby/cloned database via Data Guard for database disaster recovery.
• Employed predefined UNIX scripts to cleanup database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories.
• Troubleshot and configured Sql*Net files according to client and server settings to transfer data.
• Worked on export/import, data pump and SQL Loader.
• Process/workflow analysis, project management from analysis and design to implementation.
• Conceptual data modeling, logical and physical data modeling.
• Analyze the performance issue with help of ADDM, AWR report.
• Hands on experience with Red Hat HA Cluster configuration and solution level.
• Extensive performance tuning experience, specializing in operating system tuning, SQL tuning, database/instance tuning.
• Delivering Oracle database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.
• Good experience in SQL, PL/SQL, shell scripting, partitioning, data modeling, OLAP, logical and physical standby databases, backup and recovery procedures.
• Worked closely with the application development team for bug fixes and escalation of critical issues.
• Expertise in maintaining database security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*Loader.
• Worked with team of DBAs in migration of databases from oracle 10g to Oracle 11g.
• Configuration management has worked along with day to activities
• Handled supervisory duty more than 20 DBA’s along with process management.
• Oracle security experience both banking domain projects.
• Worked on Oracle Audit vault for security encryption data.
• Managed with separate user for Audit vault and configured steps along TNS service.
• Have written PL/SQL store procedures and Function
• Modified the PL/SQL and troubleshoot fixes the issue when it is required.
• Understanding of the software development lifecycle process (SDLC) and which covers ITIL process. This contains how to deliver the project.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris, AIX, Red Hat Linux Windows NT/2000

RDBMS: Oracle 11g/10g/9i

DB Management: TOAD, OEM

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Query builder, Net Backup

Tuning Tools: Tkprof, Explain Plan, StatsPack

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Install 11g databases on Linux, apply patches in various environments and upgrade databases from 10.2.0.1 to 11.1.0.
• Functional tests and performance tests with real life data load associating with test team.
• Expertise in Redhat Linux server support.
• Installation and configuration, maintenance for Oracle Golden Gate.
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Resolved replication issues in Golden Gate.
• Upgraded Oracle Goldengate v10 to v11
• Troubleshooting and fixing Goldengate errors in a 2 node RAC production environment
• Support and maintain the ERP and other internal programs and databases. Understand business processes,
• Analyze and correct end user issues.
• Analyze the performance issue with help of ADDM, AWR report.
• Utilized new features with oracle 12c, especially multi-tenancy, ASM and data guard.
• Upgrading Exadata environment
• Maintaining Exadata hardware
• Configure, Maintaining and troubleshooting Exadata Cell disk/Grid Disks
• Troubleshooting Exadata smartscan/offloading issues
• Design, develop, implement, modify and maintain complex business database applications to support requirements of end users.
• Creates, monitors, and maintains Oracle databases, applies patches as needed.
• Hands on experience with Red Hat HA Cluster configuration and solution level.
• Configures Oracle environment to efficiently support ERP and business needs, performs database backup and recovery.
• Remain current on database and technology advancements. Recommend new technologies as warranted.
• Database scripting and data updates.
• Oracle RAC supports for oracle 10g and 11g
• RMAN backups and recovery for 10g and 11g.
• Document requirements, code programs, prepare test data, test and debug programs.
• Analyze data; create and analyze reports.
• Supporting Oracle OEM 12c for all reporting and alerting systems
• I use OEM mostly performance issues
• Prepare application documentation.
• Consult with software and hardware vendors and internal business users to research and identify opportunities for system and process improvements.
• Work independently or in a team environment
• Modify and develop new SQL codes to develop new enhancements.
• Implement Oracle and application software patches.
• Assist development team, manage SQL queries, enhance and support service issues.
• Plan backup/restoration strategy, plan and schedule backups, taking logical backups with export/import utilities.
• Database backup and recovery using RMAN written scripts to perform automatic full and incremental backup.
• Tune backup for performance by parallelizing channel allocation. Perform complete and incomplete recovery using RMAN.
• Worked on Oracle Audit vault for security encryption data.
• Managed with separate user for Audit vault and configured steps along TNS service.
• Database tuning - tuning applications, memory tuning and tuning disk usage.
• Develop/customize UNIX shell scripts to automate routine DBA tasks like monitoring space and memory requirements and memory tuning.
• Check alert logs, archive logs, trace files and to work proactively on alerts for the file system and CPU issues.
• Understanding of the software development lifecycle process (SDLC) and which covers ITIL process. This contains how to deliver the project.

Environment: Oracle 10g,11g, OEM, RMAN, DBUA, TOAD, Oracle Grid Control, AWR, UNIX, Red Hat Linux, AIX, Golden Gate

Confidential, North Carolina

Oracle DBA

Responsibilities:

• Install 11g databases on Linux, apply patches in various environments and upgrade databases from 10.2.0.1 to 11.1.0.
• Functional tests and performance tests with real life data load associating with test team.
• Support and maintain the ERP and other internal programs and databases. Understand business processes,
• Analyze and correct end user issues.
• Design, develop, implement, modify and maintain complex business database applications to support requirements of end users.
• Creates, monitors, and maintains Oracle databases, applies patches as needed.
• Configures Oracle environment to efficiently support ERP and business needs, performs database backup and recovery.
• Remain current on database and technology advancements. Recommend new technologies as warranted.
• Database scripting and data updates.
• Document requirements, code programs, prepare test data, test and debug programs.
• Analyze data; create and analyze reports.
• Analyze the performance issue with help of ADDM, AWR report.
• Supporting Oracle OEM 12c.
• Prepare application documentation.
• Consult with software and hardware vendors and internal business users to research and identify opportunities for system and process improvements.
• Work independently or in a team environment
• Modify and develop new SQL codes to develop new enhancements.
• Implement Oracle and application software patches.
• Assist development team, manage SQL queries, enhance and support service issues.
• Plan backup/restoration strategy, plan and schedule backups, taking logical backups with export/import utilities.
• Database backup and recovery using RMAN written scripts to perform automatic full and incremental backup.
• Tune backup for performance by parallelizing channel allocation. Perform complete and incomplete recovery using RMAN.
• Database tuning - tuning applications, memory tuning and tuning disk usage.
• Develop/customize UNIX shell scripts to automate routine DBA tasks like monitoring space and memory requirements and memory tuning.
• Check alert logs, archive logs, trace files and to work proactively on alerts for the file system and CPU issues.
• Understanding of the software development lifecycle process (SDLC) and which covers ITIL process. This contains how to deliver the project.

Environment: Oracle 10g,11g, OEM, RMAN, DBUA, TOAD, Oracle Grid Control, AWR, UNIX, Sun Solaris, Red Hat Linux, AIX

Confidential - Seattle, WA

Oracle DBA

Responsibilities:

• Install 11g databases on Linux, apply patches in various environments and upgrade databases from 10.2.0.1 to 11.1.0.
• Functional tests and performance tests with real life data load associating with test team.
• Attend meetings regarding up gradation project and give different recommendations as to how to make faster upgrades to make less database down time.
• Implementation and loading of data from various modules.
• Support and maintenance of 6 production/development databases on various servers with volume ranging from 1 to 2 terabytes databases
• Create PL/SQL functions to facilitate business function and calculations.
• Modify and develop new SQL codes to develop new enhancements.
• Implement Oracle and application software patches.
• Assist development team, manage SQL queries, enhance and support service issues.
• Plan backup/restoration strategy, plan and schedule backups, taking logical backups with export/import utilities.
• Database backup and recovery using RMAN written scripts to perform automatic full and incremental backup.
• Tune backup for performance by parallelizing channel allocation. Perform complete and incomplete recovery using RMAN.
• Database tuning - tuning applications, memory tuning and tuning disk usage.
• Develop/customize UNIX shell scripts to automate routine DBA tasks like monitoring space and memory requirements and memory tuning.
• Check alert logs, archive logs, trace files and to work proactively on alerts for the file system and CPU issues.

Environment: Oracle 10g,11g, OEM, RMAN, DBUA, TOAD, Oracle Grid Control, AWR, UNIX, Sun Solaris, Red Hat Linux, AIX

Confidential

Oracle DBA

Responsibilities:

• Provided Development DBA support for Developer queries and requests, which included query tuning, server tuning, identifying problematic code, etc.
• Developed new scripts to monitor the oracle database processes, user processes and log file monitoring.
• Suggested and improved system design and architecture, included building new Oracle 10g/11g RAC databases, ASM physical and standby systems, enabling LDAP authentication and configuring RMAN backups.
• Coordinated capacity planning through in-depth trend analysis to calculate space utilization, application growth, and projected database sizing.
• Provided ongoing support of production database environment, space projection and reclamation, query performance tuning of existing applications.
• Installed, configured and tuned Oracle 10g/11g databases.
• Migrated existing Development and Test 10gR2 environment databases to Oracle 11g databases.
• Analyze the performance issue with help of ADDM, AWR report.
• Patched Oracle production RAC databases hosted on Linux environment.
• Monitored operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like SAR, VMSTAT, IOSTAT and TOP.
• Worked with Oracle support services to resolve issues, and applied Oracle escalation procedures to use as needed, followed by standard built documentation and best practices as well refined these based on experience and new findings from database vendors.
• Responded to all database alerts, warnings, and errors in a timely, consistent manner.
• Escalated complex issues to internal team members and third party group members as appropriate.

Environment: Oracle 10g/11g/9i, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, RMAN, TKPROF, StatsPack, SQL* Loader, DBArtisan

Confidential

Oracle DBA

Responsibilities:

• Implemented database monitoring, tuning application queries using TKPROF, Explain Plan OEM and custom scripts for optimum performance within testing, development and production environments.
• Prepared systems for upgrading from 9.2.0.3 to 10.2.0.3.
• Installed and configured Oracle 11g/10g RAC--4 node cluster with OCFS2 on AIX and Linux using ASM storage for testing and development.
• Installed, configured and maintained Oracle RDBMS Software and tools on HP/UX, AIX, Linux.
• Helped implement and maintain disaster recovery and archiving procedures for data.
• Aided system administration in UNIX disk implementation and management.
• Implemented database management strategy and performed full, incremental and cumulative backups using RMAN utilizing the recommended backup strategy through grid control.
• Successfully planned, implemented and upgraded database management system from Oracle 8i, version 8.1 to Oracle 9i, version 9.2 using Oracle Data Migration Assistant and Oracle upgrade checklist.
• Created PL/SQL code standards for company wide use, which were highly appreciated by the client.
• Evaluated design, quality, stability and maintainability of custom code (PL/SQL).
• Wrote efficient stored procedures, functions and packages using PL/SQL.
• Analyze the performance issue with help of ADDM, AWR report.
• Made triggers to enforce certain business rules and to perform auditing.
• Supported the advertising publication system including order entry, advertisement publication workflow, billing and invoicing of the advertisements, handling customer complaints, error detection, scheduling, allowing Editorial Staff to manage advertisement space without any conflicts.

Environment: Oracle 11g/10g/9i, Sun Solaris AIX, Windows NT/2000, Red Hat Linux, TOAD, RMAN, SQL server, OEM

Confidential - Chicago, IL

Oracle DBA

Responsibilities:

• Recovered databases.
• Applied Oracle patches.
• Refreshed tables.
• Monitored database performance.
• Managed tablespaces and resolved space related issues.
• Created database links.
• Oracle 9i installation for the development environment.
• Performed SQL statement tuning.
• Rebuilt databases.

Environment: Oracle 10g/9i, Sun Solaris, Red Hat Linux, HP-UX, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TKPROF, StatsPack, SQL* Loader, Windows NT/2000, Veritas Backup