Database Administrator

1 week ago

Fort Worth, TX, United States Omni Inclusive Full time
9-12 years Overall
Joining: Immediate

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.

  • Database Administrator

    2 weeks ago

    Fort Worth, TX, United States Omni Inclusive Full time

    Cassandra NoSQL DBA Mandatory Skills Looking for a Database Administrator (DBA) contractor for staff augmentation purposes to help manage its NoSQL database environment. The position will be responsible for defining, implementing and maintaining physical Cassandra databases for the enterprise. Candidate should possess extensive knowledge of all aspects of...

  • Database Administrator

    6 days ago

    Fort Worth, TX, United States Omni Inclusive Full time

    Cassandra NoSQL DBA Mandatory Skills Looking for a Database Administrator (DBA) contractor for staff augmentation purposes to help manage its NoSQL database environment. The position will be responsible for defining, implementing and maintaining physical Cassandra databases for the enterprise. Candidate should possess extensive knowledge of all aspects of...

  • Database Adminstrator

    2 days ago

    Fort Worth, TX, United States Collabera Full time

    Description Home Search Jobs Job Description Database Adminstrator Contract: Fort Worth, Texas, US Salary Range: 40.00 - 45.00 | Per Hour Job Code: 366231 End Date: 2026-01-07 Days Left: 29 days, 2 hours left Apply Position Title: Database Administrator/SQL Data Analyst # of Openings: 1 Interview Process: 1 round onsite. 1 hour long Location: Fort...

  • Donor Database Coordinator

    2 weeks ago

    Fort Worth, TX, United States Sky Ranch Full time

    Responsive recruiter Replies within 24 hours Benefits: Dental insurance Health insurance Paid time off Vision insurance This position is critical to the ministry of Sky Ranch and contributes directly to our mission of leading youth and families to know and follow ChristThe Database Coordinator will play an important role in advancing the mission by...

  • Donor Database Coordinator

    2 weeks ago

    Fort Worth, TX, United States Sky Ranch Full time

    Responsive recruiter Replies within 24 hours Benefits: Dental insurance Health insurance Paid time off Vision insurance This position is critical to the ministry of Sky Ranch and contributes directly to our mission of leading youth and families to know and follow ChristThe Database Coordinator will play an important role in advancing the mission by...

  • Donor Database Coordinator

    2 days ago

    Fort Worth, TX, United States Sky Ranch Full time

    Responsive recruiter Benefits: Dental insurance Health insurance Paid time off Vision insurance This position is critical to the ministry of Sky Ranch and contributes directly to our mission of leading youth and families to know and follow ChristThe Database Coordinator will play an important role in advancing the mission by serving as an expert and...

  • Donor Database Coordinator

    2 weeks ago

    Fort Worth, TX, United States Sky Ranch Full time

    Responsive recruiter Replies within 24 hours Benefits: Dental insurance Health insurance Paid time off Vision insurance This position is critical to the ministry of Sky Ranch and contributes directly to our mission of leading youth and families to know and follow ChristThe Database Coordinator will play an important role in advancing the mission by...

  • Systems Administrator/Engineer

    6 days ago

    Fort Worth, TX, United States Pivotal Solutions Inc Full time

    Job Description Position Summary and Responsibilities: This position is for a Systems Administrator/Engineer responsible for the life cycle management of infrastructure platforms including cloud and on-prem technologies with both virtual and physical servers, Microsoft SQL databases, ETL services, some middleware services, backup services, and monitoring...

  • ALIS System Administrator

    1 week ago

    Fort Worth, TX, United States Texas Staffing Full time

    Summer 2025 ALIS System Administrator Intern By bringing together people that use their passion for purposeful innovation, at Lockheed Martin we keep people safe and solve the world's most complex challenges. Our people are some of the greatest minds in the industry and truly make Lockheed Martin a great place to work. With our employees as our priority, we...

  • ALIS System Administrator

    1 week ago

    Fort Worth, TX, United States Texas Staffing Full time

    Summer 2025 ALIS System Administrator Intern By bringing together people that use their passion for purposeful innovation, at Lockheed Martin we keep people safe and solve the world's most complex challenges. Our people are some of the greatest minds in the industry and truly make Lockheed Martin a great place to work. With our employees as our priority, we...