INFOLOB · 2 days ago
Senior PostgreSQL DBA
Harrisburg, PA
Contract
Hybrid
Senior LevelINFOLOB is seeking a Senior PostgreSQL DBA to play a critical role in managing PostgreSQL as their primary database management system. This position involves leading the design and implementation of database environments, mentoring junior team members, and ensuring high performance and availability of the database systems.
AnalyticsBig Data
Hiring Manager
Anand Yalla
Responsibilities
Lead the design, implementation, maintenance and support of database environments
Develop and design database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements
Coordinate and support other database administrators as senior database administrators are expected to mentor, coach, and train less senior team members
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
Design and create database schemas and tables, configuring indices and other database objects to optimize query performance
Ensure the database is designed for scalability and maintainability, considering future growth and data retention needs
Identify and resolve performance issues by monitoring database performance metrics and analyzing query performance
Optimize 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
Qualification
Required
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, 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
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
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
INFOLOB
INFOLOB is a prosperous information technology consulting organization dedicated to customer satisfaction via flawless digital transformation and admirable managed services.
Founded in 2009
201-500 employees
H1B Sponsorship
INFOLOB 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
2024 (6)
2023 (37)
2022 (49)
2021 (44)
2020 (82)
Funding
Current Stage
Growth StageLeadership Team
Vijay Cherukuri
Chief Executive Officer
Yzelle Conrad De Wet
VP, Cloud Data & DevOps
Recent News
EIN Presswire
2025-04-24
Company data provided by crunchbase