Omm2699J

Omm IT Solutions; Hartford (CT); On-site; USD 120,000 - 160,000; Full time

Job summary

Omm IT Solutions in Hartford, CT seeks a senior database engineer to manage MS SQL Server on Azure and PostgreSQL, ensure high availability, and optimize performance. The role requires 7+ years IT experience with clustering, Always On, backups, and data migration.

Responsibilities include capacity planning, troubleshooting, and SSIS/SSRS/SSAS work. Onsite only, with relocation consideration and 24/7 support expectations.

Qualifications

• Bachelor’s degree or foreign equivalent required or three years of related experience in lieu of education.
• 7+ years of IT experience with 6+ years in MS SQL Server on Azure or PostgreSQL administration.
• Experience installing and configuring MS SQL Server, enabling SQL clustering and Always On.
• Strong data modeling, performance tuning and capacity planning for databases.
• Proven troubleshooting of SQL clustering and Postgres environments.
• Experience with backups, restore, replication and SSIS/SSRS/SSAS.
• Knowledge of SQL Server security, roles, permissions and data integrity.
• Ability to work onsite in Hartford, CT and relocate if needed.
• U.S. citizens or work authorization; sponsorship not available.

Responsibilities

• Administer MS SQL Server in Azure and PostgreSQL databases for reliability and performance.
• Plan capacity, monitor systems, and troubleshoot issues including deadlocks and contention.
• Implement backups, restorations, replication, and data migration strategies.
• Design and tune indexes, execution plans and data models for reporting needs.
• Manage SSIS/SSRS/SSAS activities and write documentation for infrastructure.

Skills

MS SQL Server

Azure

PostgreSQL

SQL Always On

SQL Clustering

Performance Tuning

Data Modeling

SSIS/SSRS/SSAS

Backups & Restore

PowerShell

Education

Bachelor’s degree or foreign equivalent

Tools

Qlik Attunity

SolarWinds DPA

Delphix

EMC Networker

CommVault

Job description

Omm IT Solutions | Permanent W-2 Employee / Corp2Corp Contractor

Hartford, United States | Posted on 09/22/2025

• Job Type Permanent W-2 Employee / Corp2Corp Contractor
• Compensation Negotiable
• State/Province Connecticut
• City Hartford
• Country United States
• Work Authorization Authorized to work in USA
• Job Opening ID Omm2699J

Job Description

Please Note:

• It is 100% Onsite Position.
• Candidate must be located within commuting distance or willing to relocate to Hartford, CT
• Candidate must be available to work on a rotating shift schedule to provide 24/7 support, including early mornings, late nights, weekends, and on-call coverage.

Description:

• The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face.

Requirements

Required Qualifications:

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
• At least 7 years of Information Technology experience
• At least 6 years of experience in MS SQL server on Azure/PostgreSQL administration and maintenance
• Understanding of Azure framework, MS SQL Server in Azure is a must
• Able to install and configure the MS SQL Server, configure the SQL clustering, SQL Always On Availability Groups
• Able to do the capacity planning based on the growth pattern of the databases
• Have expert troubleshooting skills on the SQL Clustering environment and Postgres environment
• Monitor, maintain database systems and troubleshoot problems that may arise
• Strong Analytic skills, Data Modelling & Performance tuning in MS SQL server/PostgreSQL
• Perform Upgrade of databases to different versions of SQL and migration of databases from SQL server to PostgreSQL
• Maintain data integrity and security (manage roles and permissions of database users)
• Use tools like SQL Profiler, Database tuning advisor, Execution plans for database tuning and Index recommendations
• Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
• Develop strategies and implement solutions for managing back‑ups, restoration and replication
• Strong knowledge of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)
• Should be well versed with the SQL replication functions and Change Data capture process
• Ensure timely completion of the Databases regular refreshes keeping all the reporting environment in sync
• Create detailed documentation including diagrams of database infrastructure
• Learn relevant business processes and understand the data flow, criticality and dependencies
• U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time
  

Preferred Qualifications:

• Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix.
• PowerShell programming
• Backup and restore tools like EMC Networker, CommVault
• Planning and Co-ordination skills
• Experience of Mergers and Acquisitions will be an added advantage
• Good Communication and Analytical skills
  

Education/Work Experience

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education