PROFESSIONAL SUMMARY:

• 9 years of experience as an Oracle Database Administrator in Installation, configuration, Administration, Upgrades, migration, Patching and Troubleshooting of Oracle 12c/11g/10g/9i for OLTP (multiple instances)/OLAP environments.
• Experience in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, ASM, Performance tuning and monitoring the database using OEM Grid Control, and administration for oracle databases, which includes understanding the requirements, upgrades, performance tuning, backup recovery, cloning, and space management, shell scripting, performing according to the set standards and timelines.
• Experience in installing, configuring and upgrading Oracle Software on Sun Solaris, OEL, RHEL, IBM - AIX, HPUX and Windows Platforms .
• Coordinated development and deployment activities with project teams and contributed heavily in pre and post deployment stabilization.
• Experience in configuring and fine tuning of Oracle 12c/11g/10g RAC, Physical and Logical Standby database (DataGuard), GoldenGate and ASM for high availability of database.
• Experience in Uni-directional, Bi-directional and Integrated Capture data replication using goldengate.
• Troubleshooting GoldenGate issues such as process abending, and lag on replication both development and production environments.
• Experience in cross platform Migration from various operating systems such as Solaris linux, AIX, UNIX to RHEL and Upgraded database using Golden Gate with Zero downtime and applied Patches to GoldenGate environment.
• Experience in Schema/Table level replication using Golden Gate and Configured wallet for security purposes.
• Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.
• Installed 2 and 3 node RAC on RAW devices and ASM , and applied Patches in rolling fashion.
• Experience on taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP and Data Migration using expdp and impdp utility
• Expert in performing backup/recovery tasks such as cloning, complete/incomplete recovery, block recovery, Full/Differential/Incremental restore, export import.
• Experience in Enterprise Manager and Oracle OEM Grid Control and using TOAD , SQL Developer, Serena Version Manager and Business Manager
• Experience in Flashback Technologies, RMAN Active Database Cloning, and Virtual private Catalogs and Merging Recovery Catalogs .
• Proficient in setting up Standby Database using Dataguard, Dataguard broker and monitoring standby databases using shell scripts and Switchover, Failover, Switching Standby to Primary and Primary to Standby on scheduled basis.
• Experience in implementing Flashback Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database.
• Extensively used Flashback for Supporting CRUD changes and Handled daily production problems/change requests (DBCRS) with Oracle Patching.
• Expertise in Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSnames, SQLNet, V$, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin
• Experience in applying CPU and PSU patches/patch sets to the databases.
• Testing the deliveries, Releases, and patches before applying them in the production environments and Experience on migrating regular database from NON-ASM to ASM.
• Experience in designing database schemas as per business requirements.
• EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations and have worked on EBS Latest version R12.2 Installation, Configuration, Patching cycle and Cloning
• Proficient in Index rebuilding and Index tuning and databases maintenance activities .
• Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling jobs using Auto sys, RMAN, SQL tuning advisor to tune sql queries on database.
• Performed Data masking and Data redaction and created vault in OEM.
• Worked on Exadata Database Machine X2-2 Half Rack, X3-2.
• Migrated databases into Exadata Machine with minimal downtime using Dataguard.
• Experience in Installing, configuring and Administrating SQL Server 2005/2008(R2)/2012/2014 on Production and Non-Prod environments.
• Experience in Migrating the databases from Oracle to SQL Server
• Involved in Upgrading SQL server 2005/2008R2 to 2008R2 /2012/2014 and applied Service packs wherever needed.
• Experince in monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, RDS, etc.
• Designed, configured and deployed Amazon Web Services (AWS) for a multitude of applications utilizing the Amazon Web Services focusing on high-availability, fault tolerance and auto-scaling.
• Created and maintained logins, access privileges using roles, Profiles.
• 24x7 on call support Oracle / SQL Server DB’s and Applications owned .
• Provide day-to-day, technical support of Development, Test, Staging and Production systems running on various platforms

