SUMMARY:

• An Oracle DBA with around 8 years of experience providing technical support in all phases of Software Development Life Cycle and managing RDBMS projects. Diverse and dynamic career with extensive experience in planning, implementation and problem solving with great attention to detail, while managing and working with large teams.
• Oracle Certified Professional with around 8 years of experience in administering 24x7 Mission Critical Production Environments on UNIX Based HA Systems with SLAs, Sun Solaris, IBM AIX, Unix/Linux and Windows.
• Experience in Administration, Performance Tuning, Backup/Recovery, Upgrade, Security, Provisioning, Consolidation of, development, staging, validation, qa and production database environments.
• Oracle Certified DBA, proficient in Oracle 11g R1, 11g R2, Oracle 10g R2, 10.1.0.xOracle 9.2.0.x, Oracle 8.1.7.x design, installation, administration, management performance tuning, upgrades, disaster recovery strategies, and high - availability solutions on Sun Solaris 10, 9, 8, HP Unix 11.x, AIX 5.x, 6.x, Redhat Enterprise Linux 4.0, Windows-2003, Windows-2000.
• Experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
• Expert in configuration of 11gRAC, 10gRAC, 9iRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS
• Experience in using OEM, TOAD, and Data Migrations using Export/Import, benchmarking using Load testing tools.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Experience with Data Modeling, Logical and Physical database design. Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Experienced in using 10g features Datapump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Knowledge on different hardware clustering environments like IBM HACMP,EMC DMX, CLARION, Symetrix.
• Experienced in Installations and maintenance of SQL server 2005 on windows server 2003 sp2.
• Experienced in complete SDLC by setting up Dev, UAT, and Production databases.
• Experienced in tuning the sqls to reduce the response time for the end users.
• Experienced in identifying and troubleshooting sql queries using sql trace and tk prof utilities.
• Extensive experience in installing, upgrading, maintaining and configuring Red Hat Enterprise Linux on vmware workstation.
• Hand of experience in installation and configuration ov vmware workstation 6 and 7 with linux and solaris operating systems.
• Installed, configured, and resolved issues with the Oracle Streams utility, and with the Oracle Change Data Capture utility.
• Good experience in configuring 10g and 11g RAC, GRID control in vmware workstation.
• Performed all dba tasks on vmware workstation for testing purpose. .
• Expertise in identifying and resolving issues related to Golden Gate.
• Expertise in Oracle GoldenGate, Veridata installation, configuration, troubleshooting GG issues.
• Experience in installing and configuring GoldenGate 9.5.
• Experience in migrating database from Oracle 10g to 11gR2 RAC.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Experienced in using 11g features DataPump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Hands on experience in installing and configuring Oracle 11g RAC and MYSQL Cluster.
• Used Cron jobs to automate many DBA tasks.
• Excellent Knowledge in Hot/Cold Backups, and Cloning of Databases.
• Extensive experience in Banking, Telecom and Manufacturing Domain using various Applications.
• Installing, Setup and configuration of Clusterware 10.2/11, Configuring Grid Control, Adding/Deleting nodes/Services, Setting up ASM instance and maintaining disk groups. Have good knowledge on Clusterware and RAC database Architecture.
• Defining Backup policy, configuring RMAN HOT/COLD/ARCHIVE backups according to the business needs and DR agreements.
• Performance Tuning of Oracle Environments - Instance Tuning/Hardware/OS Tuning,SQL Tuning, Session Trace (Tkprof/ TraceAnalyzer), investigating historical Performance/bottlenecks using Statspack/AWR/ADDM.
• Performed numerous data refreshes from Prod to Non-Prod for Application bug fixes and performance testing using RMAN Duplicate/ DATAPUMP.
• Cloning and Patching Oracle Applications Instances and Databases using Rapidclone, adpatch, distributed AD, AD Utilities and OPatch
• Used Sun E2900, V440, V490 servers hosting Solaris 10 (64 bit) with Oracle Server versions 10gR2 and 11gR1.
• Used Logminor and Flashback query to rollback operations/transactions caused by user/application errors.
• Planning Space management for existing and new applications. Migrating database from NON-ASM to ASM using OFA on EMC symmetric SAN
• Performed Several Database Upgrades/Migrations - 8.x to 9.x/10.x,9.x to 10.x, 10.2.0.4.0 to 11.2.0.2.0 on IBM AIX, Sun Solaris, HP UNIX & LINUX SUSE.
• Worked extensively with Oracle Partitioning Feature - Maintain Range/List partitioned tables, Add/Drop/Split Partitions. Local/Global Partitioned Indexes.
• Proficient in configuring and Managing Oracle Network Components/Listeners, Listener.ora, Sqlnet.ora, Listener Tracing, Connect Time Failover/Load balancing.
• Expert in SQL/PLSQL and K-Shell scripts (Coded Several Prod Monitoring/Automation Scripts).
• Extensive 24X 7 Production on-call rotation Experience. Liaising with Oracle for bug fixes ORA-600/7445 etc.
• Involved in doing Data Modeling, data mart, designing data warehousing boundaries and parameters, Data Transformation, PL/SQL. Experience in using GoldenGate to support data replication in the Oracle database environment.
• Diligent in Production Database Management Procedures .i.e. Maintaining a Log of All Production Changes, Activities/Incidents on a Daily basis.
• Good knowledge and exposure to High Availability using VCS, Sun Cluster, HP service guard, RAC, BCV, SRDF & Dataguard etc.
• Extensive experience with Cloning, Patching, Automated Rapid clone.
• Platforms/OS include RedHat Linux AS v3; Solaris 10, 9, 8,6; HP-UX 10.20; AIX 4.1.
• Configured load balancing on middle tier to distribute load evenly.
• Implemented Optio forms for packing slips, invoices and purchase orders.
• Migrations using Kintana s Object Migrator.
• Extensive experience with Logical Apps, TOAD, DBArtisan, OEM 10g, Shareplex, Stat.
• Extensive experience on Change Management, Approval procedures & SDLC.
• Experience in Oracle Grid Control installation, configuration, maintenance, and upgrades.
• Experience in Database Security and Auditing.
• Expertise in Oracle Data Guard, Cloning of Database
• Good knowledge and exposure to HA using VCS, Sun Cluster, HP service guard, RAC, BCV, SRDF & Dataguard etc.

