PROFESSIONAL SUMMARY:

• Over 10+ years of diversified experience in administration of production databases which includes 10g,11g,12c (RAC with ASM), Stand alone database, Replication options known as Data Guard, Golden Gate; In all of these expertise in Installation, configuration, Administration tuning, design, patches, upgrade, migration, capacity planning, OEM Grid Control, Flashback, RMAN backup and recovery, cloning, auditing, troubleshooting and documentation.
• Extensive hands on experience of database performance tuning including RAC and SQL tuning experience with 10g, 11g and 12c RAC scalability, HA, robustness and load balancing, RAC performance tuning, instance availability and background processes monitoring, waiting events and log and trace files investigation for troubleshooting.
• Extensive working experience with 10g,11g and 12c RAC database installation, building, configuration and administration, ASM installation, configuration and monitoring and oracle CRS administration.
• Extensive working experience with 10g, 11g and 12c DATAGUARD/active DG to administrate both standby databases including installation, configuration, run - time monitoring and administration, performance tuning and trouble shooting.
• Experience with 10g/11g/12c OEM and GRID Control including installation, configuration, run-time monitoring and administration, patching and upgrading.
• Extensive experience on exadata administration including providing advice and guidance for Disaster Recovery strategies for Database machines; Providing and implementing performance and tuning recommendations; providing upgrades and patching for exadata storage servers and InfiniBand switches or so.
• 3 years hand-on experience for Oracle Golden Gate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Extensive working experience on business continuality including setup of database redundancy with RAC, active Data Guard, enterprise database replication with golden gate, database DR to provide backup recovery strategies using Oracle ZFS and NetApp DR backup/recovery strategies to practice database DR restore and recovery to achieve minimum system down time.
• Extensive working experience with administration of large-scale, massively concurrent, highly available distributed OLTP systems to monitor and administrate running on 24*7 within a team group.
• Extensive working experience of database backup and recovery with RMAN, DATA PUMP and exp/imp on 9i, 10g and 11g.
• Proficient in shell and PL/SQL scripting to develop database administration tools for database protective maintenance, security, performance tuning, backup/recovery, SQL tuning.
• Extensive working experience with database migration experience using ETL tools involved in multiple platforms including AIX, Solaris to RHEL with VM provisions, database capacity planning, migration roadmap preparation and verification, performance evaluation and testing, storage analysis and space expectation, database design and optimization.
• Experience in programming with Perl, Unix/Linux shell script, Oracle PL/SQL. Experience in database designing and developing.
• Excellent work ethic with ability to work alone and in a team environment. Strong analytical and problem solving skills.

TECHNICAL SKILLS:

Operating Systems: Red Hat Linux RHEL 4.x, 5.x, 6.x, HP-UX 10.x, 11.x, Sun Solaris 9,10,11 AIX 5.1, 5.2

Data Bases: Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC), ASM, Mysql, SQL SERVER 2008/2012, NoSQL, Cassandra, Mongo, AWS

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: / Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC Export/Import, Data pump, Data-Guard, VERITAS Net Backup, OEL, BMC remedy, Pac 2000, VMware, Log-miner, Cron-Tab, Erwin, Ms Visio

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, FTP, TOAD

PROFESSIONAL EXPERIENCE:

Confidential, Frisco, TX

Sr. Oracle DBA/Architect

Environment: Oracle RAC Database 12c, 11g, 10g, AIX, Solaris11, RE Linux 6, Suse linux 11,OEM 12c,Windows, Cassandra, Mongo, Exadata, OVM

Responsibilities:

• Architected, Designed, Installed and configured Oracle 12c 2/3 node RAC Database on Solaris,AIX, and Linux platforms
• Installation of Oracle 12cR1 (With Multitenant Architecture i.e. CDB and PDB) Database on Oracle Linux.
• Converting Non-CDB 12c Database to 12c Multitenant Architecture (CDB and PDB).
• Administration of Oracle 11gR2 RAC (3 Nodes and 5 Nodes) databases.
• Analyzing AWR, ASH and ADDM reports for resolving DB performance issues.
• Monitoring of databases using OEM 12c Grid Control.
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used oracle Metalink.
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Cassandra database physical layout design and capacity planning
• Experience with NoSQL database-- Mongo, Cassandra database installation, configuring and administration.
• Improved performance for the Cassandra 2.0 version DB by keeping fewer SSTables and by maintain proper memory sizes. setting up of Cassandra clusters are required in the respective data centers
• Upgraded all production databases from 11g to 12c.
• Performed ODI,data migrations using ETL tools.
• Configuring, maintaining and troubleshooting Oracle Exadata Cell Disks/Grid Disks
• Migrating databases to Oracle Exadata
• Maintaining Oracle Exadata Hardware
• Configured and maintained OEM 12c
• Established RMAN backups and recovery policies
• Upgraded production and all test databases from Oracle 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and ODI have used data migration ETL tools
• Replication and Extracting data and applying on production using GoldenGate
• Extensive working experience with 10g, 11g and 12c Active DATAGUARD to administrate both standby databases including installation, configuration, run-time monitoring and administration, performance tuning and trouble shooting.
• Experience in programming with Perl, Unix/Linux shell scripting, Oracle PL/SQL.
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.

Confidential, Austin, TX

Sr. Oracle DBA/ Engineer/ Architect

Environment: Oracle RAC Database 12c, 11g, 10g, AIX, Solaris11, RE Linux 6, Oracle Data Integrator (ODI), MYSQL, Windows, Cassandra, Mongo, OVM, EXADATA

