PROFESSIONAL SUMMARY:

• Database Administrator with 8 years of experience in Installation, upgrade, migration, Management, Administration, Backup and Recovery, Replication, Maintaining and Tuning of Oracle RDBMS.
• About 7 years of Extensive Experience in Installing and upgrading Oracle 8i/9i/10g/11g databases on production, test and development environments on Solaris 8,9,10, AIX and Linux boxes.
• Experience in installing guest operating systems on VMware and installing and configuring 9i/10g databases and Oracle 9i/10g RAC.
• Experience in installing, configuring and maintenance of Oracle GoldenGate and Veridata.
• Participated in Data migrations which include migrating the source from flat file to the Oracle Database using SQL*Loader (control files).
• Well versed with new features of Oracle 12c Database.
• Experience in OLTP/DSS Database systems, managing large Oracle Databases (VLDB).
• Oracle Discoverer, Oracle OLAP and Oracle Data Warehouse Builder and expertise in multivariate statistics using SAS, SPSS and Clementine.
• 6 years of strong experience in Hot/Cold Backup and Recovery.
• Excellent knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM), EMC Data Domain.
• Point - In-Time Recovery through RMAN.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, SQL BASELINES, OEM Advisors, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• In depth knowledge of Oracle 10g, 11gR1 and 11gR2 RAC, RAC internals and RAC tuning.
• Migrated single instance databases to multinode 11g RAC environment for high availability and load balancing.
• Oracle ASM enabled 11g RAC setup and administration using Dell/EMC SAN for storage.
• Knowledge of the Oracle Golden Gate installation, upgradation and configuration. Proficiency using Oracle Golden Gate replication monitoring, tuning and capacity planning.
• Performed bi-directional replication from source to target Database using Golden Gate.
• Expertise in Replication data from Oracle to GoldenGate using GoldenGate Flat file adapter.
• Implemented FSFO (Fast start failover) on databases, configured Datagaurd setup, built standby databases.
• Implementation of disaster recovery site using Datagaurd.
• Proficient with 11g new features: Active Datagaurd, configuring Snapshot standby database.
• Implemented partitioning on large tables, expertise in using composite partitioning, local indexes and global indexes.
• Implemented indexes of Hash partitions, Reverse key Indexes, Indexes with smaller block size.
• Automated Rebuilding indexes, Partition additions and space additions.
• Strong experience in installing and administering Oracle database using tools OEM,TOAD
• Experience in Implementing and configuring 10g OEM Grid Control.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Proficient in SQL,PL/SQL, Perl Scripting, Shell Scripting, ERwin Data modeling, Oracle Data Dictionary - meta data, Logical and Physical Database Design.
• Has good experience in SQL Server Clustering and MSSQL Server 2000/2005 Log Shipping, Database Mirroring.
• Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling
• Transferred compressed files on FTP servers, on UNIX platform

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i/8i/8

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005,Windows NT,XP

Languages: SQL, PL/SQL, C, C++, Perl, Korn, UNIX Shell Scripting, Java, VB, Advanced VB

Networking: ISO 8583, TCP/IP, UDP, SCI, SPI, PCI, NFS, DHCP, LAN

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD,DBARTISAN

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.

Other Tools: EMC, NetApp, Veritas NetBackup, CSS, HTML, Java Script, GoldenGate

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Oracle Project DBA

Responsibilities:

• Served as subject matter expert for all GoldenGate implementations.
• Experience working with Solution Engineering team and Architechture Team to come with requirements for Server Requirements, Capacity Planning and Schema Design.
• Installed and configured GoldenGate flat file adapter to capture data and write to flat files which were then picked up and loaded into GreenPlum.
• Expertise in installing GoldenGate on RAC environments and setting up integrated extract for replicating compressed and LOB tables.
• Used GoldenGate to split a 20 TB database into 3 different databases over a two week period.
• Expertise in setting up GoldenGate using all various forms of instantiation methods such as RMAN Cloning and Export Datapump/Import Datapump utilities.
• Designed and implemented solutions to use GoldenGate for Disaster Recovery Purposes.
• Setup Oracle bi-directional replication.
• Experienced in designing solutions for conflict detection and resolution with bi-directional replication.
• Expertice in using defgen utility to generate definition files for tables setup in Oracle GoldenGate.
• Migrated large oracle database to Exadata using RMAN active cloning with minimal downtime.
• Implemented Exadata New features smart scan, storage index, HCC, smart flash cache and I/O Resource
• Attended Exadata workshop conducted by oracle.
• Implemented smart flash log for Exadata environment
• Involved in Exadata storage expansion for X3-2 .
• Deployed new Exadata machines on X4-2 and X5-2.
• Developed shell scripts to automate the start of Goldengate after server reboot.
• Developed scripts to generate the status of Oracle GoldenGate from a central OEM server.
• Developed Reconciliation reports for Oracle Goldengate.
• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Upgraded Grid Infrastructure and Database from 11.2.0.2 to 11.2.0.4.
• Upgraded both Single Instance and RAC databases from 11g to 12c .
• Converted mutiple databases from single instance to container and pluggable databases.
• Implemented password security, role management, database and server naming conventions and used database triggers to secure databases across the environment.
• Developed Security Baselines for Database and GoldenGate to ensure compliance with Technology Risk Management.
• Experienced in using Change, Incident and Knowledge management using Service Now.
• Expertise installing 11g RAC on Linux environment with four nodes and ASM as storage.
• Upgrade and Migration of Databases from 11g R2 to 12c and applying patches as per requirement.
• Supported 40 production and 300 plus development and testing databases with database ranging from 100GB to 2TB.
• Highly experienced in using SQL Baselines, AWR report and Oracle SQL monitoring tools to identify and resolve SQL performance issues.
• Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Conducting sizing & capacity planning for Oracle databases.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Maintaining schemas and partitioning tables.
• Experienced with all kinds(Status, Performance, Trend Analysis) of DB MONITORING
• 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.
• Designed and Developed shell scripts to automate the processes and to proactively monitor the database.
• Importing data from flat files into database using SQL loader and External Tables.
• Installation and Configuration of Oracle Data Integrator (ODI). Responsible for configuration of Master and Work Repositories on Oracle.
• Development and design of ODI interface flow for Upload / Download files.
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques, and other methods, including the use of automated tools.

