SUMMARY

• 10+ years of experience as Oracle DBA, strongly in Oracle Database Appliances (ODA), EXADATA and Oracle Golden gate.
• Proficient in Oracle 10g/11g/12c and 13c software installations, migrations, database capacity planning, automated backup implementation, Performance tuning on Linux/Unix and minor experience in My SQL platform using my SQL workbench.
• Involved with the architect group in designing, projects and planning the logical and physical model of the enterprise level databases.
• Provide support on oracle RAC, and data guard with various teams.
• Expertise in restoring and recovering Oracle database using RMAN.
• Extensive experience in Install, Configure, Deploy, upgrade, and patch and manage existing Oracle database 9i, 10g, 11g or 12c .
• Expertise using OEM 11g, and 12C, 13C Cloud Control .
• Experienced in troubleshooting, monitoring, backups and recovery as well as data migration, Data guard .
• Expertise in Deployment of Oracle Goldengate 11g and 12C .
• Work with various ticketing system including remedy, Service Center and Service Now. Support Oracle server and application tools. Allocating system storage and planning future storage requirements for the database system.
• Experience as On - Call 24x7 production DBA support, application/development DBA.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g and 11g, with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and standby database for High Availability and Disaster Recovery purpose.
• Experience in managing Oracle databases running on MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation).
• Good experience RAC Cluster ware administration, Configuration and Patching.
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Hands on experience in Grid control, Streams, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) for database monitoring/performance/diagnostics.
• Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good experience in writing/editing UNIX Shell Scripts.
• Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 8i to 9i, 9i to 10g & 11g, 10g to 11g.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB.
• Experience in Flash-Back Technology.
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Experience in Capacity Planning and Bench Marking.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Excellent Communication skills, co-ordination and communication with system administrators, business data analysts and development teams. Experienced in working environment Exadata, Oracle Cloud, Golden Gate, AWS Cloud etc. Participated in migrating and managing oracle databases on AWS cloud RDS and EC2 services

TECHNICAL SKILLS

Databases Installation/Management: Oracle 18C, 12c, 11g, 10g, 9i, 8i, MySQL, Microsoft SQL Server 2005,2008,2012, PostgreSQL 8.4, 9.2, Real Application Cluster (RAC), ASM

Security Tools: IDS/IPS, DLP, NESSUS, Nmap, SIEM, Wire shark, TCP/IP, NIST SP 800-53, ISO 27001, Internet Security, Malware prevention, Email Security, Security Controls, Antivirus tools.

Applications/DevOps Tools: Apache, Nginx, Lotus Notes, LVM, KVM, Xend, VMware, Virtual Box, Docker

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, IBM AIX 5.3/6.1/7.1, RHEL 3.x, 4.x, 5.x, Linux 6 and Windows

DB Utilities: SQL LOADER, Data Pump, RMAN, OPatch, TKPROF, AWR, ADDM, SRVCTL, CRSCTL, ASMCMD, ASMCA, DBCA, Golden Gate, ADRCI and DBUA, AWS

Hardware: Oracle X2/X3/X4/X6 full rack Exadata machine, IBM PowerPC, X64 box Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers

Tools: Oracle Enterprise Manager 10g/11g/12c, TOAD 8.5, SQL Developer, Putty, Log Miner, VMware

Languages: SQL, PL/SQL, Python, API, CLI, HTML5, Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior Oracle DBA

Responsibilities:

• Working on Exadata, Data guard, RAC and Multi -Tenant Environment.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advice, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Installed & configured 11g, 12c on Unix/Linux environment. Performed Migration and Upgrade of databases to 12c and 11gR2.
• Working on Incident Tickets Supporting 24/7 support, on-call for production database and supporting developers & end-users
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Create test database for ODA/ Exadata environment for TDE implementation projects.
• Migrated 12c oracle databases to AWS.
• Performance Tuning ODA in extremely high data environments. Resolving TNS time out issues on environments from Oracle Exadata
• Installed and configured Golden Gate for replication. Golden Gate setup at both object level and schema level in both uni/bi-directional.
• Configured manager process to automate purging of the old trail files. Installation of 11g, 12c oracle client on the Application servers.
• Worked closely with developers in DDL deployments. Created and managed database objects such as tables, indexes, partition tables and views.
• Performing day-to-day database administration tasks like Table space usage, monitoring alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs.
• Performing the Yearly Standby- Data Guard Tests (Fail-over/Switch over) using DG Broker. Worked on Schema Refresh Requests using import/export.
• Creating and rebuilding indexes and optimizing the code to improve the performance. Setup backup, recovery procedures and Point in time recovery using RMAN.
• Implemented Oracle Active-Data Guard for maintained Oracle disaster recovery.
• Configuration, maintenance and tuning of 11g R2 on Two-node RAC Cluster.
• Applying Patches for 10g/11g Database, Quarterly released PSU's by Oracle.
• Trained in Exadata for setting/implementing Exadata for New datacenter migrations.
• Monitoring Exadata systems using OEM 13c, Sundiag and Exachk utility.
• Experience on Exadata /Half rack/Quarter rack.
• Experience in migration of databases to Exadata using EXPDP/IMPDP and Golden Gate.
• Analysis and management of Oracle problems/defects using SR's and/or Meta link with Oracle and Follow Up with the Issues raised with Oracle Meta link support.
• Loaded entire databases with data from legacy systems into development, testing and Production areas utilizing Data Pump.
• Configuring and utilizing RMAN to perform physical and incremental backups using the RMAN utility.
• Use RMAN & User Managed backup methods for better control. And Create users and set permissions.
• Manage database security using groups, roles and handled number of databases in different places.
• Create database objects and managed the permission access on the objects with necessary security.
• Used Data Migration Service (DMS) to Migrate on-premise Oracle database to AWS RDS Oracle for development Team.

