PROFESSIONAL SUMMARY:

• Oracle Certified Database Administratorwith around 7 years experience in installing, configuring, administering and managing oracle databases & implementing solutions like high availability (HA), data guard.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, and UNIX in OLTP environment.
• Installation and administration of SQL server 2008/2012 on RHEL, Windows, and UNIX in OLTP environment.
• Experienced on SQL Server 2012 migration from SQL Server 2008/2005.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
• Good Experience in Installing, creating and maintaining Oracle Data Guard - Physical.
• Configuration of Automatic Storage Management (ASM).
• Extensive experience with Database Cloning and Refreshing pre-production/development databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM.
• Regular database synchronization for test database environments through automation.
• Experience in Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/11g/10g/9i.
• Experience in 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.
• 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.
• Experience using Pentaho as a Data Modeling tool.
• Experience designing the DW model and the physical structure.
• Proficient with Oracle Standby Database, Data Guard, Replication, Upgrade, Refresh and Cloning.
• Good Experience in Installing, creating and maintaining Oracle Data Guard-Physical.
• RMAN refresh and cloning with standalone and RAC to RAC database.
• Providing connectivity and troubleshooting of connectivity problems.
• Good experience in SQL, PL/SQL, Shell & Perl Scripting, Partitioning, Logical Database Design, Backup and Recovery procedures.
• Extensively used Import & export, Data pump, SQL*Loader, Partitioning, Materialized views features.
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data clean-up, data archiving.
• Used Oracle scheduler and Unix Cron Utility for automating jobs.
• Experience in creating databases as per Client Standard.
• Monitored and managed various database components (logical & physical) like table-spaces, segments.
• Ability to work in a team as well as to take individual responsibility.
• 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.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2008/2012, Postgres 9.0 or later, MySQL.

Oracle Products: OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, DATA PUMP, ASM, RAC, NETCA

Programming Languages: SQL, PL/SQL

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

Other Tools: OEM, TOAD, OID, FTP, PUTTY, PENATHO KETTLE, SQL DEVELOPER, SQL MANAGEMENT STUDIO, POSTGRES EDB.

Business Productivity tools: Oracle E-Business Suite, Microsoft Office, Excel, PowerPoint, Visual Paradigm, Microsoft Visio, Pentaho Business Analytics and Data Integration.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

• Administrated databases, performing data integration, testing, and auditing activities on the application.
• Implemented Database Mirroring in SQL server 2008 R2.
• Installed databases and migrated databases including structure and scripts.
• Cleaned large datasets and prepared databases using Pentaho Kettle ETL tool for analytics.
• Implemented Oracle 11g RAC (5 node) systems in HA environment in Linux & also in Virtual Machines.
• Configured and managed active Data Guard for Production & Pre Prod databases for reporting purpose and monitored log transport services and log apply services in Physical/Logical databases.
• Good experience with Oracle performance issues in both application tuning &memory tuning.
• Monitoring databases using Oracle Enterprise Manager (12c) to diagnose & troubleshoot database and host problems.
• Worked with RMAN backups, expdp/impdp utilities and Hot/Cold backups.
• Performed Oracle 11g/12c, SQL server 2008/12 RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities.
• Worked on SQL Server 2012 migration from SQL Server 2008/2005.
• Closely worked with developers and worked as release coordinator for all changes in databases.
• Generated AWR, ASH and ADDM reports in production database.
• Databases REFRESH/CLONING using EXPORT/IMPORT, DATAPUMP at table, and schema and database level for testing & development purpose.
• Data loading using SQL loader & data pump utilities.
• Migrated database from SQL server 2008/2012 to Oracle 11g using SSMA, Oracle Migration Workbench.
• Closely worked with capacity planning teams for new implementations.

Environment: Oracle 11g/12c, SQL server 2008/2012, RHEL 5.6, TOAD, SQL Developer, TOAD, RMAN, ASM, 12c OEM, Data Guard, Putty.

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

• Responsible for providing 24X7 production support for critical Payments, Financial, Loan and Brazil applications’ Oracle 10g/11g/12c databases on OEL and RHEL.
• Installed Oracle 10g/11g/12c stand-alone and RAC systems in HA environment in different O.S platforms (OEL, Linux, RHEL and VMware).
• Involved in handling large database up to 14 TB in size with 4 nodes cluster on various flavors of UNIX.
• Configured and managed active Data Guard for Production & Pre Prod databases for reporting purpose and monitored log transport services and log apply services in Physical/Logical databases.
• REFRESH/CLONING of Databases and applications for development, testing and Prod boxes on demand from Application teams using EXPORT/IMPORT, DATAPUMP at table level, schema level and database level for Refreshes.
• Implemented various backup strategies for big / med and small databases using RMAN.
• Installed, configured Oracle 12c grid infrastructure for standalone & RAC databases.
• Upgraded Oracle 9i/10g to the Oracle 11g R2 database version.
• Responsible for identifying performance problems in production databases by identifying issues using AWR, ASH and ADDM reports.
• Worked with Oracle performance issues in both application tuning &memory tuning.
• Performed various activities, such as database recovery, performance monitoring and tuning, structured query language, operating systems and relevant tools.
• Performed database cloning production databases for the purposes of testing using RMAN.
• Developed shell scripts for daily administration.
• Responsible for day-to-day activities such as creating users, roles, schemas, tables, views, indexes, verifying and running scripts given by the clients.
• Worked as a primary for weekly and monthly releases and coordinated with application teams and development teams in release window times.
• Configured and managed Data Guard extensively for Production databases of sizes ranging from 50 GB to 5 TB.
• Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.

