SUMMARY:

• 7.0 years of Oracle DBA, Linux/AWS Administrator experience in IT Infrastructure and Hosting based 24X7 support environment. As Senior Database Administrator responsible for installing, configuring, maintaining, and tuning Oracle software, database components, backup/recovery activities, create/modify shell scripts for automation. Extensive experience in Oracle RAC, ASM, Data guard, Golden Gate and Performance Tuning. Seeking a Technical position fully utilizing strong customer service attitude, exceptional organizational ability and technical skills.
• Expert in Oracle 9i, 10g, 11g, 12c Extensive experience in upgrading Oracle databases from 11g to 12c.
• Expertise in RAC and ASM installation and administration. Expertise in Data guard configuration, maintenance and gap resolutions.
• Experience in Golden Gate configuration and administration.
• Experience in architecting multi - terabyte systems, including a proven track record of physical optimization, query optimization and capacity planning.
• Expertise in installing, upgrade, migration and patching standalone and RAC databases.
• Have completed successful migration of SQL server to Oracle databases.
• Have been part of storage migration from EMC to Oracle with size of 15TB / 20 TB
• Extensive experience with features such as Oracle Real Application Clusters (RAC), ASM and Active Data Guard for HA and DR solutions
• Restoration and Recovery of databases. Responsible for refreshing and cloning of databases per customer requirements using RMAN, Data Pump.
• Possesses strong coordination with global teams, planning, interpersonal, communication, presentation and decision making skills.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Experience in monitoring database performance statistics and recommending improvements.
• Experience in Backup and Restore strategies, modifying and creating RMAN backup scripts and database cloning using RMAN
• Maintenance and Support of multi-terabyte databases in production, testing and development environments hosted on Unix servers (HP, Linux) and Linux, Solaris servers
• Write UNIX shell scripts to automate database functions.
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these capacity requirements to management.
• Proven track record administering Oracle databases in a challenging environment
• Experience with upgrading OEM from 11G to 12C
• Have migrated Oracle databases to AWS EC2 and RDS.
• Solid Experience with design, development, and implementation of database instances - schema, queries, pl/sql code, triggers, etc.
• Ability to work effectively in a team environment and able to stand alone in meetings and represent group with internal/external customers
• Ability to learn and adapt to new technologies and ability to collaborate with multiple teams and stakeholders
• Proven success in a fast-paced environment and highly demanding environment and capable of providing thought leadership and abstract thinking
• Willing to relocate: Anywhere

PROFESSIONAL EXPERIENCE

Senior Oracle Consultant and System Architect

Confidential - Charlotte, NC

Responsibilities:

• Serve as Oracle and Linux subject matter expert for migrating and upgrading 40T data warehouse from single instance 11gR2 to 12c RAC database.
• Automating validation of OS configuration by writing shell scripts.
• Manage and oversee operational readiness of new servers for 12c RAC databases, such as the OS configuration, the mounting of ACSF file systems, and the installation of Oracle clusterware and application softwares.
• Security check for database by SQL scripts and provide remediation suggestions to meet data security and compliance requirements
• Work closely with other database administrators/developers, OS engineer and subject matter experts to ensure the success of migration of 40T data warehouse from single instance 11gR2 to 12c RAC database by DataGuard; and the integrity and availability of databases and their accompanying application softwares, such as Anthill Pro, NDM and Autosys
• Performance testing and tuning of 12c RAC database after migration and upgrade from 11gR2 single instance by using AWR/ASH/ADDM/OEM 12c/SQL Plan Management and home-cooked scripts
• Support and maintain Redhat Enterprise Linux 7.2 - Oracle 12c RAC database building documentation.

Oracle Database Administrator

Confidential - Austin, TX

Responsibilities:

