Senior Database Administrator

Job Description

We are looking for an experienced Database Administrator for MySQL role who shall be responsible to work Maintenance, Security, Upgrades, Performance Tuning, etc. and to handle a wide range of activities from leading mid to large-size projects. You’ll be part of a team of problem solvers who are passionate about working in a highly dynamic, client-centric technology company. The candidate must possess the ability to think quickly, provide creative and effective solutions for clients through analytical and logical acumen.

Must Have Skills:

Experience in logical and physical data modeling.

Experience in crafting indexes, SQL queries, and resultant explanation of access paths for optimizing the SQL.

Experience in Linux / Unix operating systems.

Expertise in upgrading and migrating databases to Cloud.

Experience troubleshooting oracle instance/SQL performance issues.

Proficiency in database administration, management, data imports and exports, and developing reports.

Good to Have Skills:

Excellent written and verbal communications skills with a demonstrated ability to make difficult concepts easy to understand.

Intermediate knowledge in hardware and networking.

Experience managing databases. Ability to adapt to varied roles and problem-solving skills.

Good scripting/coding experience with any of the following: Unix Shell, Python and Ruby.

Experience with 24/7 support, backup and recovery practices.

Experience with MongoDB is a plus.

Job Responsibilities:

Server and Database Security Administration.

Builds and provides support for entire database schemas.

Develops database utilities and automated reporting.

Analyses and sustains capacity and performance requirements.

Monitors systems and platforms for availability.

Oversees backup, clustering, mirroring, replication and failover, and ensure all jobs complete successfully.

Designs and documents database architecture.

Performs maintenance operations daily, weekly and monthly on MySQL database.

Implements and maintains database security, permissions and encryption.

Disaster recovery/high availability, Failover Clustering.

Performs any necessary restorations, database recovery, and troubleshooting for any critical problems