Confidential, Atlanta, GA

Sr. Oracle Database Administrator

Responsibilities:

• Experience in working on an application migration from the ground up wherein I was responsible for the hardware design, architecture, migration planning, database configuration and application code review.
• Installing, configuring and maintenance of Oracle Replication Tool Oracle Golden Gate.
• Setup and monitored multi node RAC to RAC Dataguard with real time apply for Disaster recovery and offload backups.
• Applied database patches using Opatch utility for RAC and Non RAC databases & building Clone instances for Development and Test teams.
• Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 and 6 Node RAC Clusters and Upgraded single instance 10g databases to 11gR2 RAC.
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Installed and configured Oracle OEM 12Con test environments. Used OEM extensively to monitor the general health and troubleshoot/diagnose problems in the environment both on server, database level and also most importantly at the Sql level to identify and subpar Sql queries. Configuring custom metrics, monitoring templates and alerts set up based on individual dba preference and also tailored to application requirements.
• Redesigned table and index partitioning strategies, using HINTS to improve the query Performance.
• Developed, modified and optimized very complex queries to data retrieval Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning using techniques.
• Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat etc.
• Analyzing STATSPACK, AWR, ADDM and TKPROF and 10046 traces for diagnosing the root cause of the issue.
• Traced the application using ORADEBUG and event 10046 and helped developers to identify the SQL statements performing slow on the Oracle 10g development server.
• Proficient in evaluating shared memory level parameters that need to be allocated for new database requirements on existing servers to balance cumulative performance of all candidate databases and efficiency in terms of existing infrastructure.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level errors.
• Successfully configured 2 node Oracle 11gr2 RAC environments on Linux platform using.
• Adept in working with Oracle Dataguard and Oracle Active Dataguard to set up maximum availability solutions. Setup Oracle failover JDBC connections and switchover and failover standards.
• Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.
• Monitoring and performance observation of Oracle environments on both Customer productive systems and in house test systems. Working closely with upstream and downstream clients in migrating data using oracle replication tool Golden Gate.
• Analyzed the Business requirement for ODI Mappings the Architecture.
• Extensively experience in development of ELT and ETL Mapping in Oracle Data Integrator (ODI).
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• Worked extensively on setting up Split mirror backups for large SAP databases.
• Worked on Unicode Migration of SAP databases using SAP Inst from 10gR2 on AIX to 11.2.0.3 on RHEL.
• Working knowledge of SAP Installer and BR tools.
• Worked with SAN admins on EMC SRDF technology to provide replication and disaster recovery solutions for mission critical databases.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Installed, and patched Oracle software and associated applications.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• 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.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Established and maintained sound backup recovery and procedures.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Experience in configuring Data guard 10g R2 for physical standby database.
• Experienced in managing data guard configuration using DGMCRL tool.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.

Confidential, Detroit, MI

Oracle Database Analyst / DBA

Responsibilities:

• Providing 24x7 on call support for the business critical production RAC databases.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3.
• Applied bug patches according to the Oracle Critical Patch alerts.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Solving problems related to extent allocation.
• Solving problems of database connectivity.
• Cloned database for development needs.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Applied High priority, security patches downloaded from Metalink
• Monitoring the Database storage and Day to Day activities.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Experienced with DATA GUARD implementation and Point in time Recovery.
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.

Confidential

Jr. Oracle DBA

Responsibilities:

• Installation, Configuration, Upgrade, patching of Oracle RDBMS in development, test and production environments on Various OS Platforms like Linux, AIX and HP-UX.
• Refresh/Cloning of Database and applications for as and when needed.
• SQL and PL/SQL Programming. Involved in developing PL/SQL functions, procedures, packages, and triggers. Involved in creating tables, views etc.
• Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements.
• Designed and implemented database solutions like backup and security, testing backups periodically for consistency and reliability.
• Implementing User management strategies for database like schemas, Objects and user profiles, roles etc. As per business standards.
• Working with Programmers and Developers and assisting them on issues related to database whenever needed.
• Write shell scripts to monitor and maintain the Oracle database.
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Fixed errors related to connectivity issues involving SQLNET, TNSNAMES, and Listener etc.
• Write SQL*Loader control files for uploading legacy data to interface tables.