AREAS OF EXPERTISE:

Oracle Database administration

Patching, Upgrades & Cloning.

Database, Applications and

SQL Tuning.

RMAN Backup and Recovery

Unix Shell, SQL and PL/SQL

Scripting

Oracle Database Upgrades

Logical and Physical Database Modeling.

Real Application Clusters(RAC) and ASM

OEM Grid and Data Guard.

Golden Gate & Shareplex Replication

IMPORT & EXPORT, Datapump10g, STATSPACK

PROJECT & WORK EXPERIENCE:

Confidential, Richardson, TX

Sr Database Administrator

Environment: RAC, Golden Gate, Tkprof, Grid, Toad, 11gR2, Data guard, ASM.

Responsibilities:

• Primary DBA for many mission critical applications, Enterprise Applications like HP SM7 (Which is the ITSM tool for whole enterprise), Oracle Financial reporting.
• Providing 24x7x365 support 10+ RAC clusters and 30+ single instances for prod/dev/test/dss databases.
• Worked with development team in identifying and troubleshooting sql queries by using tkprof and ADDM.
• Installation, Configuration of Oracle Clusterware, Created ASM, RAC database, adding services & maintaining GRID control.
• Upgraded, Migrated databases to 11gR2, Single instance to multimode RAC, Worked with application team extensively to correct the connectivity issues, environmental setting after the Upgrade/migration.
• Installed and configuration ov vmware workstation 6 and 7 with Aix 6.1 and solaris operating systems.
• Experience in Data transfer between SQL Server and Oracle.
• Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2005.
• Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
• Experience in Microsoft SQL Server 2005 Database Administration including planning, implementing, backup, and recovery strategies.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Extensive experience in installing, upgrading, maintaining and configuring Red Hat Enterprise Linux on vmware workstation.
• RAC Architecture in brief: SUSE 10, x86 64, EMC Power Path & Fiber HBA for SAN/TAN Connectivity, Gigabit Ethernet for cluster interconnects, EMC symmetric SAN storage, CRS configuration files on RAW and ASM for database files.
• Knowledge on different hardware clustering environments like EMC DMX, CLARION, Symetrix
• Design, Development & implementation of large volume OLTP and large scale Data Warehouse/DSS environments.
• Worked closely with application teams for rolling application Release/Migration and patches.
• Performance tuning of Oracle instances using AWR/ASSM/ASH/Explain Plan/ TKPROF, Used GRID/OEM/TOAD etc.
• Extremely proficient with RMAN, Restore & Recovery scenarios and Planning backups.
• Active member of DR team, successfully completed the 2009 DR exercise for all Tier1 and identified Tier 2 applications.
• Converted numerous single instance databases to RAC 10gR2 based Architecture for the server retirement project with either 3 - node RAC or 2 - node RAC
• Applied CPU/PSU patches to 100 s of databases and re-mediated database as per Audit and agreed security standards
• Used Dataguard for contingency of mission critical applications operated on Performance & Availability modes. Used DGMGRL command for switchover and failover purposes.
• Experience in implementing Unidirectional Golden Gate, from Source to a Repository Database.
• Experience in Installation of Golden Gate 9.2 on Oracle Servers.
• Performed Initial load, extract, replicat, trial files and exporting data onto Repository Database using Golden Gate tool.
• Proactive monitoring using OEM/HPOV/PLSQL/SHELL scripts for Space, DB load, Backups and other infrastructure related activities.
• Performed numerous data refreshes using RMAN, Datapump & export/import.
• Used RMAN and DBMS FILE TRANSFER utility to copy ASM archive log files from RECOVERY DEST AREA for Point-in-time recoveries.
• Extensively used Logminor, Flashback queries on ITE & Dev environments for rolling back changes due to user/application errors.
• Extensively used SRVCTL, CRSCTL, CLUVFY, OCRCONFIG, DGMGRL & Grid control.
• Worked with Oracle closely for bug fixes, internal errors and one of patches. Liaised with storage, Unix SYSADMIN and Storage/Backup teams for migrating 100 s of databases from existing AIX 6.1 architecture to Linux based RAC.
• Regular maintenance for space optimization, Index rebuild and online re-org of segments.
• Team Player, volunteering attitude, sharing new findings and mentoring new/junior dba s.

