SUMMARY

• Solid hands on 12+ years of experience with the database from designing, developing, implementing and ppl networking, monitoring & managing of users, performance tuning of applications and the databases Oracle 11g/12c as well; using SQL, PL/SQL, SQL*Plus, ORACLE RAC (Real Application Cluster), Standby (Data Guard) Database, Exadata, Golden Gate, Oracle Utilities, Oracle Enterprise Manager & Oracle Management Server on Unix (Linux, AIX, SUN and Confidential ) & Windows platforms.
• Problem solving skills to develop quick yet sound solutions to resolve complex issues.
• Experience in supporting and administrating large 24x7 production databases in Oracle 11g and 12c r2 RAC, ASM, GoldenGate and Data Guard environments.
• Expertise in installing, building, configuring, managing, upgrading and patching and trouble - shooting oracle databases in different operation systems environment like AIX, Linux, SunSolaris, and Windows. Good hands-on knowledge in 11g/12c Real Application Cluster (RAC) with ASM & OCFS2 file systems.
• Experience with SRVCTL, CRSCTL, Oracle Enterprise Manager (OEM) 11g/12c, Grid Control, DBCA, VIPCA, OIFCFG,OCRCONFIG, ASMCMD and SQL*Plus for administration of Services, ASM instances and RAC databases.
• Experience with all phases of the Software Development Lifecycle, including system analysis, design, coding, testing, debugging and documentation.
• Designing, installing, upgrading, patching, tuning, monitoring and troubleshooting databases with large amounts of data (Terabytes) and high transaction rates (4000 tps).
• Experienced in GoldenGate 11g installation, configuration of Extract, Pump and Replicate. Managing GoldenGate process, Trouble Shooting and Upgrade of software.
• Experience is adding/deleting a Node from an existing RAC Cluster and Load Balancing.
• Deployed Oracle High Availability based on Streams Replication and Active Data guard.
• Data replication using GoldenGate Transaction Data Management Tool.
• Experienced in Oracle migration 11g to12c, 11G to 12c for different Character Set using CSSCAN to identify data loss and migration of database across platforms.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Complete range of Oracle DBA activities including day-to-day production database maintenance and monitoring, Backup & Recovery using RMAN, troubleshooting production issues, performance tuning, export-import, client installation, high availability (HA), disaster, and recovery, management of physical storage of database in Solaris, AIX and Linux platform.
• Experience in creating non-production instances using Export / Import utilities / Datapump Schema and User management.
• Coordinating several tuning efforts using ASH,AWR, Statspack reports, SQL tuning, OSwatcher with Dev and Test team’s that ensued in significant enhancements of response times for both application and data migration modules.
• Experience in backup and recovery, using RMAN, export/import and datapump.
• Migration of databases between Software versions, Platforms and database products.
• Expertise in writing UNIX shell scripts and SQL scripts for database monitoring and administration.
• Hands on Knowledge in Mongo DB and Casandra, No SQL DB,
• Knowledge in implementing multi-data center and multi-rack Cassandra cluster.
• Knowledge on Maria DB as POC
• Knowledge in configuration of master slave replication servers in Mongo DB and shared MangoDB clusters
• Knowledge in migrating databases to Oracle Exadata Database Machine.
• Working Knowledge on Develop/capture/document architectural best practices for building systems on AWS.
• Extensively worked as Team Leader in performing task such as Strategic Planning, Installations, and Configurations.
• Excellent interpersonal, analytical, and problem-solving skills.
• Providing off hours support to avoid impacting database availability during normal business hours.

TECHNICAL SKILLS

Database Administration: Oracle 11g/12c/13c, Exadata, SQL server 2000-2005, NoSQL Database, Cassandra, MangoDB

Platforms: UNIX, Solaris, Linux, Windows 2003-Server 2005, Confidential -UX, AIX

High-Availability: Real Application Clusters (RAC) 11g-12c, Data Guard, RMAN, Confidential Service Guard, VERITAS Cluster Server, GoldenGate 11g/12c

Enterprise Database Tools: Oracle Designer, OEM/EM Grid Control (Enterprise Manager), Patrol, Service Manager Toad & Quest Central Suite of Products, Oracle streams, Oracle Warehouse Builder (OWB).

