Job ID :
10113
Company :
State of Arkansas
Location :
LITTLE ROCK, AR
Type :
Contract
Duration :
7+ Months
Salary :
Open
Status :
Active
Openings :
1
Posted :
18 May 2017
Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:  The Database Developer/Analyst will be responsible for building and maintaining client database systems.

Complete Description:  Local Candidates Preferred.Candidates should be direct to presenting vendor, no multi-layering.3 to 6 month assignment.
The Database Developer/Analyst will be responsible for building and maintaining the Arkansas All Payer Claims Database (APCD), contributing data systems, conducting analysis using statistical software and preparing tables and reports as needed. This individual conducts extract, transform and load (ETL) analysis, designs ETL processes, maintains process and system documentation, conducts application unit testing, assists in application functional, integrated, and performance testing; resolves problems, and participates in "on call" support for internal staff. 
This person will report to the ACHI Director of the Health Data Initiative (HDI) and will be working closely with other members of the APCD project team.
In addition, this person will be also be responsible for developing and qualifying database release management/deployment procedures and collaborating with the Software Development, Quality Assurance, and Support teams.
Responsibilities:Buildings and maintains database systemsExperience in and knowledge of performing extract, transform and load (ETL) processesExperience in and knowledge of database design, installations, conversionsResponsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage managementResponsible for definition of standards of data dictionariesMay program dictionary analysis and maintenance softwarePerform performance tuningMonitor database performance and space requirementsSchedule and monitor end of day data warehousing jobsAssist in coordinating software releasesCommunicate accurate and useful status updatesFollow quality standardsAbility to work in a project team environmentStrong communication skills; both written and spokenBusiness systems analysis and design experienceLogical data modeling techniques, with emphasis on processing speed and versioningProduction environment Tools/UtilitiesKnowledgeable in data analysis and database management techniquesExecution of all responsibilities with little direct supervision of Team LeadAdministration and scripting experience in relative platformAuthor shell scripts to perform back up, restore, and monitoring tasksAnticipate and resolve issues specific to the teamDetermine time estimates and schedule for own work and resolve issues in a timely mannerIdentify and track issues, risks and action items Provide status of work to project team lead and project manager.Engage in ongoing process improvement.
Skill
Required / Desired
Amount
of Experience
Database Development
Required
5
Years
T-SQL & ANSI SQL
Required
5
Years
SQL Server 2008 - 2016
Required
5
Years
SSIS
Required
5
Years
SSRS
Required
3
Years
C# Programming
Required
5
Years
Data Warehousing concepts
Required
2
Years
Multi-source database integration solutions
Required
2
Years
SSAS
Highly desired
2
Years
Current MS SQL certification
Highly desired