Job Description :
Job Title: ADE DBA3 SC3 [477449]

Location: Little Rock AR, (Local candidate strongly preferred)

Duration: 10 Months

Citizens only

Job Description:

Local candidates preferred but not required.

No more that one subcontractor between the candidate and submitting vendor.

The Senior Database Administrator will be a member of the Dev-Ops Team and
will be responsible for directly supporting the daily administration of the
agency''s Microsoft SQL Server databases. Responsibilities include capacity
planning work (including migration) and monitoring database growth and
design, maintaining and ensuring High Availability solutions including
replication, clustering, performance tuning etc. The position will be a
strictly staff augmentation position for a period of 6 - 9 months.

Duties and Responsibilities

Perform Microsoft SQL database administration including software
installations/configurations for SQL Server 2008 to 2014 including SSDT,
SSIS, SSRS, SSAS and peripheral features/products such as log shipping,
mirroring, and maintenance packs (dbcc, backups, re-indexing

Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware,
query related, etc and resolve database related issues.

Responsibilities include capacity planning work (on Production, UAT, DEV
and DR environments); platform migration and monitoring database growth and
design, maintaining and ensuring High Availability solutions including
replication, clustering, performance tuning etc.

Duties include developing and enforcing database standards and best
practices including performance, security, monitoring policies and
procedures along with researching improvements to enhance overall system
performance.

Provide hands-on training, mentoring and support to current ADE - Network
& Server Administration staff with Microsoft SQL Server databases.

Qualifications

A successful candidate may have experience with:
7+ years of experience developing, maintaining and administering Microsoft
SQL Server databases.
Bachelor''s degree in Computer Science/Information Science or equivalent
work experience.

Involved in prior enterprise-level databases migrations and deployments.
Experience configuring SQL Server replication required
Hand-on experience with MS SQL Server 2014; 2012; 2008 R2 versions.
Hand-on experience with SQL monitoring tools - Red Gate; SQL Sentry; etc.
Special Requirements

Experience with Business Intelligence and Data Warehouse products preferred.
Development experience with complicated DTS/SSIS Package coding and
maintenance a plus. Experience with Data Modeling Tools as well as creating
and maintaining data models preferred.

Skills:

* MS SQL DBA. Required 7 Years
* Enterprise Level Database Migrations & Deployments. Required 4 Years
* Configuration SQL Server Replication. Required 3 Years

* Work Experience with MS SQL Server 2014, 2012, 2008 R2. Required 7
Years
* Work Experience with SQL Monitoring Tools; Red Gate, SQL Sentry;
etc.Required 5 Years

* MCDBA or MCSE Certification (provide certification numbersRequired
* Work Experience with BI Products. Highly desired
* Work Experience with Data Warehouse Products. Highly desired

* Development Experience with DTS/SSIS Packages. Highly desired
* Work Experience with Data Modeling Tools.Highly desired
* Work Experience Maintaining Data Models. Highly desired