Database Administrator (PostgreSQL / SQL Server)

 

Position Overview: 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.

Required Technical Skills

• Hands-on PostgreSQL Database Administration experience (EDB preferred).
• Microsoft SQL Server Database Administration experience.
• 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.

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