SUMMARY

• Extensive knowledge on database administration for Oracle 11g RAC/10g RAC/9i/8i.
• Experience in Configuring Single Instance, Oracle Real Application Clusters(RAC) and Automatic Storage Management(ASM).
• Expert in backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring, cloning, upgrading and migration of oracle software and tools.
• Solid experience on Upgrading Oracle databases for Oracle 11g RAC/10g RAC /9i.
• Solid experience in Oracle Recovery Manager (RMAN), and standby database using Data Guard.
• Expertise in the database infrastructure design which also include Real Applications Clusters (RAC), Standby Databases (Data Gaurd).
• Data transferring with export/import utilities and Data Pump and SQL* Loader.
• Good experience in SQL, PL/SQL Programming (Functions, procedures, packages and triggers).
• Developed SQL, UNIX and LINUX shell scripts to automate DBA functions. Diagnosed problems and implement corrective actions.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Listener, TNS Names, SQL*Net.
• Experience working with Oracle Data Integrator (ODI).
• Maintained large production as well as development/test/stage databases which involve Data warehousing and OLTP applications.
• Hands on experience in build and Design of Databases for Oracle 10g and 11g.
• Installation of various SOA features like Encryption, SSO, Secure Socket Layer, Data Integration.
• Proficient with OEM, Erwin, SQL Developer, RMAN and Toad.
• Exposure to Oracle Utilities and Tools like OEM 12C, Import - Export, Auditing, RMAN
• Experience in implementing Oracle Streams and in installation and administration of GoldenGate.
• Experience in Capacity Planning and Bench Marking.
• Experience in all facets of the systems development lifecycle, from requirement development, architecture design, testing, and post implementation revisions.
• Experience in working with Big Data Appliance with Oracle Exadata Machines.
• Capable of working under pressure and stiff deadlines with 24/7 Database support.
• Experience in analyzing, translating business requirements to technical requirements and architecture.
• Experienced in performance tuning of various aspects of the database by using oracle utilities like TKPROF, EXPLAIN PACK PLAN, STATS, SQL TRACE, TOAD and Automatic Database Diagnostic Monitor (ADDM).

TECHNICAL SKILLS

Databases: Oracle 11g R2 RAC, 10gR2RAC, 9i, 8i, 7.x, Server 2012/2008/2005 , IBM DB2.

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows.

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB Artisan.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, OEM 12C, Grid Control

ETL Tools: Informatica 5.1, Data pump, Data warehousing

Other: EMC, Net App, VERITAS

PROFESSIONAL EXPERIENCE

Confidential, Cary, NC

Oracle RAC DBA

Responsibilities:

• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked in AES encryption in oracle 10g and 11g by using DBMS Crypto package.
• Worked 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.
• Involved & performed 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.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Apparently perform SQL tuning and baseline tuning. Experience Flash back .
• 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.
• Experience in providing Real time data feeds, heterogeity and transactional integrity by using Golden Gate.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Experience in Data Migration Working 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 designingpackages, stored procedures, functionsand databasetriggers.
• 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.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables.
• Exposure to Oracle Utilities and Tools like OEM 12C, Import-Export, Auditing, RMAN.

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

Confidential

Database Administrator

Responsibilities:

• Installation and configuration of the Development, Test and Production databases.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose Performed database logical and physical design, maintenance, archiving, cloning, administration and upgrades for Oracle.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Upgrade/Migrated the production and development databases from RAC /10g to RAC /11g.
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS.
• Experience working with Oracle Data Integrator (ODI).
• Worked extensively in Build and design for oracle database for People Soft Applications.
• Installation and Configuration of Web Logic Server on Sun Solaris for People Soft HCM Migration.
• Migration of ADP HR to People Soft HCM.
• Installation and configuration of People Soft HCM and CRM. Modules.
• Installation and Configuration of Golden Gate. Done data replication using Golden Gate software.
• Involved in the Design of Backup and Recovery Strategies using RMAN and traditional backup methods.
• Provided 24/7 Production Database and Applications support.
• Maintenance of 8 TB EDW Data warehousing environment.
• Worked closely with Business Intelligence Developers to extract data From EDW using Informatica.
• Worked on large and complex databases SQL Server 2012, SQL Server 2008 and 2005.
• Implemented new SQL Server 2012 mechanisms like data compressions, online indexing, contained databases, security principles and AAG.
• Implemented and Configured Standby database (Data guard) for disaster Recovery
• Involved in performance-tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, SQL/PLSQL statement, error checking and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
• Applied patches and updates to the Oracle database.
• Installation of various ASO environments Featuring Encryption, SSO, Secure Scoket Layer, Data Integration
• Provided documentation as well as training on process and procedures for infrastructure architecture.
• Worked on Design for a project using Exadata Machines.
• Worked on Setup, configuration, performance tuning, troubleshooting on Exadata machines.
• Worked on Oracle Big Data Appliance on Exadata Machines to capture and analyze the data.
• Worked on Shell scripts to automate system and database administration tasks.
• Designed data files, log files and control files layout across disks.
• Developed PL/SQL Packages, procedures and triggers to implement various functionalities.
• Support and ensure the high availability of all the databases especially on Clustered Databases.
• Implemented Oracle Real Application Clusters (RAC).
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
• Experience in setting up and administering Oracle Streams. Configured replication based on Oracle Streams.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Used Erwin database design tool and Oracle Enterprise Manager (OEM).
• Troubleshooting for Production database issues/Performance issues based on Remedial tickets.
• Documentation of RAC Database Setup, Stream Replication and administration of Server Environment.

