SUMMARY:

• Around 11 years of experience as an Oracle and NoSQL Database Administrator having hands on experience in database installation, configuration, upgrading, patching, performance tuning, backup and recovery, cloning, space management and database security in production as well as development databases on different platforms. Also, having experience in implementing AWS cloud infrastructure, using the compute, database, storage, monitoring services to managing the databases on AWS cloud .
• Hands on experience in the Installation, setup and configuration of Oracle 10g, 11g and 12c databases on Sun Solaris, Unix/Linux and Windows environments.
• Experience in the Installation, setup and configuration of Oracle 11gR2 and 12cR1 Grid Infrastructure (GI) with Oracle RAC 3+ nodes .
• Exposure to single instance to Real Application Cluster (RAC) database instances conversion.
• Experience in migration database storage from Non - ASM to ASM .
• Hands on experience in implementing Active Data Guard with Data Guard Broker for DR solution.
• Expertise in upgrading databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c.
• Experience using 12c pluggable and container databases (PDBs and CDBs).
• Performance Monitoring of Databases using Grid Control & Diagnostic pack (AWR, ASH, etc.)
• Experience in creating and managing Automatic Storage Management Clustered File System (ACFS).
• Hands on experience in Active Database and RMAN backup based database cloning.
• Proficient in Database administration activities such as User management, Space management, Monitoring, Creating database, managing oracle Instance and Database security and Materialized Views.
• Worked with Oracle support on Ora-00600, Ora-01578 issues and resolutions.
• Expertise in Oracle GoldenGate Replication setup, Analysis of trail files using Logdump and monitoring.
• Experienced in GoldenGate Performance tuning with replicat parallelism, range filtering and batch SQL.
• Exposure to Golden Gate Collision Detection Resolution (CDR) method with Active-Active Replication.
• Experience in Quest Shareplex Installation, Configuration, Administration and migration.
• Hands on experience in Oracle Databases and GoldenGate migration from On-Premises to AWS cloud .
• Experience in implementing Oracle Databases on EC2, RDS (Oracle, MySQL) and NoSQL (DynamoDB).
• Monitoring and troubleshooting of AWS Cloud with Cloud watch and Cloud Trail.
• Experienced in implementing VPC, EBS, S3, Glacier, Elastic Load Balancing and Elastic beanstalk.
• Expertise in the Installation, setup and configuration of MongoDB with 3-node Replica-Set Sharding .
• Experience in Creating DBs, Collections and Indexes on QA and DEV and migrating collections from Oracle to MongoDB .
• Experience in installation and setup of Single-Node and Multi-Node Cassandra Cluster .
• Hands on experience in configuring data replication across Cassandra nodes for high availability.
• Experienced in implementing Cassandra database backup and restore.
• Worked on regular task automation using UNIX shell scripting and Python.

TECHNICAL SKILLS:

Operating System: Solaris, HP-Unix, Linux, Windows XP/2000/NT, UNIX.

Languages: SQL, PL/SQL, Perl, shell scripting, C, C++, Python.

RDBMS: Oracle 10g (10.1.0.2, 10.2.0.3), 11g (11.0.1.7, 11.2.0.3, 11.2.0.4), 12c (12.1.0.2), Oracle MySQL, 11gR2, 12cR1 Real Application Cluster (RAC)

Tools: / Utilities: Oracle Data guard, Toad, Export/Import, Data Pump, AWR, RMAN, TOAD, ASM, RAC (11gR2 / 12c), Robomongo 1.0.0, Zeppelin.

Replication: Oracle GoldenGate 11g, 12c, Quest Shareplex 8.4.2.

NoSql: MongoDB 2.4.1, Apache Cassandra, Amazon DynamoDB

Cloud: AWS, VPC, EC2, RDS, S3, Route 53, EBS, Elastic Load Balancing, Auto scaling, ACLs, IAM, Cloud Formation, Cloud Trail.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Oracle DBA - SME

Responsibilities:

• Installed and Configured Oracle 12c RAC Grid Infrastructure (GI) with 3-node on Sun Solaris.
• Supported 60+ databases including RAC Production databases and Development and Test databases.
• 24 X 7 Production Oracle database support, administration and on call rotation.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Upgraded multiple databases from 11.2.0.4 to 12.1.0.2 on Sun Solaris and migrated Non-CDB to PDB databases.
• Implementation of High Availability solutions with Oracle 12c, 11gR2 RAC, Standby Database (Active Data Guard with Data Guard Broker ) and Replication.
• Wrote shell scripts for automation of tasks and used shell scripts with crontab for job scheduling
• Performs ongoing database performance tuning, including review & tune complex SQL statements.
• Performed conversion of Single Node Instance to Multi Node RAC with ASM, and adding instance to existing RAC.
• Cloning multiple 11g databases to 12c using Active Database and RMAN backup based database cloning.
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Installed Oracle GoldenGate 11g and 12c Installation, Setup, Configuration and Administration.
• Extensively worked on Golden gate and configured cascading and bi-directional replication across 3- data centers to accommodate the business requirements.
• Worked on Oracle GoldenGate trail file Analysis using Logdump and upgrading to 12c version.
• GoldenGate Performance tuning and Collision Detection Resolution (CDR) with Active-Active Replication.
• Worked extensively on Quest Shareplex 8.6.4 Installation, Configuration and implementing bi-directional data flow across 3-data centers for DR solution.
• Installation, setup and configuration of MongoDB 2.6 with 3-node Replica set.
• Implementation of MongoDB replication with Multi-node Sharded cluster.
• Created DBs, Collections, Indexes on QA and DEV and migrated collections from Oracle to MongoDB as per the business requirement.
• Migrated multiple Oracle Databases and Golden Gate and Shareplex configurations from on-premises to AWS cloud.
• Worked on installing Oracle Databases on EC2, RDS (Oracle, MySQL) and NoSQL (DynamoDB).
• Monitoring and troubleshooting with AWS Cloud watch, Cloud Trail.
• Implemented Single and Multi-Node Node Cassandra .
• Worked on configuring data replication across MongoDB nodes and backup and restore.
• Setting up Multi-Node Cassandra Cluster and administration.

Environment: Oracle 12c, 11g R2 RAC, Solaris, RHEL 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, Spotlight, PL/SQL, Shell scripting, AWS, EC2, EBS, S3, Route 53, MongoDB, Cassandra.

Confidential, San Jose, CA

Sr. Oracle DBA

Responsibilities:

• Installation and configuration of oracle 11gR2 RAC databases with 2 nodes.
• Creating User accounts, Roles and granting required access permissions and privileges to the database Based on the applications they are accessing.
• Worked on rolling patch apply throughout the environment with no downtime.
• Implementing database backup & recovery solutions using RMAN and manual methods.
• RAMN Cloning of databases from both backup and active databases to prepare the environment for new enterprise releases.
• Performed capacity planning for the Database and added nodes to the RAC Database to make the 2 node RAC Database a 3 node RAC Database in order to accommodate growing needs.
• Setting up Physical Standby Database Data Guard for Disaster recovery and implemented failover and switchover mechanisms.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Migrated Non-ASM file system to ASM File system for better space management.
• ASM Disk group growth monitoring and releasing space or adding additional disks as per the requirement.
• Set up Active Data guard Configurations for oracle database 11.2.0.3 for eight databases whose size ranging from 2TB to 8TB on a 3 node RAC .
• Administrate OCR and voting disk files and taking proper backup and on-demand recovery.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Implemented oracle 12c active standby database for test database environment.
• Identified bugs and applied required patches like CPU, PSU Patches as per the oracle recommendations.
• Monitoring system resources and taking action to keep the system at optimal performance using Grid Control.
• Developed shell-Scripts for RMAN, Hot and Cold backups.
• Performed daily database administration tasks such as User management, Space monitoring, Performance monitoring, alert Log monitoring and backup monitoring.
• Planning, Installation and configuration of Oracle GoldenGate for Unidirectional and active-active Replication.
• Upgraded databases from 10.2.0.4 to 11.2.0.3 using GoldenGate with zero downtime.
• Configured initial and incremental load using golden gate.
• Extensively worked on Golden gate with cascading and bi-directional setups to accommodate the business requirements.
• Implemented Data transformation & Data pre-processing features using GoldenGate functions and PL/SQL Triggers and Functions.
• Wrote PL/SQL Procedures and functions to implement data transformation and pre-processing during GoldenGate replication.
• Implemented OLTP data replication to Operational Data Store for reporting and archival purposes.
• GoldenGate Performance tuning with Replicat Parallelism.
• Database backup & Recovery with expdp and impdp for non-archive and archive database with RMAN commands.
• Worked on SQL explain plans and query performance, session tracing.
• Developed Scripts for transferring data from production server to testing/development servers.
• Diagnosed and troubleshooted typical SQL Tuning issues using SQLTXPLAIN.SQL
• Shell scripting and PL/SQL programming to resolve business problems of various nature.
• Application Tuning: Identifying the SQL’s causing I/O bottlenecks, SQL’s of high cost and giving recommendations to the development teams accordingly.