Confidential, OWINGS MILLS, MD

Sr Database Administrator

Environment: RAC, 10g, 11g, Solaris, Red Hat Linux, Windows, DBMS, RMAN, OEMShell scripts, SQL, PL/SQL

Responsibilities:

• Installing and maintaining 4 - node Oracle RAC
• Expertise in Production Support and maintenance of Oracle 10g/11g on different platforms Solaris, RedHat Linux and Windows Platforms.
• Performing Cross platform upgrade of Oracle 10g/11g from Sun Solaris to Windows and Windows to Solaris.
• Creating and maintaining DBMS objects tables, indexes, views, sequences, triggers, packages, partitioning, compression and data encryption
• Cloning and refreshing databases/schemas to development, test and QA environments from production
• Installing and maintaining Oracle Databases and Oracle Application server instances
• Implement effective database security practices and procedures and managing database security with oracle database users, roles, responsibilities, privileges and profiles
• Performed pro-active monitoring and performance tuning of Applications and Database environments using OEM, AWR, ADDM and changing database parameters
• Formulating and implementing DBMS backup and recovery strategy using RMAN and archivelog.
• Actively participating in discussions with business team in creating physical & logical data model diagrams, and entity relationships and technical/system design documents.
• Meeting with vendors/share holders/management team and reporting the status and progress of different Projects
• Providing 24x7x365 on call support, resolving tickets, migrations, metalink SRs and service requests for databases and applications
• Collaborate with Enterprise Architecture teams on recommendations and changes in service/integration best practices, standards, processes and frameworks
• Patching Oracle Instances and Databases using OPatch Utility.
• Troubleshoot problems with concurrent managers, Apache and database performance.
• Installing and configuring logical standby database and data guard for high available production instances
• Implemented Oracle Enterprise Manager (OEM) and configured all the databases
• Installing RAC with ASM and Configuring with Custom Applications and Oracle Applications
• Mentoring, Allocating and monitoring the work performed by DBA and development Team.
• Performing maintenance operations involving quarterly password changes and CPU patching
• Configuring and developing applications with streams and advanced replication for multi-master replication of seed data between various county departments.
• Automating tasks using Cron jobs and OEM Grid.
• Creating database maintenance scripts using SQL, PL/SQL and Shell scripts.

Confidential, Dallas, TX

Database Administrator

Environment: Datapump, Flashback, DataGaurd, RAM, Sun E2900, V440, V490, Solaris 10, 10gR2, 11gR1, Grid Control

Responsibilities:

