SUMMARY

• Over 8+ years of professional experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation in high - availability environments such as Online Marketplace, State department, Healthcare and Information Technology.
• Providing DBA support to multiple Cluster, Non-cluster and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environment ranging from 9i/10g/11g.
• Excellent experience in Installation, administration and troubleshooting of Oracle 11g/10g/9i for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.
• Having Hands on experience working in both Application and Production support environment.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c.
• Configuration and Management of Data Guard 10g/11g on RHEL, OEL and Sun-Solaris fo Disaster Recovery
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues
• Performed Upgradation of databases from lower version (9i/10g) to higher version (11g)
• Implemented RMAN Backup&Recovery, Incomplete Recovery and disaster recovery using Data Guard
• Have good experience in migrating data from Solaris, HP-Unix to Linux
• I did worked on disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies
• System administration, Oracle Problem analysis & resolution and active cloning of databases between servers
• Testing and implementing different physical (hot/cold) and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import
• Knowledge of various storage solutions (SAN, NAS)
• Database refresh from production to QA, development and testing environments
• 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
• Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management
• Experience in SQL Tuning, SQL Optimization, cost based optimization and Hints
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Extensively used BMC Remedy, Pac 2000 ticketing systems.
• Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching
• Good analytical and problem solving skills with ability to work independently and in a team environment.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.xSun Solaris 9.0/10.0, AIX 5.1, 5.2

Data Bases: Oracle 11g/10g/9i, Oracle 11g/10g Real Application Cluster (RAC), ASM, MysqlSQL SERVER 2008/2012

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: /Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/ImportRMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC Export/Import, Data pump, Data-Guard, VERITAS Net Backup, OELBMC remedy, Pac 2000, VMware, Log-miner, Cron-Tab, Erwin, Ms Visio

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, FTP, TOAD

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

Senior Oracle DBA

Responsibilities:

• Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure
• Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments
• Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB
• Migrated databases from File-system to Automatic Storage Management (ASM)
• Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert
• Up-gradation of single instance databases from 10.2.0.1 to 11.2.0.3 on Linux
• Responsible for using Flashback query mechanism along with automatic undo management
• Experience in Creating Physical and logical database design Data Models using Erwin Tool.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c
• Implemented Data Guard with maximum availability and performance configurations for production databases
• Worked on Active data guard, Fail over and Switch over cases
• Hands on Experience in SQL Tuning and SQL Optimization.
• Created Oracle Tables, Table Partitions, Views, and Materialized Views
• Worked on database security, Transparent Data Encryption, Created tables with Encrypted Columns and Managed Encryption Keys
• Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation.
• Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.
• Creation of Users and granting them the required Roles and Privileges accordingly
• Cloned schemas, objects and data on new server using Data pump utility
• Decreased Contention by reducing the Wait Events as a part of Performance Tuning
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between oracle servers
• Involved in Tuning Query's, Stored procedures by making use of PL/SQL collections and its BULK FETCH and BULK INSERT features
• Ability to work effectively and can liaise as a part of team monitoring proactively
• Involved in 24x7 production database maintenance and on-call support

Environment: Oracle 10g, 11g, RHEL 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, TOAD, TDE, SQL*LOADER, Performance Tuning, AWR, ADDM, ASH, Data pumps, Exports/Imports

Confidential, Detroit

Senior Oracle DBA

Responsibilities:

• Involved with installation and maintenance of Oracle 3 node RAC for high availability.
• Involved in change control process and 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.
• Worked extensively on monitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control
• Involved in Migrating applications from single instance databases to Exadata
• Maintained 10g/11g RAC environment and troubleshooting issues.
• Responsible for implementing Load Balancing in RAC Database.
• Performed health checks in RAC instances using Crsctl and Srvctl utility
• Having good experience in Migrating single Instance database to RAC Environment
• Performed Capacity Planning, Undo segments and Health check reviews in RAC
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas.
• Performed Migration of databases 10g on Hp - Unix to Oracle 11gR2 on Linux.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Experience in Creating Physical design Data Models using Erwin Tool.
• Generation of DDL scripts using Erwin Tools.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Created Partition’s estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
• Involved in 24x7 production database maintenance and on-call support.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN, Data Guard, Golden-Gate, Toad, Exadata, OEM, ASM.

Confidential, Baltimore

Oracle DBA

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Worked on RAC (2 node) using cluster ware and ASM on 10g.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard).
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Install, upgrade and maintain Oracle 10g on HP-UNIX.
• Installed 10.2.0.4 agent and involved in registering of databases in OEM.
• Involved in Upgrade/Migration of the databases from Oracle 9i to Oracle 10g.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security.
• Database Restore using RMAN, Cold Backup and Export.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures.
• Performed database Cloning using hot backup and cold backup to setup test and development database.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block corruption Errors.
• Usage of Partitions to improve the query performance and manageability.
• Involved in taking logical backup using Data pump and Exports/Imports Utility
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and table-space I/O statistics.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Expertise in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK using OEM.
• Proficient in developing and maintaining of functions, procedures, triggers, indexes using Mysql database programming language.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• 24/7 on-call production database support.

Environment: Oracle 10g/9i, Mysql, Sun Solaris, HP-Unix, AIX, Linux 4.0, RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, Toad, PL/SQL.

Confidential, Sanfrancisco, CA

Oracle DBA

Responsibilities:

• Installed and configured Oracle and Oracle Products on Linux and Windows Environments.
• Involved in Installation and customization of Databases (10g&9i) in Linux and Solaris environments
• Supported databases on AIX, UNIX and Linux.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Manage users, privileges, profiles and schemas.
• Experience in using automatic monitoring and management processes such as batch processing using Crontab for processes like import, export databases.
• Involved in checking the status of listener and restarting listener.
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the alert logs and trace files regularly. Administering the Client’s Oracle 10g Database.
• Configured database on AIX,UNIX and LINUX.
• Compared schemas, databases, TNSNAMES.ora file and Table-spaces for better understanding of databases between test and production environment.
• Storage management, sizing the database objects, monitoring Disk usage.
• Involved in writing UNIX shell scripting for automating the jobs.
• Experience with SQL query tuning, SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• 24/7 on-call production database support.
• Architecture reviews, Change management meetings and Team meetings.
• Documented the complete project including all pre installation, post installation and database configuration steps.

Environment: Oracle9i/10g, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL Developer, Shell Scripting

Confidential

Junior DBA

Responsibilities:

• Managed Table spaces such as creation, reorganization and modification of storage parameters for optimization of disk space and defragmentation.
• Created and maintained user accounts, roles, privileges, and system & user level database objects.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.
• Day to day maintenance, troubleshooting and tuning of production Oracle database applications, daily monitoring and management network management software.
• Disaster recovery planning and testing, on site recovery.
• Experienced in Tuning SQL statements using Explain Plan, Profiler and TKProf.
• Setup various automation scripts process in crontab on Various Servers to automate tasks like Analyze the Tables and Indexes and Monitor the Object growth.
• Maintained 24X7 Web based Production database with ODBC/JDBC environment.
• UNIX shell scripting to automate different processes such as data loading and data analyze.

Environment: Oracle 9i, WinNT/2000, HP-Ux10.2, HP-UX, Explain Plan, Profiler, TKProf, Java, UNIX and Solaris 2.5