Role : SQL DBA
Location : Little Rock, Arkansas (Onsite)
NO H1B and OPT
Duration: Long Term
- This position is responsible for the performance, integrity and security of the ARCSIS database.
Job Duties
- Install, configure, and maintain Microsoft SQL Server Databases in a highly distributed,secure enterprise environment.
- Maintains Development, Staging, Training and Production environments.
- Review SQL code, optimizing code, checking coding standards against ANSI standards.
- Maintains data standards, including adherence to the Data Protection Act.
- Monitoring performance and working with SQL profiler and Database Engine Tuning Advisor for tuning queries, indexes, to find performance issues, etc.
- Develop SSIS packages, scheduled them as jobs and deploy packages in SQL Server Integration Services.
- Implementation of SQL logins, users, roles and authentication modes as a part of security policies
- Create and monitor NAS backups and maintain backups as per State and federal retention policies.
- Analyze, solve, and correct the production issues based on help desk tickets.
- Create, maintain and monitor nightly batch jobs using Argent Job scheduler and Argent Queue Engine.
- Creates physical data model and maintains/modifies as needed Assists with complex queries.
- Review execution plans to determine where indexes can be built to improve performance.
- Writes database documentation, including data standards, procedures and definitions for the data dictionary (‘metadata’)
- Controls access permissions and privileges
- Develops, manages and tests backup and recovery plans
- Ensures that storage, archiving, backup and recovery procedures are functioning correctly
- Conducts capacity planning
- Provide 24×7 support for critical production systems and Participate in on-call duty
Qualifications
Functional Requirements
- 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. - 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.
Database Administration Roles and Responsibilities
Technical Requirements
- Contractor resources shall meet the following requirements:
- Master’s degree in computer applications or related field and minimum 5 years of experience
- Databases: Microsoft SQL Server
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.
Thanks & Regards,
Mounika
—
