Senior Database Administrator Job in Sarvika Technologies Pvt. Ltd

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.

Roles and 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