Talent.com
Database Administrator - PostgreSQL

Database Administrator - PostgreSQL

TechDigital GroupFort Worth, TX, United States
3 days ago
Job type
  • Full-time
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

    Create a job alert for this search

    Database Administrator • Fort Worth, TX, United States

    Related jobs
    • Promoted
    Senior Azure SQL Database Administrator

    Senior Azure SQL Database Administrator

    Wellfit TechnologiesIrving, TX, US
    Full-time
    Wellfit is the dental industry’s fintech solution! A healthcare fintech company that enhances experiences between patients, providers, employers, and payors. Wellfit provides access to tr...Show moreLast updated: 20 days ago
    • Promoted
    MS SQL Database Administrator

    MS SQL Database Administrator

    Orion180Irving, TX, US
    Full-time
    At Orion180, we don’t just stand out for what we do - we shine because of how we do it.By integrating cutting-edge proprietary technology, innovative solutions, and compassion for serving our...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Linux Administrator

    Linux Administrator

    TEKsystemsIrving, TX, United States
    Full-time
    MUST SIT ONSITE 3 DAYS A WEEK IN IRVING, TX.This is a global team, and this person will be required to provide shift coverage which will include weekends • • •. TEKsystems is currently looking for RHEL...Show moreLast updated: 22 hours ago
    • Promoted
    Lead Database Administrator

    Lead Database Administrator

    defi AUTO LLCRoanoke, TX, US
    Full-time
    It’s an exciting time to join defi!.SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive a...Show moreLast updated: 30+ days ago
    • Promoted
    Mainframe Database Administrator

    Mainframe Database Administrator

    ArtechIrving, TX, United States
    Full-time
    Mainframe Database Administrator.Location Irving TX, Hopkins MN, Atlanta GA, Charlotte NC.We are seeking a skilled professional to join our team as a Mainframe Database Administrator.This role invo...Show moreLast updated: 3 days ago
    • Promoted
    Senior Oracle PL / SQL Developer

    Senior Oracle PL / SQL Developer

    Macpower Digital Assets EdgeIrving, TX, United States
    Full-time
    Senior Oracle Developer you will perform advanced analysis involving supporting, improving, and enhancing the database and reports for a large project. This position requires strong SQL, PL / SQL, and...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Senior ServiceNow Administrator

    Senior ServiceNow Administrator

    CHRISTUS HealthIrving, TX, US
    Full-time
    Description Summary : The System Administrator Senior is responsible for technical leadership in support of core network services, such as email, anti-virus, application deployment, data delivery, s...Show moreLast updated: 18 hours ago
    • Promoted
    Oracle Pl / SQL Developer

    Oracle Pl / SQL Developer

    Purple DriveWestlake, TX, United States
    Full-time
    Develop, test, and maintain PL / SQL procedures, functions, packages, and triggers.Assist in the design and optimization of complex SQL queries for data extraction and reporting.Support ETL workflows...Show moreLast updated: 3 days ago
    • Promoted
    Oracle Database Architect

    Oracle Database Architect

    Staffing the UniverseRoanoke, TX, United States
    Permanent
    Location : Merrimack, NH Smithfield, RI Boston, MA Westlake, TX.Job Type : Contract 6 Months (Probably going permanent).Work Status : US Citizen / Green Card / GC-EAD. This role will be a longer-term (star...Show moreLast updated: 3 days ago
    • Promoted
    Database Architect

    Database Architect

    Resource Informatics Group IncSouthlake, TX, US
    Full-time
    Greetings from Resource Informatics Group!.We are urgently looking for a “Database Architect” in Southlake, TX.JD & send me the matching profiles : .Role ...Show moreLast updated: 30+ days ago
    • Promoted
    Database Administrator

    Database Administrator

    TradeJobsWorkForce76014 Arlington, TX, US
    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 moreLast updated: 30+ days ago
    • New!
    Contract Role : SQL Database Administrator at Irving, Texas (Onsite from Day 1)

    Contract Role : SQL Database Administrator at Irving, Texas (Onsite from Day 1)

    Yochana ITIrving, TX, United States
    Full-time
    Quick Apply
    SQL Database Administrator Irving, TX (Onsite from Day 1) Contract Role Show moreLast updated: 22 hours ago
    • Promoted
    Senior ServiceNow Administrator

    Senior ServiceNow Administrator

    Christus HealthIrving, TX, US
    Full-time
    The System Administrator Senior is responsible for technical leadership in support of core network services, such as email, anti-virus, application deployment, data delivery, server hardware and op...Show moreLast updated: 1 day ago
    • Promoted
    Databricks DBX Developers

    Databricks DBX Developers

    Tachyon TechnologiesIrving, TX, United States
    Full-time
    We are seeking experienced Databricks Developers with strong expertise in designing and implementing scalable data solutions on the Databricks platform. The ideal candidate will be proficient in DBX...Show moreLast updated: 3 days ago
    • Promoted
    Linux Administrator

    Linux Administrator

    Eliassen GroupWestlake, TX, US
    Full-time
    This is a Shift role Wed-Sat or Sun-Wed (10 hours each day) -12 pm – 10 pm EST.Our client has an exciting opportunity for a Linux Administrator. The role involves working within an enterprise ...Show moreLast updated: 4 days ago
    • Promoted
    Snowflake Administrator (Westlake, TX)

    Snowflake Administrator (Westlake, TX)

    CedentWestlake, TX, United States
    Full-time
    Bachelors or master's in engineering, Information Systems, Computer Science or Information Technology or equivalent experience. Snowflake Administration (AWS preferred but Azure is okay too).Years o...Show moreLast updated: 3 days ago
    • Promoted
    Mongo DB Administrator

    Mongo DB Administrator

    ClifyXIrving, TX, United States
    Full-time
    Perform hands-on technical work to install and configure MongoDB in DBaaS platform.Assist application support for cross-region migrations. Support migrations in new data center (DC).Provide extended...Show moreLast updated: 3 days ago
    • Promoted
    Staff Database Engineer

    Staff Database Engineer

    Michaels StoresIrving, TX, US
    Full-time
    Partner with IT leaders and peers to influence and define strategic technology direction, target state solutions, and develop technology roadmaps in partnership with IT leadership and other busines...Show moreLast updated: 27 days ago