About Us:

At apexanalytix, we’re lifelong innovators! Since the date of our founding nearly four decades ago we’ve been consistently growing, profitable, and delivering the best procure-to-pay solutions to the world.   We’re the perfect balance of established company and start-up.  You will find a unique home here. 

And you’ll recognize the names of our clients. Most of them are on The Global 2000. They trust us to give them the latest in controls, audit and analytics software every day.  Industry analysts consistently rank us as a top supplier management solution, and you’ll be helping build that reputation.

Read more about apexanalytix - https://www.apexanalytix.com/about/

Job Details

The Role

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 - 

Education:

·        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.

(Mention the required skills in bullet points)

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.