Database Administrator (PostgreSQL / SQL Server)
Job Summary:
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).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.