SUMMARY

• Around 8 years of experience as an Oracle Database Administrator on Oracle 12c/11g/10g/9i/8i database servers with RAC, ASM, Data Guard, Golden Gate and Grid Control experience. Highly competent in database Administration, Installation, Configuration, Migrations, Upgrades, Patches, Monitoring and specialized in Advanced DBA skills such as Performance Tuning, Database Backup and Recovery, Troubleshooting, Physical and Logical database design.
• Expertise in installing, configuring and maintaining Oracle high availability solutions like Real Application Cluster (RAC) on Oracle 9i, 10g & 11g on Windows, Linux and Sun Solaris platforms.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Installed, configured and maintained ASM enabled 11g RAC and Migrated single instance databases to RAC environment.
• Oracle Golden Gate installation, upgrades, patching, High Availability (HA), configuration, troubleshooting GG issues.
• Proficiency using Oracle Golden Gate replication monitoring, tuning and capacity planning.
• Administered Oracle Golden Gate 11g application for real time transactional change data capture, transformation, and delivery, offering log - based bidirectional data replication.
• Configured and maintained physical standby databases using Oracle Data guard to perform quick disaster recovery.
• Tested and performed data guard switchover on the RAC databases manually and also using data guard broker.
• Planned, built and maintained standby database using Data Guard as both Physical Standby and Active Data Guard.
• Expert in Database Protection, backups, user-managed backup/RMAN-managed backup with or without catalog, Cold and Hot backup.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database.
• Expertise in Performance tuning like SGA (Memory) tuning, Disk I/O, SQL tuning, SQL Tracing, Segment Level tuning.
• Extensive knowledge in Database Performance Troubleshoot using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Expertise in database and Application performance tuning using EXPLAIN PLAN, TKPROF, STATSPACK and SQL Tuning.

TECHNICAL SKILLS

Tuning/Monitoring: RAC 10g/11g, RAC 10gR2, Data-Guard, DB Cloning, Standby Databases, TKPROF, EXPLAIN PLAN, STATSPACK

Tools: SQL*PLUS, TOAD 7.6/7.5, PUTTY, OEM 9.2/10G (10.1/10.2) Grid Control, RAT RMAN, SQL* LOADER, DBCA, Imp/Exp, Data pump

Databases: Oracle 12c, 11g, 10g, 9i, 8i, MySQL 5

Operating Systems: HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2, WINDOWS NT/2000/2003/2012 Server, RED HAT LINUX 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, MS SQL Server 2008/2012, VMware ESX Server 3.0.x/3.5.0.

PROFESSIONAL EXPERIENCE

Confidential, Wellesley MA

Sr. Oracle DBA

Responsibilities:

• Part of a 5 member Oracle Database Administrator team.
• 24*7 Production Technical Supports and Hardware Support.
• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Installed Oracle 10g, 11g on Production DB Servers, applied Opatch to fix the known bugs.
• Upgrade and Migration of Databases from 10g to 11g, 11g to 12c and applying patches as per requirement.
• Migrated data from MS SQL Servers to Oracle, and vice versa.
• Strong knowledge and experience of managing Oracle 10g/11g RAC environments using the Grid Control tools.
• Actively participated in installing of 11g RAC on Linux environment with two node cluster and ASM.
• Experience in using GoldenGate in moving large transactional data with minimal impact to online systems and performing GoldenGate on process of extract and replication of single instance as well as RAC Databases.
• Supported 40 production and 250 plus development and testing databases with database ranging from 50GB to 1.5TB.
• Highly experienced in using STATSPACK, AWR to check health of database & hardware.
• Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT.
• Used tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE, SQL Tuning Advisor and SPM to tune SQL Queries.
• Conducted SQL tuning and monitoring as a part of performance monitoring.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Performed database Cloning using cold backup and RMAN to setup test and development database.
• Coordinated with System Administrators for Server Support, NAS and SAN storage.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Actively monitor the Top Activity on OEM 12c Performance page.
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Involved in installing, configuring, maintaining mission critical Oracle and DB2 database in production, development and QA databases on a 24/7 basis.
• Created SRs with Oracle team and provided necessary data to achieve resolution.
• Worked with OLTP and OLAP database modeling.
• Advanced replication using Oracle Streams.

Environment: Sun STOREDGE 6140, 6130, 3500, Red Hat Linux x86, OEL, EMC Storage, VERITAS Net backup, Solaris 10, 9, 8 AIX 5.2, 5.3 BMC Patrol, SUN SPARC, Dell Power edge, 11g OPS center.

Confidential, Addison,Texas

Sr. Oracle DBA

Responsibilities:

