14 Zerto Jobs

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

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

• 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} Services TCP_01