SUMMARY

• 8+ years of experience in Information Technology in various roles, my experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication,
• Database Security, RMAN, User management, Performance tuning and monitoring the database using OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup & recovery, cloning, and space management, shell scripting using ORACLE 12c/11g/10g/9i, performing the role of Oracle Database Administrator according to the set standards and timelines, Install and configure Container and Non - Container 12c databases, Pluggable databases - Architecture, Installation and the concepts associated with 12C database.Convert Non-CDB to Pluggable databaseRAC:
• Hands on experience in Oracle 10g/11g/12c/19c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).
• Strong Oracle RAC Installation, Configuration and Tuning Skills on Red-Hat Linux and Sun Solaris.
• Experience in Installation and administrations of Oracle 10g RAC, 11g RAC,12c and 19c.Golden gate & Dataguard:
• Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery.
• Experience in using Golden Gate to support data replication monitoring, tuning and capacity planning.
• Data Guard setup with Primary and Standby Databases.
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Error handling for restart, logging, production support and status reporting in Golden Gate
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
• Experience using the Curam Intelligent Evidence Gathering (IEG2), and Curam Express Rules for Triage (CERT).
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for replication and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experience in configuring Golden Gate director for alerts monitoring.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Golden gate monitoring was done using the cronjobs, where it does report a mail in case of a process a bend or Lag more than threshold and any Checkpoint .
• Worked on Shell Scripts for the Golden gate monitoring and Trail file system size alerts.RMAN:
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in taking backup and performing recovery.
• Experience in performing point in time recovery at times of necessity.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning(active duplicatipon).Performance Tuning:
• Worked on Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring redoes generation, increasing log buffer size, blocksize and changing archiving procedures and Query tuning using Statspack, TKprof and OEM.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle tools like AWR, ADDM, Advisories, TKPROF, EXPLAIN PLAN for the Better performance.Migration & Datapump:
• Migrated DB2/MYSQL databases to Oracle 10G (R2) version using data migration tools such as DBArtisan, Oracle Developer, SQL Loader and Toad.
• Experience in Migration of Database from 9i to 10g, 10g to 11g and 12c/19c.
• Good experience in resolving the issues related to installation, upgrades and patches.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Strong knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools.
• Expertise in creating and scheduling jobs through OEM.
• Performed Export/Import through Data Pump.
• Build Grid control for Monitoring 40+ database.
• 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.
• Expertise in cross platform data migrations using Transportable Table spaces.
• Excellent Troubleshooting skills in OS level and Database level.
• Experienced in using 10g features like Flash-Back Recovery Area (FRA)SQL, Script & Oracle Database
• Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.
• Good experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• 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.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.
• Implemented replication (DATAGUARD) to create the standby by for many databases (Physical standby/ Logical standby) for DR high availability including 12c databases.
• Install and configure Cloud Control 12c, deploy 12c agents on the target servers and monitor databases.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, TOAD, Oracle SQL Developer in various versions.
• Install and configure Container and Non-Container 12c databases, Pluggable databases - Architecture, Installation and the concepts associated with 12C database.
• Convert Non-CDB to Pluggable database.
• Worked on Linux, Sun Solaris, HP-UX, AIX and Windows environments.
• Configured Database File System (DBFS) on EXADATA
• Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.
• Installed, configured and maintained databases on EXADATA X2-2 half rack.

TECHNICAL SKILLS

Data Bases: Oracle 19c/12c/11g/10g/9i, Oracle 12c/11g/10g Real Application Cluster (RAC), ASM, Golden Gate,ODA

Tools: and Utilities RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer

Languages: SQL, PL/SQL, UNIX/NT Shell Scripting, C, COBOL, CICSTuning Tools Compression Advisor, ADDM, AWR, EXPLAIN PLAN, STATSPACK, TKPROF

Operating Systems: HP-UX 10.x/11.x, AIX 4.3x/5.1/5.2, WINDOWS NT/2000/2003 Server, Red HATLinux 9/8/7.2/7.1/6.2 , RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10

RDBMS: Oracle Server 8i/9i/10g/11gR2/12c/19c, MySQL, SQL Server 200.2005