• Part of a 6 member DBA team which was involved in the maintenance of the Oracle 9i/10g/11g database for the Production as well as the development environments.
• Perform installation, maintenance, and troubleshooting and performance administration of Oracle 11g under IBM z/OS 1.12.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Planned GoldenGate setup to achieve unidirectional replication.
• Performed data replication, transformation and delivery of database transactions using GoldenGate replication tool. Supported a large number of Development Databases.
• Performing Online and Offline database backups on schedule.
• Scripting of Automated backup for Cold/Hot backups.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Performing daily Archive log file backup and checking Alert Log files.
• Monitoring the tablespace growth and resizing the tablespace on 10g RAC environment.
• Using RMAN & User Managed backup methods for better control.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Performed administrative maintenance, monitoring both Oracle and MS SQL Server database systems in a global 24x7 operational environment.
• Migrated DB2/MYSQL databases to Oracle 10G (R2) version using data migration tools such as DBArtisan, Oracle Developer, SQL Loader and Toad.
• Database creation using DBCA on RAC environment on both 11g/10g.
• Involved in Database sizing, Capacity Planning.
• Involved in monitoring the lock/block processes, releasing locks in case of resource blockage and gathering statistics.
• Maintained Microsoft SQL Database Server 2003.
• Net8 Configuration for Clients Connection.
• Creating ODBC for users & Application Developers.
• Data replication between units has been done.
• Created users and set permissions.
• Managed database security using groups and roles.
• Created database objects and managed the permission access on the objects with necessary security.

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 1TB, Solaris Fire 440,IBM z/OS 1.12, Fire 880, Oracle 11g/10g/9i, HP Integrity rx 8640, RHEL AS 5, SQL * Plus, OEM, Erwin Data Modeler.

Confidential, Lewisville, TX

Sr. Oracle DBA

Responsibilities:

• Tuning the Applications for optimal performance, designed the backup strategy for the applications, Designed and developed table structures, PL/SQL stored procedures and database triggers to implement business rules. Created Tables, Views and Indexes for the Project.
• Support involves handling multiple Oracle 10g RAC with Veritas Cluster, Sun Cluster and Oracle Clusterware across various applications hosted in Oracle 9i/10g and 11g Databases across Linux, HP-UX and Solaris.
• Installation and supporting oracle enterprise manager grid Control (OEM Grid Control 10g), Cloning of oracle 10g binaries, Deploying of OEM 10g agents, Migrating and Upgrading Database and Oracle binaries, Applying Patches with automate scripts.
• Handling all maintenance and administrative functions for databases, including space management, backup/recovery, RMAN Backup copying prod to development databases. Schema level refresh on user’s request using import/export and data pump.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Installation and configuration of Oracle 9i & 10gRAC database and Performed DBA tasks
• Migration of database from Oracle 9i to Oracle 10g.

Environment: - Oracle 9i/10g/11g, RAC, ASM, RMAN, Data Guard, SQL Developer, SQL Loader, OEM, Sun Solaris, Red Hat Linux, OEL, Toad, PL/SQLComerica Bank

Confidential, MI

Sr. Oracle DBA

Responsibilities:

• Part of a 6 member DBA team. It was involved in 5 production databases and 11 development/test databases.
• Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
• Proficiency with Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate.
• Hot/Cold backups of the database through RMAN, Hot backups & BCV’s.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Installed and Configured MS SQL Server 2005 on Windows 2003.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Extensively used 10g asmcmd utility.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Exposure to Exadata commands and experienced overview of architecture and some hands on.
• Perform Space Management & Troubleshooting the database issues.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Environment: Oracle 8i, Oracle 9i, Oracle 10g

Confidential

Oracle DBA

Responsibilities:

• Involved in a 7 member DBA team.
• Load data from OLTP systems into data warehouse databases.
• Installed and configured Oracle and Oracle Products on Linux and Windows Environments.
• Monitored & tuned the performance of database and SQL statements
• Monitored for unusual conditions in database against contention, load throughput and cache utilization.
• Performed database Logical backups using export, import and Datapump.
• Performed database Recovery using physical, logical and RMAN backups.
• Collecting the statistics using Explain Plan and TKPROF, studying the report.txt during performance slowdowns. Collecting the statistics of tables and indexes by analyzing for cost based optimizer mode.
• Used SQL LOADER for dumping data into database from Legacy Systems and Flat files.
• Good experience in SQL, PL/SQL, Shell Scripting.
• Shell scripting in Korn Shell for monitoring heartbeat of the database, disk utilization and paging dba with errors in alert log file.
• Worked with DW team for loading data to warehouse databases.
• Performed Table space Management and Rollback table space Management.
• De-fragmentation of database objects
• Involved in migration of the databases in Oracle 8i from Windows to Linux.
• Monitor and tune Database, SQL statements performance using OEM, STATSPACK, TKPROF, and EXPLAIN PLAN.
• Cloned environments to create patch test, development and QA environments.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.

Environment: Linux AS4, OEL 5.3, Red Hat Linux, Oracle 8i/9i OEM

Confidential

Jr. Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Creating primary database storage structures (table spaces, rollback segments, etc.)
• Design and development of Database Objects and Users as per the business needs.
• Developed entity relationship, data flow and functional diagrams.
• Designed Logical and physical data models using Erwin Data Modeling Tool.
• Developed new PL/SQL programs - Triggers, Functions, Procedures and Packages to manage various business functionalities.
• Maintained batch files, shell scripts and PL/SQL Procedures for scheduling backups.
• Developed PL/SQL Packages to monitor earnings and expenses, for maintaining the general ledger of the organization.
• Responsible for developing PL/SQL programs that includes function, procedures, triggers and packages.
• Maintained control files, log file, data files, table spaces and rollback segments.

Environment: Linux AS4, OEL 5.3, Red Hat Linux, Oracle 8i/9i O