• Database refresh, creating duplicate database, schema refresh
• Taking the backup of database on scheduled basis and performing the recovery if required including user managed and RMAN method as per requirement. Data export and import using datapump.
• Performing the upgrades and patching in standalone and RAC databases.
• Have been part of Database Migration from SQL Server to Oracle Database using Golden Gate.
• Dataguard DR setup, administration and monitoring.
• Golden Gate Setup, administration and monitoring.
• Create/restore/refresh standalone and RAC databases as per business requirement.
• Have part of storage migration from EMC to Flash array.
• Migrated oracle databases to AWS. Experience in creating and administrating RDS and EC2 instance.
• Have migrated Oracle databases to AWS EC2 and RDS.
• 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.
• Troubleshoot and resolve database and/or application problems encountered by end users.
• Works directly with software developers to develop and enhance applications and data conversions.
• Support development teams with technical and physical design, development, and maintenance of Oracle Server databases; including data analysis and modeling, programming, implementation, performance monitoring, tuning, cloning/refreshing, planning, problem resolution, and data dictionary administration.
• As Scrum master to create backlog templates, run the standup meetings, help the team to get the impediments resolved.
• Partitioned large tables for better performance and manageability.
• Experience on 24*7 environment including on call support as per requirement. Conversant in handling requests within SLA.
• Provide on-call support in adherence to specific business and customer Service Level Agreements
• Implementation of daily, weekly, and monthly DBA checklists for each environment.
• To work with the integration team to implement the data model in database.
• Installation & configuration of windows Active
• Directory Configuration of Liferay with AD
• Configuration of Liferay with AD sync and replication Single sign on
• Logging with the Screen Name
• Working on iframe portlets
• Importing users and groups from AD to Liferay

Oracle DBA, Consultant

Confidential, Costa Mesa, CA

Responsibilities:

• Working as the primary/lead DBA in the Database Support Team to support (daily On-Call rotation) the core Billing Management & CRM production and non-production environments.
• Working with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model for the development and production environments for Data Warehouse and OLTP systems.
• Coordinating with storage team to design/optimize the storage system by using IBM GPFS(General Parallel File System), Oracle/Sun ZFS and Exadata Servers.
• Lead for a large number of tuning projects. Working with third party vendor developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, Statspack, OEM Performance Manager, Spotlight and home-cooked scripts by using Korn shell/Perl.
• Designing and implementing High Availability Oracle GoldenGate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments. Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments ( from Oracle to MS SQL Server).
• Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c (OEM), developing and maintaining the Korn shell based home-cooked monitoring scripts to monitor database instance status, tablespace usage, goldengate process running status, J2EE/Weblogic server status, etc.
• Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export / Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.

Oracle DBA

Confidential,Tallahassee, FL

Responsibilities:

• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g and Sun
• Created cdb and many pds in development environment and managed them.
• Installed and used OEM 12C Grid control to monitor all databases.
• Implementation of High Availability solutions with Oracle 11g RAC,
• Developed back - end logic for business applications, e.g. views, procedures/functions, triggers. demigration of all custom application changes
• Developed 3 node RAC environments for a 1TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.
• Monitored/managed 3 node RAC environments, databases using OEM Grid control, and RMAN database backup and recovery.
• Working alongside programmers and contributing to the development process; Enabling and analyzing trace files
• Performing monitoring and performance tuning.
• Architected and created a robust backup and recovery procedure.
• Performed and tuned using AWR,OEM Grid and AWR/ADDM etc Oracle Databases.
• Tuned the database using statspack and custom scripts
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Tuning and balancing I/O by monitoring file system and table space I/O statistics.
• Performance tuned multiple SQL statements
• Created automation Shell Scripts for managing day-to-day activities and automation of backup.
• Implemented Optimal Space utilization in table-space by avoiding fragmentation.
• Usage of Partitions to improve the query performance and manageability.
• Automated the process of analyzing table spaces every night.

Oracle DBA

Confidential, Herndon, VA

Responsibilities:

• Supported navy NMD application production and development.
• Oracle 10g on Netapp with snapshot backup and rman.
• Installed, patched, configured database software.
• Assisted developers in troubleshooting sql performance issues.
• Duplicated production db’s to lower environments using snapshots.
• Used Oracle OEM Grid Control, toad, sqlplus to manage databases.
• Monitored space usage, performance tuning.
• Created oracle servers, configured rman and oem database control.
• Supported Sybase 12.5, 15 servers.
• Managed daily tasks using unix scripts.
• Implemented dod stgg security on the databases.
• Installed and configured 11g test databases for developer evaluation.
• Part of 3 person dba team with 24/7 support coverage.
• Proactive real-time monitoring with oem grid control