Job Profile : Database Administrator, MySQL Job Location : Pune Experience Required : 6-7 yrs Job Description : Design and implement high-performance, scalable database architectures for MySQL and SingleStore systems. Architect and optimize distributed database systems leveraging SingleStores in-memory capabilities and MySQLs traditional disk-based storage. Use EXPLAIN and Query Profiler to analyze and optimize complex queries in MySQL and SingleStore. Optimize schema design, indexing strategies, and partitioning for performance in large-scale systems. Implement caching strategies, query parallelism, and other techniques to reduce query latency in SingleStore. Implement SingleStores distributed SQL architecture for horizontal scalability and high availability. Configure and optimize multi-Region replication for MySQL and SingleStore, ensuring low-latency data access and fault tolerance Leverage SingleStores real-time backup capabilities to ensure data consistency and durability. Configure database-level encryption (at rest and in transit) for MySQL and SingleStore. Implement role-based access control (RBAC) and fine-grained user permissions for MySQL and SingleStore. Ensure compliance with data security standards such as GDPR, HIPAA, and PCI-DSS for both MySQL and SingleStore databases.,
Employement Category:
Employement Type: Full time Industry: IT Services & Consulting Role Category: Not Specified Functional Area: Not Specified Role/Responsibilies: Database Administrator, MySQL Job in Softenger