Description
You will manage and optimize complex database environments across Oracle and PostgreSQL ecosystems.
Responsibilities
- Design and implement business solutions for DBMS internals, backup and recovery, performance monitoring, and tuning.
- Lead database structure migrations and coordinate infrastructure maintenance, including reorganizations and restructures.
- Ensure data access efficiency by analyzing transaction access paths with application developers.
- Manage high availability systems using Oracle standby, Always On SQL Server, and Amazon Aurora Global databases.
- Direct and mentor teams of infrastructure and application DBA staff to resolve technical challenges.
- Secure company information through database monitoring and strict compliance with security and audit standards.
- Participate in on-call and overnight production support and problem resolution.
Required Skills
- 15+ years of progressively responsible system administration and DBMS experience.
- Expertise in administering Oracle 19c, PostgreSQL, Aurora PostgreSQL, and SQL Server in AWS.
- Proficiency with AWS services including EC2, RDS, Redshift, SCT, DMS, S3, SNS, EBS, and Lambda.
- Strong AWS coding skills for delivering Infrastructure as Code solutions.
- Hands-on experience with Ansible, Jenkins, Git, and Elastic DRS.
- Extensive knowledge of physical database design, client/server applications, and data warehousing.
- Experience managing NoSQL databases.
- Bachelor's degree.
Preferred Skills
- Experience with Oracle to PostgreSQL migrations.