PostgreSQL DBA (Database Administrator)

Job Description: 

PostgreSQL DBA (Database Administrator) is responsible for managing and maintaining PostgreSQL databases to ensure performance, security, and data integrity. 

Key Roles and Responsibilities: 

Installation and Configuration: Install, configure, and upgrade PostgreSQL databases. 

Database Design: Design and implement database schema, indexes, and constraints. 

Performance Tuning: Monitor and optimize database performance, queries, and indexing. 

Backup and Recovery: Develop and implement backup and recovery strategies. 

Security: Implement security measures, manage user access, and monitor database activity. 

Troubleshooting: Identify and resolve database issues, errors, and conflicts. 

Maintenance: Perform routine maintenance tasks, such as updating statistics and vacuuming. 

Replication and High Availability: Set up and manage replication, failover, and high-availability solutions. 

Monitoring and Alerting: Monitor database performance, set up alerts, and notify teams of issues. 

Documentation: Maintain documentation on database design, configuration, and procedures. 

Collaboration: Work with development teams to optimize database usage and resolve issues. 

Staying Up-to-Date: Keep current with PostgreSQL features, best practices, and new releases. By fulfilling these roles and responsibilities, a PostgreSQL DBA ensures the reliability, efficiency, and security of PostgreSQL databases. 

Work with business customers gathering requirements and provided analysis, and programming support on integration of these customer requirements into existing software.  

Working on new Unix Shell Scripts for batch processing jobs.  

Working & writing PL/SQL scripts. Working & writing Wrote Perl scripts to analyse the logs.  

Writing SQL scripts for Data clean up. Involve in Code Review and Test Cases Review.  

Provide technical support for the project.  

Knowledge in Mulesoft integration is plus 

Skill set needed: 

SQL and PostgreSQL fundamentals: SQL syntax and querying - PostgreSQL data types, tables, indexes, and constraints - Understanding of PostgreSQL architecture and internals 

Database design and modeling: - Data modeling concepts (entity-relationship diagrams, normalization) - Database schema design and optimization 

Performance tuning and optimization: - Query optimization techniques - Indexing strategies - Understanding of execution plans and query analysis 

Backup and recovery: - Backup and recovery concepts (full, incremental, differential) - Understanding of PostgreSQL backup tools (pg_dump, pg_basebackup) 

Security and access control: - User management and authentication - Role-based access control (RBAC) - Understanding of PostgreSQL security features (SSL, encryption) 

Replication and high availability: - Understanding of replication concepts (master-slave, multi-master) - Setting up and managing replication - High-availability solutions (failover, load balancing) 

Monitoring and troubleshooting: - Understanding of PostgreSQL logs and monitoring tools (pg_stat_statements) - Troubleshooting techniques for performance, connectivity, and data issues 

Scripting and automation: - Familiarity with scripting languages (Bash, Python, Perl) - Automating tasks using cron jobs, scripts, and tools (pg_agent) 

Top Qualifications: 

SQL and PostgreSQL 

Scripting (Shell, Perl) 

DevOps, DB Design & Modelling