Responsibilities:

• Architected, Designed, Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Clusterware, Oracle 12c two node RAC for the database tier.
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions
• Patching & upgrades on Oracle 12c database (whilst minimizing or eliminating the impact to Live services, i.e. using rolling node patching)
• Cassandra database physical layout design and capacity planning
• Experience with NoSQL database-- Mongo, Cassandra database installation, configuring and administration.
• Have involved in the process of upgrading, Adding & removing nodes also, have collected production metrics by using SPLUNK tool
• Worked with logical backup using Data pump and Exports/Imports Utility
• Database Load and Transformation Techniques (SQL Loader, External Tables)
• Upgraded production and all test databases from Oracle 9.2.0.8 to 10.2.0.3 to 11.2.0.4 to 12.1.0.2
• Execute the collection of requirements, product comparisons, product research, and architecture
• Implements, administers, manages, monitors, and tunes the assigned application databases in development, pre-production and production environments. Designs and implements performance tuning improvements and advises developers on tuning options. Ensures that data integrity and data security is maintained. Demonstrates advanced troubleshooting and analytical skills through problem resolution.
• Performed data migrations and ODI using ETL tools.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Support Production, QA, DEV, UAT databases.
• Experience in programming with Perl, Unix/Linux shell scripting, Oracle PL/SQL.
• Configured and Monitored of databases using OEM 12c Grid Control
• Cross platform Migration of databases using export/import and datapump
• Daily health checkup of databases
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools
• Replication and Extracting data and applying on production using GoldenGate
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Configuration of Oracle Standby Databases(Active Data Guard) for high availability /Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle GoldenGate for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Creating documentation during project planning, project execution and project maintenance phases.

Confidential, Atlanta, Georgia

Sr. Oracle DBA/ Engineer

Environment: Oracle RAC Database 12c, 11g, 10g,AIX, Solaris11, RE Linux 6, ASM, OEM, ODI

Responsibilities:

• Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure
• Administered and monitored over 15 0 databases both on 10g/11g on prod/test/dev environments
• Migrated databases from File-system to Automatic Storage Management (ASM)
• Analyzing AWR and ADDM Reports.
• Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert
• Experience with NoSQL database-- Mongo, Cassandra database installation, configuring and administration.
• Up-gradation of single instance databases from 10.2.0.1 to 11.2.0.3 on Linux
• Responsible for using Flashback query mechanism along with automatic undo management
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases
• Implemented Data Guard with maximum availability and performance configurations for production databases
• Worked on Active data guard, Fail over and Switch over cases
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions
• Cloned oracle production databases for development and testing
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools.
• Cross platform Migration of databases using export/import and datapump
• Experience in replication using golden gate, materialized views
• Implemented and configured Goldengate in 2-node RAC cluster
• Implementation of High availability solutions with Oracle 11gR2 RAC, 10g RAC Standby Database(Active Data Guard), Replication
• Creating documentation during project planning, project execution and project maintenance phases.

Confidential

Database Engineer

Environment: Oracle RAC Database 11.2.0.4, 10.2.0.3, Solaris11,AIX, RE Linux, Windows, ASM

Responsibilities:

• Involved with installation and maintenance of Oracle 3 node RAC for high availability.
• Involved in change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Ensuring regular RMAN backups are in place
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Having good experience in Migrating single Instance database to RAC Environment
• Performed health checks in RAC instances using Crsctl and Srvctl utility
• Upgradation of database from 10g to 11g and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Maintained Standby Databases(Active Data Guard) for Production Databases
• Daily health checkup of databases
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases

Confidential

Oracle DBA

Environment: Oracle 11g,10g, 9i, RAC, AIX, RHEL Linux 5, 6, Solaris 10, 11, Windows, ASM,OEM

Responsibilities:

• 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).
• Installed 10.2.0.4 agent and involved in registering of databases in OEM.
• Database Restore using RMAN, Cold Backup and Export.
• Periodic data refresh from production to testing environments, Re-organizing database structures.
• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Ensuring regular RMAN backups are in place and Validate RMAN backups Daily
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and datapump
• Involved in taking logical backup using Data pump and Exports/Imports Utility
• Configuration of Oracle Disaster Recovery Solution (DR) from Production Server to the DR Server
• Expertise in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK using OEM
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks
• Creating documentation during project planning, project execution and project maintenance phases.

Confidential

Oracle DBA

Environment: Oracle 9i, 10g, RHEL Linux 5, Solaris 10, Windows

Responsibilities:

• 24*7 production support and monitoring to ensure proactive problem recognition and resolution of various issues related
• Involved in Installation and customization of Databases (10g&9i) in Linux and Solaris environments
• Created instances and databases with appropriate initialization parameters and database structures
• Installed and configured Data Guard using physical-standby for high availability and reporting
• Partitioned large tables and created indexes to improve the performance
• Good experience with recovery managed backups i.e. RMAN
• Configured tnsnames.ora, listener.ora for sqlnet.ora and connectivity
• Upgradation of database from 9i to 10g and applying patches whenever required
• Cloned oracle production databases for development and testing
• Cross platform Migration of databases using export/import and data pump
• Configured database on AIX,UNIX and LINUX
• Making sure that proper RMAN backups are in place as part of a daily job
• Cloning of database from production to development and test databases using RMAN
• Resolution of day to day issues, and routine tasks
• Resolution of day to day related issues, adhering to the service level agreement
• Management of security, granting and revoking permissions to users or roles when required
• Resolution of day to day related issues, documentation of Oracle DBA routine tasks