Job Information
The Hartford IND Senior Engineer, Infrastructure in Hyderabad, India
IND Senior Engineer, Infrastructure - GCC034
We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.
We are seeking a highly skilled and experienced Senior Windows/SQL Platform Engineer to join our team. The preferred candidate for this position will have an extensive history working with the full stack of products offered by Microsoft with a core focus on SQL Server database infrastructure deployment experience and a proven ability to develop with Powershell and WinRM to automate infrastructure deployments and configurations. A history of experience using configuration management tools such as Ansible in conjunction with PowerShell to manage Windows servers is highly desirable for this position.
In this role, you will:
Require a deep understanding of Microsoft SQL Serverinternalsand haveexperience working with the full suite of servicesoffered (Ex. SSIS, SSRS, SSAS)
Work closely with a team of database product specialists and help enhance our product portfolio ofSQL Serverproducts on the AWS platform with a core focus on SQL Server products deployed onWindows virtual machines.
Collaborate with application teams tobuildscalable, secure, and high-performing database solutions aligned with enterprise standards.
Partner with the Cloud Engineering team to lead database migrations to AWS, ensuring seamless transitions and minimal disruption.
Leverage automationand IACtools such as Ansible and Terraform toautomate andstreamline infrastructure provisioning and database operations.
Key Responsibilities
Drive design, creation, and management ofSQL Serverdatabases running onWindows on VMWare and Windows on AWS EC2
Participate in design, development, and implementation of database architecture and database solutions for “Speed-to-Market” Agile projects underway.
Perform tuning withexpertiseusing SQL Server DMVs and Execution Plans.
Master the latest DB features and apply them to provide a measurable value on applications.
Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions, and upgrades.
Work to reduce complexity and cost in database environments through analysis, simplification, and automation using Ansible,Powershell, terraform or other tools.
ConductSQLServerdatabase configuration reviews, audits, and troubleshooting for all platforms supported bySQL Server.
Control and monitor user access to databases andmaintaindatabase security.
Manage capacity planning and forecasting for various platforms.
Facilitatedatabasesmigration from an on-prem system to the Cloud.
Maintain documentation of systems and standard operating policies and procedures
Collaborate andparticipatein application release planning and implementation.
Work with HIG onshore and offshore database partners to ensure availability, performance, quality, and Service Level Agreement specifications.
Educate and influence stakeholders to promote an understanding of theenvironments, increase simplification, risk management, and promote reuse and innovation.
* * Required Skills & Experience
Requires at least6-9years of experience with implementations,upgrades,migrationand consolidation projects withSQL Serverdatabases.
Solid knowledge and experience ofSQL Serverand technical database concepts, includingdatabase and querytuning,databasecloning,migrations, and backup/recovery techniques.
Knowledge and experience in AWS
ProficiencyinWindowsserver management
Strong organizational and communication skills with the ability to handle multiple priorities.
The ability to learn fast on the job by partnering with senior resources
A passion for engineering excellence and continuous improvement.
Strong communicationand collaboration skills to work across cross-functional teams.
A proactive mindset with the ability to troubleshoot complex issues and drive resolution.
Bachelor’s degree in computer science or a related discipline
Preferred Qualifications
3+ years working in an Enterprise environment that uses Microsoft Active Directory services to manage users andgroups, andhave a strong understanding of security best practices using Windows Auth and Kerberos.
3+ years of experience working on cloud platforms such as AWS or Azure, with preference on AWS.
3+ years of highly technical experienceofMicrosoft SQL Server, Availability Groups and Failover Clusters.
3+ years of development/automation experience usingPowershellandPowershellremoting viaWinRM.
2+ years of experience using Ansible to configure Windows systems usingWinRM(Chef, Puppet experience will also be considered)
2+ years of experience with Terraform.
2+ years of experience using 3rd Party database backup tools such as Rubrik,Idera, Redgate, etc. and a firm understanding of nativeSQL Serverbackup and recovery strategies.
AWS certifications are highly recommended for this position.
Familiarity with programming languages such as TSQL,.Net,Powershell, Python, GO.
Strong understanding of backup and recovery, security configuration, license management, reporting, integration, monitoring, audit, and performance troubleshooting skills.
Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
Experience working in an Agile development environment is a plus.
Experience with other database platforms such as Oracle, PostgreSQL,etcis a plus.
What We Offer
Collaborative and innovative work environment.
Competitive compensation and comprehensive benefits.
Continuous learning and professional development opportunities.