Database Administrator (PostgreSQL SQL Server)

Richfield, MN - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Project Overview

Our client is seeking a Database Administrator (PostgreSQL / SQL Server) who can hit the ground running and take ownership of database administration across multiple environments.
This role is open as contract-to-perm for the right candidate who demonstrates strong technical ability initiative and reliability. The client is not looking for a Senior DBA-rather someone experienced hands-on and capable of managing day-to-day DBA operations effectively.

Key Responsibilities

Install configure and maintain PostgreSQL databases across development testing and production environments.
Set up and manage streaming or logical replication failover and disaster recovery mechanisms.
Design and implement backup and recovery strategies using pgdump pgbasebackup and/or pgBackRest.
Manage role-based access control and security for users and applications.
Partition and maintain large datasets efficiently for performance and scalability.
Monitor and analyze PostgreSQL logs to identify and resolve issues such as slow queries deadlocks or system errors.
Diagnose and troubleshoot system-level performance issues including memory and disk I/O bottlenecks.
Automate routine DBA tasks using Bash Python or Perl scripts.
Work in Linux (RHEL) environments for system management and troubleshooting.
Collaborate with application and infrastructure teams to ensure database reliability and optimal performance.

Required Technical Skills

Strong proficiency in PostgreSQL administration including installation configuration and tuning
Experience with streaming/logical replication failover and high availability
Proficiency in backup/recovery strategies and point-in-time recovery (PITR)
Solid understanding of role-based access control and user management
Experience managing large datasets including table partitioning
Strong scripting skills (Bash Python or Perl) for automation
Ability to analyze logs troubleshoot errors and optimize database performance
Hands-on experience in Linux (RHEL) environments

Project Overview Our client is seeking a Database Administrator (PostgreSQL / SQL Server) who can hit the ground running and take ownership of database administration across multiple environments. This role is open as contract-to-perm for the right candidate who demonstrates strong technical ability...

Project Overview

Key Responsibilities

Install configure and maintain PostgreSQL databases across development testing and production environments.
Set up and manage streaming or logical replication failover and disaster recovery mechanisms.
Design and implement backup and recovery strategies using pgdump pgbasebackup and/or pgBackRest.
Manage role-based access control and security for users and applications.
Partition and maintain large datasets efficiently for performance and scalability.
Monitor and analyze PostgreSQL logs to identify and resolve issues such as slow queries deadlocks or system errors.
Diagnose and troubleshoot system-level performance issues including memory and disk I/O bottlenecks.
Automate routine DBA tasks using Bash Python or Perl scripts.
Work in Linux (RHEL) environments for system management and troubleshooting.
Collaborate with application and infrastructure teams to ensure database reliability and optimal performance.

Required Technical Skills

Strong proficiency in PostgreSQL administration including installation configuration and tuning
Experience with streaming/logical replication failover and high availability
Proficiency in backup/recovery strategies and point-in-time recovery (PITR)
Solid understanding of role-based access control and user management
Experience managing large datasets including table partitioning
Strong scripting skills (Bash Python or Perl) for automation
Ability to analyze logs troubleshoot errors and optimize database performance
Hands-on experience in Linux (RHEL) environments