PROFESSIONAL SUMMARY:

• Work with a wide variety of tools and technology like Ansible, Puppet, Splunk, Nagios for monitoring of applications, backups and health of database.
• Use Jira application to keep track of our activities and service Now ticketing system.
• Use of x - matter application for oncall rotation schedule.
• Hands on experience and knowledge in SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database and use of joins and cursors like explicit and implicit cursors.
• Migration of database across and within the same platform using tools like transportable tablespace and data pump.
• Installation of Golden Gate 12.1.0.2.0 and 11.2.0.4 on linux and configuring the necessary parameters.
• Implemented both unidirectional replication and bi-directional replicate using Golden Gate.
• Resolving abending issues like extract and replicat abend and handling collision issues and utilizing defgen utility.
• Configuring Golden Gate 12.1.0.2.0 and 11.2.0.4 parameters for replication of tables
• Have some hands-on administration on the unidirectional golden gate and enabling data filtration and transformation.
• Troubleshooting and debugging of PL/SQL codes for any bottleneck issues.
• Good experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like checking Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Some exposure with AWS performing backups and recovery using S3 and checking my mount points like EC2.
• Worked with T-SQL statements like DELETE and UPDATE statements and like BULK insert of data into the datable.
• Used T-SQL and SSMS to perform backup (Full backups, Differential Backups, and Transactional log backups) and recovery on Microsoft Sql Server 2008, 2012.
• Exposure with monitoring tools like Solarwinds and Redgate in Microsoft Sql Server.
• Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and windows.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security
• Implemented various backup strategies for Large / Medium sized databases using RMAN.
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
• Installed and configured oracle Grid control (12c and 11g)
• Upgrade/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Expertise in Database Space Management, Memory Tuning and Application Tuning, Expertise in troubleshooting and performance tuning. Having experience in Oracle Golden Gate 10.x, 11.x installation, Configuration, upgradation and administration.
• Configured parameters for the unidirectional, Bi-directional replication.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
• Recovery of Databases (Recovering from Media Failure, recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc)
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, ASH.
• Excellent Performance management skills on multi- terabyte Database environments.
• Extensive performance tuning experience, specializing in instance tuning, Oracle9i, 10g RAC, 11g RAC, 12c tuning and SQL optimization.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Strong Knowledge of 11g advanced features like ASM, AWR, ADDM and FLASHBACK.
• Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, VERITAS Net Backup.
• Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
• Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.
• Installing Oracle patches, Migration of database across releases.
• Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Experienced in Installation of high availability RAC environment (2, 3 node clusters) and upgraded standalone databases to 11g RAC environment.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).
• Knowledge with SQL, PL/SQL, UNIX Scripting.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Excellent analytical, problem solving, communication and interpersonal skills

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, Remedy, Jira, Service Now, Xmatters, Splunks, Github, Nagios(NRPE monitor), Puppet, Ansible, APEX

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX.

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2, 7.3, IBM DB2.

PROFESSIONAL EXPERIENCE:

Confidential, RESTON, VA

Oracle Database/ Goldengate Administrator Provision support

Responsibilities:

