Role description / primary
Responsibilities:
• Design, install, configure, and maintain MySQL databases to support AMI
applications and services.
• Perform database tuning and optimization to ensure high performance,
reliability, and scalability.
• Ensure optimal database performance by monitoring, diagnosing, and
resolving performance bottlenecks.
• Analyze and refine complex SQL queries for high-volume data processing.
Version 1.0 CyanConnode Confidential Page 2 of 2
• Implement backup strategies, disaster recovery plans, and failover systems
to ensure high availability.
• Perform routine database maintenance, including patch management and
version upgrades.
• Optimize data storage and query performance for real-time analytics and
reporting.
• Maintain detailed documentation of all database systems, configurations,
and procedures.
• Occasional out-of-hours support will be required
Experience and skills required:
• Minimum 10 years of experience in MySQL other relational DBs like MS SQL,
Oracle etc.
• Experience deploying and operating enterprise database- MYSQL
• Expert Database administrator: MySQL clustering and administration
preferably in a large-scale environment.
• Strong proficiency in MySQL performance tuning, query optimization, and
replication.
• Basic understanding of Linux Administration
• Solid understanding of on-prem and cloud infrastructure
• Understanding of security best practices for database administration,
including encryption, access control, and data masking.
• Documentation skills: Ability to create plans and SOPs
• Excellent communication skills, with the ability to convey complex
technical concepts to non-technical stakeholders.
• Ability to work independently and as part of a cross-functional team.
Preferred skills:
• Knowledgeable about common internet protocols, standards,
architectures, and patterns
• Familiarity with AMI systems, smart meter data, and IoT applications in
the utility industry is highly desirable.
• Hands on experience on version control using Git (or similar)
• Knowledge of automation tools like Ansible, Terraform, or similar for
infrastructure management.
• Proficiency JIRA and confluence tools
Personal attributes: • Excellent communication, collaboration, and organizational skills
• Confident operating in front of the customer as part of a distributed team
• Able to identify risks and estimate work
Qualifications:
Bachelor of computer science/electrical/electronic engineering