Database Administrator - MsSQL & NoSQL

Summary role description:

Hiring for a Database Administrator (MsSQL & Cassandra) for one of the fastest-growing energy technology companies in India.

Company description:

Our client is one of the fastest-growing energy technology companies in India, founded by some of the leaders in this space. They lead technological innovation for the most effective energy delivery system in automated metering, smart energy, data capture, analytics, and smart workflows. They are the pioneer and market leader in end-to-end AMI technology, comprising Smart Meters, Communication Networks, and Central Systems. Their 100% made-in-India smart automation solutions solve the most difficult and complex problems in technical and commercial losses in energy distribution. Their team of 200+ devoted professionals have been working hard for >10 years, to change how energy is distributed in India and around the world. They are a culture-driven technology business, with core values of putting employees first, entrepreneurship, honesty, and respect.

Role details:

• Title / Designation: Database Administrator
• Reporting Manager: Director of Engineering
• Location: New Delhi
• Work Mode: Work-from-Office

Role & responsibilities:

• Develop and document database architectures, schemas, and physical structures that align
• with business requirements and best practices.
• Implement and maintain security measures to ensure database integrity, confidentiality, and compliance with industry standards and regulations.
• Evaluate database performance, identify bottlenecks, and implement optimizations to enhance database performance and efficiency.
• Develop and maintain backup and disaster recovery strategies to ensure data availability and minimize downtime in case of system failures or data loss.
• Troubleshoot and resolve database-related problems, faults, and issues to ensure smooth and uninterrupted database operations.
• Plan, install, configure, optimize, and upgrade database management system software to enhance performance and keep the database environment up to date.
• Manage database replication and distribution processes to ensure data consistency and availability across multiple environments.
• Performs capacity planning of server environments and provides recommendations to management to sustain business growth.
• Provide technical support offering guidance and expertise on database-related matters.
• Leverage expertise in relational (preferably MS Sql Server) and NoSql (preferably Cassandra) to manage and optimize databases in both public cloud and on-prem setups.
• Utilize T-SQL skills to develop and optimize SQL queries, stored procedures, and function to meet performance and functional requirements.

Candidate requirements:

• 6+ years of experience in relational (preferable MS Sql Server) and NoSql (preferably Cassandra) databases in multi-cloud environments like Azure, and AWS in enterprise settings.
• SQL development (T-SQL) skills are strongly desired
• Strong track record of evaluating database performance, isolating performance bottlenecks, and implementing database optimizations in transactional settings.
• Database Architecture concepts with hands-on experience regarding high availability, load balancing, and distributed computing required.
• Experience managing and monitoring 24x7 Production database environments.
• Good communication and documentation skills.

Selection process:

• Technical Assessment
• Technical Discussion - Virtual
• Technical Discussion - Face to Face
• HR Discussion

Place of work