Other: Data Integration, Data Modeling, Data Architecture Design, Apache 1.3,APACHE Cassandra 2.1.14,Oracle Streams, Oracle financial application systems (GL, AR, AP, HR), Oracle CRM, TCA, UWQ, Forms, Report Writer, MS Project 2000/2002, ERP Systems, SDLC, EDI, MS Office Suite (Word, Excel, PowerPoint, Outlook, Visio), ODBC, ftp

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Provided 24x7 on call DBA support for over 150 Oracle 11g/12c production, QA, DEV databases on RHEL, Confidential -UX, and Solaris.
• Involved in the installation, configuration of multi node -- 2, 3, 4, 6 Node Oracle 11g/12c RAC with ASM and single instances using customized scripts, DBCA.
• Create and enhance databases across internal and end-user applications.
• Prepare periodic reports regarding unit''s activities and goal attainment.
• Migrated Oracle 11g/12c RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS) Data pump.
• Upgraded production, Development databases from Oracle 11g/12c RAC.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• Support database centric projects from inception to production deployment (all things database) Requirements Excellent written and verbal communication skills to work effectively across multiple business lines, external technology partners and fellow team members.
• Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Analyzed existing database applications to migrate into or improve the functioning on the platform.
• Handled all daily DBA activities and excellent experience with SQL scripting, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
• Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
• GoldenGate Configuration of Manager, Extract and replicate processes to set-up uni and bi - directional between different data centers.
• Troubleshoot GoldenGate on Oracle and sql server databases.
• Monitoring the CPU, memory usage, I/O contention on servers using top, IOstat, sar, glance, vmstat, etc.
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Intensively used latest11g/12c Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.
• Database software Installer 12c and creating pre-configure CDB and PDB.
• Working with technical and non-technical teams across Amazon (AWS).
• Used Ops Center to monitor prod, dev, test, and fst Cassandra clusters.
• Set Cassandra backups using snapshot backups.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database including creating documents.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.
• Partitioned of large tables and indexes to improve performance, availability, creating and rebuilding the Indexes, database reorganization to improve performance of the queries and the database.
• Performed capacity-planning, space monitoring like tablespace growth, ASM disk space.
• OS level activities like space monitoring of Mount point and relocating data files for better disk I/O.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA).

Environment: s: UNIX, Linux Servers, Exadata, SUN Solaris10, Confidential -UX, Oracle 12c, 11g, 10g - 12R, CA Erwin, Data Pump, OEM and Toad, Mongo, Cassandra.

Confidential, San Jose, CA

Oracle DBA.

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management of all the databases.
• Administration of ASM instance, managing the DISK GROUPS and DISK Operations.
• Unix scripting, database performance tuning and administration and system administration of various platforms of Unix systems.
• Creating database users and by setting the default & temporary table spaces, assigning quotas, roles, Privileges and Profiles to users. Database Refresh/CLONING from production to Development and QA environments.
• Implementing 11g Data guard with physical database.
• Installation, Configuration and Administration of Oracle 11gR2 RAC.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.
• Restoration and recovery from backup as timely manner to support application development team for testing.
• Monitoring the table growth, database growth, current users, and system resource usage .

Environment: s: UNIX, Linux Servers, Windows Servers 2008, Oracle 12c /11g, 11i-12R, CA Erwin, DataPump, OEM and Toad.

Confidential, Chicago, IL

Oracle DBA Consultant

Responsibilities:

• Verify success of database backup (Maintaining RMAN Backups and Logical Backups).
• Implemented and maintained Oracle11g/12c Data Guard/standby databases for fail-over purposes.
• Responsible for Installation, Configure, setup of 11g/12c RAC and worked on performance issues which includes node eviction and node addition.
• Upgraded 11g Two Node RAC ASM database to 12c R2 Two Node RACASM.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Implemented and maintained Oracle 11g/12c Data Guard/standby databases for fail-over purposes.
• Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC. Performed SQL Tuning by using explain plan and TKPROOF.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Upgraded Goldengate from version 11.0 to 12.2 and responsible for cross platform migration using Goldengate from Linux to Solaris.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports.
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.

Environment: : SQL*Plus, Shell Scripting, SQL, PL/SQL, SQL*Plus Golden gate, UNIX, Red hat Linux, Confidential -UX, OEM, Oracle 11g/12c

Confidential, Atlanta GA

Oracle DBA

Responsibilities:

• Database capacity Planning and Volumetric Analysis for the database more than 0.5 PB. Involved in the Implementation of Data Guard and RAC technologies in mission critical systems, configured Switch over, and Failovers with Physical standby database on UNIX environments.
• Upgrade/Migration databases from Oracle 11g to Oracle12c
• Installation, Configuration and Administration of Oracle11g RAC
• Configured the Public Network/Private Interconnect for Oracle11g RAC
• Converted a single instance database to Oracle11gRAC.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Fulfill customer service requests for SQL and database tuning, software patches and upgrades, as well as database migration and duplication. Major projects include migrations to upgrade Oracle 11g database to Oracle 12c and hardware and software testing.
• Proactively monitor 11g Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability.
• Performed disaster recovery for a production database.

Environment: s: Data Guard, OEM, Oracle 11g r2, RAC, non-ASM and ASM, AIX, Linux Servers, Crontab, Oracle 11g, Window Server 2003, Solaris, Export-Import Utilities, Putty