2am.tech Senior Database Administrator

We are 2am.tech, a team of builders and problem solvers who share a core belief of delivering excellence. This value has bred a company culture of providing solutions and products that exceed expectations every time.

Join us on the mission of reinventing businesses through groundbreaking software solutions. At 2am.tech, we celebrate autonomy and provide a nurturing space for you to unleash your potential. However, to fully embrace 2am.tech culture, it is necessary to cherish our core values. Are you a trustworthy and honest person? Are you willing to constantly expand your knowledge? Are you dedicated, innovative, and result-oriented? If the answer is yes, we would like to meet you!

We are looking for a Senior Database Administrator to join our team.

Is this your profile?

You have more than 5+ years of professional experience in the Database Engineering field. You are motivated, talented, and committed to the job at hand and your team. You take pride and ownership in your deliverables. You thrive on and enjoy the challenges of each day, and you seek to surround yourself with like-minded people. You are a clear communicator who shares your knowledge and ideas, and you expect the same from those around you.

If you're proactive, can mentor junior developers, and are available until 12 PM CST / 1 PM EST, we’d love to hear from you!

Technical Requirements

MySQL Database Administration:

• Extensive experience with recent MySQL versions (preferably 5.7, 8.0, or later).

• Proficient in installation, configuration, and administration of MySQL in production environments.

• Strong expertise in performance optimization, including query tuning, indexing strategies, and schema analysis.

• In-depth knowledge of InnoDB and other MySQL storage engines.

Amazon Aurora MySQL:

• Proven experience in 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 for high performance.

Maintenance and High Availability:

• Skilled in setting up and maintaining replicas, including native MySQL replication and Aurora replicas.

• Experience implementing high availability (HA) and disaster recovery (DR) solutions.

• Competent in configuring and monitoring automated backups and point-in-time recovery processes.

Monitoring and Security:

• Hands-on experience with monitoring tools such as Amazon CloudWatch, Zabbix, Prometheus, Nagios, or similar solutions.

• Expertise in implementing robust security policies, access control, and encryption (TDE, SSL/TLS).

• Proficient in database auditing and compliance management for regulatory adherence.

Automation and Scripting:

• Strong experience in scripting with tools like Python, Bash, or Perl for task automation.

• Familiarity with infrastructure-as-code (IaC) tools such as Terraform or CloudFormation for database deployment and management in AWS.

Advanced SQL Skills / Performance Tunning:

• Expertise in creating and maintaining stored procedures, triggers, and events.

• Proficient in managing transactions, locks, and other advanced SQL features.

• Skilled at diagnosing and resolving SQL query performance issues.

• Hands-on experience with SolarWinds Database Performance Analyzer or EverSQL

• Demonstrated experience taking existing DB schemas and redesigning them to fine-tune the performance.

Migration and Upgrades:

• Demonstrated experience migrating databases from other engines (e.g., PostgreSQL, Oracle, SQL Server) 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 like S3, IAM, Lambda, and RDS Proxy.

• Strong understanding of AWS networking, including VPC, subnets, and security groups.

Soft Skills:

• Excellent problem-solving and critical thinking abilities.

• Strong team collaboration skills and the ability to work closely with developers and other stakeholders.

• Clear and effective communication skills, especially in explaining complex technical issues and solutions to non-technical audiences.

• Demonstratable experience mentoring junior DB staff

Nice-to-Have:

• Working knowledge of related technologies such as Redis, MongoDB, or Elasticsearch.

• Familiarity with CI/CD tools and DevOps methodologies to support modern development workflows.

• AWS Certifications
  

Check our other open positions https://2am.tech/careers#positions, if you didn’t find your fit - join Roles Pilot, the ultimate platform for remote experts https://rolespilot.com/link-as-expert. You can advance your career by becoming a valued member of the premier network of world-class experts. RolesPilot brings together top talent developers and professionals in business, marketing, design, and technology to embark on exciting, remote software development projects for prestigious clients across diverse industries.