SUMMARY

• 8 years of experience in Database Administration - DBA including analysis, modeling, design, coding, testing, administration, maintenance of Oracle Database systems on Windows, UNIX and NT platforms.
• 7 years of solid database experience on Oracle 12c/11g/10g, PL/SQL, SQL *Loader, Physical database design, Logical database design, Cleansing, Data Exports & Imports, Application Support, Performance Tuning, Security Administration, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization etc. Strong Back-end programming experience using Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes-B-tree Index, Bitmap Index, Views Materialized Views, Database Links, Export/Import Utilities etc.
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, Oracle Golden Gate etc.
• Expertise included implementation, maintain, monitor and performances of databases across multiple platforms. Have experience in banking, healthcare and telecom domain. Performed several functions of outlining a design for database and making updates to ensure the database provides faster results to the end user.
• Performance Tuning experience on Explain Plan, HINTS, TK Proof and Trace.
• Experience with Installations, Configurations, Upgrades, Migrations, Administration and Patching with Oracle (ver. 10g to 12c) databases.
• Experience included providing support to over 800 Development, Test and Production Databases including critical Production Databases comprising of complex and challenging Unix, Linux, Solaris, Windows environment in Oracle versions 10g, 11g and 12c.
• Migrated Databases from Oracle Database 10.2.0.3 to Oracle Database 12.1.0.2(Size of 12 Terabytes).
• Installation of Oracle 11g & 12c (Binaries) and Oracle11g Grid Infrastructure for Cluster Database (RAC).
• Used Golden Gate 11g/12c to migrate database inventory from older data centers & hardware in Georgia and Denmark to newer data centers in Ohio and Texas.
• Implemented Golden Gate 12c replication for 64+ databases, 4 different applications, in three data centers across the SIT, Pre-Prod and Production environments within the Managed Services Group.
• Experience with Building RAC, Data Guard, ASM, Flashback and RMAN.
• Comprehensive experience as Oracle DBA, especially in Exadata and Oracle Goldengate.
• Proficiency in Oracle database Backup/Recovery(RMAN), Cloning, Maintenance, Exp/Imp/Datapump, Performance monitoring/tuning, Security management, PL/SQL Programming, Oracle System Architecture, Oracle Forms/Reports development etc.
• Experience in relational database design, relational integrity constraints, OLAP, OLTP and normalization.
• Oracle Backup and Recovery (Hot Backup / Cold Backup / RMAN Backup) command in creating backup & recovery procedures and implementing strategies for hot and cold backups.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.

TECHNICAL SKILLS

Operating System: Solaris v10,11.2, Linux 6, RedHat Linux RHEL 4.x, 5.x, Exadata v5, Windows

RDBMS: Oracle/10g/11g/12c with RAC, SQL Server, Access, OLAP, OLTP

Languages: Oracle SQL, PL/SQL, T-SQL, Bash/Korn Shell scripting, Perl, HTML, Visual Basic 6.0, Python, C Programming.

High Availability: Oracle 10g/11g RAC, Oracle 12C Golden Gate

Database Tools: SQL Developer, SQL Listener, SQL*Loader, SQL*Plus, SQL Navigator, Toad, App Designer, Data Mover, Oracle Grid Control, Goldengate 11.2/12.2, RMAN, Data guard Export/Import, Oracle Data pump(exp/imp), Nexus, Foglight, Blade Logic

Tools: & Utilities: Oracle Import/export utility, SVRMGRL and SQL*PLUS, Oracle ASM, Oracle Cloud, Oracle Enterprise Manager, Cron, Autosys, DBCA, SVRCTL, CRSCTL

Telnet Tools: PuTTy, Secure Shell, SuperPutty

Ticketing Tools: Service Now, BMC Remedy, Bridge clarify, CMR (Change management request)

Others: NAGIOS, MRTG, SNMP, WinCSP, FileZilla.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA/Engineer

Responsibilities:

