Senior SQL/PostgreSQL DBA - Azure, Onsite in Providence

Omm IT Solutions

Providence (RI)

On-site

USD 110,000 - 150,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Omm IT Solutions is seeking an experienced Senior SQL Server DBA to join our on-site team in Providence, RI. The role focuses on MS SQL Server and PostgreSQL administration on Azure, with emphasis on data integrity, security, and performance optimization.

The ideal candidate has 7+ years in IT, deep knowledge of SQL Server on Azure, and experience with SSIS/SSRS/SSAS, backups, and migrations. U.S. work authorization is required; relocation within commuting distance is expected.

Qualifications

Bachelor’s degree or foreign equivalent required; will consider 3 years of progressive experience in lieu.
At least 7 years of Information Technology experience.
At least 6 years of 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 MS SQL Server, configure clustering, and Always On Availability Groups.
Capacity planning based on database growth.
Expert troubleshooting in SQL Clustering and PostgreSQL.
Monitor and maintain database systems; troubleshoot problems.
Strong analytic skills, data modeling, and performance tuning in MS SQL Server/PostgreSQL.
Upgrade and migration of databases to newer versions; migrate SQL to PostgreSQL.
Maintain data integrity and security (roles/permissions).
Use SQL Profiler, tuning advisor, and execution plans for performance.
Generate traces, identify performance issues; resolve deadlocks/contention.
Backup/restoration and replication strategies; regular refreshes of reporting environments.
Learn business processes and data flow; document infrastructure.