TECHNICAL SKILLS:

Operating Systems: HP-Unix 10., 11., Sun Solaris 8, 9, 10, AIX 5., 6., Red Hat Linux RHEL 5.,6., Windows

Database: Oracle 10g/11g/12c, MS SQL Server 2008,2012 and 2014, MongoDB, AWS, MY SQL, Sybase.

Languages: SQL, PL/SQL, C, C++ and UNIX Shell Scripting.

DB Management: TOAD, DB Artisan, SQL Developer and Enterprise Manager grid.

Tools: /Utilities: RMAN, OEM, Oracle Management Service (OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, DBUA, DBCA, putty, Grid Control, Data pump, Data guard.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, SQLT, SQL TUNING ADVISOR

PROFESSIONAL EXPERIENCE:

Confidential, Roswell, GA

Database Engineer

Responsibilities:

• Performed installation, configuration, administration, and Troubleshooting of oracle 11g/12c, 11gR2/12c RAC databases.
• Migrated oracle 11g non-RAC to RAC database instances and also upgraded oracle 11g RAC to 12c RAC database .
• Monitored the database performance using Oracle Enterprise Manager (OEM) 11g/12C .
• Performed database backups with RMAN incremental and cumulative backups by registering 11g/12c databases in recovery catalog.
• Performed complete and incomplete database recovery, data file and table space point in time ( TSPITR ) recoveries using RMAN and user managed backups.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and upgrading them to Oracle 12c and Production to development refresh.
• Extensively used data pump for data migration at table, schema and database level.
• Used SQL*loader to move data from flat files into oracle database.
• Configuring Enterprise Manager ( OEM ) 12c for Exadata environment.
• Involved in configuring Exadata X2-2 Half Rack, X3-2 and having hands on experience on smart flash cache, storage index, storage management and migration.
• Implemented Disaster recovery for production databases using Dataguard and created physical standby databases, and also Active Data-guard
• Converted physical standby to Snapshot standby and back to physical standby as per business requirement
• Configured physical standby (Dataguard) for several Databases and Dataguard broker between the primary and standby databases, perform Switchover/Failover and monitor the Dataguard status via command line
• Installed, Configured and Monitered Goldengate Unidirectional and Bidirectional replication by creating extract process, extract pump, and replicate in Development, Test, Staging and Production environment.
• Upgraded GoldenGate from 11g to 12c and Expertise in troubleshooting the issues related to GoldenGate and used Logdump utility, Defgen utility.
• Implementation of OEM12c installation for multiple data centers, POC of OEM 11g grid control and OEM12c .
• Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS SCHEDULER and enabled oracle vault features from OEM.
• Worked on EBS Latest version R12.2 Installation, Configuration, Patching cycle and Cloning
• Installed the application on AWS EC2 instances and configured the storage on S3 buckets.
• Created S3 buckets and managing policies for S3 buckets and Utilized S3 bucket and backup on AWS.
• Experience in applying quarterly security patches ( PSU/CPU ), as well as interim patches for fixing bugs.
• Performed database tuning using Explain plan, Stats Pack, TKPROF, SQL tuning advisor, SQL access advisor, SQL planned management tools and AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH reports and performed database tuning based on the recommendations suggested by ADDM reports.
• Implemented Flashback Technology-Query, Table, Drop and Database to undo specific transactions, recovered database objects and rewind entire database to a particular time.
• Configure Oracle Advanced Security to implement Transparent Data Encryption for encrypting the sensitive data, using column encryption and tablespace encryption at table space, table and column levels and also configured Redaction using OEM's Policy expression builder.
• Used Oracle database vault for protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet and master keys to tapes.
• Provided weekly reports on memory, disk usage and I/O and UNIX utilities and Responsible in creating and management of table spaces, indexes and rebuilding indexes.
• Created triggers, worked with PL/SQL developers in tuning procedures.
• Worked in documentation on database design, analysis and modifications and performed database monitoring activities including checking alert logs, database lock issues, schemas, users, jobs, table spaces, database objects.
• 24x7 on call support for Development, Test, Staging and Production databases.

Environment: Oracle 12c/11g, MongoDB, RHEL 5., 6., AIX 6., OEM 12c, Exadata, AWS, TOAD, FTP professional, BMC Remedy, EMC Wizard, putty.

Confidential, Kansas City, MO

Goldengate Consultant

Responsibilities:

• Installed, configured and administrated Oracle ( 12c and 11g R2 ) databases on Linux 5, HP-Unix 11.X.
• Implemented Oracle Partitioning, Advance Queuing and Index-Only Tables to enhance performance of large OLTP environments and enhance the online community experience.
• Managed users, privileges, profiles, and schemas using Grid Control of Oracle Enterprise Manager (OEM).
• Migrated 10g Non-RAC single instance database to 11g RAC database.
• Performed health checks regularly on RAC database and Performed backups of OCR and Voting files.
• Performed Add-Node procedure on a 2-NodeRAC Cluster to add an additional node.
• Migrated the database from existing Oracle 10g to Oracle 11g and Upgradation of database (from 10.2.0.3 to 11.2.0.2 ) and Applied Critical Patch Updates and Patch Set Update ( CPU/PSU ) on various platforms using Universal Installer and OPatch Utility
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database and performed replication using Oracle Streams and GoldenGate Technology.
• Configured Golden gate extract and replicate during the database character set conversion.
• Configured Golden gate pump extract to move the trails from source database server to target database server.
• Implemented heartbeat tables to monitor lag in GoldenGate Environment, Migrated oracle databases with minimal down using GoldenGate.
• Developed Shell scripts for monitoring GoldenGate processes and their stats running on 60+ servers from one single database repository and thus maintain history of all GoldenGate processes.
• Configured Integrated Extract and integrated Replicat and converted classic Extract to integrated Extract and classic replicat to integrated replicat in GoldenGate.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard fail overs and switch overs.
• Applied missing archive logs that were not shipped to the standby database in Data Guard.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Installed, Configured and managed 11g Oracle Enterprise Manager ( OEM ) grid control for Performance, Administration and Maintenance of Databases.
• Experienced in working with tools like TOAD .
• Performed performance tuning by using Explain Plan, Tkprof, Statspack, AWR, ADDM and ASH.
• Performed logical backup using traditional export/ import and Data Pump .
• Created Materialized views, groups for performing SQL*Loader jobs for data loading and used Data Pump jobs for loading the subscriber and history related data at replicated site.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate. .
• Experience in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication, and Audit vault, DB vault.
• Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS SCHEDULER and enabled oracle vault features from OEM.
• Implemented VERITAS Net Backup using RMAN (Recovery Manager) as a media management layer and used RMAN for cloning RAC databases.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Installed, configured and Administrated SQL Server 2005/2008(R2)/2012 on Production and Non-Prod environments.
• Involved in Implementing Database Mirroring and Transactional Replication as a part of DR plan.
• Configured Active- Active, Active- Passive clustering on physical and virtual environments.
• Created Backup strategies and scheduling them as a part of MS SQL server database maintenance plans.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers and Worked on Index tuning, stored Procedure tuning.
• Provided 24x7 on call support for Oracle / SQL Server DB’s .

Environment: ORACLE 11g RAC, 11g Data Guard physical standby, Golden Gate 11g, MS SQL Server 2008/2012, RMAN, SQL, PL/SQL, Import/Export, TDE, RHEL, Windows, Data Modeler.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g/11g databases on Linux and also Upgraded Oracle databases from 10g to 11g .
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
• Appled latest patches on the oracle database and also upgraded the database.
• Installed, Configured and Administrated Oracle 10g/11gRAC.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Installed configured and Managed DataGuard Standby Databases.
• Used DataGuard broker to monitor DataGuard configurations on standby database.
• Experience in implementing DataGuard and Stand-by databases for fail-over and recovery.
• Used RMAN for backups and recovery and configured databases in Catalog server and backup of Catalog database.
• Scheduled Oracle Jobs USING DBMS SCHEDULER and Backups using CRONTAB.
• Performed Block Recovery and Data file recovery using RMAN.
• Identified and fixed the logical block corruption using RMAN Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Performed Data load on different databases from flat file using SQL*Loader.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM for Generating reports.
• Created tablespaces and added new data file to increase the size of the existing tablespace.
• Created users and granted appropriate roles and privileges to perform regular tasks.
• Installed, configured and Administrated SQL Server 2008(R2) on Production and Non-Prod environments.
• Involved in Upgrading SQL server 2005/2008 to 2008R2 and applied Service packs.
• Provided On-Call 24x7 support for production databases.

Environment:: Oracle 10g/ 11g, MS SQL server 2008(R2), PL/SQL, TOAD, Oracle Enterprise Manager, Red Hat Enterprise Linux, UNIX.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installed and created 11g and 10g databases for Development, Test and Production including configuration, backup & performance tuning.
• Performed Database replication from production to development/test environment Using RMAN , Data pump utilities and manually.
• Responsible for network configuration and involved in a Client-Server environment using TNS Names, LISTENER, Net Configuration Assistant and other configuration files. performed block recovery and backup validations using RMAN.
• Implemented backup strategy using RMAN, Oracle Utilities (Export/Import) and OS methods.
• SQL query tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on daily basis.
• Created and Managed users, user profiles, tablespaces, data files, archive log.
• Tuning SGA , Rollback segments, Latch contention issues, Optimize sort operations.
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.
• Involved in importing the production data to lower environments for testing purpose.
• Provided On-Call 24x7 support.

Environment: Oracle 11g/10g, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator, SQL, TKPROF, STATSPACK, ASM, AWR, ADDM, Data Pump, RMAN, RAC.

Confidential

Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Databases 10g and 11g.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Implemented and Monitored Data Guard (physical standby) for standalone Oracle 10g.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Export and import of database objects using EXP and IMP.
• Responsible for refreshing and cloning of databases as per customer requirements using RMAN, Data Pump, and hot backup scripts.
• Table partitioning to improve I/O access.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump
• Alert log Monitoring every day in the production environment
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Restoration and Recovery of databases at the times of occurrence of critical failures
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN and Scripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Environment:: Oracle 11gR1, 11gR2, LINUX, RAC, ASM, RMAN, OEM Grid Control 10g, Data Guard

Confidential

PLSQL Developer/Jr. DBA

Responsibilities:

• Installed and Configured Oracle 9i database for Testing, Development, Production including configuration, backup & performance tuning.
• Created and configured database manually using Oracle Database Configuration Assistant.
• Installed and maintained standby databases.
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks.
• Applied patches whenever necessary by downloading them from Metalink.
• Used EXPORT/IMPORT to do table level and full database imports as per application team requirements.
• Created materialized views and snapshots for high-end application usage.
• Created and used different types of sequences and indexes .
• Performance tuning of database using stats pack reports.
• Backup and Recovery operations over all databases, ensuring 100% recoverability using RMAN .
• Wrote control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Created Table space, Data files, Indexes and monitoring them.
• Administering database security, Creating Users and granting/revoking roles and privileges.
• Multiplexing control files and redo logs for database security.
• Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Created UNIX shell scripts to automate batch jobs.
• Worked as a member of production DBA team in perfect coordination with seniors and team members

Environment: Oracle 9i/10g, SQL*LOADER, Tuning, Export/Import, SQL*PLUS, Explain Plan, UNIX Shell Scripting, PL/SQL navigator.