DB Management: TOAD 7.6/7.5, OEM 9.2/10g (10.1/10.2), Grid control (RAC), RAT, DMU,ERWIN

Programming: SQL, PL/SQL, C, C++, UNIX shell scripting, PERL, Bourne, Korn, AWK-SED,PHP, JavaScript, HTML, Exposure to Java

Tuning/Monitoring: RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB Cloning, Standbydatabases, RMAN9i/10g/11g/, TKPROF, EXPLAIN PLAN, STATSPACK.

PROFESSIONAL EXPERIENCE

Confidential, MN

ORACLE DBA

Responsibilities:

• Installed, configured and maintained Oracle 11g/12c/19c Real Application Cluster (RAC) databases including a 4 Node RAC on EXADATA CC.
• Setup physical standby’s (DATAGUARD) for several Databases running 11g,12c and 19c as well(Container level and Non-CDB)
• Setup the standby via OEM cloud control 13c for several databases.
• Installed and configured the ODA (ORACLE DATABASR APPLICATION) database and maintain them.
• Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI.
• Converted physical standby to Snapshot standby and back to physical standby.;
• Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Performing the initial load using (expdp and impdp) from source to target.
• Goldengate performance issues were resolved by splitting the process into subsets, so that performance is improved.
• Troubleshooting Goldengate process abends, analysing report files, error log file and discard files.
• Worked on Logdump utility of Goldengate .
• Performed skipping the transactions which are not necessary using logdump utility.
• Good at altering the Rba for replicat during the troubleshoot of Goldengate based on the transaction type and not missing any transactions.
• Maintenance of Goldengate process during the batch loads.
• Goldengate monitoring was done using the cronjobs, where it does report a mail in case of a process abend or Lag more than threshold and any Checkpoint.
• Worked on Shell Scripts for the Goldengate monitoring and Trail file system size alerts.
• Worked on writing PL/SQL packages that would find any duplicates in the tables, this is as per requirement, where the tables have no primary or unique
• Error handling for restart, logging, production support and status reporting in Golden Gate
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting
• Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
• Migrating existing 10g/11g databases to 12.1.0.1 using transportable tablespace method. Upgraded supported versions to 12cR1 using DBUA (direct path upgrade)
• Plugging from and Unplugging into XML files, creating the Container database and pluggable databases. Migrating the 11g database to 12c/19c pluggable database.
• Setup
• Storage Migrations: Solely responsible for migrating the Prod/Tst/Dev Databases from NetApp to HNAS and also to block level storage. (Migrating the databases from Non-ASM to ASM)
• Creating Solaris Zones, zone Snapshots for backup. Configuring the disks and slices for ASM
• Research, Implement, Test and configured various compression methodologies including
• OLTP compression
• HCC (Hybrid columnar compression for EXADATA)
• Exadata Scan query specific - Compress for query high/low
• Storage Savings specific - Compress for Archive high/low
• Implemented DBFS on Exadata.
• Implemented PARTITIONING using EXCHANGE PARTITION method.
• Datapump including database links and network links.
• Migrated databases from NETEZZA, AS 400 to ORACLE 11g.
• Problem diagnosis and Performance tuning by implementing Partitioning, Parallelism & Compression.
• Setting up Hugepages - Calculated the recommended values and setup hugepages on linux severs. Also configured hugepages for the X2-2 half rack boxes.
• Performed Database and SQL tuning by using various Tools like AWR reports, SQL Tuning Advisor, ADDM, Real Time ADDM, Database Replay and EXPLAIN PLAN analysis for query optimization.
• Built databases with different blocksizes and tested the performance with various parameter settings.
• Capacity planning for the projects owned in the environment.
• Backup and recovery procedures using RMAN. Created scripts for RMAN incremental backups and also for full database backups using datapump.
• Provided backup/Restore & Recover of the databases using RMAN and FLASHBACK database procedures.
• Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto.
• Creating and maintaining database objects in operational data store.
• Creation of new PL/SQL procedures and triggers based on the project requirement.
• UNIX shell scripting as and when required based on the requirement.
• Providing technical support to Application Support team for performance and database related issues.
• Effective Production Support and off hour support, support handover.

