SUMMARY:

• Extensive 9+ years of experience with the database/NoSQL from designing, developing, implementing and networking, monitoring & managing of users, performance tuning of applications and the databases Oracle 11g/10g/9i/8x as well; using SQL, PL/SQL, SQL*Plus, ORACLE RAC (Real Application Cluster), Standby (Data Guard) Database, Exadata, Golden Gate, NOSQL Cassandra, Oracle Enterprise Manager & Oracle Management Server on Unix (Linux, AIX, SUN and HP) & Windows platforms.
• Experience in supporting and administrating large 24x7 production databases in Oracle 10g and 11g 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, Sun Solaris, and Windows. Good hands-on knowledge in 10g/11g 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.
• Experienced in GoldenGate 11g installation, configuration of Extract, Pump and Replicate. Managing GoldenGate process, Trouble Shooting and Upgrade of software.
• Deployed Oracle High Availability based on Streams Replication and Active Data guard.
• Experience in MS SQL Server installation, configuration, and client/server connectivity.
• Experienced in Oracle migration 9i to 11G, 11G to 12c 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 Solaris, AIX and Linux platform.
• 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.
• Migration of databases between Software versions, Platforms and database products.
• Expertise in writing UNIX shell scripts and SQL scripts for database monitoring and administration.
• Experience in implemented and administered Data center Cassandra Clusters based on the knowledge of architecture and data modeling for Cassandra applications. Configured DataStax OpsCenter and Nagios for Cassandra Cluster maintenance and alerts.
• Experience in design/Build Cassandra Clusters both on the physical machines and on AWS
• Knowledge in implementing multi-data center and multi-rack Cassandra cluster.
• Knowledge on HANA 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.
• Involved in production DBA support in solving the database problems and co-ordination with Confidential .
• 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/12c, SQL server 2000-2005, NoSQL Database, Cassandra, MangoDB

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

HighAvailability: Real Application Clusters (RAC) 9i-11g, Data Guard, RMAN, HP Service Guard, VERITAS Cluster Server, GoldenGate 11g

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 / DATA analyst

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 and single instances using customized scripts, DBCA.
• Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS) Data pump.
• 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.
• Installations of Service Packs, patches and cumulative updates on SQL Server all versions.
• Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
• 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.
• Administered Cassandra cluster using DataStax OpsCenter and Nodetool utility to monitor CPU usage, memory usage and health of nodes in the cluster.
• Design/Build Cassandra Ring for a Service assurance application on VM's for non-prod and Physical machines for a Production Ring.
• Used Snapshot & incremental backups to take backup and restore Cassandra on another node.
• 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.
• 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 upgrade of RAC 11g/12c environment using response file, Creating pre-configure CDB and PDB.
• Working Knowledge on Mini Cluster for DB deployment and steup.
• 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.
• Installation and configuration of HANA server as POC for new application.
• HANA Administration including managing schemas, data model objects and import/export content as needed.
• HANA admin activities: User / role management, HANA security, expensive statement analysis, performance/memory issues.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Insure that designs and processes follow ITIL framework and SOX compliance.
• Creation and setup of physical standby databases and oracle active dataguard on exadata machines..
• 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.
• Manage ASM disk groups and ACFS file system, manages space in ASM by adding, deleting disks to the existing disk groups and rebalance..
• 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.
• 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, SAP HANA,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 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.
• Implementation of PCI DSS Security standards on application level.
• 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 11g/10g, 11i-12R, CA Erwin, Data Pump, OEM and Toad

Confidential, Hoffman Estates, IL

Oracle DBA Consultant

Responsibilities:

• Verify success of database backup (Maintaining RMAN Backups and Logical Backups).
• Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes.
• Responsible for Installation, Configure, setup of 10g RAC and worked on performance issues which includes node eviction and node addition.
• Upgrade of Oracle Applications EBS from R12.1.3 to R12.2.2 and 11.5.10.2 to R12.1.3
• Upgraded 10.2.0.4 Two Node RAC ASM database to 11g R2 Two Node RACASM.
• Perform database design, manipulation, maintenance, and integration tasks in Oracle Spatial using SQL, PL/SQL, SQLLDR, SQL Developer, and similar tools.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Implemented and maintained Oracle 10g/11g 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 9.0 to 10.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, 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, 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.
• 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.
• Proactively monitor 10g 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 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.
• 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.
• 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.
• 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.
• Transfers of data from one database to other by using exp/imp, oracle data pump (expdp/impdp).

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