Senior Oracle PostgreSQL Database Administrator

Published: 6/14/2022

Technology

Job Description

The candidate must have solid experience with Oracle (11g/19c), and PostgreSQL (12+), expertise in cloud environments (AWS RDS/Aurora). The candidate will occasionally handle Oracle Prod issues afterhours and carry the Oracle Duty Phone on a rotational basis. They should have experience of migrating databases (+Terabytes) from on-prem to cloud and hands-on production experience.

Responsibilities:

Take ownership the data model:
Ensure model changes make it into production with known impact to system performance
Work with the Analytics team to create a data model allowing for a holistic view of the customer, identification of gaps, and working with the development teams to fill those gaps in the data
Ensure a complete model is captured and visualized, including definitions, into consumable subject areas and work to define the tables and attributes
Publish and socialize the data model across development and business groups
Increase security around data, including roles and privileges, and treatment of PII and PCI data
Ensure data quality through a combination of traditional relational integrity checks as well as reconcilement between systems
Create a strategy where test systems have representative production level data for good performance and variety checks
Evangelize data practices and standards through tech-talks, group discussions, and 1-1 conversations
Create source of truth among different database technologies, and work to reduce data redundancy
Look at platform monitoring and alerting and ensure proper statistics are being created for optimal performance and uptime
Create standardized platforms across all data technologies including Streaming, OLTP and Analytics

Qualifications:

Strong experience in modeling transaction (OLTP) and decision support systems (dimensional/star schema/columnar); understanding of streaming technologies and how it can be leveraged for business and technical advantages
Experience supporting a business from the data perspective with a strong business understanding
MS in Computer Science preferred or equivalent experience
Experience as a DBA and/or Data Architect.
Willingness to work in multiple roles including a data architect, DBA, data analyst, and coach
Advocate for when to perform ETL vs ELT
Keep current on latest technologies and ability to provide an assessment of different platforms and provide a recommendation.
Experience in redesigning monolithic databases to more manageable databases and help application teams re architect the applications.
10 to 15 years’ experience as an oracle administrator or architect with 5 plus years as an oracle Exadata administrator.
Integrate technical functionality (eg. Scalability, security, performance, data recovery, reliability, etc)