SUMMARY:

Over 5 years of experience in Oracle database administration in heterogeneous system environment including Solaris, Linux and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c.

AREA OF EXPERTY:

Software Installation, configuration and Database creation. Performance & Tuning, Database backup/restore/duplication (cloning), Setup Patches/Upgrades, Advanced Features (12c Multitenant), Advanced Features (Data Guard), Advanced Features (RAC) and Oracle Golden Gate. Oracle Database Grid Control Support & Administration, Maintenance, Migration, Intermediate postgres version 9.5 and 9.6 Space Management, Database Monitoring, Database Security, Flash Back Technology, Troubleshooting, Documentation, Capacity Planning, cost base analyses and Shell Scripting knowledge, knowledge on Exadata .

TECHNICAL SKILLS

OPERATING SYSTEMS: Linux Red Hat 6, 7.4, Windows 2012, 2014, 2016 and Sun Solaris 10.0

RDBMS: Oracle 10g/11g/12c, Postgresql 9.5/9.6, Sql Server 2012, 2014, 2016

SOFTWARE/ APPLICATIONS/ TOOLS: Real Application Cluster (RAC), ASM, SRVCTL, Oracle Data Guard, Oracle Golden Gate, Oracle Management Service (OMS), Oracle Enterprise Management (OEM), OEM Grid Control 12c, TOAD, Sql Developer, DataPump, Exp/Imp, Recovery Catalog, Crontab, RMAN, DBCA, DBUA, Debug PL/SQL, PgAdmin, PgHero, Psql, SSMS, SP Blitz, OLA Maintenance solution, T - SQL

WORK EXPERIENCE:

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux and Windows environments.
• Applying upgrade patch, and interim (opatch) patches on all the databases.
• Implemented oracle 12c active standby databases for test database environment and oracle 12c flex asm for pre - prod environment.
• Successfully implemented Backup & Recovery using RMAN which includes hot and Cold backups, recover table functionality and scheduling backups using Crontab.
• Played integral role in the configuration of GOLDENGATE for real time replication and high availability in a heterogenous Environment. Performed initial load using datapump and RMAN from source database to target.
• Providing database administrative support and 24x7 on call support for production and the smooth functioning of all ecommerce activities.
• Experience with large databases (1.5 Tb) for OLTP and OLAP applications.
• Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 nodes) using clusterware and automatic storage management (ASM).
• Performed migration of oracle 10g/11g non RAC single instance to RAC database instances. Clone Database using RMAN on remote Server.
• Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM. SQL query tuning using tools like Explain Plan, SQL TUNING ADVISOR, ASH, AWR & ADDM.
• Worked extensively on Performance tuning of Queries by maintaining partition, indexing and use of Hints, Statistics.

Confidential

Responsibilities:

• I have been involved in Installing/configuring PostgreSQL. Mainly Three postgres VERSIONS 9.5 and 9.6 and 10 Managed and monitored these databases using pgAdmin.
• Performing BASIC TASKS such as OBJECTS, creating roles, granting privileges, creating tables and Managing Users and Tablespace on PostgreSQL Servers.
• Provided PRODUCTION SUPPORT based on a ticketing system. And Assisted in defining and implementing MAINTAINANCE PLAN for the database system
• Experience in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Hands on experience on restoration techniques on PostgreSQL like pg restore and (PITR) Point in Time Recover.
• USE pgHero for Performance TUNING mostly. SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY, performing maintenance activities like vacuum, analyze etc.
• Exposure on cross platform migrations preferably Oracle to PostgreSQL. I documented and assisted as an ORACLE DBA Data MIGRATION from ORACLE Databases to PostgreSQL database in AWS Cloud
• Control and monitor user access to databases and maintain database security.
• Analyze online and database performance and/or implements improvements.
• Analyzing, integration and reporting of services
• Perform basic analysis to help in identifying and resolving performance issues
• Document the company’s database standards and changes for future reference.
• Proficiency with SQL Server backup and recovery techniques.
• Responsible for 24X7 support of production databases.
• Install, configure, patch, and upgrade Microsoft SQL server databases.
• Support multiple databases in development, test, and production environments.
• Setup High-Availability as part Disaster Recovery Strategy for the Databases and migration on same platform.

Confidential, Dallas, TX

Oracle DBA

Responsibilities:

• Cloned/Migrated databases using RMAN and Datapump expdp/impdp utilities in Oracle 11g
• Used CRONTAB and OEM to manage backup, 24 X 7 PROD and DEV database support and administration and reports for Quick Morning Check (QMC).
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TUNING ADVISOR, TKPROF, ASH, Explain Plan, TOAD, AWR and ADDM reports.
• Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Strong skills in applying security patches; Patch Set Updates (PSU) using perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Exp/Imp of Oracle 11g, 10g.
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files. Run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed disaster recovery and overall maintenance of the databases.
• Completed Data Guard switch over and failover in alignment with requirement, utilize data guard broker to monitor the configuration
• Documentation using SharePoint for feature references.