​​Environment: OEL, RHEL, Oracle Database Version 10g/11g/12c, RMAN, Data guard, RAC, ASM, and Oracle Enterprise Manager Grid Control 12c.

Confidential, Little Rock, AR

Oracle DBA

Responsibilities:

• Installation, configuring, patching of Oracle Enterprise Edition ranging from Oracle 9i, 10gR2 on various platforms.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on different nodes with Automatic Storage Management (ASM).
• Production Maintenance support with 24/7 for the Oracle 11g & 10g databases which is on primary and standby server.
• Oracle database design, installation/ up-gradation, Backup, Recovery, Migration, Cloning, Performance tuning, Integration with different products and trouble shootings.
• Maintained databasebackup and recoveryusingRMANfor various failures.
• Involved in using Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Auto Trace, Grid Monitoring, and Recycle Bin.
• Cloning databases using scripts as well as RMAN and performed Table space point in time recovery (TSPITR) using RMAN.
• Data Refresh from Production to Test and Development environments usingRMANDuplicate Database (Cloning).
• Data Partitioning, Database Snapshot, Materialized Views in SQL Server 2005.
• Managing the Clustering failover environment.
• SupportedAutomatic Storage Management (ASM)database and performedmigrationto normal database to ASM database using RMAN.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor the database performance and for user management.
• Extensive performance tuning experience, specializing in Operating System Tuning,SQL Tuning,Database/Instance Tuning.
• Creation of table spaces, database users, roles and DB-links required.
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.
• Perform Data validation and massaging to ensure accuracy and quality of data

Environment: Oracle 11g/10g/9i, RAC, DATAGUARD, ASM, Red Hat Linux, SOLARIS, RMAN, SQL*Plus, SQL, PL/SQL, UNIX, SQL*LOADER, OEM Grid Control, Import/Export, Data pump, STATSPACK, AWR, ADDM.

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• The work involves overall ORACLE Database Maintenance, Performance Tuning, Backup, Recovery and other Database related activities.
• Installation and Configurations of 9i, 10g databases.
• Daily Health Check of the Database and Monitoring Alert Logs of all databases.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL Trace, TKPROF, Explain Plan, AWR and ADDM.
• Designed the database schema and created any necessary database objects.
• Partitioning Strategies for very large tables.
• 24x7 on-call production database support
• Data refresh from production to test and development, maintain Database Security.
• Used shell scripts to monitor and maintain the Oracle database.
• Resolve various application failures due to data entry errors or system errors.
• Automation of Startup Shutdown on all Production and Development Database.
• Providing Solutions to the Oracle Problems Faced by End Users Or Programmers.
• Taking Backups on scheduled time and monitoring scheduled Backups
• Diagnose and troubleshoot Database problems and failures.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Tuned memory structures such as the database buffer cache, shared pool and library cache.

Environment: Oracle 10g/9i, Windows, RedHat Linux, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL*Loader, Data Pump

Confidential

Oracle DBA

Responsibilities:

• Performing day-to-day activities such as creating users, roles, schemas, tables, views, indexes and running scripts given by the clients.
• Creating and Maintenance of the Oracle databases on different servers.
• Installed and implemented 2 node 11g RAC on RHEL and worked on ASM features of Oracle.
• Installation, Configuration and Maintenance of Oracle RDBMS software.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard.
• Installation, Configuration and Maintenance of Oracle Grid Control.
• Setup of Cold Backup of test/development databases through RMAN for weekly maintenance.
• Data refresh from Production to Test and Development environments using RMAN duplicate database.
• Migration of databases from My-SQL to Oracle 11g using SQL Developer
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily health checks up of the database using STATSPACK, AWR, and ADDM.
• Involved in migration of applications of the clients.
• Automating the routine DBA tasks through Cron.
• Worked on uploading large batch of transaction data using batch processing technique.
• Loading the data into database with SQL*Loader and External Tables.
• Supported different databases like Production, Testing, Staging and Training.
• Granted permissions to end users according to their level of access to database objects.
• Monitoring the database daily activities through the Grid.
• Monitoring alert log/system log.

Environment: Oracle 10g, MySQL, SQL, PL/SQL, Oracle Grid Control, TOAD, Oracle Enterprise Manager, SQL*Loader, NT, Red Hat Enterprise Linux, UNIX, AIX.