TECHNICAL SKILLS:

• Oracle DB 10g/11g/12c/13c/18c
• RAC (5yrs), TOAD 11.5UNIX scripting (10yrs)
• Business 12.1
• Oracle RMAN (10yrs)
• Data Warehouse (6yrs)
• (AWS), (EC2), & RDS . VPC. Azure virtual machine (VM)
• Data Replication
• SQLPlus, PL/SQL, Exadata, Cellcli,Dcli.DB2 DB2 UDB
• PlateSpin migrate, PlateSpin Recon, PlateSpin Protect P2V, V2P, V2V,Goldengate
• Performance Tuning, LUW Upgrades (10yrs)
• Active DataGuard
• OEM 12c Cloud Control
• DB2 SQL Server 20, MYSQL 5.6
• Platforms (Linux, Solaris, Windows, HP - UX, AIX)
• ASM, ASMCMD
• Big data, Hadoop, Tuxedo, Weblogic, NoSQL, Oracle.
• Oracle Data Pump Export, Tsunami UDP
• AWS Database Migration Service

PROFESSIONAL EXPERIENCE:

Confidential, Alabama

Sr. Oracle Database Administrator

Responsibilities:

• Installed, upgrade and configured Oracle Enterprise Databases 11.1 to 11.2 and configure dataguard 11g for DR with two Developed scripts for the creation of the physical database schema, data security and protection.
• Administration skills in sizing, capacity planning in large-scale enterprise environment, Design, document and build table, column, index and view definitions to storage requirements and drive space and growth accommodations, Optimize and tuning of workloads, query or package changes and optimizations to ensure and improve system performance and reliability, designed, monitored, and administer databases,
• Determine processes that should be developed/automated to improve efficiency and reliability, Experienced planning and installing Oracle RAC databases on 11g an 12g.
• Worked with network and storage teams to plan and create environments. Responsible for the creation and maintenance of complex UNIX shell scripts for the administration of databases
• Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade and patch application from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate’
• Strong experience on Red hat Linux and Windows enterprise server systems., Worked with PCI projects to secure production environments.,Worked with storage teams to present storage and add storage for ASM and ACFS file systems., Configured TNS, VIP and SCAN listeners, Experience with partitioning and indexing, and working with large data sets.
• Experience in Oracle performance tuning. Created SQL tracing and used tkprof, SQL baselines, and Grid control. Configured and scripted RMAN backup and recovery processes. Performed point in time recovery using RMAN and flashback operations. Strong knowledge of SQL, analytic queries, and PL/SQL. Provided support for Oracle Enterprise Manager Grid Control and Agents for database monitoring/performance/diagnostics.

Confidential, Middleton WI

Sr. Oracle Database Administrator - Lead Consultant

Responsibilities:

• As a lead DBA, Provided technical expertise for the planning, analysis, design, implementation, and support of the company Confidential and data warehouse systems running in sixteen different Oracle RAC clusters.
• Provided technical assistance for backup, performance tuning, network administration, maintenance, migration, patches and upgrade support for more than 185 oracle and instances running in Linux, AIX and windows platform.
• Installed and configured Goldengate 12c and active Dataguard in the primary and DR systems move/replicate database and, Diagnosed and resolved database issues related to but not limited to installation, configuration and performance Oracle RAC in Linux and SQL Server 2012 running Windows Virtual Server 2012 SP2.
• Perform database maintenance as per Company requirements, scheduled cron jobs to maintain automation of database backups. Implementing high availability concepts like mirroring & replication. Plan, schedule and coordinate database/application patching, and Implemented Database refresh, upgrade and migration as requested.
• Lead the Migration of ASM diskgroups/disks using Oracle OEM 12c cloud control and sometime SQL command line. Used OEM12 cloud control and Bigbrother for monitoring and support of the systems running in Oracle 9i, 10g 11g and 12c
• Utilized expertise in database performance tuning, sql query tuning to improve response time of the queries, database health checkups. Also very capable of participating in performance tests and identify high performing queries and make them perform well.

Sr. Database Administrator

Responsibilities:

• Troubleshot and resolved major tuning issues with Oracle 10g in four UNIX boxes. Converted two old Solaris boxes running Oracle 9i to Oracle 10g. Also reinstalled and maintained four boxes running Oracle 11g R 2 and RAC. Lead the project of building, implementing and maintaining Oracle DataGuard in the current 11g Oracle database server and SAP environment. Produced entity relationship diagrams, Data definition language parameters, database normalization schemas, and oversee Logical to physical database mapping. Responsible for database maintenance, UNIX scripting, Oracle Data Guard, DR, ASM, Grid Control, and RMAN support.
• Managed and supported several oracle DB instance running in production housing high traffic online extraction, analysis and ipayment applications. Used Oracle GoldenGate to move data between like-to-like and heterogeneous systems, and between Oracle and non-Oracle databases including Microsoft SQL Server and MySql, Lead major Migration project from MySql to Oracle 11g