• Mentored Junior level DBA s and Offshore DBA s
• Provided 24*7 support for a 2 node, 10TB RAC system comprising of the Production, Performance Stage, and the Disaster Recovery databases.
• Provided support for various Data Conversion (DataStage/Ascential), Cognos and Data Warehouse databases in the Integration and UAT databases in ITF.
• Setup, configured, administered, and managed a 2 node RAC database for Disaster Recovery, using Data Guard. Performed various tests, including manual switchovers and failover using SQL commands, DG Broker commands and Grid Control.
• Documented Data Guard setup, configuration, management and best practices for the DBA team. Also prepared documentation regarding the Disaster Recovery plan for the State of Washington for an official review.
• Configured and administered Grid Control on Windows 2003 for the various databases in the Production environments.
• Worked with the System Admin Team, Configuration Management Team, Data Modeling Team, Storage and Network Team, Data Conversion Team, the Chief Architect, the Vice President for Infrastructure and the application development teams. Each Application Development team work on subsystems like Claims Processing, Prior Authorization, Managed Care, HIPPA, Providers and Oracle Financials, which are all a part of the eCAMS application.
• Addressed issues between CNSI and Sun Managed Operations (SMO) and resolved Incident Tickets generated by SMO.
• Created new schemas and performed schema refreshes using DataPump.
• Worked with the DBAs and the Infrastructure team for RMAN, DataGuard, Flashback and other infrastructure requirements, including the creation of new databases, space requirements and allocations, backup strategies and retention time as per business requirements.
• Assisted in the designing process of capacity planning and physical & logical design.
• Actively worked with the Performance Benchmark Team in order to address performance issues and troubleshoot similar issues in other environments.
• Secured PHI data and implement security standards and protocols based on federal and client/state requirements.
• Provided recommendations to higher management regarding all database and infrastructure issues
• Used partitioned tables, local indexes, global indexes, LOBs and Unicode character sets.
• Implemented plans to archive claims data, based on the requirements of the State of Washington for auditing and/or purposes to be made available in the future.
• Documented setups and configurations for all environments. Streamlined best practices for the DBAs in the WA team.
• Provided conceptual and hands - on while mentoring other Oracle DBAs.
• Used Sun E2900, V440, V490 servers hosting Solaris 10 (64 bit) with Oracle Server versions 10gR2 and 11gR1.
• Installed Oracle 11g on Solaris and Windows platforms, and Grid Control on Sun Servers.
• Created and administered Oracle 11g databases for testing, development and demo environments for the South Dakota (SD MMIS ProviderOne) project.
• Performed typical DBA activities with the Oracle 11g databases, including performance tuning, physical and logical design, backups and schema refreshes.

Confidential

Database Administrator

Environment: Multiple Oracle Upgrade’s from Lower Versions to the 10.2.0.3, Migration of oracle database between HPUX to HP ITANIUM and administration of databases. HP-UX 11.X, HP-UX IA 11.X, solaris 8, Windows 2003, ORACLE 10G (10.2.0.3)

Responsibilities:

• Performance tuning using AWR, ADDM tools done.
• Database refreshes done using utilities like Export, Import, and Datapump.
• Monitoring Disk I/O activities for performance.
• Configured, monitored backups using RMAN and participated in regular DR exercise using RMAN.
• Administered RAC databases and Standby databases (Dataguard).
• Configured and monitored databases using OEM Grid.
• Installation and Maintenance of Stand by database.
• Experience in installation, configuration, monitoring of Oracle 10g,11g databases in Unix/Linux and Windows environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 11g.
• Expertise in using oracle Export/import, Datapump utility to migrate data across schemas.
• Knowledge in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases. Experience in Data warehousing and ETL.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features Data pump, AWR, ASM, ADDM, and Oracle
• Enterprise Manager.
• Knowledge on installation, maintenance and tuning of RAC applications.
• Experience in installation, configuration and administration of Oracle Databases.
• Scheduled jobs usingCron and Maestro tools.
• Coordinated with Unix team for HP OVO monitoring of file systems.

Confidential

Jr Database Administrator

Environment: SQL, Tkprof, OLAP, Linux, solaris, HP-UX, Statapack

Responsibilities:

• Provided high quality system support to over 50 clients on large and mission critical trading systems
• Key trouble shooter for numerous Oracle and Sybase server database issues and business critical issues.
• Administered and maintained OLTP and OLAP environments on Linux, Solaris and HP - UX.
• Played a key role in the devising and implementing effective Oracle backup and recovery strategies
• Proved adept at engineering, re-engineering, testing and documenting production support solutions
• Entrusted as key environment owner for 3 applications both in production and non-production
• Efficiently implemented major backup and restore strategies using SQLBACKTRACK utility
• Actively involved in Oracle Software installation, database design and creation
• Streamlined, optimised and enhanced the existing procedures and SQL statements for the better performance.
• Perfectly tuned databases and applications using Statspack, SQL trace, Tkprof and explain plan