PROFESSIONAL SUMMARY:

• Around 8 years of IT experience as an Oracle database administrator in Oracle database administration, installation, configuration, migration, sizing and space management, backup and recovery, cloning, upgrades, RAC, standby, replication, patching, performance tuning and troubleshooting, strategic planning, database security, TAR/SR support, Unix shell scripting and documentation, auditing and implementation of technology solutions.
• Extensive knowledge on database administration for Oracle 9i, 10g 11g and 12c, with experience in very large scale database environment and mission critical large OLTP and OLAP systems
• Experience in a variety of hardware and software platforms including; OEL, UNIX/Linux, Sun Solaris, HP - UX & AIX and RHEL.
• Have Hands on experience in Installation of 12C RDBMS S/W, INSTALLATION OF 12C RAC AND HANDY IN CONFIGURING DATAGUARD ON 12C
• RAC Installation and Maintenance, setting up and configuring Data-guard, performing all kinds of Backups and Recoveries, Cloning databases,
• Hands on experience in Installing Golden-gate Replication, tools in goldengate logdump, defgen for troubleshooting issues in environment
• Strong troubleshooting skills in oracle Goldengate
• Good experience in using Shareplex for data replication.
• Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup
• Handy in Migrating Single Instance databases to RAC Environment.
• Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases i.e. ACTIVE DATAGUARD & SNAPSHOT STANDBY
• Maintained Data-guard SERVER and involved in trouble shooting issues.
• Have good knowledge about Physical and Logical structure of a database.
• Maintained Catalog Server and involved in Registering the Databases in Catalog Server.
• Hands on experience in Grid Control 10g & Grid Control (11g) and INSTALLED 12C for database Monitoring/Performance/Diagnostics.
• Used Data masking to protect private and confidential data by replacing sensitive information with dummy data
• Experience in Performance Tuning, Tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Tuned the Database with Initialization Parameters. Viewing the Initialization Parameters with Enterprise Manager. Increasing Performance by Tuning the DB CACHE SIZE parameter.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Table-spaces.
• Good experience in PATCHING AND UPGRADATION from 10.2.0.x to 11.2.0.4
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS).
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.
• Experienced in maintaining databases on large Production, Testing and DEV environments.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• Handled daily production problems/change requests (DBCRS) with Oracle.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Database: Oracle 12c, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i

Oracle Products: Real Application Cluster, Golden Gate, Data guard, Import and Export, Data pumps, Oracle Wallet Management, Automatic Storage Management,RecoveryManager,Oracle10g/11g/12c(GridControl),OracleRealApplication Cluster, RMAN, Transparent Data Encryption

Operating System: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL), Sun Solaris, Windows XP/2003/2008, AIX 6.1

Languages: SQL, PL/SQL, Unix shell scripting

Tools & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, BMC Remedy, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool

PROFESSIONAL EXPERIENCE

Confidential, Virginia

Sr.Oracle DBA

Responsibilities:

• Administering and supporting Oracle database environment over 120 databases, up to 15TB, utilizing advanced concepts such as Data Guard and Oracle RAC combined on all the production, development and testing environments.
• Installed, configured and maintained Oracle 2/3 Node 12c RAC
• Performed various operations relinking protocol library, implemented 12c Transaction Guard while configuring services, deployed instance caging
• created container and pluggable databases in 12c RAC and created services configured with PDB
• Worked on ASMCA and used SYSASM for created disks, drop and add disks to disk groups and tuning ASM parameters according to requirement
• Configured disaster recovery databases using data guard and performed DR Testing
• Performed switchover and monitor using DGMGRL
• Worked on Active data guard and performed Troubleshooting data guard environment
• Involved in OracleGolden gate installation, configuration, troubleshooting Golden Gate Extract and Replicat files.
• used Defgen utility to create definition files in Goldengate
• Migrated databases using Goldengate with minimal downtime
• Involved in up-gradation of databases from 10g to 11g and applied patch set and interim patches whenever required
• Upgraded development and production databases from 10g to11g on Linux
• Involved in Installation and Configuration of Management agents in 12C(Cloud Control)
• Used 12C/11G grid control Maintenance, tuning and monitoring databases
• Providing Application Support for performance and database related issues
• worked with teams and Involved in building Databases for BI (Business Intelligence)Applications.
• Worked on storage Indexes and tested their behavior with different query predicate conditions
• Performed cross platform migration of databases on Solaris 10g to Linux 11g using GoldenGate
• Documented and logged errors in GOLDENGATE environment and worked on OLTP Compression
• Extensively used Log dump utility and define utility for resolving issues in GoldenGate
• Extensively used data pump for migrating data between platforms
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Implementation of Flashback Technology and cloned databases for development and test environments using Recovery Manager
• Involved in scheduling incremental, cumulative and full backups and configured retention policy Using RMAN
• Worked in Data Warehouse environment, involved in activities like partitioning tables, Creating materialized views and reorganizing index’s
• Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.
• Used 10046 Trace for tracing client connections, sql statements and bind variables
• Implemented database security using Transparent Data Encryption
• Configured Oracle Wallet for Transparent Data Encryption (TDE).
• Strong understanding of business processes with good experience in development.
• Strong knowledge in SDLC and all phases of Application development.
• Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
• A logical, analytical thinker with exceptional database skills having rich experience as a Oracle PL/SQL developer.
• Encrypted sensitive information like Tables, table spaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.
• Performed Explain Plan analysis for Query Optimization and SQL tuning
• Performed Database and SQL tuning by using various Tools like AWR, ADDR, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.
• Involved in managing end-end lifecycle of user identities across the enterprise resources using Oracle IDM (Identity Management).
• Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment: Oracle 11gR2/12C, Solaris/Linux, SQL, OEM, RAC, ASM, Data guard 10g/11g, Goldengate, putty, RMAN, Explain Plan, AWR, ADDM, ASH, TTS, Flashback, Data pumps.

