Description
About the Role
We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will have 3 to 5 years of hands-on experience with MySQL, ProxySQL, and PostgreSQL, specializing in database administration, performance tuning, query optimization, high availability, backup, and archival. This role involves managing and supporting database systems, ensuring uptime, performance, and scalability for mission-critical applications.
What You'll Do
- Manage and maintain MySQL databases across production, QA, and development environments.
- Implement and manage MySQL Group Replication for seamless failover and redundancy.
- Review/deploy data-manipulation (DML) and data-definition (DDL) changes to support application releases.
- Serve in an on-call rotation as an escalation contact for critical database production issues and drive escalation/resolution of problems.
- Conduct query performance tuning, indexing strategies, and schema optimization to improve efficiency.
- Setup and maintain master-slave replication topologies for high-availability and write/read scaling.
- Configure and maintain ProxySQL for database traffic load balancing and query routing.
- Monitor ProxySQL logs and troubleshoot database connection issues.
- Linux system administration and shell programming skills such as storage capacity management, performance tuning.
- Write scripts using Bash/Python to automate manual administrative tasks. Monitor performance and tune databases to optimize for different workloads.
- Maintain backups and perform point-in-time restorations. Perform regular database health checks, monitoring, and capacity planning.
- Respond to P1/P2 incidents related to database downtime, performance issues, or replication failures.
- Collaborate with DevOps and Engineering teams to resolve database-related challenges.
We'd Love for You to Have
- Minimum of 3 to 5 years' experience in administering MySQL v8.x Servers.
- Decent knowledge of PostgreSQL is required.
- MySQL Server Installation, Upgrades, Migrations and Configuration.
- Expertise and experience with clustering solutions for High Availability.
- Advanced knowledge on InnoDB storage engine.
- Expert knowledge of Performance Schema.
- Knowledge and expertise on GR cluster, Proxy SQL and operating systems, know how on Proxy SQL usage as it relates to MySQL.
- Experience in Disaster recovery planning and implementation.
- Good scripting skills (Bash/Python) and well-versed with Linux systems.
- Understand the automation concept to speed up the work: Ansible.
- Knows how to optimize queries/schema.
- Deep understanding of replication setup and replication-related issues.
- Complete understanding of backups, restores, recovery, database maintenance operations.
- Experience in Percona tools is an advantage.
- Advanced understanding of Linux OS.
- Deep understanding of monitoring requirement to catch the related issues.
- Experience in Index/Jobs fine tuning and query optimizations.
- Troubleshoot and resolve MySQL server and replication issues of any complexity.
- Perform technical work that requires planning and scheduling to ensure the best possible solution is delivered on time.
- React on incidents and provide solutions aiming at maintained environments' improvements.
- Should have experience & ability to work with various teams to resolve DB/architecture issues.
- Work in a fast-paced environment where we are responsible for most critical systems.
- Experience with database security, compliance, and audit logging.
Qualification:
- Should have a Bachelor’s or master’s degree in computer science, Data Science, Statistics, Mathematics, Engineering, or a related field.
Similar jobs
Est. 140,000 USD
We exist to wow our customers. We know we’re doing the right thing when we hear our customers say, “How did we ever live without Coupang?” Born out of an obsession to make shopping, eating, and living easier than ever, w…
Est. 95,000 EUR
At Sonatus, we’re driving the transformation to AI-enabled software-defined vehicles. Traditional automotive software methods can’t keep pace with consumer expectations shaped by the mobile industry—where features evolve…
BOLD seeks a senior professional to provide support for various MS SQL databases. This person will perform database structure and software maintenance and implementations, support database tuning and consultation, and as…
A CAREER WITH POINT72’S TECHNOLOGY TEAM As Point72 reimagines the future of investing, our Technology group is constantly improving our company’s IT infrastructure, positioning us at the forefront of a rapidly evolving t…
Est. 120,000 PLN
Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…
Est. 45,000 EUR
We are Kaizen Gaming Kaizen Gaming, the team powering Betano, is one of the biggest GameTech companies in the world, operating in 20 markets. We always aim to leverage cutting-edge technology, providing the best experien…
Key Responsibilities Design, develop, and maintain complex Oracle database applications using PL/SQL. Develop and enhance Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Analytical Functions,…
Dear Applicant, Greetings from Encora Innovation Labs! A Leading SaaS Technology Product Engineering Company! Please find the below detailed job description and the company profile for your better understanding. Position…
Securing the Future with AvePoint AvePoint is a global leader in data management and governance, trusted by over 21,000 customers worldwide to enhance their digital workplaces across Microsoft, Google, Salesforce, and ot…
Est. 140,000 USD
Position Overview: The Senior SQL Database Administrator (DBA) is a strategic technical leader responsible for the design, optimization, security, and scalability of enterprise database platforms. This role partners clos…
About the role With tens of millions of visitors every week, we strive to be the best in the industry for our users. You’ll be responsible for taking ownership of our existing and new database infrastructure for multiple…
Est. 60,000 EUR
We are Kaizen Gaming Kaizen Gaming, the team powering Betano, is one of the biggest GameTech companies in the world, operating in 20 markets. We always aim to leverage cutting-edge technology, providing the best experien…
As a Senior Staff Backend Engineer - Cloud Infrastructure, this role will focus on Cloud Platform Infrastructure, Services and processes at its best to enhance Cloud infrastructure reliability & system efficiencies,…
P-375 At Databricks, we build powerful infrastructure that accelerates innovation and enables data teams to deliver with confidence and scale. Our unified schema migration platform underpins automated, observable, and de…
Est. 120,000 PLN
Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…
At NiCE, we don’t limit our challenges. We challenge our limits. Always. We’re ambitious. We’re game changers. And we play to win. We set the highest standards and execute beyond them. And if you’re like us, we can offer…
As a Senior Staff Backend Engineer - Cloud Infrastructure, this role will focus on Cloud Platform Infrastructure, Services and processes at its best to enhance Cloud infrastructure reliability & system efficiencies,…
About Workato Workato delivers enterprise infrastructure for the agentic era, redefining iPaaS and helping enterprises unify data, applications, processes, and AI into a single, governed platform. A leader in Enterprise…
Est. 110,000 USD
Join Us in Making an Impact ✨ At OneAZ Credit Union, our success is measured only by yours. We’re here to create lasting change in the lives of our members, our communities, and our team. If you're looking for a career w…
Est. 124,000 USD
Position Overview: Senior Oracle Database Administrator (Sr. DBA) plays a critical role in maintaining and optimizing the databases that support our corporate and municipal clients. This position operates under the guida…
Est. 120,000 PLN
Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…
Est. 120,000 PLN
Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…
Est. 84,000 PLN
Xebia is a global AI-first, digital transformation, and engineering partner. With over 25 years of experience and a team of 5,000 professionals across 16 countries, we help organizations design and build scalable product…
About Us “Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 b…
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…
Job Title: AWS data Engineer About Us “Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Compan…
Est. 124,000 USD
Position Overview: The Senior Oracle Cloud Database Administrator is responsible for architecting, implementing, securing, and optimizing Oracle Cloud-based database solutions utilized by our corporate and municipal cust…
KnowBe4 empowers the modern workforce to make smarter security decisions every day. Trusted by more than 70,000 organizations worldwide, KnowBe4 is the pioneer of digital workforce security, securing both AI agents and h…
The Data Engineering team is responsible for building ETL pipelines that populate the Internal Data Platform, which drives analytics that help the company run more efficiently. Our team builds highly performant and scala…
Est. 124,000 USD
Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and…