SUMMARY:

• Over 10 years’ of experience in IT Industry working as a DBA in multiple industries
• Experience as On - Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g, and 12C with experience in very large scale database environment and mission critical large OLTP and OLAP systems.( size=10TB)
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and and 12CRAC and standby database for High Availability and Disaster Recovery purpose.
• Experience in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 10g/11g/12C RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Clusterware administration, Configuration and Patching.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Materialized views, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) & Cloud Control (12c,13c) for database monitoring/performance/diagnostics.
• E xtensive experience in database Backups RMAN ((Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces
• Good experience in writing/editing UNIX Shell Scripts.
• Good Experience in PATCHING AND UPGRADATIONand upgrading Oracle Development and Production databases from 9i to 10g & 11g, 10g to 11g, 11g to 12C.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

TECHNICAL SKILLS:

Operating System: Red Hat Linux, Unix, Solaris, HP-UX, AIX, Windows 2003/XP/7/8.

Databases: Oracle 9i/10g/11g/12c,RAC 10g/11g/12c, MS Access, Mysql 5.5/5.6/5.7,Mysql Cluster, MsSql Server(2005-2014),Mongodb

Virtualization Technologies: VMware, Oracle Virtual Machine

Languages: SQL, PLSQL, UNIX shell scripting, Ant scripting, Batch Scripting

Web Servers: Apache Tomcat, Web logic, Jboss

Tools: and Utilities(ORACLE): Oracle Cloud Control (12,13), Oracle Grid Control, Oracle Enterprise Manager,Sql Developer, PL/SQL Developer,Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, Explain Plan, Dataguard,HA, Snapshot Standby,Mysql Replication,Statspack, Golden Gate, AWR,ASH, ADDM, RMAN, Oracle Secure Backup, FTP, TKPROF,Amazon RDS,Flashback,Partitioning,Mysql Enterprise Backup,Mysql Dump,Mongodb Replication,Oracle Goldengate(11,12),Mysql Enterprise Monitor,Performance Tuning,Disaster Recovery, OLTP, OLAP,Datawarehouse, ASM, CRS, SRVCTL, Sql Loader, Bash, Data Mining, Sql, PL SQL, Top, AWK, SED, Veritas,CVS,SVN

Other Tools: SQL Developer, OEM, VMware, putty, TOAD, WINSCP

PROFESSIONAL EXPERIENCE:

Confidential, Brookfield, WI

Senior Oracle DBA

Responsibilities:

• Handled On call issues and jump into Sev1 /2 calls and ensure timely restoration of database services. Take care of critical Database tasks and ensure end-to-end delivery of work
• Extensively worked on multiple 10g/11gR2 RAC environments on ASM, 10g/11g/12c DATAGUARD setups & RMAN
• Applied quarterly PSU Patches to RAC/Non-RAC databases.
• Applied CRS Bundle patches/PSU to CRS on RAC clusters.
• Upgraded of CRS/ASM/RAC databases from 10.2.0.4 to 10.2.0.5 & 11.1.0.6 to 11.2.0.3, 10.2.0.5 to 11.2.0.3 etc.
• Upgraded from 10.2.0.4 CRS/ASM to 11.2.0.2 GRID Infrastructure
• Space Management in ASM Diskgroups, Addition of new disks etc.
• Troubleshooted RAC, DATAGUARD, and ASM issues
• Creation of new RAC databases, conversion from single instance to RAC
• Installed and Configured 2/3 Node 10gR2/11gR2 RAC setups with ASM on Linux & HP-UX
• Configured of RMAN backups/Monitoring for RAC databases, refresh stage databases
• Setup 11g Standby database setups, Active Dataguard
• Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Faststart Failover
• Perform DR drills e.g Switchover/Switchback using DG Broker etc.
• Upgraded RAC-Dataguard setups from 11.2.0.4 to 12.1.0.2
• Setup and configured OEM 10G Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc.
• Support RAC & Single Instance Production/Stage/Dev databases on (Redhat, Solaris, And Vmwareenvionments)
• Installed and configured Goldengate replication. Perform zero downtime migrations
• Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp
• Configured RMAN backups for databases and schedule them through Crontab
• Resolved common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc
• Performance Tuning of problem queries
• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.
• Installed and Configured Oracle Goldengate 12.2 on (windows, linux and unix platforms)
• Configured from Oracle 11g to Mysql 5.6 replication via Goldengate 12.2
• Configured Oracle Goldengate 12.2 from Oracle11g (windows platfrom) to Oracle 11g (Solaris sparc platform) replication
• Configured Oracle Goldengate MsSql to Oracle (linux platform) replication
• Upgraded Oracle GoldenGate from 11.2 to 12.2
• Implemeted and maintained Database security (create and maintain users and roles, assign privileges)

Confidential, Oak Brook, IL

Oracle DBA

Responsibilities:

• As Production DBA, managed all database issues including database capacity, backup & recovery, scripting and Performance tuning.
• Worked as team member to provide 24/7 on call production database support.
• Supported and maintained multi-terabyte high transactional OLTP RAC-enabled database.
• Implemented Upgradation and Migration of Database's from 11.2.0.2 to 11.2.0.4 and applying patches whenever required.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• ASM Setup and maintenance on RAC databases.
• Used RMAN for backup and recovery.
• Configured and managed Data Guard for Production databases.
• Installed and configured Oracle 11g RAC, developed 2 node RAC environments for a 25TB database by implemented WAN technology to reduce the network traffic.
• Responsible for Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Responsible for regular Security Patching on Oracle Products and interim patches for various bug fixes on database products.
• Migrated of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.
• Recovered Golden Gate corruptions and managing host/cluster maintenance mode blackouts.
• Installed, configured and supported uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.
• Monitored of database using Oracle's Enterprise Manager (OEM), Statspack Reports, Explain Plans, and SQL Trace.
• Regularly monitored the Production databases using OEM 11g Grid control.
• Applied Consolidated Update, Critical Patch Update (CPU's), Security alert patches using Opatch.
• Monitored and tuned database performance including SQL tuning.
• Implement complex enterprise changes as they pertain to the database environment.
• UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• UNIX shell scripts for partition splitting.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.

Confidential

Senior DBA

Responsibilities:

• Installed and Configured 11g Oracle database
• Installed and Configured Physical standby database for Production Database
• Installed and Configured Application Servers (Jboss AS, Apache Tomcat,Dal, EYEKS,OTURUM)
• Created and Scheduled Backups for Production Database and Application servers
• Created and Installed Development Environment (Database and Applications)
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Confidential

Senior Oracle DBA

Responsibilities:

• Supported a five-terabyte data warehouse.
• Played a lead role in enterprise-wide database optimization and instance and resource monitoring.
• Performed root cause analysis on failures.
• Resolved performance tuning related issues.
• Worked actively with Oracle features such as AWR, ADDM, and ASH, performance statistics collection, and fine tuning database wait events.
• Provided on-call support for enterprise databases.
• Started and managed weekly optimization meetings with enterprise user groups to address and resolve performance-related issues with a high degree of success.
• Successfully set up a four-node cluster and RAC(11g) data warehouse on Linux (Oracle) using ASM/OCFS2.
• Identified, led, and established automation of repetitive processes to minimize errors.
• Completely eliminated space errors by implementing proactive space monitoring and effective space allocation.
• Greatly improved performance in daily transforms by identifying and reorganizing indexes on major tables.
• Successfully set up 2-node cluster RAC (11g) OLTP on SOLARIS(sparc64)
• Successfully set up in three different location Oracle Standby Database for RAC
• Successfully Upgraded Oracle 10GR2 RAC Database to 11GR1 RAC database
• Successfully Upgraded Oracle 11.1.0.7 database to 11.2.0.2
• Provided 24x7 Remote / on-call production supports
• 24x7 Production database and applications support.
• Installed, configured, and maintained Oracle 10g and 11gR2.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied CPU patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moved data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured GoldenGate for replication.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Performed Capacity Planning and Bench Marking
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables
• Installed and Configured Jboss As, Apache Tomcat Application servers
• Installed and Configured Sql Server 2008
• Monitored and troubleshooted Sql server 2008
• Backup and Restored Sql Servers
• Configured Mirroring, Logshipping and replication for Sql Server Intances

Confidential

Senior Oracle DBA

Responsibilities:

• Installed Real Application Cluster Databases (4 different cluster database)
• Installed and Configured Physical standby database for Production Databases
• Installed and Configured Application Servers (Jboss)
• Created and Scheduled Rman and expdp Backups for Production Database and Application servers
• Created and Installed Mysql database for integration for other organizations
• Created andScheduled Backups for Mysql database
• Created and Installed CVS server
• Created and Installed Development Environment (Database and Applications)
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Confidential

Oracle DBA

Responsibilities:

• Created and Installed Oracle Real Application Cluster Database (with 2 nodes)
• Installed and Configured Physical standby database for Production Database
• Installed and Configured Application Servers (Jboss, Dal, Eyeks, Oturum)
• Created and Scheduled Rman and expdp Backups for Production Database
• Created and Installed Development Environment (Database and Applications)
• Created andScheduled Backups for Application servers
• Created and Installed CVS server
• Migrated All previously Installed Databases into one Production Database
• Created and Configured Automated Document Management Systems
• Managing and maintaining Oracle databases running on Linux
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Installed and Configured Sql Server replication and log shipping
• Installed and Configured Sql Server 2005
• Upgraded All Sql 200 servers to 2005 and migrated all Databases to SQL 2005

Confidential

Jr DBA

Responsibilities:

• Created and Configured 11g Oracle database
• Created and Configured Physical standby database for Production Database
• Created and Scheduled Backups for Production Database servers
• Created and Installed Development Environment (Database and Applications)
• Created and Configured Automated Document Management Systems
• Managed and maintaining Oracle databases running on Linux
• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.