Job ID :
9408
Company :
State of Arkansas
Location :
LITTLE ROCK, AR
Type :
Contract
Duration :
9+ Months
Salary :
Open
Status :
Active
Openings :
1
Posted :
12 Oct 2016
Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:  The Senior Database Administrator will work under the supervision of current ADE – Network & Server Administration staff to build and augment internal capacity; migrate and support the databases for ADE Education Information Systems.

Complete Description:  Local candidates preferred but not required.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.
QualificationsA 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 RequirementsExperience 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.
Skill
Required / Desired
Amount
of Experience
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 numbers)
Required
 
 
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