SQL Database Administrator

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