SQL Database Administrator

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

**Job Details**:
**The Role**

**Quick Take -**

**The Work -**

**Database Implementation and Support**
- Assist in the installation, configuration, and maintenance of PostgreSQL databases.
- 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)**

**Benefits**

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.