Senior Database Administrator

What you’ll Do:

• Provide expert database administration support for LMWN's databases, including AWS Aurora (MySQL & PostgreSQL) and our large-scale, self-hosted MongoDB replica sets.
• Play a key role in designing and implementing our database infrastructure,  including building out MongoDB sharding and a robust Patroni PostgreSQL cluster.
• Develop and implement automation tools to streamline database operations,  minimize manual intervention, and proactively address potential issues.
• Champion database reliability by managing all database scripts, schema changes, and automation code within Git, ensuring a consistent and auditable workflow.
• Lead the charge in performance tuning, troubleshooting, and root cause analysis for all database-related incidents.
• Work closely with our engineering teams to optimize database usage, review changes, and provide expert guidance on best practices 
• Utilize Grafana and other monitoring tools to maintain a vigilant watch over our database health and ensure the highest levels of availability and reliability.
   

What you’ll Need: 

• A Bachelor's degree in Computer Engineering, Computer Science, or a related field.
• At least 3 years of hands-on experience in database administration, with a proven track record of managing complex, large-scale database environments.
• Deep expertise in administering AWS RDS and Aurora (both MySQL and PostgreSQL).
• Strong experience with MongoDB, including replica sets and a solid understanding of sharding concepts.
• Proficiency in troubleshooting and resolving complex database issues.
• Experience with version control systems, notably Git, for managing code and configurations.
• A proactive mindset with a passion for automation and continuous improvement.
   

It'd be great if you have:

• Experience with Patroni for PostgreSQL high availability.
• Familiarity with containerization and orchestration technologies, particularly Kubernetes.
• Experience with Infrastructure as Code (IaC) tools like Terraform or Ansible.
• Proficiency in scripting languages such as Bash Shell Script, Python, or Go.
• Knowledge of monitoring and observability tools like Grafana and Prometheus.