SUMMARY

• Solid hands on 10+ years of experience with the database from designing, developing, implementing and administering, upgrading which includes installations, support, troubleshooting, backup & recovery, testing, networking, monitoring & managing of users,performance tuning of applications and the databases Oracle 11g/10g/9i/8x as well;usingSQL, PL/SQL, SQL*Plus, ORACLE RAC (Real Application Cluster), Standby (DataGuard) Database, Exadata, Golden Gate, Oracle Utilities, Oracle Enterprise Manager & Oracle Management Server on Unix (Linux, AIX, SUN and HP) & Windows platforms.
• Experience in supporting and administrating large 24x7 productiondatabases in Oracle 10g and 11g r2 RAC, ASM, Golden Gate 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, Sun Solaris, and Windows.Good hands-on knowledge in 10g/11g Real Application Cluster (RAC) and its Setup & Administration. Hands-on knowledge on Implementation of Real Application Cluster 10g and 11gR2 with ASM on AIX/Linux platform.
• 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.
• 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.
• Installed Oracle 11g & 10g RAC software with ASM & OCFS2 file systems.
• Deployed Oracle High Availability based on Streams Replication and Active Data guard.
• Data replication using GoldenGate Transaction Data Management Tool.
• Experienced in Oraclemigration 9i to 11G for different Character Set using CSSCAN to identify data lossy 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 AIX and Linux platform.
• Experience in creating non-production instances using Export / Import utilities / Data pump Schema and User management.
• Experience in oracle EBS with multi-tier configuration, Oracle Applications Manager (OAM), Admin AppServer Utility
• Expertise in Monitoring and performance tuning, optimization, capacity planning, standby databases.
• 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 data pump.
• Migration of databases between Software versions, Platforms and database products.
• Experience in UNIX shell, Perl and windows batch Scripting.
• Expertise in writing UNIX shell scripts and SQL / PL/SQL scripts for database monitoring and administration.
• Experience in Mongo DB and Casandra NoSQL DB,
• Experience in implementing multi-data center and multi-rack Cassandra cluster.
• Experience in configuration ofmaster slave replication servers in Mongo DB and shared MangoDB clusters
• Knowledge in migrating databases to Oracle Exadata Database Machine.
• Knowledge in Configure, Maintaining and troubleshooting Exadata Cell disk/Grid Disk. Knowledge of OneCommand configuration on Exadata.
• Working Knowledge on Develop/capture/document architectural best practices for building systems on AWS.
• Experience Installed and configured Oracle Audit Vault to automate the audit collection, monitoring and reporting process for oracle databases.
• Involved in production DBA support in solving the database problems and co-ordination with Oracle Corporation.
• Extensively worked as Team Leader in performing task such as Strategic Planning, Installations, and Configurations.
• Excellent interpersonal, analytical, and problem-solving skills.

TECHNICAL SKILLS

Database Administration: Oracle 8i-11g, Access 97-2005, SQL server, NoSQL Database, Cassandra, MangoDB

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

High-Availability: Real Application Clusters (RAC) 9i-11g, Data Guard, RMAN, HP Service

Guard, VERITAS Cluster Server, GoldenGate 11g:

Enterprise Database Tools: Oracle Designer, CA Erwin, 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, Data Warehouse, OLTP and OLAP, Apache 1.3, APACHE Cassandra 2.1.14, Shareplex, Advanced Replication, 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, Microsoft Internet Explorer, Netscape and Opera Internet browsers, ISO 900 Toolkit, Statistical and econometric Analysis

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Provided 24x7 on call DBA support for over 150 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, and Solaris.
• Involved in the installation, configuration of multi node -- 2, 3, 4,6 Node Oracle 10g/11g RAC with ASM.
• Architect for the cross platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces (XTTS).
• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS) Datapump.
• Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, and 10.2.0.4 to 11g/11g RAC.
• Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
• 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.
• Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
• 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).
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, 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.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• 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 latest 10g/11g/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.
• Develop/capture/document architectural best practices for building systems on AWS.
• Working with technical and non-technical teams across Amazon (AWS).
• Used OpsCenter 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.
• Testing, evaluation and troubleshooting of different No SQL database systems and cluster configurations to ensure high-availability in various crash scenarios.
• Worked on creating documents in Mongo database.
• 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.
• Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
• Data aggregation and replication setup using Oracle Streams and Materialized views for reporting.
• Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
• 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, SUN Solaris10,HP-UX, Oracle 12c,11g/10g,9i 11i-12R, CA Erwin, Data Pump, OEM and Toad, Mongo, Cassandra.

