SUMMARY

• Around 8 years of experience as an Oracle DBA and Golden Gate Admin in various domains to deliver new products, upgrades with Oracle Software 12c/11g - R2/10g/9i on Red Hat Linux, Sun Solaris and Windows platforms.
• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• 2+ years in the field of NOSQL DATABASE(MONGODB) administration.
• 2+ years in the field of AWS RDS and Red shift administration.
• Expertise in different environments like SUN SOLARIS, Linux and Windows.
• Experience in 12c/11g/10g Real Application Clusters (RAC), ASM, CRS installation and maintenance
• Experience in Configuring, installing, monitoring, troubleshooting and upgrading Oracle Golden Gate 11g/12c.
• Experience in Configuring Unidirectional and bi-directional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
• Experience in implementing conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
• Good experience in Oracle Exadata.
• Hands on experience with Installation, Configuration, Oracle Data Guard, Disaster Recovery and Patching, upgrading and administering Terabytes of Oracle Databases.
• Implementation of high availability solutions with Oracle 10g & 11g RAC, Physical and Logical Standby database, Data Guard, Materialized views, Single and Bi Directional Golden Gate Replication.
• Experience in upgrade of oracle database from Oracle 10g to 11g and 11g to 12c with Oracle Database Upgrade Assistant (DBUA) in development, test and production environment.
• Good experience in Data Modeling Concepts using Relational / Object Models and techniques.
• Experience with Transportable Table spaces.
• Experience in Oracle Golden Gate with very large Data bases.
• Experience in performance tuning for Oracle Golden Gate Extract and Replicates.
• Experience in migrating Databases along with Golden Gate from HP UX to Sun Solaris.
• Expert knowledge of database scripting and automation technology.
• Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
• Used Explain plan and TKPRO, AUTO TRACE, AWR, ADDM, ASH for SQL Tuning; Performance tuning i.e. tuning SGA, I/O distribution and with events causing DB time to be high.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Installation, configuration, upgrading and migration of Oracle software (10g, 11g &12c). Applying patches under UNIX, Linux and Windows platform.
• On call 24x7 Production Support Worked beyond regular hours.
• Implemented Export and Import using original Export/Import method in Oracle 9i Databases and Data pump in Oracle 10g,11g and 12c Databases.
• Creation and maintenance of database Standard Operating Procedures (SOP's).Experience with OLTP and batch processing in a large data processing environment
• Back-end programming experience using PL/SQL, SQL, Stored Procedures, Functions, Cursors, Constraints, Triggers, Indexes, Views, Database Links, Export/Import Utilities, Ad-hoc queries using SQL
• Knowledge of Autonomous Transactions, Materialized Views, Bulk Collects and Collections.
• Work closely with developer, provides Oracle DBA support and technical support for multiple applications in DEV, TEST, UAT and PRODUCTION environments.
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database.
• High Availability Solution like Oracle 10g/11gRAC, Advanced Replication, Oracle Streams, Oracle Failover using Active-Passive cluster and disaster recovery.
• Oracle Enterprise Management (OEM) with standard management, diagnostic, tuning, and change management packs to perform various administrative tasks. Setting-up and configuring Oracle Management Server (OMS) to monitoring database operation.
• As an Oracle DBA, I have handled major projects such as designing database, performance tuning, migration of oracle from lower version to higher version and platform to platform, applying patches for bug fixing to oracle software, setting-up proper backup policies using RMAN, designing automated backup architecture and disaster recovery, implementing advanced features of Oracle10g & 11g RAC database with +ASM.
• Experience in define and monitor RedShift database performance metrics and resolve bottlenecks pro-actively.
• Experience in Pro-actively monitor the space consumed by RedShift and propose corrective actions.
• Experience in User and Access management for Redshift Cluster.
• Solid experience in Nosql Database MongoDB and MongoDB Replica Set and Sharding.
• Strong experience in Replication setup and managing replicaset.
• Experience in performing Mongo DBA operational routines.
• Performing Security measures, backups and restore backups
• Experience in understanding business requirements for analysis, detailed design, database design & development of applications. Worked with various projects in large enterprise projects.

TECHNICAL SKILLS

Operating System: Red Hat Linux RHEL, Sun Solaris, and Windows, HP-UX, IBM-AIX 5L.

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Databases: ORACLE 12c,11g,10g,9i, Standalone, RAC, NOSQL(MongoDB), MS-SQL server, Postgres, AWS RDS and Redshift

Terminal Emulation: Putty, Telnet

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

Replication Tools: Oracle Golden Gate 11g/12c, Oracle Data Guard 10g/11g/12c, Oracle Streams10g/11g, Oracle Golden Gate Veridata 12c

Tools: & Utilities: GGSCI, RAC, SQL Navigator, SQL* Loader, ASM,SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET,ODBC, Data pump, VMware, Oracle Enterprise Manager(11g & 12c), MongoChef

Oracle In Built Packages: DBMS COMPARISON, DBMS SQLTUNE, DBMS JOB, DBMS LOGMNR, DBMS OUTPUT, DBMS PROFILER, DBMS SHARED POOL

IDE's: Toad, SQL Developer and PL/SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Las Vegas

Oracle DBA, Oracle Golden Gate Admin, Multi DB Admin

Responsibilities:

• On call 24x7 production support.
• Installations of Oracle Databases and clients.
• Manage data administrators and client enhancement requests.
• Responsible for data base migration between data centers through data pump or replication and upgrade of database versions.
• Strong experience in SQL & Database Level performance tuning skills.
• Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
• Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
• Configured Unidirectional and bi-directional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
• Experience in Oracle Golden Gate with very large Data bases.
• Experience in data filtering using Oracle Golden Gate.
• Implemented conflict resolution and detection measures to maintain data integrity between replicated sites using Oracle Golden gate 11g/12c.
• Involved in the installation of 11 g RAC on LINUX environment.
• Installation, configuration and monitoring of MongoDB
• Performed upgrade of oracle database from Oracle 10g to 11g and 11g to 12c with Oracle Database Upgrade Assistant (DBUA) in development, test and production environment.
• Experience in backup and recovery and migration using RMAN, datapump and export/import.
• Experience in handling out of sync data issues with Oracle Golden Gate.
• Experience in performance tuning for Oracle Golden Gate Extract and Replicates.
• Experience in migrating Databases along with Golden Gate from HP UX to Sun Solaris.
• Experience in Oracle Golden Gate Veridata 12c.
• Experience with Transportable Table spaces.
• Created table spaces, tables, users for custom applications. Worked on Table Partitioning.
• Created and managed database objects such as tables, indexes, partition tables and views.
• Worked on Real Application Testing(RAT).
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance
• Creating and dropping of Users, granting and revoking permissions to users/roles as and when required.
• Implemented Data Guard for Disaster recovery system using Oracle 11g.
• Created and managed users, roles, privileges, profiles.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Worked on recovering of database in case of Media Failure, Block Corruption, missing data files and accidental tables dropped..
• Implemented backup/recover strategies using HOT backup, COLD backups RMAN and Export/Import utilities.
• Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Experience ensuring the high availability and integrity of databases.
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Wrote PL/SQL Procedures, functions, packages for various requirements in the database.

Environment: HP -UX, Linux, Windows, Golden Gate, Golden Gate Veridata, Streams, ASM,12c/11g/, Oracle RAC, Data Guard, Mongo DB, MS-SQL server, Postgres, AWS RDS, Redshift, Unix Shell scripting, SQL*Plus, OEM, TOAD

Confidential

Oracle DBA and Oracle Golden Gate Admin

Responsibilities:

• Installed and configured oracle 10g and 11g on Solaris.
• Administration of a 3 node RAC, configuring and monitoring daily backups, troubleshooting errors, to improve performance
• Experience in Configuring, installing and upgrading Oracle Golden Gate 11g/12c.
• Experience in monitoring and troubleshooting Oracle Golden Gate Extract and Replicate process issues.
• Experience in data filtering using Oracle Golden Gate.
• Experience in handling out of sync data issues in Oracle Golden Gate.
• Experience in performance tuning for Oracle Golden Gate Extract and Replicates.
• Configured Unidirectional replication between multiple Oracle database instances using Oracle Golden gate 11g/12c.
• Performed upgrade of oracle database from Oracle 10g to 11g and 11g to 12c with Oracle Database Upgrade Assistant (DBUA) in development, test and production environment.
• Performed HOT backup and COLD backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Worked on database design, creation and configuration, space management and other database maintenance procedures in a multiple oracle production and development environments.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager / Grid Control to monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Performed Data migrations from CSV/flat files using scripts and SQL Loader.
• Worked with Enterprise Grid and Infrastructure support.
• Developed automated scripts for database creation and builds.
• Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
• Creating batch files and automating the tasks.
• Granting roles and privileges to end users.
• Worked on import/export and Datapump utility.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.

ENVIRONMENT: Oracle 10g/11g, Oracle RAC, ASM, SQL Loader, Windows, Sun Solaris, FTP, putty, Unix Shell scripting, Golden Gate, Golden Gate Veridata, Streams, MS-SQL Server, Data Guard, Programming Language/Tools: TOAD, PL/SQL

Confidential

Oracle DBA

Responsibilities:

• Supported different Databases like Production Development Testing UAT and Training.
• Installations of Oracle Databases and clients.
• Maintaining data broker functionality in Data guard.
• Installation and administration of replicating Golden Gate.
• Analyze SQL statements, reorganize Database objects and design indexes to improve response of queries.
• Creation of Database maintenance plans, rebuild indexes and integrity checks.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Checking the process Extract jobs as the part of Golden Gate.
• Maintain the manager at both sides physical replicated Golden Gate.
• Cloning of production Database to the test environment using Recovery Manager (RMAN).
• Monitoring Enterprise Manager Alert Logs for taking corrective actions including table space sizing.
• Performed full and incremental backups using RMAN.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database and managing user groups, Database security, OS space monitoring etc.
• Installation and administration replication tools like Golden Gate.
• Export and Import of Database objects to copy from one Database to another Database as well as copy the export dump file to tape that can act as a backup.

ENVIRONMENT: Oracle 10g/11g RAC, ASM, Data Guard SQL Loader, Windows, Sun Solaris, FTP, putty, Unix Shell scripting, Programming Language/Tools: TOAD, PL/SQL

Confidential

Junior Oracle DBA

Responsibilities:

• Responsible for database refreshes/cloning from production to QA/Reporting environments.
• Responsible for localizing the cloned databases for QA/Reporting use e.g. creating users, resetting privileges/passwords, resetting sequences, resetting database links etc.
• Executed all major DBA activities which include creating databases, performance tuning, backup and recovery, import/export, network administration, installation, managing the physical and logical structures, managing database availability, monitoring databases on a daily basis, creating users/profiles/roles/db-links/tables/indexes/sequences, troubleshooting etc.
• Co-ordinated backup and recovery operations over all databases and ensured complete restore and recovery.
• Performed installation of Oracle software products and database creation and upgrade. Responsible for data integrity and user security.
• Perform physical database design, database space needs and growth analysis, and future disk need analysis.
• Implement backup and recovery strategies for archiving and non-archiving databases.
• Conducted database and applications performance tuning operations making significant improvements in database system performance.
• Supported developers in tuning DB and apps for optimal performance.
• Administered, maintained, developed and implemented policies and procedures for Managing DB Security and alert log entries.
• Resolved database performance issues, database capacity issues, and distributed data issues.

ENVIRONMENT: Oracle 10g, 9i,toad, Red Hat Linux, RMAN, SQL Loader.