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.
... multi-network connectivity—enabling a wide array of innovative cloud-based solutions. ———————————————————— Position Overview Telna is seeking a skilled and experienced Database Administrator (DBA) to join our team. In this role, you will be responsible for the end-to-end lifecycle management of our heterogeneous database environment ...
Role Overview : The Database Administrator (DBA) will be responsible for the security of enterprise database platforms supporting IAM and other critical business services. This is a mid-level role that independently executes day-to-day database operations and partners with application, infrastructure, and security https://jobeax.com/link/ZlR3JZToBtLJKlA9 ...
... Install, configure, administer, and maintain DB2 UDB databases.- Perform database monitoring, performance tuning, backup, recovery, and troubleshooting.- Manage database availability, security, access, and capacity.- Support PostgreSQL database environments and related administration activities.- Work with AWS and/or GCP cloud-based ...
... administer, optimize, and support DB2 z/OS v12 and IMS v15 databases.- Work with IMS FF/FP databases and DB2 z/OS data-sharing environments.- Convert logical database models into physical database designs.- Perform access path re-engineering and optimization for large-scale databases.- Administer database security in accordance ...
... the financial infrastructure of the future. The Role: A Senior Database Administrator at Razorpay is well-grounded - responsible for managing and maintaining databases. Their primary role is to ensure the integrity, security, and performance of the databases that store and retrieve data critical to the organization's operations. ...
... mechanisms. - Experience with encryption methodologies for databases. - Experience with database clustering techniques. - Hands on Experience with the following database technologies (Postgres). Education and Experience: - Seven or more years of direct experience working as a (Postgres) Database Administrator. - Bachelor’s degree ...
... likes of Kunal Shah, Amrish Rao as angel investors. About this Role: We are looking for a Senior DBA with 5-8 years of experience running mission-critical databases across relational , NoSQL, key-value and analytical engines, in both on-premise and managed cloud (AWS) setups. You will own uptime, performance, scaling, ...
Description: is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
... https://jobeax.com/link/9YsaXf36psowmkfi This Role, You Will:- Manage and support PostgreSQL databases hosted on Google Cloud SQL for PostgreSQL.- Monitor database health, performance, availability, backups, storage usage, and recovery readiness.- Review the current GCP database infrastructure across security, compute, ...