Mindteck · 1 day ago
Sr PostgreSQL Database
Harrisburg, PA
Full-time
Onsite
Senior LevelMindteck is a company that values strong relationships and diverse talent. They are seeking a Senior PostgreSQL Database professional to lead the design, implementation, maintenance, and support of PostgreSQL database environments, ensuring optimal performance and scalability while mentoring junior team members.
Information Technology
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, replication, 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 PGSQL databases using containerization tools such as Terraform, Ansible, Rancher, 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
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
Advanced 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
Qualification
Required
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, replication, 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 PGSQL databases using containerization tools such as Terraform, Ansible, Rancher, 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
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
Advanced 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
Preferred
SQL Server Database Administration Experience (technical skills: see above list)
MongoDB Database Administration Experience (technical skills: see above list)
LUWDB2 Database Administration Experience (technical skills: see above list)
Familiarity with RHEL and Windows Server OS's
Familiarity with Jira
Familiarity with ITIL Service Management Change Processes
Familiarity with Grafana
Familiarity with monitoring tools like Nagios, Zabbix, Prometheus, and Grafana to detect and report potential issues
Company
Mindteck
Mindteck is a global technology company devoted to delivering knowledge that matters to help clients compete, innovate and propel forward.
Founded in 1991
1001-5000 employees
H1B Sponsorship
Mindteck has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (3)
2023 (21)
2022 (6)
2021 (15)
2020 (32)
Funding
Current Stage
Late StageRecent News
2025-06-13
2025-06-13
2025-06-12
Company data provided by crunchbase