• Hands on experience on Oracle 10g/11g/12c, RAC Installation using ASM, Grid Installation, Patching, configured Oracle databases on different platforms of UNIX (RHEL 4/5, OEL 5/ 6, Solaris 10, HP-UX, AIX) and Installing, upgrade & DB migrations.
• Extensive DBA experience with export/import, datapump, indexing and administration tool like dbca, netca, asmca, dcli, cellcli srvctl, crsctl, opmnctl, emctl, ggsci, sqlplus, ardci etc.
• Upgraded and configured OEM Cloud Control and all server agents from 12.1.0.2 to 12.1.0.3.
• Working Experience in Exadata x3-2, x4-2 migrated databases to Exadata RAC environment.
• Extensive experience in Dataguard Configuration, Implementing and Maintaining Standby Databases I.e. Active Dataguard & Snapshot Standby.
• Migration of non-container to container and pluggable databases (PDB).
• Implemented and supported Golden Gate replication in production, and development environments and troubleshoot Golden Gate Replication issues across database environment.
• Applied Oracle PSU patches (Security Patches) using Opatch utility and upgraded databases from 9i/10g to 10g/11gr2/12C and expert in applying Oracle PSU and CPU patches.
• Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Working Experience on Enterprise database High Availability (HA) and Disaster Recovery (DR) solution.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN), logical backups and Database migration tools with Datapump, Export/Import and Transportable Table-spaces.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Tuned and optimized SQL Query, SGA, Disk I/O using Oracle Enterprise Manager and by monitoring the AWR report generated from snapshots taken at the peak business hours.
• Creating alarms in CloudWatch service for monitoring the server's performance, CPU Utilization, disk usage etc.

Confidential

Oracle Database Administrator

Responsibilities:

• Creation of Development, Integration Test and Production Oracle 12C/11g databases.
• Migrated Database from Oracle Database 10.2.0.3 to Oracle Database 12.1.0.2.
• Planning and scheduling the Physical (Cold/Hot) backups as well as Logical backups
• Planning, developing, deploying and supporting RAC/ASM environment for 12c, 11g and 10g versions.
• Implementation and support of 12C and 12C migrations and upgrades from Oracle 10g databases on Exa-Linux.
• Experience in administering and monitoring database using Oracle Enterprise Manager, TOAD and SQL Developer.
• Hands on knowledge of RCA Preparation, Monitoring and managing database.
• Experience in cluster ware and database upgrades from 10g to 11g and 12c.
• Performed regular DIT/SIT, UAT/Prod health check, monitored the system and fixed if any issues.
• Automated the procedures and interface programs using Oracle Enterprise Manager - OEM.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Issues with block change tracking & also flash recovery area.
• Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, de-installation & clean-up of cluster ware).
• Perform root cause analysis on failures. Experienced in Oracle Support processes for technical requests through Metalink.
• Written the Shell(Korn) and SQL Scripts in coordination with system admin for monitoring the alter logs, disk spaces at O/ S level, table spaces at DB level, to check the availability of database and listeners, and automated jobs through cronjobs.
• Perl scripting, shell scripting and PL/SQL programming to resolve business problems of various nature.
• Sound knowledge on Exadata - ASM file extent and table extent configuration.
• Written Perl Script for scheduling varies SQL queries, processing unknown bill files and their related data in Oracle database. Assisted development team on debugging or updating existing programs
• Used materialized Views to reduce query execution time and help with Database Performance.
• Monitored and checked the logs files for the file failures or successful processing in various environments
• 24x7 on-call Production support for database activities.

Confidential

Oracle DBA/Goldengate Administrator

Responsibilities:

• Installation, configured and supported oracle 12C databases.
• Managing backup & Recovery for Oracle on Linux (RMAN and expdp).
• Oracle Goldengate replication (12c) with datapump and without datapump.
• Setup GoldenGate Database User with necessary privileges and Investigate Replication failures using LogDump utility.
• Control User access and monitor space consumption and Cross-Train Other DBAs on replication concepts.
• Test impact of multiple Extract and Replicate processes on a Single Node.
• Test initial Data Load option of GoldenGate during environment build
• Building test strategies, backup & recovery models for Oracle.
• Shell scripting for monitoring oracle Database status, security & backups.
• Monitored Tablespace size, resizing Tablespace, relocating data files for better disk I/O.
• Creating and managing User Accounts.
• Replication services and Statistics management.
• Interpreting OEM metrics and alerts.
• Zero Downtime Migration to Oracle Exadata with Oracle GoldenGate
• Successfully Maintained RAC environments of 2 Nodes with ASM file system using cluster ware.
• Good understanding on all stages of software development life cycle (SDLC).
• Provide support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN, trace analysis, service creation, cluster and system management.
• Working closely with application teams and supporting on various performance and configuration issues on day to day basis.
• Awareness on Oracle Support processes for technical requests through Meta link.
• Experience in fulfilling DBA daily activities, including schema management, user management, space management, monitoring, scheduling jobs etc.
• Monitor storage capacity, predict future usage and escalate needs / issues as appropriate.
• General DBA activities - Capacity Planning, Heath Check, Alert monitoring, Backup management and validation etc.
• Unix administration - Job monitoring and scheduling, CRON, Autosys, OEM and Shell Scripting.
• Service Level Agreements (SLA) for Incident response and resolution, Service and Access Requests.
• Review and provide feedback for design and test case materials for approval.

