Inviting applications for the role ofPrincipal Consultant - SQL DBA

In this role you are responsiblefor implement and support SQL Server technologies, ensuring technical capabilities are met. The ideal candidate will thrive in a fast-paced environment, possess strong communication skills, and manage multiple projects with minimal supervision

Responsibilities

.Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.

.Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all CAI environments DEV/QA/PROD.

.Maintain/Monitor systems On-Prem or in AWS/Azure.

.Coordinate and schedule DB downtimes to perform DB maintenance procedures. i.e. DB patching, upgrades, etc.

.Define Backup and Recovery strategies using technologies used at CAI:Netapp Snapshots, SnapCenter/Snap Manager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.

.Perform advanced database administration activities including but not limited to: DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions.

.Create/update CAI's database documentation about standard procedures, DB technology features, or production issue troubleshooting.

.Stay current with changes in the technical area of expertise.

.Support highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, Availability Groups.

.Work with development teams to deploy code in production when needed.

.Participate in on-call rotations.

Qualifications we seek in you!

Minimum Qualifications

.Bachelor's degree or equivalent work experience

.Strong communication and collaboration abilities.

.Hands on experience in Microsoft Windows/ SQL Server Technologies, .Net development.

.Experience working in 24x7 environments oriented towards a zero-downtime target.

.Working knowledge or previous administration of SQL 2016-SQL 2022 and Windows Server 2019+.

.Experience with ETL, DTS, T-SQL and SSRS, SSIS.

.Ability to work with minimal direction, in a team environment.

.Performance tuning for SQL server, queries, stored procedures, views, etc.

.Hands on experience with configuring and administering Log Shipping and SQL Availability Groups.

.Experience with SQL in virtual, physical and cloud-based environments.

.Proven ability to quickly learn and implement new technologies

.Experience with Sentry One a plus.

.Ability to code PowerShell commands

.Excellent problem-solving and analytical skills.

.Ability to work independently and as part of a team.