PARTNER CONSULTANT - SQL

Happiest Minds Technologies; Bengaluru; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Happiest Minds Technologies in Bengaluru seeks an experienced MSSQL Database Engineer to manage on-prem and cloud SQL environments, including Always On, replication, and DR planning. You will optimize performance, ensure security, and implement backup/recovery strategies while aligning with ITIL processes.

The role requires 8+ years in MSSQL, strong scripting (PowerShell), and collaboration across IT teams to deliver scalable database solutions in a fast-paced environment.

Qualifications

• Minimum 8+ years in MSSQL Database Domain (On Prem and cloud).
• Strong proficiency with MSSQL 2019/2022, Always On, Replication, Clustering.

Responsibilities

• Provision MSSQL instances in clustered and non-clustered configurations with replication, Azure & AWS support.
• Ensure performance, security, and availability of databases.
• Handle upgrades, backups, recoveries, migrations and DR readiness.
• Monitor health and perform root-cause analysis for incidents.

Skills

MSSQL DB admin

Always On AG

Replication

Clustering

PowerShell

SQL optimization

Azure

AWS

Backup & recovery

DR planning

ITIL

On-call

Communication

Education

B.S./M.S. in CS/CE

Tools

SQL Server

Azure

AWS

PowerShell

Job description

MSSQL Database Engineer Job Description

As an MSSQL Database Engineer (DBA you will plan, coordinate and administer database functions, documentation, upgrades, lifecycle, long-range requirements, operational guidelines and data protection. In this role, you will regularly work with Business Units to ensure solutions meet or exceed business requirements. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. You will maintain operational excellence in multiple world-class Data Center environments, both on prem and cloud, with published standards and compliances.

Responsibilities and Tasks

• Provision MSSQL instances, both in clustered and non-clustered configurations with replication, Azure & AWS database support.
• Ensure performance, security, and availability of databases.
• Handle common database administration and maintenance such as upgrade, backup, recovery, migration, etc.
• Monitor overall health of databases and provide timely resolution and root cause analysis for incidents to prevent issues.
• Profile server resource usage, capacity management, optimization and enhanced structure
• Partner with other infrastructure team members and user customers.
• Partner with multi-functional application teams to design efficient and scalable database structure throughout development, testing and deployment to production.
• Investigate and fix database-related issues, including connectivity problems, performance degradation, and data inconsistencies.
• Provide technical guidance and support to developers and end-users.
• Prepare SOE and Runbook documentations, specifications and refine processes to support dynamic environments.
• Participate in setting objectives, strategies, plans, programs, performance standards/measures and procedures.
• Follow SOX compliances
• Drive innovation and automation of database resiliency.
• Contribute to IT project execution.
• Collaborate with IT Operations Managers to continually improve operations through routine monitoring of system performance metrics, review system log files, trend analysis, configuration, incident, release and problem management ITIL processes
• Require working in 8/5 shift support and weekend rotational On-Call support in collaboration with global DBA teams.

Qualifications / Experience:

• A minimum of 8+ years of overall experience in IT MSSQL Database Domain (On Prem and cloud) with proven experience in Database Operations.
• Strong proficiency in MSSQL database management with 2019 and 2022 versions of MSSQL
• Solid understanding on installing, configuring and troubleshooting MSSQL server, specifically Always ON Availability Groups, Replication, Clustering.
• Develop and implement backup and recovery strategies to ensure data integrity and availability.
• Test and validate backups to guarantee recoverability in case of failures with DR experience
• Knowledge of Cloud services, preferably Azure and AWS
• Proficient in writing and optimizing SQL statements.
• Experience in designing and automating repetitive processes to streamline service and ensure consistency.
• Good hands-on PowerShell scripting and automation
• excellent problem-solving and analytical skills.
• Good communication, decision‑making, prioritization, negotiation, collaboration and project management abilities.
• Understanding and alignment of ITIL change and incident management processes.
• Growth mindset for continuous improvement
• Ability to plan system resource requirements from high level specifications.

Education

B.S. or M.S. degree in Computer Science, Computer Engineering, other technical disciplines, or equivalent work experience.