Database Administrator - PostgreSQL
Job in
Fort Worth, Tarrant County, Texas, 76102, USA
Listed on 2025-12-14
Listing for:
TechDigital Group
Full Time
position Listed on 2025-12-14
Job specializations:
-
IT/Tech
Database Administrator, Data Engineer, Systems Administrator, IT Consultant
Job Description & How to Apply Below
9-12 years Overall
Joining:
Immediate
In Postgre
SQL, a Database Administrator (DBA) is responsible for the installation, configuration, maintenance, and overall management of the Postgre
SQL database system. The roles and responsibilities of a Postgre
SQL DBA can be categorized into several key areas:
- Install Postgre
SQL on various platforms. - Configure Postgre
SQL to meet specific performance and security requirements. - Set up and manage configuration files like postgresql.conf and .conf.
- Design and create databases and schemas.
- Create and manage database objects such as tables, indexes, views, and sequences.
- Implement data integrity and normalization.
- 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.
- Develop and implement backup strategies.
- Perform regular backups of databases.
- Test and execute recovery procedures.
- Use tools like , , and .
- Monitor database performance and resource utilization.
- Identify and resolve performance bottlenecks.
- Optimize queries and database structures.
- Use tools like EXPLAIN, VACUUM, and ANALYZE.
- 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.
- Monitor database health and respond to alerts.
- Troubleshoot database issues and errors.
- Use logging and monitoring tools like _activity, _replication, and third-party monitoring solutions.
- Plan and execute data migrations between Postgre
SQL instances or from other database systems. - Set up and manage replication (e.g., streaming replication, logical replication).
- Ensure data consistency and availability.
- 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.
- 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 Postgre
SQL 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 Postgre
SQL.
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×