PROFESSIONAL SUMMARY:

• 7 years’ experience as DBA supporting customer - facing Oracle 11g,12c standalone/RAC databases, Exadata & ODA engineered systems ranging up to multiple TB size with high volume of transactions in production, development & testing environments for clients across various domains. Daily activities include ASM & DB installations, configurations, performance capture and tuning (query & system), backup and recovery (RMAN), High Availability (Data Guard), DML & DDL codes deployment. Extensively worked on Storage Expansions on RAC, PSU Grid & Oracle Patching, DB upgrades, Cloning/Refresh, Node addition and Disaster Recovery, OEM 12c & 13c
• 4.5 years of experience managing end to end Oracle E-Business Suite Application 11i, R21.1, R12.2
• Worked on Oracle Golden Gate 12c installation, configuration (using oracle DBFS), troubleshooting sync issues, Attunity change data capture (CDC)
• 2+ year of experience installing and administering Microsoft SQL Server 2016, MySQL and MariaDB databases with Galera clustering. Exposure to PostGRESql, Databases & Fusion Middleware, WebLogic Applications. Good at Unix Scripting
• Hands on experience in building large infrastructure supporting high volume of transactions in a mission critical environment with 0 downtime.
• Strong communication skills, self-motivated and excellent at interpersonal skills. Ability to thrive in a fast-paced environment with tight deadlines. Looking for opportunities near Los Angeles, California area. Authorized to work for any employer in the USA.

TECHNICAL SKILLS:

RDBMS: Oracle 10g/11g,12c,18c Database, Oracle EBS Applications 11i/R12.1, R12.2, Exadata, ODA, Grid & ASM, MySQL, MariaDB, Microsoft SQL Server

Operating Systems: Linux, Windows, Solaris

Languages: SQL, PL/SQL, Unix Programming

Utilities: SQL*Plus, SQL* Loader, EXPDP/IMPDP, DGMGRL, GGSCI, RMAN, OPATCH, EXPLAIN PLAN, DBMS XPLAN, AWR, ASH, AUTOTRACE, SQL Trace, TKPROF & SQL Tuning Advisor, Exadata, ODA, T-SQL, PowerShell.

Tools: Toad, SQLDeveloper, Oracle DBCA/DBUA, OAKCLI, CELLCLI, ADDM, OEM13c, ServiceNow

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, California

Senior Database Consultant

Environment: ORACLE 11g/12c, Attunity CDC, SQL, RMAN, Solarwinds Ignite DPA, Physical Standby (Data Guard), MySQL, MariaDB, Exadata and ODA machines, Unix Scripting. Oracle Cloud Infrastructure(OCI), Golden Gate 12c

Responsibilities:

• Lead onshore/offshore team of DBAs to support Oracle RAC & single instance databases on Exadata and ODA Appliances, MySQL and MariaDB databases
• Test out and deploy Oracle databases on different solutions offered by Oracle Cloud Infrastructure
• Perform database monitoring, maintenance, reorganizations, resource management, schema management, and capacity planning and performance tuning for the company's databases
• End to end understanding of Exadata and Oracle Data Appliance engineered systems. Work with oracle to schedule and manage Exadata patching via OASG tool for platinum support, patch ODA appliances using oakcli on a quarterly basis
• Use CELLCLI, DCLI, OAKCLI command line utilities to routinely identify issues, correct and patch Exadata & ODA. Work with on-field datacenter technicians for diagnosing & replacing faulty parts on engineered systems
• Build/maintain physical standby’s and support Disaster Recovery architecture. Expert in DGMGRL,FSFO
• Install Oracle Golden Gate CDC. Perform OGG installation & setup between Oracle Database versions, monitor and fix OGG lag process and errors. Implement and support Oracle to SQL Server change data capture using Attunity.
• Oracle Grid installation, work with ACFS filesystems, migrated storage from ACFS to ASM storage. Implement best security practices, encryption using Oracle TDE in Data Guard environment.
• Involved in dbms auto sqltune.report auto tuning task, dbms auto task admin enable/disable during the performance hit scenarios, capture resource sensitive sql’s from AWR/Memory to create/load/delete STS, dba sqlset statements, Manually creating/executing/reporting sql tuning task from either AWR/Cursor and fixing as per suggestions, staging STS, dba sql profiles, dbms spm, dba sql plan baselines, work on dbms stats for gathering system/database stats, locking volatile table stats
• Implement best practices for RMAN backups and restores, write scripts and automate reporting. Spearhead the project of moving backups to tape to a different vendor
• Work with various internal teams such as server, storage, backup & network administration teams to coordinate and troubleshoot infrastructure related issues. Work with developers and analysts to support development efforts. Clone databases as needed to support development and testing efforts.
• Provide end to end to install support for MariaDB implemented with Galera clustering and MySQL databases with InnoDB and Replication
• Install and configure OEM 13c, manage OMS and configure/maintain targets. Write Unix shell scripts for design and implementation of proactive alerting and monitoring using Solarwinds Ignite Data Performance Analyzer(DPA), OEM 13c
• Actively design and lead team meetings, document process, streamline and automate tasks using Unix scripting, report & resolve bugs with help from Oracle Support

Confidential

Database Administrator

Responsibilities:

• Patch Oracle database and EBS application using OPatch and AD utilities. Cloning/Refreshing Oracle EBS Test/Development environments from Production environments using RPA, RMAN, RapidClone and automated methods
• Use AD utilities to perform maintenance of multinode EBusiness Suite environment with Shared File System, managing and administering Concurrent Requests & Programs, Request Sets/Groups, and troubleshooting Workflow Mailer/Notification issues
• Architect, plan, strategize and implement Oracle database upgrades from versions 10g/11g to 11g/12c and Oracle EBS Application versions 11i/12.1 to 12.1/12.2 from planning to go-live
• Proactively tune Applications and Database using AWR, ASH, OEM, Oracle Diagnostic Tools and SQL Advisory for better performance
• Using Oracle Recovery Manager (RMAN) for backup and disaster recovery of databases/single datafile/block and fix corruption issues. Perform Disaster Recovery(DR) tests
• Implement and upgrade Oracle Enterprise Manager(OEM) 11g, 12c to monitor and optimize system performance. Install, support and upgrade Discoverer 10g/11g standalone services. Support Oracle WebLogic, SOA Suite, Hyperion, Apex, Vertex, GRC, GL Wand/More4Apps and Markview Applications
• Aid in scripting and automating common, repetitive routine tasks to across the spectrum of supported products and technologies. Work closely with Oracle Support, Functional, Systems and Network team to troubleshoot issues