Job description
<p>Company Profile : <br/><br/>Knot Solutions delivers large-scale digital transformation solutions that help TSP majors to increase revenue streams at lower costs and better efficiencies through a combination of consulting, products, solutions, and services.
<br/><br/>Innovative solutions with integrated frameworks <br/><br/>We help global business majors leverage digital readiness for all their B2C, B2B, and B2B2X revenue stream needs.
With over 18+ years of expertise in delivering value towards Business and Operations Support Systems to the telecom industry, we deliver large-scale digital transformation solutions that help TSP majors to increase revenue streams at lower costs and better efficiencies through a combination of consulting, products, solutions, and services.
<br/><br/>We came across your profile in Job boards and would like to give you the details.
<br/><br/>Job Title : MySQL Database Administrator <br/><br/>Location : Hyderabad (Work from Office ) <br/><br/>Experience Level : 5-8 years <br/><br/>Qualifications : <br/><br/>- Bachelor's or Master's degree in computer science, Information Technology, or a related field.
<br/><br/>- 5-7 years of experience as a MySQL Database Administrator or in a similar role.
<br/><br/>Core Skills : <br/><br/>MySQL : <br/><br/>- Administration : Installation, configuration, upgrades, backups/restores, user management, performance tuning, security hardening, replication, clustering (MySQL Group Replication, Galera), partitioning <br/><br/>- Development : SQL (SELECT, INSERT, UPDATE, DELETE, JOINs, subqueries, stored procedures, functions, triggers, views) <br/><br/>- Troubleshooting : Performance issues, replication errors, data corruption, security breaches <br/><br/>- Storage Engines : InnoDB, MyISAM, Memory <br/><br/>- High Availability & Disaster Recovery (HA/DR) : Replication topologies, failover procedures, RTO/RPO, DR drills <br/><br/>- Monitoring & Alerting : Performance monitoring tools (e.g., MySQL Enterprise Monitor, Percona Monitoring and Management (PMM)), setting up alerts, log analysis <br/><br/>- Security : User management, access control (RBAC), encryption, data masking, security audits <br/><br/>- Scripting : Shell scripting (Bash, etc.), Python (for automation) <br/><br/>- Cloud Platforms (if applicable) : AWS RDS, Azure SQL Database, Google Cloud SQL <br/><br/>Advanced Skills : <br/><br/>- Performance Optimization : Query optimization techniques (indexing, query rewriting, EXPLAIN plan analysis), slow query analysis, tuning server parameters <br/><br/>- Clustering : Advanced cluster configurations, troubleshooting cluster issues <br/><br/>- Replication : Advanced replication setups (multi-source replication, cascading replication) <br/><br/>- Database Design : Normalization, denormalization, data modeling, schema design <br/><br/>- Troubleshooting Complex Issues : Deep dive into performance bottlenecks, replication failures, and other critical issues.
<br/><br/>Key Responsibilities : <br/><br/>- Database Management : Install, configure, and maintain MySQL databases, ensuring optimal performance and reliability.
<br/><br/>- Performance Tuning : Monitor database performance, identify bottlenecks, and implement tuning strategies to enhance efficiency.
<br/><br/>- Backup and Recovery : Develop and implement backup and recovery strategies to safeguard data integrity and availability.
<br/><br/>- Security Management : Implement and manage database security measures, including user access controls and data encryption.
<br/><br/>- Troubleshooting : Diagnose and resolve database issues, including performance problems, data corruption, and connectivity issues.
<br/><br/>- Replication and Clustering : Set up and manage MySQL replication and clustering for high availability and disaster recovery.
<br/><br/>- Upgrades and Migrations : Plan and execute database upgrades and migrations with minimal downtime.
<br/><br/>We are looking for the candidate who is ready to join immediately.
<br/><br/></p> (ref:hirist.tech)
Required Skill Profession
Computer Occupations