Database Administrator

Jobtailor; Fort Worth (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor in Fort Worth seeks a seasoned Database Administrator to oversee MariaDB and PostgreSQL ecosystems, optimize queries, and manage AWS RDS deployments.

You will collaborate with DevOps and development teams to enforce database standards, implement robust backups, security roles, and conduct regular performance reviews.

Qualifications

• Bachelor of Science degree (or equivalent) is required.
• Extensive experience with MariaDB/MySQL and PostgreSQL administration.
• Strong knowledge of query planning, transaction mechanisms, and multi-page query optimization.
• 2+ years deploying and managing Postgres and MySQL compatible AWS RDS instances.
• Working knowledge of Linux and scripting (Python or Bash).
• Experience with AWS or similar cloud platforms and RDS deployments.
• Familiarity with Docker containers and orchestration tools (Ansible, Chef, Puppet).
• Ability to troubleshoot Linux network and system issues and communicate with stakeholders.

Responsibilities

• Understand existing database architecture for MariaDB and PostgreSQL.
• Review and upgrade replication and backup processes.
• Build reports to support company data needs on reporting platforms.
• Establish regular cadence for database performance reviews and optimization.
• Manage and enhance data retention processes.
• Communicate with stakeholders to establish database standards.
• Address security issues with databases using well-defined roles.
• Coordinate with DevOps and developers for troubleshooting and maintenance.
• Identify and address systemic errors; perform root-cause analysis.

Skills

MariaDB/MySQL

PostgreSQL

AWS RDS

Docker

Linux scripting (Python/Bash)

Query optimization

Security & access controls

Orchestration tools (Ansible, Chef, or

Troubleshooting & problem solving

Education

Bachelor of Science degree (or equivalent)

Tools

AWS

Docker

RDS for MySQL/Postgres

Ansible

Job description

Responsibilities

• Understand existing database architecture of both existing MariaDB and Postgres installs
• Review and upgrade our current replication and backup processes
• Support the company’s data needs by building reports on reporting platforms
• Establish a regular cadence for database performance review and optimization
• Manage and enhance existing data retention processes
• Communicate with stakeholders to establish database standards
• Identify and address security issues with the databases, using well-defined roles
• Establish a regular cadence for database updates
• Participate in the process of identifying and addressing systemic errors
• Perform root cause analysis of errors and resolve technical issues
• Work closely with DevOps and Developers for system troubleshooting and maintenance

Requirements

• Minimum four years of experience administering both MariaDB (or MySQL) and Postgres
• In-depth knowledge of database query planning and transaction mechanisms, with experience in complex (multi-page) query optimization
• Minimum 2 years of experience building, deploying and managing Postgres and MySQL compatible AWS RDS instances.
• Working knowledge of Linux and a scripting language like Python or Bash
• Problem-solving attitude and exposure to troubleshooting tools on Linux OS, Network issues etc...
• Collaborative team spirit
• Bachelor of Science degree (or equivalent)
• Experience with Ubuntu distro
• MSSQL experience a plus
• Experience configuring, deploying, and managing Docker containers
• Experience with Amazon Web Services (AWS) or similar
• Working knowledge of orchestration tools such as Ansible, Chef, or Puppet
• Ability to research, plan, and implement solutions that may be outside of your current knowledge
• Highly motivated

Core Competencies

Demonstrates expertise in administering MariaDB and Postgres databases, with a strong focus on query optimization, performance review, and security management. Proficient in deploying and managing AWS RDS instances and utilizing orchestration tools for efficient database operations.