Job id : MI-571452 (98590809)
SQL DBA with SSIS, SSRS and performance tuning Experience
Location: 7285 Parsons Drive, Lansing, MI. 48933 (DEQ, DNR, MDARD)
Duration: 12 months
Interview – Either Webcam or In Person
U S. Citizenship is required for this position
SkillRequired / DesiredAmountof Experience
experience as a SQL DBA on a large scale database.Required5Years
experience working with SQL database used by both front end web application and thick client.Required5Years
experience with SSIS and SSRSRequired5Years
experience in database performance tuning.Required5Years
experience monitoring SQL databases, developing databases, troubleshooting issues, and setting databases upRequired5Years
DBA role – not developer – for greater than 5 yearsRequired5Years
Position Description:
This analyst is responsible for the logical design and physical implementation of the applications, backups, disaster recovery, space allocation, object design and all other areas of database design, implementation, maintenance and construction. This includes database software configuration, database software installation and upgrades and supporting procedures and utility programs that run on servers for data processing and database updates. This position analyzes business processes and designs solutions through data modeling, process modeling, and event modeling techniques. They review requirements, design documents and write design documents when necessary. They will work with program/project managers, development managers, team leads and business area experts to provide estimates. This position will work closely with the Software Architect, Project Management, other database administrators (DBA)’s, Software Developers and Quality Assurance (QA) to coordinate product releases, data structure evolution, capacity planning and forecasting. They will be responsible for upgrading Structured Query Language (SQL) databases and applications to next supported level and move the applications and databases to the next levels, diagnose database and application performance issues and coordinate resolution with tech personnel, programming analysts, & software designers. This position will support multiple applications using a SQL/Server Database. MDOS has several red card applications that depend on SQL Server databases to be functioning correctly. There are vendor systems that the State hosts the SQL database – this position will work with vendors from time to time on support of their databases.