Confidential

Oracle DBA

Responsibilities:

• Installed and configured Golden Gate on 11gR2 RAC environment (Uni directional).
• Developed (Unix shell & SQLplus) a fully automated active/passive failover/failback system to rapidly switch source/target replication roles and reverse replication direction & processes for disaster recovery.
• Developed custom utilities to automate manually intensive tasks including mass schema changes, recovering GoldenGate corruptions and managing host/cluster maintenance mode blackouts.
• Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
• Installed and configured 2 node Oracle 11g RAC database environment.
• Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues
• Plan GoldenGate setup to achieve Unidirectional and Perform POC for testing DDL and DML replication across Databases.
• Implementation of High Availability solutions with Oracle 11g RAC, 10g RAC, Standby Database (Active Data Guard), Replication.
• Knowledge on business requirements into conceptual, logical and physical (OLAP) data warehouse model.
• Wide experience in application development, QA and Systems Development Life Cycle (SDLC).
• Prepare GoldenGate parameter files for Extraction and Replication and install GoldenGate software in Test region to perform POC.
• Investigate Replication failures using LogDump utility, Test initial Data Load option of GoldenGate during environment build.
• Responsible for maintaining Every Day Backups and also to maintain ASM and Disk Space.
• Written and updated some deploy or application scripts in Perl for various build, testing, and system management purposes.
• Implemented and configured GoldenGate on a 2-node RAC cluster.
• Expertise in oracle utilities like Export/import, /expdp/impdp sql loader, RMAN etc
• Ability to support and work within standard software development life cycle (SDLC) practices.
• Troubleshooting RMAN whenever backup failed and Configured retention policy, archive log deletion policy for Production databases and registered databases in catalog server.
• Familiar with ORA-600 error. Involved with this ERROR.

Confidential

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle Database (10g) on Solaris and Windows Platforms.
• Scheduling shell scripts or dbms jobs using Crontab or Autosys or DBMS SCHEDULER (monitoring script, listener check, backup script) etc.
• Creating and managing of database users, roles, privileges, profiles and database links.
• Creating and managing tables, functions, stores, procedures and optimization.
• Handled Service Requests raised by application development teams, Documented instructions for migrating & upgrading databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Implemented 11g RAC/12C RAC with ASM files system using Oracle clusterware.
• Setup GoldenGate Database User with necessary privileges and Investigate Replication failures using LogDump utility.
• PL/SQL Coding of Back End Stored Procedures, Functions, Packages & Triggers & Debugging.
• Knowledge and good experience with database backup and recovery methods using RMAN, Data Pump.
• Prepare GoldenGate parameter files for Extraction and Replication.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
• Communicating with Oracle to get the necessary patches required to fix up the database changes needed using TAR support and coordinating the patches and implementing the necessary changes.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Experience in Sizing the SGA, Database buffers, shared SQL area, log buffer based on the requirements.
• Performed logical backup using export/import and data pump (remote export) utilities.
• Performed Database refreshes based on Application requirements and written the shell script to perform backup, scheduled it with crontab.
• Created tablespaces and managed tablespaces by adding/deleting/resizing data files, Created schema (tables, Indexes, views, sequences, synonyms, packages).
• Setup database auditing, granted privileges to users through system/object roles, Monitoring and Maintaining standby databases.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora.
• Involved in DATAGUARD (Standby) setup for high availability and disaster recovery purpose.
• Daily Health check of the Database. And monitoring the log files, backups, database space usage and the use of system resources.
• Installed and Configured the Golden Gate software and created manager, extract, replicate trail files.
• Preparing HLD, LLD, User Manual and Reviewing Code.