Confidential, Atlanta, GA

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 Real Application.
• 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.
• Automating routine server tasks and alerts using various scripting technologies like Unix Shell scripting, batch files, configure alerts through OEM.
• Creating database users and by setting the default & temporary table spaces, assigning quotas, roles, Privileges and Profiles to users.
• Implementing 11g Data guard with physical database.
• Installation, Configuration and Administration of Oracle 11gR2 RAC.
• Configured the Public Network/Private Interconnect for Oracle 10g/11gR2 RAC.
• Troubleshoot the OS level Kernel parameter errors such as Ora-600.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.
• Through shell scripts, generate reports and send these reports to database groups.
• Audit Database usage.
• Data encryption and Database security using database Vault and wallets.
• Administration of QA, UAT and R&D databases.
• Database structure changes, table/index sizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Install patches, upgrade, cloning & refresh from production and UAT to other environments (UAT,DEV,Training,Marketing etc.).
• Defines capacity planning across the entire Oracle environment with coordination of third party vendors and application team.
• Timely Reorganization of the tables and rebuilt of indexes to improve the performance of the SQL queries as part of scheduled maintenance window.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• 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.
• Periodic Database Refresh/CLONING from production to Development and QA environments.

Environment: s: UNIX, Linux Servers, Windows Servers 2008, Oracle 11g/10g, 11i-12R, CA Erwin, Data Pump, OEM and Toad

Confidential, Chicago, IL

Oracle DBA Consultant

Responsibilities:

• Verify success of database backup (Maintaining RMAN Backups and Logical Backups).
• Implemented and maintained Oracle 10g/11g Data Guard/standbydatabases for fail-over purposes.
• Responsible for Installation, Configure, setup of 10g RAC and worked on performance issues which includes node eviction and node addition.
• Upgraded 10.2.0.4 Two Node RAC ASMdatabaseto 11g R2 Two Node RACASM.
• Managed two nodes Real Application Clusterdatabases on Red hat Linux advanced server 2.1.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Developed PL/SQL Stored procedures, Triggers and Functions and embedded them in packages.
• Performed large batch jobs, and tuning of SQL queries anddatabasesystems.
• Implemented and maintained Oracle 10g/11g Data Guard/standbydatabases for fail-over purposes.
• Experience with Systems Analysis, Design and Data Modeling.
• Knowledge of writing Automated Scripts in the cron for backups and restoration.
• Used TKPROF, EXPLAIN PLAN, and STATSPACK to improve the performance.
• Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracledatabase through ODBC, JDBC. Performed SQL Tuning by using explain plan and TKPROOF.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
• Monitored the production Oracle alert logs fordatabaseerrors and data issues.
• Performeddatabaseand Application Performance tuning using EXPLAIN PLAN, TKPROF, Statspack and SQL Tuning.
• Used EXPORT/IMPORT to do table level and fulldatabasedefragmentation.
• Managed RAC Linux servers running Oracle in cluster environments. Performed patching of Oracledatabases with latest patches from Oracle.
• Upgraded Goldengate from version 9.0 to 10.2 and also responsible for cross platform migration using Goldengate from Linux to Solaris.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports.
• Written Shell scripts to Monitor activities like availability ofdatabase& listeners, space utilization, gathering statistics for the cost base optimizer, index rebuilding.
• Experience in Shareplex replication.
• Work within the production support team and maintain operational consistency and efficiency
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along With AWR & ADDM reports.
• Support migration and loading of data into oracledatabaseusing SQL*Loader.
• 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, HP-UX, OEM, Oracle 9i/10g

