Sr. Database Administrator

TEKsystems•Harrisburg, PA

5d•$40 - $65•Hybrid

About The Position

A PostgreSQL DevOps DBA plays a critical role in modern IT organizations that rely on PostgreSQL as their primary database management system. This position leads the design, implementation, maintenance and support of database environments. This role includes the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements for the most complex projects, working independently. This position requires the necessary skills to coordinate and support other database administrators as database administrators are expected to mentor, coach, and train team members. We are not asking a DBA to directly support Kubernetes. Rather looking for someone familiar with supporting PGSQL in a containerized environment. PRIMARY DUTIES AND RESPONSIBILITIES Database design and architecture • Manage PostgreSQL database design and architecture, infrastructure management, high availability (HA) assurance, security, performance monitoring and alerting and the performance of routine maintenance tasks including performance tuning, backup, and recovery. • Understanding of the application's data storage requirements and the business logic involved. • Design and create database schemas and tables, configuring indices and other database objects to optimize query performance. • Full understanding of architecture and performance to recommend deployment options for Aurora (AWS PostgreSQL) and/or open PostgreSQL on both AWS and on-premises. • Ability to deploy and maintain database using containerization tools such as Terraform and Kubernetes. • Ensure the database is designed for scalability and maintainability, considering future growth and data retention needs. Knowledge of database configuration requirements for both AWS and on-premises installations.

Requirements

PostgreSQL Database Administration Experience
Installation management
Upgrading/Patching
Setup and Configuration
Backup and restore for both daily use and/or disaster recovery (both annual testing and disaster preparedness)
Data export, load processing, and transformations (ETL)
PostgreSQL extensions familiarity
High Availability, Load Balancing, and Replication
Monitoring, reporting, and alert configurations
Advance shell scripting skills
Extensive familiarity with PostgreSQL database and schema objects
Extensive familiarity with AWS RDS/S3/EC2/Aurora PostgreSQL.
Understand access controls, encryption, and other security measures to protect the data.
Authentication Configuration - LDAP configuration and implementation, local account maintenance
Ability to identify and resolve performance issues by monitoring database performance metrics and analyzing query performance.
Optimizing queries and indexes, tuning memory settings, and identifying and addressing performance bottlenecks.
Automation of backups, monitoring, and patching using tools like: Unix shell scripting, Windows PowerShell, Python, Ansible, and Stone Branch.
Excellent communication skills – both written and oral
Self-Starter initiative with Team-Player mentality
Experience leading a project
Problem-Solver
Basic Project Management skills – ability to create, read, append to, and follow plans
This position requires participation in a 24x7x365 on-call rotation. The frequency of the rotation depends on the number of members in the team. On-call requires carrying a cellphone and responding to calls within the agreed upon timeframe set within PHEAA’s standards. Internet connectivity from home is required as part of the on-call rotation.

Nice To Haves

SQL Server Database Administration Experience (technical skills: see above list)
MongoDB Database Administration Experience (technical skills: see above list)
LUWDB2 Database Admin

Responsibilities

Manage PostgreSQL database design and architecture, infrastructure management, high availability (HA) assurance, security, performance monitoring and alerting and the performance of routine maintenance tasks including performance tuning, backup, and recovery.
Understanding of the application's data storage requirements and the business logic involved.
Design and create database schemas and tables, configuring indices and other database objects to optimize query performance.
Full understanding of architecture and performance to recommend deployment options for Aurora (AWS PostgreSQL) and/or open PostgreSQL on both AWS and on-premises.
Ability to deploy and maintain database using containerization tools such as Terraform and Kubernetes.
Ensure the database is designed for scalability and maintainability, considering future growth and data retention needs. Knowledge of database configuration requirements for both AWS and on-premises installations.