Apply Now

Database Administrator

• Posted 5 days ago • Updated 7 hours ago

Full Time

Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

Query Optimization
Backup
Scalability
Quality Assurance
Management
Failover
Data Manipulation
DML
DDL
Optimization
Load Balancing
Routing
Linux Administration
Shell Scripting
Performance Tuning
Capacity Management
Collaboration
DevOps
Database
Servers
PostgreSQL
Migration
Clustering
High Availability
Storage
GR
Operating Systems
Proxies
SQL
Disaster Recovery
Scripting
Bash
Python
Ansible
Backup Administration
Recovery
Database Administration
Linux
MySQL
Replication
Scheduling
React.js
Database Architecture
Database Security
Regulatory Compliance
Auditing
Computer Science
Data Science
Statistics
Mathematics

Summary

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: RTX16960c
Position Id: 76090e1d9d5e47e2f8ab586b56e63da7
Posted 5 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Database Administrator

Kissimmee, Florida

•

Today

Database Administrator I Direct Hire Target Salary: $115K Hybrid schedule available after onboarding/training period Position Overview Seeking a Database Administrator to support the stability, security, and performance of enterprise database environments. This role will be responsible for database architecture, optimization, monitoring, backup/recovery planning, and ongoing system maintenance while partnering with cross-functional teams to support business-critical applications and initiative

Full-time

USD 115,000.00 per year

Database Administrator

Waukegan, Illinois

•

Today

Uline, Inc. Job Location: 2105 S. Lakeside Drive, Waukegan, IL 60085 Job Title: Database Administrator Job Duties: Uline, Inc. seeks a Database Administrator in Waukegan, Illinois to perform database administration. Design databases, tables, stored procedures, views, triggers, and other database objects. Design and develop ETL (Extract, Transform & Load) solutions. Optimize database performance through indexing, query optimization, database design. Participate in periodic High Availability /

Full-time

USD 133,973.00 - 133,973.00 per year

Staff Database Administrator

Englewood, Colorado

•

Today

Company Summary DISH, an EchoStar Company, has been reimagining the future of connectivity for more than 40 years. Our business reach spans satellite television service, live-streaming and on-demand programming, smart home installation services, mobile plans and products, and now we are building America's First Smart Network . Today, our brands include EchoStar, Hughes, DISH TV, Sling TV, Boost Infinite, Boost Mobile, DISH Wireless, OnTech and GenMobile. Job Duties and Responsibilities Staff

Full-time

USD 153,750.00 per year

Database Administrator

New Jersey

•

Today

Database Administrator Req number: R7849 Employment type: Full time Worksite flexibility: Onsite Who we are CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right-whatever it takes. Our tailor-made solutions create lasting result

Full-time

USD 70.00 - 80.00 per hour

Search all similar jobs