Confidential

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 and configured Switch over and Failovers with Physical standby database on UNIX environments.
• Upgrade/Migration databases from Oracle 9i to Oracle 10g
• Installation, Configuration and Administration of Oracle 10g RAC
• Configured the Public Network/Private Interconnect for Oracle 10g RAC
• Converted a single instance database to Oracle 10g RAC.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Setting up and testing the backup and recovery strategies.
• A 10 member of oracle DBA team database size was half petabytes (500 Terabytes) with 100 test data instances and 15 production instances.
• 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 9i database to Oracle 10g and hardware and software testing.
• Responsible to trouble shooting requests for Oracle bugs, suggestion as an expert development and implementation of backup/recovery strategies, configuring replication environments, as well as database process automation.
• Proactively monitor 10g Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability.
• Performed disaster recovery for a production database which went offline after the server was moved to a new Sun box. Recovered a testing server after accidentally deleting all its syslogins entries including sa login.

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

Confidential

Oracle DBA

Responsibilities:

• Worked as a team member to provided 24x7 support for Production and Development databases.
• Installation of Oracle binaries, administration of oracle 9i/10g/10g RAC production, test and development environments on RHEL, Sun Solaris platform in OLTP and Data Warehouse environments.
• Installed, configured 2 node 10g RAC with ASM for billing systems, account detail databases.
• Administrated Very Large Data Warehouse Databases (VLDB) ranging from 500GB to 20TB.
• Migrated databases around 1.7 TB (VLDB) across platforms from Sun Solaris 10 to RHEL 3.2 using TTS.
• Upgraded databases in production, test and development environments from 9.2.0.6 to 10.2.0.2 (Oracle 10gR2).
• Applying high priority, security patches, patchsets to oracle using OPatch Utility, runInstaller.
• Data Refresh/Cloning from production to setup test (QA) and development environments.
• Planned and implemented Disaster Recovery (DR) solutions using Oracle Standby Database/Data Guard.
• Had very good experience with SQL, PL/SQL and UNIX Shell Scripting, writing stored procedures, functions and database triggers for maintaining data integrity in the databases.
• SQL Query tuning, Database instance tuning, application tuning using sql trace, explain plan, hints, tkprof, AWR reports, Statspack reports, ADDM reports, initialization parameters, etc.
• Partitioned the large tables and indexes by determining the suitable methodology to improve performance and manageability, Extract, Transform and Load (ETL) data from flat files into database using SQL* Loader.
• Defining and implementing Backup and Recovery Strategies on production, test, development databases using RMAN, VERITAS Net backup, and RECOVERPOINT, Hot and Cold Backups.
• Recovered tablespaces, datafiles on Oracle 10g using Recovery Manager (RMAN).
• Converting datafiles across different platform using RMAN convert, Transportable Tablespaces (TTS).
• Crontab jobs and UNIX Shell scripts to automate backups, exports/imports, analyzing tables indexes, monitor tablespace growth, alert logs, startup, shutdown of databases, gathering statistics.
• Excellent day-to-day administration in every means and monitoring alert log files and trace files.
• Transfers of data from one database to other by using exp/imp, oracle data pump (expdp/impdp).
• Setting up Oracle read only replication with materialized views, Streams to develop scripts for automating the rebuilt process of replication and documented oracle database setup and administration of server environment.
• Assisting developers with SQL, PL/SQL coding to enhance the database performance.
• Find solution and resolve critical issues with Oracle Support.
• Database sizing analysis, recommendations and perform database re-organizations as required to assist performance and ensure maximum uptime of the database.

Environment: RHEL, Sun Solaris, Oracle 10g, 9i, ASM, RMAN, Dataguard, SQL, PL/SQL, UNIX Shell Scripting, OEM Grid Control, Informatica MDM, Quest Toad, Putty, exp/imp, Datapump, JSF.