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 :

• Participate in application development projects and be responsible for the database modeling, database design, data profiling, and data querying.
• Develop procedures, functions, packages, triggers, collections, indexes, constraints, views, sequences, optimized queries using joins and subqueries in support of application development.
• Responsible for Tune and optimize database objects
• Responsible for the monitoring, uptime of all production databases and manage data security and privacy.
• Responsible for regular databases maintenance activities (e.g., Vacuum, Re-indexing, Archiving, Monitoring, alerting, and error analysis on logs).
• Responsible for regular backups and recovery of databases, includes PITR (Point in time recovery) based on the requirement.
• Responsible for Configuring replication setup between Production and DR sites.
• Responsible for applying patches (version upgrades) to PostgreSQL.
• Participate in a 24×7 support and perform other duties as assigned.
• Responsible for performing database migrations across environments.
• Hands-on experience with Barman backups, WAL archiving, and restores.
• Responsible for capacity planning and managing tablespaces / storage.
• Participate in implementing and maintaining high availability solutions.
• Responsible for configuring monitoring and alerts for database health.
• Hands-on experience with documenting SOPs, backup, and DR procedures.
• Participate in coordinating with IT / app teams for incidents and changes.
• Responsible for staying updated on PostgreSQL best practices and security.

EXPERIENCE AND SKILLS REQUIRED :

DESIRABLE SKILLS :