• Configuring and setting up of physical/logical/snapshot and cascading data guard for replication of data from one data centre to another.
• Configure data guard broker for manual switching and failover of database between the primary and standby databases.
• Installing MYSQL 5.6.19 software on linux redhat and setting up replication between the master host and slave host for data replication.
• Configured parameters for the unidirectional, Bi-directional replication, such as the manager process, extract, pump and replicat processes.
• Implemented both unidirectional Golden Gate 12.1.0.2.0 replication as well as bi-directional Golden Gate 12.1.0.2.0 and 11.2.0.4 replicate using Golden Gate.
• Resolving network issues and abending issue in golden gate like extract and replicat abend.
• Have some hands-on administration on the unidirectional golden gate.
• Exposure on postgres databases taking export of the database and some administration like taking database backups.
• Perform daily refresh of production data into the test and pre-production environment for testing and trails of product before deployment in live environment.
• Hands on experience on golden gate 11g and 12c administration and configuring all the necessary parameter required and troubleshooting abending issues.
• Monitor databases and database host using OEM 12C and Nagios application (NRPE) and scheduling of jobs on crontab for alerts and backing up of databases.
• Exposure on data warehouse creating users and assigning roles and groups in BI Publisher and OBIE accounts.
• Hands on experience and knowledge in SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.
• Migration of database across and within the same platform using tools like transportable tablespace and data pump utility.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Perform database and schema refreshes when requested by developer for product testing
• Run adhoc query and provide production support for customers.
• Involve in 24/7 oncall support activities.
• Perform monthly partition maintenance and monitoring tablespace usage for critical and warning threshold set.
• Create spread sheet documentation for all host, database and application monitoring service names.
• Working on work request from end client and from developers and equally resolving incidents when occurred.
• Used to run scripts and schedule jobs to check the status of databases such as growing table sizes, extent allocation, free space, used space.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Confidential, ORLANDO, FL

Oracle DBA

Responsibilities:

• Installed and configured Oracle 12c database and oracle grid cloud control 12c to monitor all databases.
• Installation of grid infrastructure including ASM and CLUSTERWARE software.
• Crating of oracle and grid account in our company 3 nod rac setup.
• Configured parameters for the unidirectional, Bi-directional replication, such as the manager process, extract, pump and replicat processes.
• Implemented both unidirectional replication as well as bi-directional replicate in Golden Gate 12.1.0.2.0 and 11.2.0.4.
• Resolving network issues and abending issue in golden gate like extract and replicat abend.
• Have some hands-on administration on the unidirectional golden gate.
• Experience with sql server implement backup strategy and performing backup and recovering strategy.
• Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
• Installed and configured oracle Grid control (12c and 11g)
• Upgrade/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Production support on a 24/7 on call support rotation and performing upgrades and applying quarterly patches (PSU AND OJVM)
• Production support on a 24/7 on call support rotation.
• Hands on experience and knowledge in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.
• Migration of database across and within the same platform using tools like transportable tablespace and datapump.
• Installed and configured MySQL on Linux and Windows environments.
• Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and windows.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security
• Troubleshooting and debugging of PL/SQL codes for any bottleneck issues.
• Worked with T-SQL statements like DELETE and UPDATE statements and like BULK insert of data into the datable.
• Used T-SQL and SSMS to perform backup (Full backups, Differential Backups, and Transactional log backups) and recovery on Microsoft Sql Server 2008, 2012.
• Exposure with monitoring tools like Solarwinds and Redgate in Microsoft Sql Server.
• Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Installed and administered Real Application Cluster (10g, 11g, 12C RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also, managed redo and undo in the RAC environment.
• Applied patches (PSU and CPU patches) and worked closely with Oracle to make Application environment up to date.
• Involved in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.
• Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.
• Applying upgrade patches, maintenance and interim patches on all the databases.
• Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
• Experience in Working with RAC Databases.
• Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
• Responsible for setup and implementation of 2Node RAC on IBM-AIX in log and 11gR2 using Veritas clusterserver.
• Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
• Implemented Point in time recovery using RMAN.
• Configuration and implementation of Oracle) for high availability.
• Performed Schema as well as Table Level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Tuning SQL queries when the performance is poor.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage. Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Installed the Oracle software using silent feature and also created databases
• Worked on designing, installing & maintainingOCR, 11gRAC and Dataguardcomponents of Oracle.
• Supported& maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, StorageAllocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.

Confidential, Raleigh-Durham, NC

Oracle Database Administrator

Responsibilities:

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Installation, configuration, upgrade and performance tuning of Oracle 12c, 10g, 11g RAC.
• Installed and configured oracle Grid control (12c and 11g)
• Upgrade/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using DatapumpExport/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle database.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database and Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN