SUMMARY

• DBA with over six years of hands - on experience as an Oracle Database Administrator.
• Extensively worked on Installing, configuring Oracle 12c, 11gR2 and 10g. Good with Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security and Memory Management.
• Supported databases on AIX, Linux, UNIX and Windows environments.
• Experienced in configuring and managing Oracle Real Application Cluster (RAC) 10g/11g, Data Guard and Golden Gate for Oracle High Availability.
• Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.
• Managed Oracle databases in very large (over 45 TB) databases and Oracle Application environment to support over 3,000 concurrent users.
• Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams and Oracle Golden gate.
• Good experience in applying Patch set update (PSU) and Critical Patch Update (CPU Patches) on Databases.
• Good experience in Oracle Clustering services (CRS), VERITAS Cluster Services (Quick I/O file systems) and High Availability features. Extensive Knowledge of 10g and 11g ASM.
• Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.
• Extensive hands on experience with Oracle Cluster ware, MC/Service Guard and configuration with Oracle 10g and 11g RAC. Strong skills on Data guard.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Configuration and Management of Data Guard on RHEL, OEL.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
• Proactively monitoring the database's health and taking preventive or corrective actions
• Proficient in Database Design (Physical and Logical Database Design) and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
• Proactively monitoring the database's health and taking preventive or corrective actions
• Proficient in Database Design (Physical and Logical Database Design) and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

TECHNICAL SKILLS

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

Databases: Oracle 10g, Oracle 11g, Oracle 12c, MS SQL, MY SQL, SQL Server database.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, FTP, WINSCP, EXP, IMP, Data Pump, TOAD, SPM, SQLT, OSWATCHER, SQL*Plus, Grid Control, DBCA, Data Guard, TKPROF, Golden Gate, TOAD, RDA, Streams, Oracle warehouse builder (OWB)

Other: EMC Storage, Net Backups, VERITAS, SAN Storage.

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Created and monitored Physical standby databases on maximum protection, performance mode using Data guard for Disaster Recovery and High Availability.
• Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4.
• Upgrading Grid Infrastructure and databases from 11.2.0.4 to 12c.
• Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker (DGMDRL)
• Installed and configured 4 node server side load balancing Oracle RAC 11g, 12c databases on Linux with ASM and Data Guard.
• Production support database on 10g, 11g and 12c versions with standalone and RAC environment.
• Set up user profiles and roles as per the access level of user for the data and application security.
• Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment
• Installation and configuration of Oracle Golden gate.
• Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.
• Configured deployed and administered 4 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 6.0, using ASM and Raw Devices on Oracle 11gR2.
• Supported 24x7 mission critical applications which include different versions Oracle 10g/11gR1/11gR2/12c for Stand alone and RAC Databases.
• Table created with Daily Range partition, indexes and script automated which add/remove partition as per client requirement.
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, AWR, ADDM, ASH, SQL tuning advisor etc.
• Resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 11.2.0.2to 12.2.0.2 and applying patches whenever required.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Supporting multiple database for and staging purposes on DEV,INT1,STAGING and PROD red hat enterorise Linux, HP-UIX UNIX, AIX windows and sun salari.
• Successful in installation/maintenance of Physical Standby database using OracleData Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
• Refreshing DEV and Staging instance with data from production on a regular basis and also when QA need to test an application and requires a refresh from me.
• Made optimal use of Meta link in resolving the SRs.
• Participate on project team as a database administrator, supporting and ensuring that databases are appropriate modified to support new business applications and requirements.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Backup of Archive Logs, Control Files and SPFILE on Tapes to Ensure Complete Recovery can be achieved.
• Worked closely with Performance testing team in providing Database support for all the application releases in reaching the required SLA standards.
• Involved in engaging different people bringing them on-board whenever a triage need to be opened.
• Contacting Oracle Support for technical assistance in resolving problems in a timely fashion.
• Ensuring Database security by virtually separating databases and using VPD (Virtual Private Database) in RAC environment to support two different set of application users by making data non-transparent to each other.
• Participate on project team as a database administrator, supporting and ensuring that databases are appropriate modified to support new business applications and requirements.

Environment: ORACLE 12c, 11g/10g, RAC, Red Hat Linux, Solaris, Data Guard, Golden Gate, VCS Storage, PL/SQL, RMAN, Toad, OEM GRID.

Confidential - Schaumburg, IL

Oracle Database Administrator

Responsibilities:

• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Performed disk and disk group management in ASM while installing 11gR2 RAC.
• Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).
• Ensured that oracle database systems operate securely and efficiently.
• Managing databases from planning and testing stages through implementation and support.
• Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• On call Production & Development database support and administration.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
• Involved in query optimization and using rule-based optimizers and cost-based optimizers.