Job Description :
SQL Database Administrator/ SQL DBA(573192)
Des Moines, IA
Duration: 6 Months
In Person Interview
Required:
Senior level Database Administrator may work with more than one database architecture or have deep knowledge in a specific application database or set of databases to support architectural or decision support activities.
The State of Iowa is seeking an ETL Developer with extensive experience with SQL and SSIS. The ideal candidate will have the ability to troubleshoot and problem-solve with a strong sense of urgency. This person should be a self-starter, able to work both independently and cooperatively as required. The successful developer must be able to understand business requirements, data and concepts. State government experience is a definite plus.
Responsibilities
Refine business requirements into technical requirements and specifications
Design and develop SSIS packages, database objects, tables, stored procedures and views
Performance tuning the stored procedures and T-SQL.
Communicate accurate and useful status updates
Manage and report time spent on all work activities
Data extraction from WSI SQL tables
Mapping of worksheets to import table supplied by BasicGov
Validated imported data
Build cross-reference SQL table to equate WSI data to new SQL data
Execute this process multiple times to verify all pertinent data is exported and imported
Support go-live
Analyze and digest business and technical requirements as provided by multiple sources
Analyze and develop mapping and translations between the data elements in client, carrier and payroll systems, interfacing with the Benefitsolver platform
Manage towards test plans with clients and carriers, testing the data exchange process end-to-end
Build import files from various data sources and execute the data import process end-to-end
Develop XML configuration files from Businessolver to carrier and payroll systems; coordinate and test ETL processes or EDI feeds with external vendors
Manage towards project plans and timelines based on assigned priorities
Communicate with all internal and external partners in a pleasant, professional manner and with an attitude that promotes Business partner’s goals and core objectives
Be a self-starter who has the ability to prioritize and execute.
Critical thinking skills and ability to solve problems; detail-oriented with a high degree of accuracy and follow through
Expertise with Excel; experience with Access, XML, JavaScript, ETL and text files a significant plus
Skill Required / Desired Amount of Experience
Solid experience with Microsoft SQL Server 2008 R2 and above Required 8 Years
Developing packages with SSIS Required 8 Years
Strong knowledge of XML, schemas Required 8 Years
T-SQL language (queries, views, procedures) Required 8 Years
SQL Reporting Services Required 8 Years
Strong analytical/mathematical and reasoning skills. Required 8 Years
Ability to work in a team environment Required 8 Years
Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision Required 8 Years
Strong written and verbal communication skills Required 8 Years
Large-scale data migration experience Required 8 Years
Data warehousing concepts Required 5 Years
Agile Methodology Desired
Understanding of RDBMS and Data Warehouse designs Desired
SQL Server database troubleshooting and query optimization Desired
SQL Server Database Design Desired