MySQL Developer

MySQL Developer

This role has been designed as ‘Hybrid’ with an expectation that you will work on average 2 days per week from an HPE office.

Job Description:

What you'll do:

Scope of Work for MySQL Database Administrators

1. Database Design and Architecture:

• Collaborate with developers and architects to design and implement efficient database schemas.
• Ensure proper normalization & indexing, for optimal performance and scalability.
• Evaluate and implement replication architectures as needed for high availability and fault tolerance.

2. Performance Tuning:

• Monitor database performance using tools like MySQL Enterprise Monitor or custom scripts.
• Identify and optimize poorly performing queries through query analysis, index optimization, and query rewriting.
• Configure MySQL server settings, buffer pools, and caches to maximize throughput and minimize response times.

3. Security and Compliance:

• Configure role-based access controls (RBAC) and auditing features to ensure data integrity and confidentiality.
• Coordinate with UIDAI-appointed GRCP and security audit agencies to conduct regular security audits and share artifacts to address any identified risks promptly.

4. Backup and Disaster Recovery:

• Ensure integration of databases to suitable backup mechanisms and recovery procedures to safeguard against data loss and ensure business continuity.
• Coordinate with relevant teams to conduct regular DR drills.

5. Monitoring and Alerting:

• Set up monitoring systems to track database health and performance metrics.
• Configure automated alerts to notify administrators of critical issues, such as performance degradation, replication lags, or storage constraints.
• Proactively investigate and resolve alerts to maintain system stability and availability.

6. Capacity Planning:

• Monitor database growth trends and resource utilization to forecast future capacity requirements.
• Evaluate and recommend hardware upgrades or version upgrades to support long-term scalability goals.

7. Maintenance and Upgrades:

• Perform routine maintenance tasks, including database backups, index rebuilds, and statistics updates, during scheduled maintenance windows.
• Support execution of MySQL version upgrades and patch deployments, ensuring compatibility and minimal downtime.
• Coordinate with application teams to test and validate database changes in development and staging environments before production rollout.

8. Documentation and Knowledge Sharing:

• Maintain comprehensive documentation of database configurations and other Standard Operating Procedures
• Provide training and knowledge transfer to team members on database administration best practices, tools, and technologies.
• Foster a culture of continuous learning and improvement through regular team meetings and knowledge sharing sessions.

9. Incident Response and Problem Resolution:

• Respond to database-related incidents and outages promptly, following established incident management procedures.
• Jointly work with relevant teams to carry out root cause analysis to identify underlying issues and support the implementation of corrective actions to prevent recurrence.
• Collaborate with cross-functional teams, including developers, network engineers, and system administrators, to troubleshoot complex issues and drive resolution.

10. Service Ticket Handling for DML Operations:

• Receive and prioritize service tickets related to Data Manipulation Language (DML) operations, including INSERT, UPDATE, DELETE, and SELECT queries.
• Analyze and troubleshoot reported issues, such as data inconsistency, performance degradation, or query optimization.
• Work closely with application developers and end-users to understand the context and requirements of DML operations.
• Provide guidance and recommendations to developers & architects on optimizing DML queries for improved performance and efficiency.
• Implement database schema changes, data migrations, and data transformations as requested through service tickets, ensuring proper testing and validation procedures are followed by the development team.
• Communicate updates and resolutions to stakeholders in a timely and transparent manner, ensuring customer satisfaction and alignment with service level agreements.
• Collaborate with other teams, such as application support, quality assurance, and release management, to address cross-functional dependencies and ensure smooth execution of DML-related tasks.

12. Collaboration with Developers for DDL Operations:

• Assist developers/ application architects in planning and executing Data Definition Language (DDL) operations, such as creating, altering, and dropping database objects (tables, indexes, views, etc.).
• Review proposed schema changes and provide recommendations on best practices for database design and optimization in consultation with application architects and developers
• Perform impact analysis to assess the potential implications of DDL changes on existing data, applications, and performance.
• Execute DDL changes during scheduled maintenance windows, following change management procedures and ensuring minimal disruption to production systems.

13. Data Archival and Cleanup:

• Collaborate with application architects and developers to define data retention policies and archival strategies for each schema/table based on UIDAI data retention policies and business needs.
• Develop and implement data archival processes to move inactive or historical data to secondary storage or archival databases, freeing up space and improving database performance.
• Monitor data growth trends and implement proactive measures, such as purging, to manage database size and mitigate performance degradation, in consultation with application architects and developers.
• Document data archival and cleanup procedures, including retention periods, criteria for data selection, and execution schedules, ensuring compliance with data governance policies.

What you need to bring:

• Qualification – BE / BTech/MCA/ MSc
• Min years of TOTAL experience – 4+ years
• Location – Bengaluru, UIDAI
• Onsite deployment
• Nature/Key activities – DBA related activities

Accountability, Accountability, Active Learning (Inactive), Active Listening, Bias, Business Growth, Client Expectations Management, Coaching, Creativity, Critical Thinking, Cross-Functional Teamwork, Customer Centric Solutions, Customer Relationship Management (CRM), Design Thinking, Empathy, Follow-Through, Growth Mindset, Information Technology (IT) Infrastructure, Infrastructure as a Service (IaaS), Intellectual Curiosity (Inactive), Long Term Planning, Managing Ambiguity, Process Improvements, Product Services, Relationship Building {+ 5 more}

Health & Wellbeing

We strive to provide our team members and their loved ones with a comprehensive suite of benefits that supports their physical, financial and emotional wellbeing.

Personal & Professional Development

We also invest in your career because the better you are, the better we all are. We have specific programs catered to helping you reach any career goals you have — whether you want to become a knowledge expert in your field or apply your skills to another division.

Diversity, Inclusion & Belonging

We are unconditionally inclusive in the way we work and celebrate individual uniqueness. We know diverse backgrounds are valued and succeed here. We have the flexibility to manage our work and personal needs. We make bold moves, together, and are a force for good.

#india#operations

Job:

Services

Job Level:

TCP_02

Hewlett Packard Enterprise is EEO F/M/Protected Veteran/ Individual with Disabilities.

HPE will comply with all applicable laws related to employer use of arrest and conviction records, including laws requiring employers to consider for employment qualified applicants with criminal histories.