PostgreSQL DBA
Prophecy Technologies, Minneapolis, MN, United States
Role Overview:
Build, configure, and maintain PostgreSQL and MS SQL Databases in development, testing, and production environments.
Key Responsibilities: Perform database upgrades, patches, and migrations. Manage database users, roles, and permissions. Monitor database performance and implement tuning improvements. Optimize SQL queries, indexes, and database configurations. Analyze execution plans and resolve bottlenecks. Required Skills:
Experience with cloud-managed databases (AWS RDS, Aurora Postgres RDS, EC2) Knowledge of scripting languages (Bash, Python, PowerShell) Experience with monitoring tools (Prometheus, Grafana, dynatrace) Experience with GitHub, terraform, Ansible, Jenkins Relevant certifications (PostgreSQL, Microsoft) Qualifications:
8-10+ years experience required Preferred Skills:
Installation & Configuration Database Performance Tuning High Availability & Disaster Recovery DB maintenance Data Security & Compliance Automation & Scripting Problem Solving & Analytical Thinking Strong Communication & Collaboration Skills
Build, configure, and maintain PostgreSQL and MS SQL Databases in development, testing, and production environments.
Key Responsibilities: Perform database upgrades, patches, and migrations. Manage database users, roles, and permissions. Monitor database performance and implement tuning improvements. Optimize SQL queries, indexes, and database configurations. Analyze execution plans and resolve bottlenecks. Required Skills:
Experience with cloud-managed databases (AWS RDS, Aurora Postgres RDS, EC2) Knowledge of scripting languages (Bash, Python, PowerShell) Experience with monitoring tools (Prometheus, Grafana, dynatrace) Experience with GitHub, terraform, Ansible, Jenkins Relevant certifications (PostgreSQL, Microsoft) Qualifications:
8-10+ years experience required Preferred Skills:
Installation & Configuration Database Performance Tuning High Availability & Disaster Recovery DB maintenance Data Security & Compliance Automation & Scripting Problem Solving & Analytical Thinking Strong Communication & Collaboration Skills