Confidential, CA

Sr .Oracle DBA

Responsibilities:

• Implemented Oracle Database 11gR2 2 node Real Application Cluster (RAC) using Oracle Cluster-ware on Unix and Installed RAC on Linux.
• Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X
• Worked on large databases size greater than 12TB.
• Involved in designing of Disaster Recovery using Data Guard and High Availability using 11gRAC.
• Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.
• Installed 7 standalone servers on ASM and maintained DR databases on it.
• Performed various tasks on ASM, creating a disk group, Adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
• Installed Golden gate on source and target side for Replication and implemented load balancing topology using Goldengate.
• Configured Golden Gate Parameter files for Extract and Replica process for replication.
• Tuned GoldenGate environment using different parameters and involved in trouble shooting.
• Used Shareplex to provide Data Accuracy and Integrityto ensure that target instances are accurate representations of the source database.
• Performed automated backups and scheduling using scripting.
• Configured RMAN and registered databases in Catalog server.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Generated AWR reports, ADDM reports for fine performance tuning and worked closed with PL/SQL developers to tune TOP SQL running queries in databases.
• Used Invisible Indexes, and turn off indexes temporarily to check how queries perform without them.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Worked on Building schemas, cursors, developed stored procedures and database triggers in PL/SQL.
• Performed Quick System Review by using Education Performance Index (EPI), System Performance Index (SPI), and Memory Performance Index (MPI). Disk Performance Index (DPI). And calculated the Total Performance Index (TPI).
• Created User accounts, Roles and granting required access permissions and privileges.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.

Environment: Oracle 9i, 10g, 11g, HP-Unix, Sun Solaris, Linux, RMAN, DBCA, GOLDENGATE, Dataguard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF and putty.

Confidential, MO

Oracle DBA

Responsibilities

• Worked on Oracle Database 10g 2 node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Performed health checks in RAC environment and keeping OCR files backup
• Configured Oracle Data guard for Oracle Disaster recovery.
• Monitored Data Guard environment using different views for proper log sync.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Involved in designing logical and physical data models using Erwin.
• Created indexes to facilitate easy user interface implementation and tuning.
• Rebuilded Indexes when fragmentation occurred.
• Worked on Databases through Business Intelligence tool.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Confidential, KS

Oracle DBA

Responsibilities:

• Involved in 24X7 on-call supporting team.
• Proficient in installation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Designing, documenting and deploying through the various development and production environments.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of DG, ASM, OCFS in RAC environment.
• Automation of deployment/migration from existing systems (Oracle), monitoring and reporting.
• Database Migration from production to test and development environments is done through Cloning, Export and Import.
• Applied CPU, One-off patches using Opatch utility; RDBMS patch set Upgrade (PSU).
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Used Oracle 10g grid control utility.
• Planned and implemented Backup & Recovery using RMAN.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, AWR, STATSPACK.
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using TAR, SAR and RDA.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Reading Alert Log & User Trace Files and Diagnosing the Problem.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Environment: Oracle 9i/10g, RHEL, HP UX, SQL, PLSQL, UNIX Shell Scripting, RMAN, Oracle 10g Grid control, Data Guard, SQL*Loader, EXP, IMP, TOAD, Datapump, SQL developer, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH, Golden gate.

Confidential

Oracle DBA

Responsibilities:

• Provided DBA Services to improve their performance of databases i.e. supported company that works with Oracle on a highly OLTP and DW environment.
• Setup Disaster Recovery solutions (Dataguard), Tuning Code, Resolved bottleneck problems.
• Applied Patches, Backup and recovery (with RMAN and Shell Scripts) over high volume Terabyte Databases.
• Worked with team to Install and configure Oracle RAC.
• Helped other team to migrate from Oracle 10g to Oracle 11gr2
• Installed standalone servers on ASM 11g, worked on creating disk groups, partitioning raw-devices .
• Used ASMCA extensively to create disk groups in ASM environment
• Installed and configured Oracle databases on severs RHEL.5.5 and RHEL 5.8
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Installed & managed 10g OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Created bit-map Indexes for data warehouse databases.
• Worked with ETL team for understating mappings for dimensions and facts.
• Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the database
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter’s.-- Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Responsible to provide 24x7 database administrative activities over different database servers

Environment: Oracle RAC 10g/11g, RMAN, OEM and ASM. RHEL4.x,5.5, RHEL5.8, Sun Solaris, TOAD, IMPORT/EXPORT, Windows NT/2000, ETL.

Confidential

Oracle DBA

Responsibilities:

• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Responsible to schedule backups through RMAN.
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization query's, Implemented scripts for daily monitoring like db status, free space etc.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.
• Tuned the SGA, Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Table spaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.

Environment: Oracle Windows, IBM-AIX, RHEL, Oracle 10g PL/SQL, SQL*PLUS, Oracle Enterprise Manager 9.2.0/10g, RMAN