Database Administrator

XPRESSDOCS PARTNERS, LTD.•Fort Worth, TX

1d•Hybrid

About The Position

Xpressdocs is seeking a Database Administrator who can take on a role larger than a traditional DBA role. This position will be responsible for managing MariaDB and Postgres database clusters, automating the deployment of schema updates, deploying database server upgrades, managing replication and backup processes, and identifying and solving performance issues. The ideal candidate will have a solid background in Database Systems, an in-depth understanding of performance tuning of databases, and a good understanding of running database servers on Linux with familiarity with Scripting and Docker to automate their management. They should also have good communication and interpersonal skills, and be able to provide guidance to developers on the usage of databases. The ideal candidate values their own work, ensures their solutions are robust, keeps the user impact in mind, and aims to deliver complete solutions.

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

Nice To Haves

MSSQL experience a plus

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