PARTNER CONSULTANT - Oracle

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

Job summary

Happiest Minds Technologies in Bengaluru is seeking an experienced MSSQL Database Engineer (DBA) to plan, administer and optimize MSSQL databases across on-premise and cloud environments.

You will implement backup/recovery, ensure performance, security and availability, and collaborate with IT operations to automate routines using PowerShell.

The role requires 8+ years of MSSQL experience, expertise with Always On, replication, clustering, and a strong understanding of ITIL processes.

Qualifications

• 8+ years of IT MSSQL Database Domain experience (On Prem and cloud) with proven DB Operations expertise.
• Proficient with MSSQL 2019/2022 and HA configurations like Always On, replication and clustering.
• Experience in backup/recovery strategies and DR planning with cloud integrations.

Responsibilities

• Provision MSSQL instances in clustered/non-clustered setups with replication, Azure & AWS support.
• Ensure database performance, security, and high availability.
• Perform upgrades, backups, recovery, migrations, and health monitoring.

Skills

MSSQL Administration

Always On Availability Groups

Azure / AWS

PowerShell scripting

SQL optimization

Backup & Recovery

Cloud migrations

ITIL processes

On Prem & Cloud

Clustered / Replication / HA

Education

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

Tools

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 clients 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. Ms sql Dtabase administration,On Prem and cloud,Ms sql 2019,Ms Sql 2022