Current jobs related to PostgreSQL DBA - Fort Worth, Texas - Cynet Systems
-
Geographic Information Systems Analyst
6 days ago
fort worth, United States Insight Global Full timeDescription: IT – Technician/DBA & GIS AnalystWe need help analyzing spatial data, creating maps, to help us maintain the database and IT infrastructure. GIS Analysis:·Analyze spatial data to support decision-making processes.·Create and maintain GIS maps, layers, and geodatabases.·Conduct spatial analyses and modeling to identify trends and...
-
Geographic Information Systems Analyst
2 weeks ago
Fort Worth, United States Insight Global Full timeDescription: IT – Technician/DBA & GIS AnalystWe need help analyzing spatial data, creating maps, to help us maintain the database and IT infrastructure. GIS Analysis:·Analyze spatial data to support decision-making processes.·Create and maintain GIS maps, layers, and geodatabases.·Conduct spatial analyses and modeling to identify trends and...
-
Geographic Information Systems Analyst
2 weeks ago
Fort Worth, United States Insight Global Full timeDescription: IT – Technician/DBA & GIS AnalystWe need help analyzing spatial data, creating maps, to help us maintain the database and IT infrastructure. GIS Analysis:·Analyze spatial data to support decision-making processes.·Create and maintain GIS maps, layers, and geodatabases.·Conduct spatial analyses and modeling to identify trends and...
-
Geographic Information Systems Analyst
2 weeks ago
Fort Worth, United States Insight Global Full timeJob Title: GIS Analyst & DBALocation: Fort Worth, TXDuration: 6 month contract, potential to go permanentlyQualifications:Bachelor’s degree in Geography, Computer Science, Information Technology, or a related field.Proven experience in GIS software (e.g., ArcGIS, QGIS), database management systems (e.g., SQL Server, PostgreSQL), and IT support.Strong...
-
Database Systems Administrator
5 days ago
Fort Meade, Maryland, United States DarkStar Intelligence LLC Full timeJob Title: Database AdministratorDarkStar Intelligence LLC is seeking a highly skilled Database Administrator to maintain the integrity, security, and availability of multiple databases. This role involves disaster recovery planning, performance analysis and tuning, index maintenance, and continuous monitoring of data.Key Responsibilities:Administer,...
-
Cloud Migrations Consultant, WWPS FedCiv
1 day ago
Fort Myer, VA, United States Amazon Web Services, Inc. Full timeAre you an experienced commercial or open source database platform specialist? Are you an Oracle or SQL Server Platform Specialist? Have you worked on Open source Database platforms like PostgreSQL, MySQL, MariaDB or Casandra? Have you migrated Applications from one Database Engine to another? Do you like to engage with senior leadership and determine ways...
PostgreSQL DBA
3 months ago
- 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:
- Install PostgreSQL on various platforms.
- Configure PostgreSQL to meet specific performance and security requirements.
- Set up and manage configuration files like `` and `
- 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 `pg_dump`, `pg_restore`, and `pg_basebackup`.
- 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 `pg_stat_activity`, `pg_stat_replication`, and third-party monitoring solutions.
- 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.
- 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 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.