Senior Azure SQL & PostgreSQL DB Engineer Onsite Raleigh

Omm IT Solutions; Raleigh (NC); Presencial; USD 110.000 - 150.000; Jornada completa

Descripción de la vacante

Omm IT Solutions is seeking an experienced SQL Server and PostgreSQL Database Administrator for an onsite role in Raleigh, NC. The position requires 7+ years IT experience, deep expertise in MS SQL Server on Azure, PostgreSQL, and related tools.

You will manage clustering, Always On, backups, migrations, and performance tuning, with on-call coverage as part of rotating shifts. The ideal candidate will have a strong analytical mindset, data modeling skills, and the ability to document

Formación

• Bachelor's degree or foreign equivalent; 3 years of progressive experience in lieu of education
• At least 7 years of IT experience
• 7+ years in MS SQL Server and PostgreSQL administration
• Azure framework knowledge; MS SQL Server in Azure is essential
• Install, configure SQL Server; set up clustering; Always On AGs
• Capacity planning based on DB growth
• Expert troubleshooting in SQL Clustering and PostgreSQL
• Monitor, maintain and troubleshoot DB systems
• Data modeling, performance tuning in MS SQL and PostgreSQL
• DB upgrades and migrations SQL to PostgreSQL
• Manage data integrity and security (roles/permissions)
• Use SQL Profiler, tuning advisor, execution plans for tuning
• Generate traces, analyze deadlocks, resolve issues
• Backups, restoration, replication strategies
• SSIS/SSRS/SSAS; replication and CDC
• Regular DB refreshes; sync reporting environments
• Document DB infra with diagrams
• Learn business processes and data flow
• US citizens or authorized to work; sponsor not available

Responsabilidades

• Provide 24/7 on-call support on rotating shifts
• Install, configure and manage MS SQL Server and PostgreSQL in Azure
• Plan capacity and optimize DB performance
• Migrate databases between SQL Server and PostgreSQL
• Ensure data integrity and security; manage user permissions
• Create and analyze traces and execution plans for performance
• Implement backups, restores and replication strategies
• Document architecture and data flow with diagrams
• Coordinate with teams to understand business processes and data dependencies

Conocimientos

MS SQL Server

Azure

PostgreSQL

SQL Performance tuning

Data modelling

Troubleshooting

SSIS/SSRS/SSAS

Capacity planning

Backup and restore

PowerShell

Communication

Analytics

Educación

Bachelor's degree

Herramientas

SQL Profiler

Database tuning advisor

Execution plans

Qlik Attunity

SolarWinds DPA

Delphix

EMC Networker

CommVault

Descripción del empleo

Omm IT Solutions is seeking an experienced SQL Server and PostgreSQL Database Administrator for an onsite role in Raleigh, NC. The position requires 7+ years IT experience, deep expertise in MS SQL Server on Azure, PostgreSQL, and related tools.

You will manage clustering, Always On, backups, migrations, and performance tuning, with on-call coverage as part of rotating shifts. The ideal candidate will have a strong analytical mindset, data modeling skills, and the ability to document