Mid-Level Postgres DBA - Hybrid

Description

We are looking for a committed and driven Mid-Level Database Administrator (Mid. DBA) with a broad understanding of Postgres DBA function and skills.

Team members are expected to demonstrate technical proficiency as well as strong communication and collaboration abilities. The Mid-Level DBA will contribute directly to operational processes and will be empowered to proactively drive best practices and changes at the program and organizational level. Candidates should demonstrate knowledge and understanding of Postgres and Oracle database technologies, frameworks, and concepts along with excellent communications skills and a desire to learn and grow.

The Database Administration Team is responsible for securing the database systems by supporting existing controls and processes and through leading efforts to continually improve security across multiple dimensions and domains and enterprise systems. The Mid. DBA will support operational database management processes. We expect the DBA to work effectively with internal stakeholders, including the information security team, leadership, developers, system operations and network administrators, and with external vendors including Cloud Service Providers and databases vendors.

The DBA 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:

• Serve as a key escalation point within the database administration team, providing guidance for effective resolution.


• Directly triage and respond to databases alerts, database capacity and performance reports, and end-user requests on a regular basis.


• Identify and resolve issues in client database related controls, systems, and applications.


• Support maintenance and troubleshooting activities for the Database Administration program.


• Support database vulnerability management processes, such as database patching, database security scanning vulnerability assessment, prevention and remediation efforts.

Database Systems Availability and Reliability:

• Monitor database status activity daily to make sure that database is up running and is working properly.


• Support database server Linux patching activities on database server monthly to keep server secured and minimize the risk of malicious impact.


• Manage and Maintain 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.


• Configure and validate Oracle database backup, exports and snapshots every day to make sure they are working properly.


• Maintain and update SOPs for Database disaster recovery. Perform periodic review and testing for database recovery processes.


• Follow DBA Protocol and procedures to promptly address any database system issues. Ensure client adapts to the changing database security landscape, making informed recommendations and decisions to database systems configurations, security controls.


• Automate controls and processes where possible.

Compliance:

• 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.


• Follow best practice to maintain and monitor classic oracle database DBA privilege users.


• Follow best practice to grant proper permission when creating database users.


• Maintain classic Oracle database storage to ensure it is good stewards and saving cost by using proper storage type.


• Monitor the classic Oracle database space usage daily to make sure it has proper available space for the database to reduce space usage cost.


• Ensure all database related audits information is collected in a timely manner.