SQL Server DBA

1. Install, configure, and maintain Microsoft SQL Server Databases in a highly distributed, secure enterprise environment.

2. Maintains Development, Staging, Training and Production environments.

3. Review SQL code, optimizing code, checking coding standards against ANSI standards.

4. Maintains data standards, including adherence to the Data Protection Act

5. Monitoring performance and working with SQL profiler and Database Engine Tuning Advisor for tuning queries, indexes, to find performance issues, etc.

6. Develop SSIS packages, scheduled them as jobs and deploy packages in SQL Server Integration Services.

7. Implementation of SQL logins, users, roles and authentication modes as a part of security policies

8. Create and monitor NAS backups and maintain backups as per State and federal retention policies.

9. Analyze, solve, and correct the production issues based on help desk tickets.

10. Create, maintain and monitor nightly batch jobs using Argent Job scheduler and Argent Queue Engine.

11. Creates physical data model and maintains/modifies as needed

12. Assists with complex queries

13. Review execution plans to determine where indexes can be built to improve performance

14. Writes database documentation, including data standards, procedures and definitions for the data dictionary (‘metadata’)

15. Controls access permissions and privileges

16. Develops, manages and tests backup and recovery plans

17. Ensures that storage, archiving, backup and recovery procedures are functioning correctly

18. Conducts capacity planning

19. Provide 24x7 support for critical production systems and Participate in on-call duty

1. Resources shall have two (2) years of public sector experience working with SQL databases on health and human services projects. Child support enforcement program experience is preferred.

2. Solid experience in complete Software Development Life Cycle (SDLC) of software and web applications including analysis, design, development, integration, implementation, maintenance, debugging, testing, and reports.

Technical Requirements

Contractor resources shall meet the following requirements:

1. Master’s degree in computer applications or related field and minimum 5 years of experience

2. Databases: Microsoft SQL Server

3. Tools: SQL Server Management Studio, SQL Profiler, SSIS, SSRS, SSAS, Import Export Utility, BCP, Commvault Backup and Recovery tool, Perfmon Admin Tool, ARGENT Scheduler, ERWIN, MS VSS, TFS, MS Office and MS Visio.