SUMMARY

• Hold 9+ years of Oracle database administration and related experience with extensive knowledge and proficiency in Oracle 10g, 11g, 12c, 18c and 19c database design, administration and systems analysis in test, dev and production environments.
• Experience in managing databases on multiple platforms as well as on Oracle engineered systems such as Oracle Database Appliance (ODA) and Exadata appliances.
• Excellent communication skills and a great team player with a fast learning curve.
• Work effectively under stressful conditions where speed and accuracy are necessary for mission critical databases.
• Possess great attention to detail and the ability to maximize system resources; skills which are beneficial in the following areas:
• Monitoring and Performance tuning using OEM 13c Cloud Control.
• Database growth monitoring and capacity Planning.
• Database duplication and refreshes.
• DB Creation, Configuration, Upgrade, Patching and Migration.
• RDBMS data loads into Oracle tables using ETL tools.
• Oracle Virtual Machine (OVM) for testing.
• Backup and recovery using data pump and RMAN.
• Database integrity and advanced security implementations (TDE).
• Automation and shell scripting
• Oracle High Availability involving Oracle RAC, Golden Gate and Data Guard.
• Oracle Cloud Infrastructure (VM, Bare Metal, Exadata)

TECHNICAL SKILLS

Platform/Operating Systems: Unix, Sun Solaris, Linux, Windows Server, Oracle Database Appliance (ODA) and Exadata

RDBMS: Oracle 10g, 11g, 12c, 18c, 19c, Oracle Cloud Infrastructure, MS SQL Server, MySQL.

Languages: SQL, PL/SQL, Shell Scripting, RStudio.

Tools: OEM 13c Cloud control, SQL Developer, Toad, Putty, MobaXterm, WinSCP, Team Viewer, Service Now, Freshdesk, Remedy, JIRA, CommVault, Rubrik, NetBackup

Database Utilities: Oracle Enterprise Manager (OEM), Real Application Cluster (RAC), ASM, Transportable Tablespaces, RMAN, SQL*Plus, SQL*Loader, Data Pump, Golden Gate, Data Guard, TKPROF, Explain Plan, Statspack, AWR, ADDM, SQL Profiling, and DBSAT

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Providing senior level database support skills in administration of production and non - production database environments.
• Supporting activities including installations, configurations, upgrades, performance, tuning, backups and disaster recovery (DR), regular maintenance jobs, encryption and troubleshooting.
• Supporting UAT/TEST/DEV endeavors and work with architects complete testing in pre-production environments.
• Administering databases on Exadata X4-2, X5-2, X6-2 and X7-2 running Oracle 12cR2 with current upgrades to 19c.
• Extensive experience ensuring scalability and high availability using Real Application Clusters (RAC) under controlled failover scenarios.
• Executing and troubleshooting SQL Queries as required.
• Experience in database performance tuning and Reporting
• In collaboration with team, strategize, collaborate, participate, and troubleshoot in various technical meetings with strong verbal and written soft skills.
• Configuring, monitoring, using current and historical metrics using Oracle OEM.
• Extensive working knowledge of UNIX/LINUX and Shell Scripts, along with an automation mindset and practice.

Confidential

Senior Oracle Database Engineer

Responsibilities:

• Experience providing high scalability and availability with Real Application Cluster (RAC). Hands-on experience in the implementing and managing heterogeneous database systems including 12c multitenant databases, RAC, ASM, Data Guard, Exadata, GoldenGate and Oracle Cloud environments.
• Upgrade databases from 10g, 11g and 12c to most recent versions 18c and 19c in test/dev and eventually production environments.
• Oracle Exadata Databases 12c Administration on Exadata on Premise and Oracle Exadata Cloud Service, such as database creation, managing storage structures, users, objects, privilege, security, backing up and recovery by RMAN
• Hands on experience in Grid Installation - Oracle ClusterWare/ASM setup and configuration to ensure high availability and scalability.
• Configuring, patching, administering, registering and monitoring of agents using EM 12c / OEM 13c Cloud Control and Oracle Management Cloud (OMC) in a high availability environment.
• Handling OEM & ILOM alerts for all agents and appservers within the environment. Managing/administrating Exalogic using OEM and managing Exalogic using emcli/GUI interfaces.
• Hands-on experience in with database security strategies such as user management, identity access management (IAM), implementing advance security features like transparent data Encryption (TDE) and audit banner related features.
• Database migration across platforms and on engineered systems like Oracle Database Appliance (ODA) and Exadata using RMAN Duplicate, Data pump and Transportable Tablespaces.
• Database Refresh/cloning from production to development using RMAN and data pump as requested by development team.
• Proficient with upgrading and patching of Oracle databases and Oracle applications.
• System tuning, performance monitoring, and database maintenance. Database performance improvement through design reviews, review explain plans, SQL code reviews, AWR analysis and SQL tuning using recommendations from SQL tuning advisor.
• Develop procedures, packages and scripts and tuning SQL & PL/SQL
• Managing Oracle Cloud Database as a service DBaaS Infrastructure
• Designed, Architected and implemented projects to migrate services from on-premises servers to Oracle Cloud
• Configuring and managing bare metal and virtual machine oracle database services on Oracle’s Cloud Infrastructure - OCI-Classic and OCI
• Upgrading and Migrating oracle databases from on-premise infrastructure to Oracle cloud infrastructure (OCI)
• Provisioning databases using Oracle Cloud API’s
• Ensuring Maximum Availability Architecture by implementing redundancy across Oracle Cloud Availability Domains (AD’s)
• Configuring database backups to Oracle’s Cloud Object Storage