Database Administrator (PostgreSQL / SQL Server)

System Soft Technologies; Farmington Hills (MI); On-site; USD 90,000 - 120,000; Full time

Job summary

System Soft Technologies is seeking an experienced Database Administrator to join the Enterprise Data team. The role centers on PostgreSQL and Microsoft SQL Server, with 3+ years of DBA experience handling installation, configuration, patching, security, performance, and capacity management across enterprise environments.

The DBAs will manage production and non-production databases, implement backup/recovery, support high availability, and automate routine tasks.

Qualifications

• 3+ years of database administration experience across production and non-production environments.
• Hands-on experience with installation, configuration, patching, and security of databases.
• Experience with backup, recovery, and disaster recovery management.
• Knowledge of high availability solutions and database reliability.
• Scripting and automation with Bash, PowerShell, Python, or Perl.
• Experience with Windows Server and/or Unix/Linux environments.
• Cloud database migration and administration experience.

Responsibilities

• Monitor and manage day-to-day operations of production and non-production database environments to ensure availability and performance.
• Perform database space management at database and OS levels to prevent capacity issues.
• Configure, monitor, and respond to automated alerts to maintain integrity and stability.
• Develop, maintain, and document DBA procedures and work instructions.
• Implement and maintain backup/recovery procedures and automated maintenance activities.
• Perform database performance tuning for OLTP and data warehouse environments.
• Manage installation, configuration, patching, upgrades, security, and capacity planning.
• Evaluate and implement new database technologies for seamless integration with enterprise systems.
• Develop, maintain, and test business continuity and disaster recovery procedures.

Skills

PostgreSQL DBA

MS SQL Server

Backup & Recovery

Performance Tuning

Scripting: Bash/PowerShell/Python

Cloud DB Migration

HA & DR

Tools

EDB PostgreSQL

SQL Server

Linux/Unix

Job description

We are seeking an experienced Database Administrator (DBA) to join our Enterprise Data team, with a strong focus on PostgreSQL and Microsoft SQL Server database platforms. The ideal candidate will have a minimum of 3 years of database administration experience and be responsible for the installation, configuration, patching, security, performance optimization, and capacity management of enterprise database systems.

The candidate should have hands-on experience managing production and non-production database environments, implementing backup and recovery strategies, supporting high availability solutions, and automating routine database administration tasks.

Responsibilities

• Monitor and manage day-to-day operations of production and non-production database environments to ensure availability, stability, and optimal performance.
• Perform database space management at both the database and operating system levels to prevent capacity-related issues and service disruptions.
• Configure, monitor, and respond to automated alerts to maintain database integrity, availability, and stability.
• Develop, maintain, and document database administration procedures, operational guidelines, and work instructions.
• Implement and maintain database monitoring processes, backup and recovery procedures, and automated routine maintenance activities.
• Perform database performance tuning and troubleshooting for OLTP and Data Warehouse environments.
• Manage database installation, configuration, patching, upgrades, security, and capacity planning.
• Evaluate, recommend, and implement new database technologies and ensure seamless integration with the enterprise technology environment.
• Develop, maintain, and test business continuity and disaster recovery procedures.

Qualifications

• Hands-on PostgreSQL Database Administration experience (EDB preferred).
• Database installation, configuration, patching, upgrades, and maintenance.
• Database performance monitoring, troubleshooting, and tuning.
• Backup, recovery, and disaster recovery management.
• High Availability (HA) and database reliability solutions.
• Scripting and automation using BASH, KSH, PowerShell, Python, or Perl.
• Experience with Microsoft Windows Server and/or Unix/Linux environments.
• Cloud database migration and administration experience.