Full-Time Senior Database Administrator
2am.tech is hiring a remote Full-Time Senior Database Administrator. The career level for this job opening is Experienced and is accepting Worldwide based applicants remotely. Read complete job description before applying.
2am.tech
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
We are 2am.tech, a team of builders and problem solvers. We strive for excellence, providing solutions and products that exceed expectations. Join us in reinventing businesses with groundbreaking software solutions!
We value autonomy and nurturing spaces where you can unleash your potential. To embrace our culture, we value trustworthiness, honesty, continuous knowledge expansion, dedication, innovation, and a result-oriented approach.
We are seeking a highly motivated, talented, and committed Senior Database Administrator. You should have strong communication skills, actively share knowledge, and expect the same from your team. You should have pride in your deliverables and thrive on daily challenges.
Technical Requirements
- MySQL Database Administration: Extensive experience with recent MySQL versions (5.7, 8.0, or later). Proficient in installation, configuration, and administration of MySQL in production environments. Expertise in performance optimization (query tuning, indexing strategies, schema analysis). In-depth knowledge of InnoDB and other MySQL storage engines.
- Amazon Aurora MySQL: Proven experience configuring and managing Aurora MySQL databases on AWS. Deep understanding of Aurora's architecture, including distributed design, replicas, auto-scaling, and automated backups. Proficient in monitoring and tuning Aurora clusters.
- Maintenance and High Availability: Skilled in setting up and maintaining replicas (native MySQL replication and Aurora replicas). Experience implementing high availability and disaster recovery solutions. Competent in configuring and monitoring automated backups and point-in-time recovery processes.
- Monitoring and Security: Hands-on experience with monitoring tools (Amazon CloudWatch, Zabbix, Prometheus, Nagios). Expertise in implementing robust security policies, access control, and encryption (TDE, SSL/TLS). Proficient in database auditing and compliance management.
- Automation and Scripting: Strong experience scripting with Python, Bash, or Perl for task automation. Familiarity with IaC tools (Terraform or CloudFormation).
- Advanced SQL Skills / Performance Tuning: Expertise in stored procedures, triggers, events, transactions, locks. Skilled in diagnosing and resolving SQL query performance issues. Experience with SolarWinds Database Performance Analyzer or EverSQL. Demonstrated experience redesigning DB schemas for performance tuning.
- Migration and Upgrades: Experience migrating databases from other engines to RDS MySQL or Aurora MySQL. Proficient in securely and efficiently upgrading MySQL and Aurora cluster versions.
- General AWS Knowledge: Familiarity with complementary AWS services (S3, IAM, Lambda, RDS Proxy). Strong understanding of AWS networking (VPC, subnets, security groups).
Soft Skills
- Excellent problem-solving and critical thinking abilities
- Strong team collaboration skills
- Clear and effective communication skills, explaining complex issues to non-technical audiences
- Demonstrable experience mentoring junior DB staff
Nice-to-Have
- Working knowledge of Redis, MongoDB, or Elasticsearch
- Familiarity with CI/CD tools and DevOps methodologies
- AWS Certifications