19 Aug
|
Happiest Minds Technologies
|
Bengaluru
19 Aug
Happiest Minds Technologies
Bengaluru
MSSQL Database EngineerAs 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.
- Valuable 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.
EducationB.S. or M.S. degree in Computer Science, Computer Engineering, other technical disciplines, or equivalent work experience.
📌 PARTNER CONSULTANT - SQL (Bengaluru)
🏢 Happiest Minds Technologies
📍 Bengaluru