| PostgreSQL DBA || Fort Worth, TX (Onsite) at Worth, Illinois, USA |
| Email: ayush@applabsystems.com |
|
From: Ayush Sharma, AppLab Systems, Inc. ayush@applabsystems.com Reply to: ayush@applabsystems.com Hello, Greetings for Applab Systems, Inc. Please find the detail job description below Job Title: PostgreSQL DBA Job Location: Fort Worth, TX (Onsite) Job Duration: Long Term Contract Job Description: 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 `pg_hba.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 `pg_dump`, `pg_restore`, and `pg_basebackup`. 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 `pg_stat_activity`, `pg_stat_replication`, and third-party 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. Keywords: Texas PostgreSQL DBA || Fort Worth, TX (Onsite) ayush@applabsystems.com https://jobs.nvoids.com/job_details.jsp?id=1426267 |
| ayush@applabsystems.com View All |
| 09:49 PM 24-May-24 |