Environment: Oracle 12c, 11g R2 RAC, Solaris, RHEL 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, PL/SQL, Shell scripting, Golden Gate.

Confidential

Sr. Oracle DBA

Responsibilities:

• Oracle 10g and 11g Database Installation, Creation, Monitoring and Troubleshooting.
• Creating table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users, roles as and when required.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Automation of Startup Shutdown on all Production and Development Database.
• Proactive database monitoring using automated scripts based on v$views.
• Daily Health Check Up of the Database using AWR, ADDM.
• Implemented Data Guard on Non-production database.
• Developing Scripts for Automatic Database Health Check and send email alerts.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Taking logical backup using export, import utility and data pump .
• Administration of database listener and tnanames.ora file.
• Multiple database upgrades from Oracle 10.2.0.3 to 11.2.0.2 as per oracle’s recommendations.
• Installation and configuration of oracle 11gR2 RAC databases with 2 nodes.
• Implementation of RAC, ASM, DATAPUMP,FLASH BACK Recovery
• ASM Disk Group space management to reclaim space and added disks on-demand.
• Administrate the RAC databases using SRVCTL, CRSCTL and CLUVFY utilities.
• Database Refresh from Production to Non Production environment for new releases.
• Index management, table partitioning, SQL tuning were some of the activities performed for better Performance.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Performing User managed & RMAN Backups and Recoveries.
• Cloning the databases from both backup and active databases with RMAN.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Worked on schemas creation and maintaining large partitioning tables.
• Monitoring space requirement for non-production databases.
• Administrate OCR and voting disk files and taking proper backup and on-demand recovery.
• Installation and configuration of Oracle GoldenGate for Change Data Capture (CDC).
• Configured GoldenGate from database to databases and database to Flat File with proper User Exit for further analysis of the data.
• Implemented DML and DDL replication for Load balancing between 2-data centers.
• Configured unidirectional and Active-Active GoldenGate replication between 2-data centers for Implementing DR solution.
• GoldenGate Performance tuning with Replicat parallelism, Range filtering and Batch SQL.
• GoldenGate trail file analysis with Logdump utility for troubleshooting purpose.
• Implemented GoldenGate Column mapping and Row mapping functionalities as per the business requirement.
• Data Pump implementation in GoldenGate configuration across data centers for High Availability purpose.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Taking periodic backup of the database and the software.
• Performing OS level activities like space monitoring of Mount points.
• Writing the shell scripts to automate the Backup and copying the production copies to Test environment.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Writing Scripts for Analyzing Tables and Rebuilding of Indexes.
• Providing Solutions to the Problems Faced by end Users or Programmers.

Environment: Oracle 10g, 11g R2 RAC, Solaris, RHEL 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, PL/SQL, Shell scripting, Golden Gate, Logdump.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Proactive database monitoring using automated scripts based on v$views.
• Developer Environments setup using database cloning
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
• User management including creating users, roles, profiles and assigning roles, profiles to the respective users.
• Space management including creating table spaces, adding data files as and when required, log file and control file management & multiplexing control files.
• Monitoring of alert log files for any issues and analyzing them to identify the root cause.
• Troubleshooting the issue based on the error reported by the alert log file and reporting to the L2 support, if required.
• Monitoring the space utilization by various database objects and adding/resizing tablespace/data files, whenever required.
• Developed scripts to monitor the space utilization and sending alerts when the available space falls under 85%.
• Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.
• Implement backup and recovery strategies for archiving and non-archiving databases.
• Coding PL/SQL & Shell Scripts, Design/Code reviews.
• Writing Stored Procedures, functions, packages, triggers.
• Implemented Database Cloning/Refresh for PEGA databases to get the latest copy of the production database into their test environment and testing the changes and analyze their effects in production.
• Configured physical standby for EBSPROD, GITTOJIRA databases, in order to keep the up to date copy of the primary database, as they are critical databases for the business.
• Backup of databases into disks based on the designed backup policy.
• Automating Physical Online Backups and Logical Backups through shell scripts
• Database/schema/table level export/import using Oracle Data Pump utility.
• Automated regular activities using Shell scripts.
• Experience in handling complete push cycles for release purpose.
• Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions tracing.
• Altering the Database objects and files during maintenance.
• Database (SQL) design, E-R Modeling, Design and Development Of database design.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• Writing the shell scripts to automate the Backup and copying the production copies to Test environment. (Scripts to copy from one test database to another database)
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.

Environment: Oracle 9i, RHEL, Data Guard, OEM, ASM, ASH, RMAN, ASSM, AWR, PL/SQL, Shell scripting, Logdump.