OBJECTIVE

• 8+ years of IT experience with increasing levels of responsibility. Experience managing a Global IT infrastructure team.
• Significant experience with outsourced IT service providers.6+ years of budget responsibility.
• Experience with high volume, high performance database systems. Experience with enterprise scale data warehouse systems.
• Experience saving money and time based on new solutions and proposals.
• Experience in the design, maintenance, and administration of ORACLE … Experience writing, creating, and tuning SQL.
• Experience in monitoring and runtime optimization of applications, data jobs, replication, and ETL activities including Informatica, SAS, & Maestro.

SUMMARY

• Oracle Database Administratorwith around 8+ years’ experience in installing, configuring, administering and managing oracle databases & implementing solutions like high availability (HA), data guard, Oracle streams and golden gate.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, UNIX, Solaris 10 & IBM AIX V 5.3.
• Ability to understand and perform the enhancement based on client’s requirement.
• Excellent interpersonal and strong analytical, problem - solving skills.
• Experience and exposure to oracle Utilities and Tools like OEM,, TKPROF, STATSPACK, EXTERNAL TABLE, IMPORT-EXPORT, Data pump, flashback, AWR,ADDM,ASH
• Performed Migration and Upgrade of 20+ databases to 11g and 10g
• Up-gradation of databases applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle RAC with ASM & OCFS2 file systems on multi node systems, 12c, 11g, 10g and 9i in different operating systems according to OFA for OLTP and Data Warehouse environment on Very Large Databases (VLDB).
• Experience on oracle 12c/11g/10g/ASM/RAC and up-gradation of standalone databases to RAC environment.
• Extensive experience in installation and implementing OEM and setup of Oracle Grid Control.
• Configuration of Automatic Storage Management (ASM).
• Extensive experience with Database Cloning and Refreshing pre-production/development databases with prod/pre-prod databases.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Experience on Oracle golden gate Homogeneous/ Heterogeneous environments and implemented (uni/bi) directional replication.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/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, and data pump export/import.
• Implementation of Flashback Technology.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, and SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Installed OSWATCHER & PROCWATCHER for monitoring OS resources on RAC nodes
• Experience on Oracle monitoring tools including Oracle SQL*Forms monitoring, Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Skilled in writing PL/SQL Procedures, Packages, Functions and Triggers.
• Experience using Erwin as a Data Modeling tool.
• Experience designing the DW model and the physical structure.
• 24*7 on-call production database support and maintenance including remote database support.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2000, 2005

Oracle Products: Golden gate, Streams, Oracle (Grid Control), OEM (Oracle Enterprise Manager), Oracle Fail-Safe (OFS), RMAN, SQL*Loader, DATA PUMP, APEX, ASM

Programming Languages: SQL, PL/SQL, JAVA, C, C++

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP Professional, Windows 2003 Professional

Other Tools: VERITAS Cluster Manager (Java Console) v3.5, TOAD, Erwin, Putty, SecureCRT, Oracle Streams, Quest Share Plex, Rational Suite-Clear Quest, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Sr. Database Administrator

Responsibilities:

• Provided Technical support and issue resolution to Enterprise applications, hardware, networks, and databases by root cause analysis, assessment, development, and implementation of solutions that meet the needs of users and kept them productive with minimal disruption
• Kept databases, applications, and operating systems up-to-date through assessing, planning, and implementing upgrades and patches
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data • Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Supported more than 130 production and development databases
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logica l/O and Memory Usage.
• Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Responsible for capacity planning, recovery planning and installing patches
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Assisted users with performing their job functions more efficiently by installing, configuring, problem solving, maintaining, and uninstalling software on servers and laptops

Environment: Oracle 9i, 10g, 11g, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM.

Confidential, Minneapolis, Minnesota

Sr. Database Administrator

Responsibilities:

• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Installed and upgraded Oracle10.2.0.1 database to 10.2.0.4.
• Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Managed and monitored the Oracle Real Application Cluster (2 node RAC) running on VERITAS storage.
• Created custom services for RAC database for distribution of load across the nodes.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Creation of materialized views and fine-tuned them for better performance.
• Working Experience with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Tuning SQL statements using Explain Plan and STATSPACK.
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Installed & managed 10gOEMgrid 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.
• Performed Schema as well as Table level Replication using Oracle Golden Gate and also did set up Disaster Recovery solution using Golden Gate.
• Created bit-map Indexes for data warehouse databases.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Worked with ETL group 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.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.

Environment: Oracle 11g/10g, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 12c RAC, TOAD, Data guard

Confidential, SFO, CA

Database/System Administration

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to10g version using OPatch.
• Maintenance of around 200 databases combined on all the production, development and testing environments on various databases (DB2, SQL servers 2005).
• Converted a single instance database to Oracle RAC 10g.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Configured Oracle Data guard for Oracle Disaster recovery.
• 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, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump utility for moving data among the servers.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL* UNIX Shell Scripts for backups.
• Managed and monitored the Oracle Real Application Cluster (4 node RAC) running on ASM storage.
• Supported more than 300 production and development databases* Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load and data parsing using Pl/Sql procedures, Korn shell scripting and Sql*loader.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Involved in gathering requirements from end users.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK. * Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, OEM, Oracle 10g RAC, Sybase, STATSPACK, EXPLAINPLAN, IBM Data stage, C++, Web logic, SQL Server 2005.

Confidential

Database/System Administrator

Responsibilities:

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and Stats pack.
• Installation, Maintenance and administration of Oracle 10g on Red hat Linux.
• Implemented Data guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches.
• Database Restore using RMAN, Cold Backup and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Extensive application tuning through STATSPACK, explain plan, SQL*Trace.
• Implemented scripts to capture high resource utilization queries.
• Implemented Oracle Advanced Security Options.
• Maintained multiple terabyte databases on Oracle.
• Cloned the production database periodically to the testing databases through RMAN.
• Used Enterprise Manager on Oracle10g for diagnostic summary, host CPU utilization, finding wait events, alert Log errors etc.
• On-Call 24x7 DBA support for production databases.
• 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 Tablespaces and Segment fragmentation.
• Performed trouble shooting activities, created new users and assigned privileges and roles to users.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g,