Talent.com
Database Administrator - PostgreSQL
Database Administrator - PostgreSQLTechDigital Group • Fort Worth, TX, United States
[error_messages.no_longer_accepting]
Database Administrator - PostgreSQL

Database Administrator - PostgreSQL

TechDigital Group • Fort Worth, TX, United States
[job_card.30_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

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 :

  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

    #J-18808-Ljbffr

    [job_alerts.create_a_job]

    Database Administrator • Fort Worth, TX, United States

    [internal_linking.related_jobs]
    Sr. Data Analyst and Coffee Procurement Support

    Sr. Data Analyst and Coffee Procurement Support

    Treehouse Foods • Northlake, TX, United States of America
    [job_card.full_time]
    Data Analyst and Coffee Procurement Support.TreeHouse Foods (NYSE : THS) is a leading manufacturer of private label packaged foods and beverages, operating a network of over 20 production facilities...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Desktop Engineer W / Tanium

    Desktop Engineer W / Tanium

    TEKsystems • Fort Worth, TX, United States
    [job_card.full_time]
    Senior Desktop Systems Engineer accountable for Office 365 endpoint client design and build.The resource is responsible for the Office Professional Plus client design, build process, packaging meth...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Escrow Assistant

    Escrow Assistant

    Solugenix Corp • Westlake, TX, US
    [job_card.temporary]
    Escrow Assistant Westlake, TX (Remote) 3-Month Contract Job ID 25-09861 Solugenix is assisting a client, a leading financial services company, in their search for an Escrow Assistant.This is a 3-mo...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Principal Java / Kafka Developer

    Principal Java / Kafka Developer

    Dexian - DISYS • Roanoke, TX, US
    [job_card.full_time]
    Bachelor's degree in computer science or engineering.Java, Spring Boot, Oracle in a fast-paced Agile environment.Develop and expose RESTful APIs to integrate with frontend systems.Build and integra...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Remote Database Administrators - AI Trainer ($75-$100 per hour)

    Remote Database Administrators - AI Trainer ($75-$100 per hour)

    Mercor • Keller, Texas, US
    [filters.remote]
    [job_card.temporary]
    Role Overview • • Mercor is collaborating with a leading AI organization to identify experienced Database Administrators for a high-priority training and evaluation project.Freelancers will be tasked...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Cloud Engineer – Hybrid Cloud Infrastructure (Azure Focus)

    Cloud Engineer – Hybrid Cloud Infrastructure (Azure Focus)

    Jobot • Fort Worth, TX, US
    [job_card.full_time]
    This Jobot Job is hosted by : Robert Donohue.Are you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume. Salary : $115,000 - $130,000 per year.We are a highly respecte...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Bookkeeper (Remote Position – Entry-Level or Experienced)

    Bookkeeper (Remote Position – Entry-Level or Experienced)

    GOLD GATE • Keller, Texas
    [filters.remote]
    [job_card.full_time] +1
    [filters_job_card.quick_apply]
    Bookkeeper (Remote Position – Entry-Level or Experienced).Part-Time : $20–$28 per hour.Full-Time : $25–$35 per hour.We are seeking a reliable and detail-oriented Remote Bookkeeper t...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Database Administrator

    Database Administrator

    TradeJobsWorkForce • 76177 Fort Worth, TX, US
    [job_card.full_time]
    Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Systems Administrator - Blue Mound

    Systems Administrator - Blue Mound

    Carvana • Fort Worth, Texas
    [job_card.full_time]
    [filters_job_card.quick_apply]
    About Carvana At Carvana, we’re changing the way people buy and sell cars.With an ambitious vision and a fundamentally different approach designed to be fun, fast,...[show_more]
    [last_updated.last_updated_variable_days]
    Cloud Engineer

    Cloud Engineer

    Jobot • Fort Worth, TX, US
    [job_card.full_time]
    This Jobot Job is hosted by : Christian Aviles.Are you a fit? Easy Apply now by clicking the "Apply Now" buttonand sending us your resume. Salary : $115,000 - $130,000 per year.Employee owne...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    TeamCenter Admin

    TeamCenter Admin

    Axis Technologies • Hurst, TX, US
    [job_card.permanent]
    The Teamcenter Administrator is responsible for managing, configuring, and maintaining Siemens Teamcenter PLM environments. This role ensures system stability, data integrity, and smooth integration...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    PL / SQL Developer (Roanoke)

    PL / SQL Developer (Roanoke)

    Mastech Digital • Roanoke, TX, US
    [job_card.part_time]
    Bachelors in Computer Science or related field with.OOP, data movement / transformation).Git, Jenkins, CI / CD automation.[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior SQL / Python Report Developer

    Senior SQL / Python Report Developer

    Axxum Technologies • Haltom City, TX, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Senior SQL / Python Report Developer Location : .SQL / Python Report Developer focuses on designing, developing, and maintaining data-driven reports using SQL and Python. This role involves crafting ...[show_more]
    [last_updated.last_updated_30]
    ObGyn

    ObGyn

    KPG Provider Services • Fort Worth, Texas, US
    [job_card.full_time]
    ObGyn physician employment in Texas : TBD .ElementsByTagName("script")[0]; first.Before(script, first);}; reb2b.Board Certified or Board Eligible Medical Doctor with or w / o US residency wit...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Senior Data Engineer (Python, SQL, AWS)

    Senior Data Engineer (Python, SQL, AWS)

    Capital One • Fort Worth, TX, US
    [job_card.full_time] +1
    Senior Data Engineer (Python, SQL, AWS) Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and it...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Senior Data Engineer - Data Ops

    Senior Data Engineer - Data Ops

    Pluralsight, LLC • Westlake, TX, United States
    [job_card.full_time]
    At Pluralsight, we are an established team of data practitioners supporting our Pluralsight platform as well as decision makers across the company. We use data to improve outcomes for our colleagues...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel CT Tech - $2,471 per week in Cleburne, TX

    Travel CT Tech - $2,471 per week in Cleburne, TX

    Medical Solutions • Cleburne, TX, US
    [job_card.full_time]
    A facility in Cleburne, TX is seeking its next amazing CT Technologist (Computed Tomography).Read on if this sounds like your perfect fit!. Nurses and allied healthcare professionals are in high dem...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Travel Board Certified Behavioral Analyst - School (BCBA) in Cleburne, TX

    Travel Board Certified Behavioral Analyst - School (BCBA) in Cleburne, TX

    AlliedTravelCareers • Cleburne, TX, US
    [job_card.full_time]
    AlliedTravelCareers is working with Aequor to find a qualified BCBA - School in Cleburne, Texas, 76033!.Aequor is now hiring a full-time Board Certified Behavior Analyst (BCBA) for the 2023-2024 sc...[show_more]
    [last_updated.last_updated_30] • [promoted]