PostgreSQL Database Administrator

Job Description

Quick Take: We are looking for a motivated and detail-oriented junior to mid-level Database Administrator (DBA) with experience or strong interest in PostgreSQL. This is an excellent opportunity for candidates early in their database career to work in a collaborative IT environment and gain exposure to real-world production systems. The role involves supporting the design, implementation, and maintenance of PostgreSQL databases while ensuring high availability, performance, and data integrity. The Work: Database Implementation and Support • Assist in the installation, configuration, and maintenance of PostgreSQL databases. • Collaborate with senior DBAs and developers to understand database structure and application needs. • Support the creation and management of database objects (schemas, tables, indexes, views, functions). • Assist in the assessment, planning, and execution of database migrations from Microsoft SQL Server to PostgreSQL. • Work with tools such as pgloader, or custom scripts to migrate schema, data, and logic. • Participate in identifying incompatibilities and rewriting T-SQL logic into PL/pgSQL High Availability & Disaster Recovery • Learn and assist with PostgreSQL replication (streaming, logical) and HA technologies. • Participate in PITR (Point-in-Time Recovery), base backup strategies, and recovery testing processes under guidance. Monitoring and Alerting • Utilize monitoring tools (e.g., pg_stat_activity, Prometheus, pgAdmin) to observe performance metrics and database health. • Raise alerts and work with senior team members to troubleshoot performance or availability issues. Capacity Planning • Track basic storage and performance trends. • Assist in gathering data for future capacity planning. Backup and Recovery Operations • Run and validate pg_basebackup, pg_dump, and pgBackRest backups. • Participate in periodic backup restore drills and understand RTO/RPO implications. Performance Tuning • Hands-on PostgreSQL query planning using EXPLAIN (ANALYZE) and auto_explain. • Assist in analyzing long-running queries and identifying missing indexes. Security and Access Control • Manage PostgreSQL roles and privileges with oversight. • Participate in periodic access reviews and implement role-based access controls (RBAC). Patching and Updates • Support patching and PostgreSQL version upgrades under supervision. • Track new PostgreSQL releases and understand feature deprecations. Incident Handling • Assist in troubleshooting database-related incidents. • Escalate complex incidents with detailed documentation. Automation and Scripting • Write basic Bash, SQL, or Python scripts to automate regular maintenance tasks (e.g., VACUUM, backups). • Contribute to automation of alerts and log parsing Documentation • Maintain up-to-date documentation for database configurations and procedures. • Contribute to standard operating procedures (SOPs). Team Collaboration • Work closely with developers, sysadmins, and support teams. • Take part in team meetings, planning sessions, and code reviews where applicable. The Must- Haves • Bachelor's degree in Computer Science, Information Technology, or a related field. Experience: • 0 to 5 years of experience working with PostgreSQL. • For freshers, Internship or project-based exposure to database management is a plus. Required Skills: • Understanding of relational database concepts and pgSQL. • Exposure to POSTGRESQL installation & configuration, security, and basic tuning. • Problem-solving and analytical skills. Communication: • Strong verbal and written communication skills. • Ability to document processes and follow standard procedures. Good to have skills, but not mandatory: • Basic understanding of Microsoft SQL Server. • Basic understanding of Kubernetes, Helm, or container orchestration. • Knowledge of scripting languages like PowerShell or Bash. • Awareness of monitoring tools like Prometheus/Grafana or pgAdmin. Over the years, we’ve discovered that the most effective and successful associates at apexanalytix are people who have a specific combination of values, skills, and behaviors that we call “The apex Way”. Read more about The apex Way - https://www.apexanalytix.com/careers/ Benefits At apexanalytix we know that our associates are the reason behind our successes. We truly value you as an associate and part of our professional family. Our goal is to offer the very best benefits possible to you and your loved ones. When it comes to benefits, whether for yourself or your family the most important aspect is choice. And we get that. apexanalytix offers competitive benefits for the countries that we serve, in addition to our BeWell@apex initiative that encourages employees’ growth in six key wellness areas: Emotional, Physical, Community, Financial, Social, and Intelligence. With resources such as a strong Mentor Program, Internal Training Portal, plus Education, Tuition, and Certification Assistance, we provide tools for our associates to grow and develop. Show more Show less