Employer Active
Not Disclosed
Salary Not Disclosed
1 Vacancy
Position : Database Administrator PostgreSQL
Location : Fort Worth Texas USA
Job Type : Contract
Required Skills/Experience:
In PostgreSQL a Database Administrator (DBA) is responsible for the installation configuration maintenance and overall management of the PostgreSQL database system. The roles and responsibilities of a PostgreSQL DBA can be categorized into several key areas:
1. **Installation and Configuration**:
Install PostgreSQL on various platforms.
Configure PostgreSQL to meet specific performance and security requirements.
Set up and manage configuration files like postgresql.conf and pghba.conf.
2. **Database Design and Development**:
Design and create databases and schemas.
Create and manage database objects such as tables indexes views and sequences.
Implement data integrity and normalization.
3. **User Management and Security**:
Create and manage database users and roles.
Define and enforce database security policies.
Manage access controls using GRANT and REVOKE statements.
Implement SSL/TLS for secure connections.
4. **Backup and Recovery**:
Develop and implement backup strategies.
Perform regular backups of databases.
Test and execute recovery procedures.
Use tools like pgdump pgrestore and pgbasebackup.
5. **Performance Tuning and Optimization**:
Monitor database performance and resource utilization.
Identify and resolve performance bottlenecks.
Optimize queries and database structures.
Use tools like EXPLAIN VACUUM and ANALYZE.
6. **Maintenance and Upgrades**:
Perform routine maintenance tasks such as vacuuming analyzing and reindexing.
Plan and execute database upgrades and patching.
Monitor and manage database replication and failover strategies.
7. **Monitoring and Troubleshooting**:
Monitor database health and respond to alerts.
Troubleshoot database issues and errors.
Use logging and monitoring tools like pgstatactivity pgstatreplication and thirdparty monitoring solutions.
8. **Data Migration and Replication**:
Plan and execute data migrations between PostgreSQL instances or from other database systems.
Set up and manage replication (e.g. streaming replication logical replication).
Ensure data consistency and availability.
9. **Compliance and Documentation**:
Ensure compliance with relevant data protection regulations.
Maintain thorough documentation of database environments procedures and configurations.
Keep track of database changes and maintain version control.
10. **Automation and Scripting**:
Automate routine DBA tasks using scripts and tools.
Develop and maintain custom scripts for specific DBA tasks.
Use tools like cron jobs for scheduled tasks.
A PostgreSQL DBA needs to have a solid understanding of SQL database design principles and system administration skills as well as familiarity with the specific features and tools provided by PostgreSQL.
SQL , POSTGRESQL , DATABASE DESIGN
Full Time