SUMMARY:

• Overall 8 plus years of experience in IT
• Sr. Oracle DBA with 7 years of experience as a Database Administrator DBA on 8i, 9i, 10g, 11g R2, and 12.1.0.2 database servers with RAC, ASM, Data Guard and Grid Control
• Worked as a Pentaho Developer - Business Intelligence tool OBIEE - PDI
• Extensive experience in installing and configuring Pentaho BI Server 3.6 for data warehouse ETL and reporting purposes. Managed license files for subscription of the products in Enterprise Console.
• Managed OBIEE and Developed Data Warehouse architecture, ETL framework and BI Integration using Pentaho Reports and Pentaho Dashboards.
• Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling them on Pentaho BI Server.
• Recently migrated 8i, 9i, 10g, 11g, and 12Cdatabase to another data center using Oracle Data Guard feature with minimal downtime.
• Worked on multiple OS systems (HPUX, AIX, LINUX, SOLARIS, & WINDOWS)
• Supported Informix Databases- Involved directly with monitoring sessions
• Worked on large databases with over 50 TB of data.
• Good hold of RHEL administrations
• Extensive experience setting up Maximum Availability Architectures and Capacity on Demand Architectures using various products, protocols and methodologies from Oracle including 11g & 12C Real Application Cluster (RAC), Data Guard, ASM, Grid Control, (ADDM), RMAN, Materialize view along with GoldenGate replications
• Installed maintained, migrated and upgrade different versions/releases of Oracle
• Worked with developers in troubleshooting bad SQLs to reduce the response time and rewrite efficient SQLs with proper indexing techniques and using SQL HINTS
• Worked with many new features of Oracle 11g and 12c
• Experience in Global Deployment R12/Upgrade

PROFESSIONAL EXPERIENCE:

Confidential, Fort Wayne, In

Sr. Oracle DBA

Role & Responsibilities:

• 24x7 Production Database administration
• DB upgrades - 75 Oracle DBs upgraded to version 12C
• Oracle patching - 149 DBs patched to the latest patch level on 12C
• Supported and monitored database with AR data of clients
• Analyzed development codes for AR data and provided high availability for specific database tables
• Implementation of data replication to new site for all Tier 1 databases, read/write instance builds for App DR testing, automation of R/W DB refresh using Pure snap/clone technology.
• Installed, configured and managed 11g R2 & 12.1.0.2 RAC databases
• Established Disaster Recovery for 11g R2 & 12.1.0.2 Clustered database using Oracle Data Guard.
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Create and manage Enterprise Manager jobs, alerts and notifications
• Analyzed and wrote various Stored procedures, Functions, Triggers to be created at the backend database to cater for the entire application
• Creating stored programs for PL/SQL
• Created and managed ASM instance and ASM disk groups
• Installing ASM environment and migrating database from NON-ASM to ASM
• Worked with Networking team for SCAN listener needs.
• Worked on several Shell scripts to maintain the database activities
• Configured the Flash Recovery Area
• Written shell scripts
• Configured Grid Control with RMAN backups.
• Set threshold alerts using Grid control.
• Troubleshoot slow running queries with the help of many oracle provided tools like statspack, ASH, AWR, ADDM, SQL Advisor.
• Worked with different teams during migrations, deployments and Database build tasks.
• Provided 24/7 on call assistance.
• Configured the RMAN with CommVault for backup and recovery
• Created shell and Perl scripts for automated tasks
• Monitor performance through Grid control and executes performance tuning, in particular, balancing application needs on shared platforms.
• Created a backup strategy, transaction log strategy & management, disaster recovery planning using Oracle's Data Guard
• Used Transportable tablespaces (TTS) for moving large volumes of data between Oracle databases.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Informix databases Support Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning. REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of STANDBY database using DATAGUARD.
• Applied High priority, security patches downloaded from Meta link
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Worked on Materialize Views.
• Managed tablespace needs.
• Participated in Business Analysis & requirement collection. Interacted with clients directly before writing requirement specification documents.
• Worked very closely with Project Manager to understand the requirement of ETL and reporting solutions to be built.
• Designed Data warehouse including star schema design, DW capacity planning, performance and tuning.
• Installed and configured Pentaho BI Suite 3.7 along with Pentaho Data Integration Server 4.1 on BI production box.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i,9i, 10g, 11g; RHEL, AIX, Windows NT/2000, HP UX,TOAD, Grid Control, GoldenGate, OEM, SQL Developer, RAC, ASM, Data Guard, Pentaho BI Server, Pentaho Data Integration (PDI/Kettle), Pentaho Mondrian OLAP Server, Pentaho Metadata Editor, Pentaho Design Studio, Pentaho Report Designer

Confidential, Cincinnati, OH

Oracle DBA

Role & Responsibilities:

• 24x7 Production Database Administration support
• Installed, configured and managed Oracle 10g RAC
• Configured Oracle networking for RAC
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of STANDBY database using DATAGUARD.
• Conducting sizing & capacity planning for Oracle databases.
• Creating stored programs for PL/SQL
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Experience in troubleshooting the ORACLE streams.
• Configured RMAN backup for 10g RAC database
• Monitoring 10g RAC performance
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Worked with system administrators, business analysts in designing and implementing backup and recovery procedures using RMAN, SAN based backups using EMC BCVS
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN. Using OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Provided System support for both development and 24*7 production environments.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Worked very closely with Oracle for Data Guard implementation and other major issues.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 9i, 10g, 9iAS; Sun Solaris Unix, Linux Windows XP, Oracle Forms 10g, Oracle Streams Oracle Reports 10g, Oracle Developer, RAC, ASM, Data Guard

Confidential, Bentonville, AR

Oracle DBA

Role & Responsibilities:

• All the daily database administration tasks including backup and recovery thru RMAN
• Import/Export, grants and roles etc.
• Optimized queries and generated graphical SQL results from Grid Control. Starting and shutting down and configured agents for various different maintenance tasks
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Perform Backup and Recovery thru RMAN.
• Full fill developers request to refresh schema's on a daily basis.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Worked on Global Deployment R12/Upgrade
• Applied various patches which includes quarterly critical patch & applied DST patches on multiple platforms.
• Upgraded oracle clients as per application needs.

Environment: Oracle 10g RAC/9i, SQL, RHEL 4, AIX 5.2, Shell scripting, Oracle Streams Oracle Reports 10g, Linux