SQL Server DBA

Required Skills:

• Seven years of demonstrated experience supporting operational Microsoft SQL Server database systems.
• Seven years of demonstrated experience providing application database design deliverables and support for web application teams.
• Seven years of demonstrated experience creating and reviewing application database schemas using Microsoft SQL Server using SQL, T-SQL, and SSIS programming.
• Seven years of demonstrated experience using Crystal Reports or similar reporting tools, such as SQL Server Reporting Services, Tableau or PowerBI.
• Five years of demonstrated experience developing or supporting of financial, accounting or health care database systems.
• One year of experience with cloud-based database provisioning using services like Azure or AWS.

Responsibilities:

1. Create database system designs in the time indicated on the work tickets assigned by the Department related to the requested feature enhancements or defect corrections. Ensure the following requirements are met:

a. Participate in design meetings, collaborate with peers, managers and customers.

b. Scope and level of detail for database designs will be determined by the work tickets.

c. Designs that satisfy the needs defined in the work tickets and follow the Department templates while meeting the quality standards.

d. Work tickets will be used to document the task and should include all relevant database design documents or a reference link to the SharePoint repository location for the designs

2. Create and modify database code elements daily as defined by work tickets assigned by the Department. Ensure the following requirements are met:

a.  Participate in code review meetings, collaborate with technical peers and managers.

b.  Scope and level of detail for database code changes will be determined by the approved designs or specifications included in the work tickets.

c.  Code elements that satisfy the needs defined in the work tickets and follow the Department’s templates and change management processes will meet the quality standards.

d.  Work tickets will be used to document task completion. All source code and associated documentation will be placed in the Department’s source control and team document repository systems.

3. Troubleshoot and determine resolutions and work arounds to system issues as identified by incident tickets or management inquiry as directed by the Department. Ensure the following requirements are met:

a. Participate in troubleshooting activities, collaborate with technical peers, customers, management and vendors as needed.

b. Scope and level of detail for troubleshooting efforts will be determined by the incident.

c. Participation and collaboration that follow the Department’s incident and problem management processes will meeting the quality standards.

d. Incident tickets will be used to document task activities.

4. Provide work estimates and status updates, daily as specified in the work ticket assigned by the Department. Ensure the following requirements are met:

a. Participate in planning and work activities as specified in the work tickets assigned by the Department.

a. Scope and level of detail for planning and status updates will be determined by the work ticket.

b. Participation and collaboration that follow the Department’s incident, problem management, and system development lifecycle (SDLC) processes will meet the quality standards

c. Work ticket will be used to document estimates and status updates.