MemSQL DBA

Overview

Prodapt is the largest specialized player in the Connectedness industry. As an AI-first strategic technology partner, Prodapt provides consulting, business reengineering, and managed services for the largest telecom and tech enterprises building networks and digital experiences of tomorrow. Prodapt has been recognized by Gartner as a Large, Telecom-Native, Regional IT Service Provider. A "Great Place To Work Certified" company, Prodapt employs over 6,000 technology and domain experts in 30+ countries. Prodapt is part of the 130-year-old business conglomerate The Jhaver Group, which employs over 32,000 people across 80+ locations globally.

Responsibilities

• MemSQL Database Management : Install, configure, and maintain MemSQL databases. Monitor, diagnose, and resolve database issues related to performance, availability, and security. Manage database clusters, ensuring they are running efficiently with minimal downtime. Ensure data replication, backup, and restore procedures are in place and functioning correctly.
• Performance Optimization : Analyze query performance and apply best practices for query optimization (e.g., indexing, sharding). Work with developers to write and tune efficient SQL queries. Diagnose and address performance bottlenecks across database, disk I / O, and network latency. Implement and optimize partitioning and indexing strategies to improve database performance. Review and improve MemSQL architecture to meet growing application demands.
• High Availability & Disaster Recovery : Design and implement disaster recovery solutions, including automated failover and replication strategies. Work on database clustering and sharding to ensure scalability and high availability.
• Database Security : Ensure the security and integrity of the database by implementing role-based access control, encryption, and auditing. Stay current with database security threats and protect the environment from external threats.
• Collaboration & Reporting : Collaborate with developers to provide insight into database challenges and recommendations on schema design, indexing strategies, and data access patterns. Work with system administrators to optimize resource utilization across servers and networks. Generate regular reports on database performance, availability, and capacity.
• Documentation & Best Practices : Maintain detailed documentation on database configurations, performance benchmarks, and troubleshooting procedures. Implement and enforce best practices for database management and optimization.

Required Skills & Qualifications

Seniority level

Employment type

Job function

Industries

J-18808-Ljbffr