Sr. Postgres DBA - Hybrid

The Sr. Database Engineer will support operational database management processes. We expect the Sr. Database Engineer to work effectively with internal stakeholders, including the information security team, leadership, developers, system operations, network administrators, and with external vendors including Cloud Service Providers and database vendors.

The Sr. Database Engineer will also be responsible for performance monitoring and tuning. They will work collaboratively with developers, IT Infrastructure, and IT Operations to ensure the system is operating within desired specification ranges.

Essential Duties and Responsibilities:

Operational Oversight and Support:

1. Serve as a key escalation point within the database administration team, providing guidance for effective resolution.
2. Directly triage and respond to database alerts, database capacity and performance reports, and end-user requests on a regular basis.
3. Identify and resolve issues in database related controls, systems, and applications.
4. Lead and support maintenance and troubleshooting activities for the Database Administration program.
5. Lead and support database vulnerability management processes, such as database patching, database security scanning, vulnerability assessment, prevention, and remediation efforts.

Architectural Excellence and Resilience:

1. Lead and work with team members to configure database resources including but not limited to Postgres, Oracle, AWS Aurora PostgreSQL RDS, and DynamoDB, and continuously monitor and proactively prevent and correct any issues to ensure the highest availability for database systems.
2. Design and implement robust security measures on all databases applications including web applications, cloud infrastructure, and enterprise systems.
3. Use AWS CI/CD pipeline with Python and AWS CLI for database resources management and deployment to ensure predictability and consistency on all database systems.
4. Implement consistent AWS Aurora RDS Parameter groups for both cluster and instance levels.
5. Identify and implement the best practices to secure database resources and web applications against potential threats.
6. Ensure compliance with relevant regulations, standards, organizational policies, and best practices, including cloud standards and best practices.

Database Systems Availability and Reliability:

1. Monitor database status activity daily to ensure that the database is up and running and working properly.
2. Support database server Linux patching activities on the database server monthly to keep the server secured and minimize the risk of malicious impact.
3. Manage and apply Oracle Critical Patch Updates (CPU) patches each quarter and other Oracle recommended patch sets when they become available and upgrade AWS Aurora PostgreSQL databases to ensure proper security measures and address any known security risks.
4. Configure and validate Oracle and AWS database backup, exports, and snapshots every day to ensure they are working properly.
5. Maintain and update SOPs for Database disaster recovery. Perform periodic review and testing for database recovery processes.
6. Follow DBA Protocol and procedures to promptly address any database system issues. Ensure we adapt to the changing database security landscape, making informed recommendations and decisions to database systems configurations and security controls.
7. Automate controls and processes where possible.

Compliance:

1. Reach the goal of always being compliant. Collect and centrally maintain all database systems artifacts to respond to audits in a timely manner, with limited SME impact.
2. Follow best practices to maintain and monitor classic Oracle database DBA privilege users.
3. Follow best practices to maintain and monitor the AWS cloud databases to ensure the secrets storing database user information are automatically rotated every 90 days.
4. Follow best practices to grant proper permission when creating database users.
5. Maintain classic Oracle database storage to ensure it is good stewards and saves costs by using the proper storage type.
6. Monitor the classic Oracle database space usage daily to ensure it has proper available space for the database to reduce space usage cost.
7. Ensure all database related audits information is collected in a timely manner.
8. Choose proper resource type and size when provisioning AWS RDS database related resources to reduce expenses.

Cloud Systems Design and Management:

1. Design and implement AWS Cloud database systems to ensure failover and monitor capabilities are in place for the high availability of database resources.
2. Design and support the DMS tasks of migrating data from classic Oracle databases to Aurora Postgres clusters and S3 buckets.
3. Follow best practices to design and create database resources using CDK and CI/CD pipelines.
4. Create, maintain, and implement Aurora Postgres Database clone from one environment to multiple environments.
5. Continue implementing, improving, and securing database systems to enhance users’ management and monitoring of resources.
6. Work with project teams to plan, architect design, implementation, setting, and enforce database standards on AWS Cloud systems environment including Aurora PostgreSQL, AWS DynamoDB, and AWS Glue/Athena.

Requirements

Qualified candidates will have 10+ years’ experience in enterprise database management, including Postgres, Oracle, and AWS Cloud platform, Identity and Access Management (IAM), Cloud Watch, Performance Insights, and PostgreSQL query management is desirable.