Position Purpose :
The Database Administrator monitors and analyzes the status of the Afni SQL Server Environment. The incumbent is responsible for monitoring the ticket queue for issues from users as well as system-generated alerts and outages.
The incumbent is responsible for documenting resolutions and escalating as necessary. The incumbent will handle minor code changes following Afni’s software development lifecycle.
Implements and alters File Transfer processes. Incumbent will also provide production deployment support for changes, will be expected to perform data repairs, and may have SQL Server related tasks on managed projects or other planned work.
Proactively monitors SQL Server Performance and coordinates changes for improvement (Indexes, CPU, RAM).
Essential Functions and Responsibilities :
Install / Configure Microsoft SQL Server and related components.
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot issues reported by users, reassigning to other teams or escalating to Data Science and Engineering team as necessary.
Troubleshoot database service outages as they occur, including after-hours and weekends
Monitor and troubleshoot SQL Server job failures and Configure monitoring utilities to minimize false alarms
Deploy changes to SSIS packages, jobs, databases, and MFT processes.
Troubleshoot SSIS Packages, Reporting Services, and Stored Procedures.
Alter SQL Server and Reporting Services Security.
Create and modify Reporting Services Subscriptions.
Review index recommendations and tune queries for improving performance.
Mentor other Database Support Engineers.
Minimum Job Requirements :
Bachelor’s degree in Information Technology or any related course.
At least 5 years of experience with a relational database management system, preferably Microsoft SQL Server.
Experience with SQL Server Reporting Services, Integration Services, and stored procedures is required.
Experience with Microsoft Office.
Strong organizational skills with the ability to multi-task and attention to detail.
Strong verbal and written communication skills in English are required; ability to type proficiently.
Exceptional interpersonal skills (negotiation, team-building, positive thinking, can-do attitude, and job flexibility).