Environment: Oracle 11gRAC/10g RAC, 9i, SQL Server 2012/2008/2005 , AIX, HP-UX, LINUX,SUN SOLARIS, WINDOWS, Grid Control, RMAN, SQL*Loader, SQL*Plus, Data Pump, ERWIN.

Confidential, Irving, TX

Senior Oracle DBA

Responsibilities:

• 24/7 Production Database support of multi-terabyte Oracle 11g database.
• Performed all aspects of database administration including Installation, Configuration, Patches, Monitoring, Import/Export, Cloning, etc.
• Upgrade/Migrated the production and development databases from RAC /10g to RAC /11g.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Plan, implement, and troubleshooting Oracle RMAN backup, restore, and recovery.
• Provide performance tuning, problem diagnosis, data reorganization and database upgrade support.
• Monitor and tune Oracle database for optimum performance. Assist in capacity planning of Oracle database servers.
• Responsible for Creating, Constructing, Operating and maintaining Interfaces using ODI.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports, error checking and monitored statistics for performance tuning of the database.
• Performed Data replication and Data transformation.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Performed data loads using SQL*LOADER.
• Developed PL/SQL Packages, functions and triggers to implement various functionalities.
• Experience in Managing work repositories and creating reports.
• Installation and administration of GoldenGate.
• Wrote UNIX Shell Scripts for Backup and cloning.
• Tune SQL, PL/SQL statements found in the reporting utilities and queries.
• Involved in the maintenance and trouble shooting of RAC Databases.
• Monitored and managed the space usage and table partitioning.
• Implemented and Configured Standby database (Data guard) for disaster Recovery.
• Primary point of contact between customer and core development team.

Environment: Oracle 11g RAC/10g RAC, RedHat Linux, Sun Solaris, HP-UX, AIX, Windows, Oracle Data Integrator, GoldenGate, SQL, PL/SQL, RMAN, SQL*Loader, Import/Export, Data Pump, Data guard, AWR, ADDM.

Confidential, Dallas, TX

Database Administrator

Responsibilities:

• Installation and configuration of the Development, Test and Production databases.
• Installation, configuration and administration of Oracle Real Application Clusters (Oracle 11g RAC/Oracle 10g RAC) and Standby Databases for High Availability and Disaster Recovery purpose.
• Performed database logical and physical design, maintenance, archiving, cloning, administration and upgrades for Oracle.
• 24/7 Production Database and Applications support.
• Experience working with Oracle Data Integrator (ODI).
• Performed and monitored Hot and cold database backups and implemented backup and recovery using RMAN and Knowledge of storage technologies SAN, NAS.
• Designed data files, log files and control files layout across disks.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Involved in the Design of Backup and Recovery Strategies using RMAN and traditional backup methods.
• Provided documentation as well as training on process and procedures for infrastructure architecture.
• Applied patches and updates to the Oracle database.
• Support and ensure the high availability of all the databases especially on Clustered Databases.
• Implemented Oracle Real Application Clusters (RAC).
• Worked on Shell scripts to automate system and database administration tasks.
• Involved in capacity and resource planning. Estimated the size of data files and redo log files considering transactions rate, transaction records size, transaction type, recovery time allowed etc.
• Developed PL/SQL Packages, procedures and triggers to implement various functionalities.
• Experience in setting up and administering Oracle Streams. Configured replication based on Oracle Streams.
• Involved in performance-tuning activities to improve performance of the Oracle database. Tune database through initialization parameter, SQL/PLSQL statement, and memory by performing routine checks of the SGA, CPU, logical and physical I/Os and contention.
• Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and monitored statistics for performance tuning of the database.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Used Erwin database design tool and Oracle Enterprise Manager (OEM).
• Troubleshooting for Production database issues/Performance issues based on Remedial tickets.
• Documentation of RAC Database Setup, Stream Replication and administration of Server.

Environment: Oracle Database 10g RAC/9i, RedHat Linux, HP-UX, Sun Solaris, AIX, OEM Grid Control, TOAD, RMAN, Data Pump, SQL*Loader, Erwin.

Confidential

Oracle DBA

Responsibilities:

• Part of a 5 member DBA team which was involved in the maintenance of the Oracle 9i/8i databases for the Production as well as the development environments.
• 24x7 Production database and applications support.
• Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
• Configuring RMAN backup to various databases.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Experience working with Oracle Data Integrator (ODI).
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning to setup identical databases in the production and development environments.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 8i to 9i.
• Oracle 9i Streams Replication setup and Configuration.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Back end Programming/scripting using SQL and PL / SQL.
• Created table partition and index partition.
• Troubleshooting for Production database issues/Performance issues.

Environment: Oracle 10g RAC9i/8i, HP-UNIX, Linux SUSE, SQL, Oracle Replication, Explain Plan, Toad