Database Administrator

Xpressdocs Partners, Ltd.
Fort Worth, United States of America
yesterday

Role details

Contract type
Franchise
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Remote
Fort Worth, United States of America

Tech stack

Amazon Web Services (AWS)
Bash
Ubuntu (Operating System)
Databases
System Configuration
Data Retention
Database Servers
Database Queries
Linux
DevOps
Python
Network Troubleshooting
PostgreSQL
MariaDB
Microsoft SQL Server
MySQL
Performance Tuning
Query Optimization
Ansible
Workflow Management Systems
Diagnostic Tools
Scripting (Bash/Python/Go/Ruby)
Database Performance
Amazon Web Services (AWS)
Puppet
Docker

Job description

We are looking for a Database Administrator who can take on a role larger than a traditional DBA role, who can be responsible for managing our MariaDB and Postgres database clusters, automating deployment of schema updates, deploying database server upgrades, managing replication and backup processes, identifying and solving performance issues. The ideal candidate will have a solid background in Database Systems, 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, be able to provide guidance to developers on the usage of databases. The ideal candidate really values their own work, ensures their solutions are robust, keeps the user impact in mind and aims to deliver complete solutions.

In this position, you will:

  • 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

This job description outlines the primary responsibilities of the position. Employees may be required to perform any other duties required as assigned by management to meet the needs of the organization.

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

Benefits & conditions

Pulled from the full job description Tuition reimbursement Health insurance 401(k) matching Vision insurance Dental insurance Life insurance Disability insurance, An environment that prioritizes balance between work and family. Our comprehensive benefits package and workplace opportunities include:

  • Collaborate with an upbeat team of techies, creatives, and specialists…who actually like what they do.
  • Enjoy our modern, secure and centrally located office in Fort Worth
  • Flexible work from home options
  • Onsite coffee bar and wellness rooms
  • Medical, dental, vision, disability, and life insurance
  • 401K with company matching
  • Paid holidays, vacation, and personal time
  • Tuition Reimbursement
  • Employee awards program
  • A dedicated social platform for peer, work anniversary and birthday recognition

About the company

A Marketing/Print/Technology company with more than 20 years of experience helping some of today's top companies simplify and strengthen their marketing. We provide cutting-edge but accessible marketing technology, produce high-quality marketing materials, and create world-class customer experiences. We take our solutions seriously, but we don't take ourselves seriously. To learn more about what we do and who we serve, visit www.xpressdocs.com.

Apply for this position