Environment: Oracle 12c/11g/10g/ RAC, ASM, Data Guard, Golden Gate, Exa data, Cassandra IBM AIX 5.3, Red Hat Linux 6/7, Grid Control (OEM) 12C and 13C, AWS

Confidential, Pittsburg, PA

Oracle Database Administrator

Responsibilities:

• 24x7 Production database and applications support.
• Installed, configured, and maintained Oracle 10g and 11gR2.
• Upgraded databases from Oracle 9i, 10g to 11g.
• Involved with installation and maintenance of ORACLE 10g RAC/ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied CPU patches.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Performed block recovery using RMAN.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Partitioned large tables for better performance and manageability.
• Installed and configured Golden Gate for replication.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Migrated databases from Sun Solaris, HP-UX to IBM AIX, and Windows to Linux.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Performed Capacity Planning and Bench Marking
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables. Oracle old Database decommissioning.

Environment: Oracle 11gR2, 12C, ASM, RAC, OEM 13C, OGG 12C, ODA, RHEL 5.x, Solaris 5.x, Windows 7, Toad, SQL developer, PL/SQL, SQL* Loader, Exadata, Rman, Datapump, Remedy, ServiceNow.

Confidential

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 11gR2, 12C, etc. And Upgrade 11.2.0.4 to 12.1.01
• Worked and managed databases including an 8 Node Exadata on X2 & X3s from Development, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 6.5. Database sizes range from 500GB to 7TB (in MANHATTAN, ODS & FIN, OC11, SCI & EDW environments).
• Oracle Database Administration, database backup and recovery.
• Support many databases running Oracle 11g & 12.2.0.1 on Standalones & Exadata environment, running on X6s with the use of both Cloud Control 12C & 13C in monitoring.
• Implemented Golden Gate Technology on Oracle 10g. Monitoring and maintenance of multiple databases for production, development, testing and Staging purposes using utilities like OEM and Toad.
• Worked on development of PL/SQL stored procedures, Triggers. Applying upgrade patches, maintenance and interim patches on all the databases.
• Performance monitoring and tuning the database using OEM, AWR and ADDM analysis.
• Working on Oracle SQL & PL/SQL programming and tuning. And Using OEM Grid control to manage and administer database. Created initial process documentation to upgrade OEM 11G to 12C.
• Perform management, performance tuning, physical database design, and data replication.
• Provide database management, logical database design, complex recovery management, SQL coding and optimization techniques, etc. Oracle software upgrades, fixes and patches necessary for the software.
• Input information on inventory software of database configuration and licensing.

Environment: 11g, 10g, 9i, RAC, Data guard, Linux, HPUX, OEM, Grid Control, Toad, SQL Developer, Banner, Cosima etc.

Confidential

Oracle Database Administrator

Responsibilities:

• Maintenance of Oracle Production, Development, Testing and QA databases.
• Installation and configuration of Oracle 9i, 10g databases.
• End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
• Worked with developers to provide queries and tuning the queries for better performance.
• Issues related to Space Management, Locks, Database Hit Ratios, Backup failures and UNIX related On-Call alerts.
• Resource Management (Create and manage Indexes, Clusters, Tables), allocate and manage physical storage structures like Data files, Redo logs, Control files. Allocate and Manage logical storage structures like Table spaces.
• Database backup & Recovery.
• Load data using SQL*Loader.
• Alert monitoring and Ticketing.
• Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers
• Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.
• Coordinating Backup and Recovery operations over all databases.
• Creation of users and Granting them privileges and roles.
• Export and Import Data according to the users request.
• Environment: Oracle 10g RAC/9i/8i, SUN SOLARIS, REDHAT LINUX, OEM (Grid Control), RMAN, Explain Plan, Data Pump, EXP/IMP, SQL*Loader, STATSPACK, AWR, ADDM.

Environment: 11g, 10g, RAC, Data guard, Linux, AIX, OEM, Grid Control, Toad, SQL Developer etc.