PostgreSQL DBA (Database Administrator)

Job Summary:

Top Qualifications:

1. SQL and PostgreSQL

2. Scripting (Shell, Perl)

3. DevOps, DB Design & Modelling

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

Here are some key roles and responsibilities:

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

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

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

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

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

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

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

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

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

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

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

12. *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 for a PostgreSQL DBA:

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

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

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

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

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

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

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

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

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.