Drive design, creation, and management of large, complex Oracle databases running on Oracle 19c environments on Exadata, LINUX, AIX with features for data compression, partitioning, RAC, RMAN, Data Guard
Drive design, creation, and management of large, complex Oracle databases running on Oracle 19c environments on Aurora Postgres, Oracle RDS and Oracle EC2
Participate in design, development, and implementation of database architecture and database solutions for “Speed-to-Market” Agile projects underway
Perform advanced tuning with expertise on Oracle performance analysis tools such as ASH and AWR along with SQL Plan Baselines, SQL Profiles
Master the latest DB features and apply them to provide a measurable value on applications
Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions, and upgrades
Work to reduce complexity and cost in database environments through analysis, simplification, and automation using Ansible, Python, terraform
Manage and maintain Exadata environments with expert knowledge of Oracle Exadata architecture including Database Machines, Storage Cells, networking, and database functionality specific to Exadata
Conduct Oracle database configuration reviews, audits, and troubleshooting on version 19c for all platforms supported by Oracle.
Proficient in Data Modeling including physical and logical data modeling.
Control and monitor user access to databases and maintain database security
Manage capacity planning and forecasting for various platforms.
Facilitate databases migration from an on-prem system to the Cloud
Maintain documentation of systems and standard operating policies and procedures
Collaborate and participate in application release planning and implementation.
Provide technical assistance and mentor junior members of the team
Work with HIG onshore and offshore database partners to ensure availability, performance, quality, and Service Level Agreement specifications.
Educate and influence stakeholders to promote an understanding of the environments, increase simplification, risk management, and promote reuse and innovation