Environment: Oracle 12c, Oracle EXADATA X7-2 HALF RACK 4,7 and EX@CC/Oracle 11g, Red Hat Linux 5.8, OEM 12c/13c, RAC, Oracle Advanced Security, Pluggable databases, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, OPatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations.

Confidential, West Des Moines, IA

ORACLE DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Databases 9i, 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
• Configured GOLDENGATE unidirectional in classic capture mode on LINUX
• Installed, Configured and monitored GOLDEN GATE replication
• Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in UNIX scripting
• Oracle Installation/Migration of various versions from 9i and 10g.
• Conducted migration across various platforms like sysbase to oracle and SQL server to Oracle
• Expertise in installing, configuring and maintaining Oracle databases on various platforms
• Supported Business, Post go-live by Cloning/refreshing Production to DEV, UAT, TEST and PREPROD Database instances, for testing at Scheduled intervals.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.
• Performed documentation for Clusterware installation, RAC RDBMSinstallation, RACDatabase creation, Grid Control installation, Oracle 11g Standby Documentation.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Expertise in Job Scheduling environments like AutoSys & Cronjobs
• 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.
• Upgraded the database 10gR1 to 10gR2 and applied database patches using opatch utility.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring, for custom scripts troubleshooting using SQLTRACE utilities
• Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.
• Analyzed the user requirements and designed partitioned tables for improving performance.
• Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.
• Used Oracle Streams for Basic and Advanced Data Replication between oracle database servers.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installed VERIDATA tool for comparing data synchronization between SOURCE and TRGET
• Installed and monitored STREAMS one-way replication
• Involved in the 10g 2 Node RAC installation on RHEL 5.4 server
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in the Migration projects Extensively using Data pump and Rman utilities
• Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool
• Excellent in writing SQL scripts using SPOOL command
• Expert in using Data pump
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Experience in moving the data from one server to another server using SFTP,FTP and SCP
• Building new databases and schemas from the scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database
• Troubleshooting ORA errors when occurred
• ASM Disk storage and user Management
• Performance Tuning for the SQL queries by scrutinizing the long running sql queries
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Environment: Oracle 11g/10g/9i, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP.

Confidential, Baltimore

Oracle DBA

Responsibilities:

• Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
• Worked on RAC (2 node) using cluster ware and ASM on 10g.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard).
• Configuration of system to achieve High Availability, Load balancing and automatic fail over functionality.
• Install, upgrade and maintain Oracle 10g on HP-UNIX.
• Installed 10.2.0.4 agent and involved in registering of databases in OEM.
• Involved in Upgrade/Migration of the databases from Oracle 9i to Oracle 10g.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security.
• Database Restore using RMAN, Cold Backup and Export.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Cloning of databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organizing database structures.
• Performed database Cloning using hot backup and cold backup to setup test and development database.
• Actively involved in validation of the data files using DB Verify Utility. In order to solve Block corruption Errors.
• Usage of Partitions to improve the query performance and manageability.
• Involved in taking logical backup using Data pump and Exports/Imports Utility
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Tuning and balancing I/O by monitoring file system and table-space I/O statistics.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Expertise in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK using OEM.
• Proficient in developing and maintaining of functions, procedures, triggers, indexes using Mysql database programming language.
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• 24/7 on-call production database support.

Environment: Oracle 10g/9i, Mysql, Sun Solaris, HP-Unix, AIX, Linux 4.0, RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF, Toad, PL/SQL.

Confidential

Oracle Developer

Responsibilities:

• Analyzed the structures using Analyze command.
• Involvement in all phases of the project life cycle
• Developed database Schema, Stored Procedures and Database Triggers for data manipulation.
• Written, tested and implemented various UNIX Shell, PL/SQL and SQL scripts to monitor the pulse of the database and system
• Assuring appropriate backup and recovery procedures to be in place to meet the Company’s requirements.
• Working on Designing Schema / tuning PL*SQL/ SQL code
• Implemented automated backup strategy using the UNIX shell script, CRON UTILITY.

Environment: Oracle 9i/8i, SQL, PL/SQL, SQL plus, TOAD, Windows 98/NT.