Senior SQL Server DBA

$49,400 - $146,800/Yr

CGI - Lafayette, LA

Full-time - Senior

Lafayette, LA

1,001-5,000 employees

Professional, Scientific, and Technical Services

About the position

CGI is seeking a Senior SQL Server DBA to join a high-performing client-based team. This role involves working independently to implement, plan, test, troubleshoot, and manage database projects, primarily in a healthcare environment. The DBA will ensure high security of protected health information and monitor production applications, while also addressing user requests and performance issues.

Responsibilities

• Implement, plan, test, troubleshoot, and manage database-related projects either On-Prem or in Azure.
• Install, configure, administer, and maintain SQL Server for a healthcare database environment.
• Monitor and investigate issues with production applications.
• Evaluate and identify operational issues within the databases.
• Work on tickets and monitor databases related to projects.
• Complete user requests for access, change requests, and scripts.
• Respond to performance issues for related project database servers.

Requirements

• At least 6+ years of experience with Microsoft SQL Server 2008 - 2019.
• Strong understanding of DBA concepts.
• Proficient in T-SQL (scripting, stored procedures, triggers, query development).
• Experience with Clustering/Always On technology, Log Shipping, Replication, and High Availability.
• Knowledge of SQL Performance Analysis (Index Management and Query Plan Assessment).
• Experience with SQL installation, configuration, troubleshooting, and RCA.
• Knowledge of Incident Management and Best Practices.
• Familiarity with SQL monitoring tools (Idera, Spotlight, SCOM, Zabbix, SQL Sentry, Foglight, SolarWinds).
• Experience with ETL, SSIS, SSRS, SSAS, OLAP, OLTP.
• Knowledge of Security and User Management.
• Experience with Backup/Recovery and Disaster Recovery Procedures.
• Experience with Standardized Database Maintenance.
• Knowledge of upgrade planning, migrations, and implementations for SQL Server versions.

Benefits

• Dental insurance
• Health insurance
• Pet insurance
• Vision insurance