SUMMARY

• Over 6 years of strong experience in Oracle database administration in heterogeneous system environment including Linux, HP - UX, AIX, Solaris, UNIX, and Windows.
• Team player with excellent interpersonal, analytical and communications skills.
• Worked on Creation of tablespaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers
• Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.
• Create Oracle SRs and follow up with oracle support to fix bugs issues that came up in both production and development environments.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, Patch sets as per the oracle recommendations.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g/12c/19c
• Upgraded Oracle 10g database to 11g and upgraded Oracle 11g database to 12c, and 12c to 19c..
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experienced in full life cycle of database administration in Oracle, working both as a Development support and as well as Production Support Oracle DBA.
• Experience in Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
• Performance tuning of the database with experience using tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM.
• Perform complete and incomplete recovery using RMAN. Also experience in recovery of control file, online redo log file, critical data files and parameter file.

TECHNICAL SKILLS

OPERATING SYSTEMS: Red Hat Linux, Oracle Linux, UNIX, AIX, HP-UX, and all Windows

RDBMS: Oracle 9i, 10g, 11g, 12c and 19c

LANGUAGES: SQL, PL/SQL, Shell Scripting, Ksh, bash

SOFTWARE/APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), 11g OEM Grid Control OEM 12c, OEM 13c, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, Data Pump (expdp, impdp), TOAD, SRVCTL, SQL*Plus, SQL Developer, Apex, ETL, SQL Loader, Oracle Streams, golden gate

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, and ADDM, ASH

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Topeka, KS

Sr Oracle DBA

Environment: Oracle Linux, HP-UX, windows, Oracle database 11g, 12c, 19c

Responsibilities:

• Installed and configured Oracle 19c Databases and Migrated Oracle 11g and 12c databases to new 19c development, test and production databases which supports MPA terminal operations and Finance in standalone with appropriate storage specifications for indexes, tables and tablespace partitioning
• Implemented high availability solutions like Oracle Goldengate integrated bi-directional configuration to replace Oracle streams
• Installed, Managing, and supporting Oracle WebLogic 12c Forms and Reports and OHS and Migrate the applications from 10g to 12c Forms and reports.
• Migrated all the Oracle database and application servers to Oracle Virtual servers as Virtual machines to comply with Oracle Licensing
• Performs daily data refreshes, production code deployments, troubleshooting various client server and web application issues
• Installation and configuration of Oracle Enterprise manager 13c to monitor databases and application servers.
• Encrypted Oracle Tablespace using TDE wallet with Advanced Security option
• Scheduled Data pump (Expdp/Impdp), hot and cold Full backup and Recovery manager (RMAN) Incremental backup jobs
• Responsible for performance tuning, security administration and disaster recovery
• Application of Oracle Linux and Windows Security patches to all database servers in compliance with Oracle and Microsoft.

Confidential, Baltimore, MD

Oracle Database Administrator

Environment: Linux RHEL 5.X, 6.X, Windows NT 2000/2003; Oracle 10g, 11g, 12c

Responsibilities:

• Automated hourly, daily, weekly system health reporting using Crontab, PL/SQL and shell scripts.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Worked on data guard physical/logical standby databases.
• Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Install Oracle EBS APPs and repository database, create and manage user account, troubleshooting performance issues and fixing user access issues.
• Database Refreshing / Replication from production to testing using datapump Exp/Imp.
• Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Implemented procedures to detect the poor database performance, collecting required information, root cause analysis, successfully tuned and improved the performance of the database.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
• Configuration and implementation of Oracle RAC for high availability.
• Performed Schema as well as Table level Replication using Oracle Streams and real time replication using oracle Golden gate worked on setting up and standardizing auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.

Confidential, Tampa, FL

Oracle Database Administrator

Environment: Linux, Solaris, AWS RDS and EC2 VMs, Oracle database 11g, 12c

Responsibilities:

• Daily duties may include: Writing SQL Queries, Updating/Archiving MySQL and Oracle databases, Updating Apache Servers,understanding what our employees need in the software to be more efficient, then implementing the best option.
• Installation and administration of RAC Clusters, configuring and monitoring daily backups, troubleshooting errors to improve performance.
• Created physical standby database using RMAN duplicate from active database
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Applied monthly Linux OS patches to the database RAC clusters.
• Created and maintained oracle maintenance scripts for rotation and trimming of various logs.
• Regular RAC health check using RAC-check tool to look for any inconsistencies and best practices.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
• Handling support tickets in timely manner based on the severity level and always be available for developers.
• Administered Oracle 11gR2 production environment on RHEL, IBM-AIX, and Sun Solaris.
• Worked on tools such as AWR, ADDM, TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Conducted sizing & capacity planning for Oracle databases.
• Worked on maintaining schemas and partitioning tables.
• Implementation and release of database changes as submitted by the development team.
• Installed and administered Goldengate uni/bi directional for data replication between 2 sites.
• Check environment for production readiness and suggest required improvements.
• Performed Basic administration tasks for Linux Machines (RHEL, SOLARIS)).
• Provided 24X7 support for all the production and development databases.