▷ (15h Left) Database Administrator PostgreSQL

POSITION SUMMARY : We are looking for PostgreSQL database administrator, who will be working with development team, to provide technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, optimizing and efficiently managing technology using tools and scripting.

ESSENTIAL FUNCTIONS :

1. Participate in application development projects and be responsible for the database modeling, database design, data profiling, and data querying.

2. Develop procedures, functions, packages, triggers, collections, indexes, constraints, views, sequences, optimized queries using joins and subqueries in support of application development.

3. Responsible for Tune and optimize database objects

4. Responsible for the monitoring, uptime of all production databases and manage data security and privacy.

5. Responsible for regular databases maintenance activities (e.g., Vacuum, Re-indexing, Archiving, Monitoring, alerting, and error analysis on logs).

6. Responsible for regular backups and recovery of databases, includes PITR (Point in time recovery) based on the requirement.

7. Responsible for Configuring replication setup between Production and DR sites.

8. Responsible for applying patches (version upgrades) to PostgreSQL.

9. Participate in a 24×7 support and perform other duties as assigned.

10. Responsible for performing database migrations across environments.

11. Hands-on experience with Barman backups, WAL archiving, and restores.

12. Responsible for capacity planning and managing tablespaces / storage.

13. Participate in implementing and maintaining high availability solutions.

14. Responsible for configuring monitoring and alerts for database health.

15. Hands-on experience with documenting SOPs, backup, and DR procedures.

16. Participate in coordinating with IT / app teams for incidents and changes.

17. Responsible for staying updated on PostgreSQL best practices and security.

EXPERIENCE AND SKILLS REQUIRED :

1. Graduated in technical discipline or equivalent professional experience in computer science (BE / B.Tech / M.Tech / MCA / M.Sc) and a minimum of 6 years relevant experience.

2. Must have strong analytical, verbal and written communication skills.

3. Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL / SQL programming, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.

4. Must have strong knowledge of Linux, RockyOS.

5. Demonstrates ability to solve moderately complex technical problems independently.

6. Experience with application deployment by using CI / CD.

7. Experience with Docker deployment

DESIRABLE SKILLS :

1. Basic understanding on GIS, spatial database (PostGIS) and queries.

2. Knowledge on issue tracking / ticketing systems like Jira, ADO.

3. Proficient understanding of code versioning tools such as Git, SVN

4. Knowledge on scripting languages like Python, shell scripting (e.g., Bash, Perl)

5. Technical certifications.