Job Details: Database Administrator 5


Job Title : Database Administrator 5
Job Ref No : 24481-1144
Job Posted Date : 5/15/2017
Job State : Michigan
Job City : Okemos
Who Can Apply : US Citizens, GC, EAD, TN, H1B
No of Openings : 1
Skills Required : ,

Job Description :


JOB ID: Database Administrator 5 (495999).
Years of experience: 5-10 years experience in the field.
Duration: 5/14/18 + possible extensions.
Number of positions: 1
Location: Okemos, MI (a suburb of Lansing)
Interviews: In-person interviews only.
Visa details: Open

JOB DESCRIPTION:
Relies on experience and judgement to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.
Years of Experience:
5 or more years of experience in the field.

This project is to refresh the current State of Michigan Workers Compensations System and supporting applications to updated technology and supported DTMB (Department of Technology, Management and Budget) standards. This includes updating the user interface, application and database. The project will be completed using ASP.NET, MVC 5, C# and SQL with an MS-SQL backend database. This resource, under State of Michigan direction, will be responsible for database work related to the solution. They will help to perform design and review tasks related to the WORCS web portal with focus on database, conversion and data synchronization. They will do initial data conversion between the current WORCS database (Mainframe) and the WORCS refresh database (SQ) using SQL server integration services. They will execute tasks as defined in the State of Michigans Project Management Methodology (PMM) as well as the Systems Engineering Methodology (SEM). The senior resource MUST take ownership of the database and associated processes. They will work with the architect and business analyst but will maintain responsibility for database integrity, synchronization across environments, performance and adherence to standards. This resource must also be proactive in improving the database, technical processes and customer relationships. Specific tasks may include, but are not limited to: Assist with the design of a highly available fault tolerant database infrastructure, assist with technical design activities, including optimizing data access for a web portal application, leveraging features in SQL to reduce latency and providing insights that could improve application performance, create and maintain application projects (ex. type of tables and indexes, partition types, keys, foreign keys/constraints, segment type and size etc.), create processes to replicate production databases (de-normalized to normalized), help with layout application schemas and database files, define and maintain database roles and permissions for application objects, develop and execute statistics collection plan for application objects depending on volume and type of queries (ex. timing of statistics collections, lock statistics, enable/disable HISTOGRAM, etc.), review back up policy with management and senior staff members and help suggest schedule/timings to avoid conflict with application processes, review SQL execution plans on critical application queries, help with application code testing during application releases or database upgrade/migration to avoid SQL performance issues, bulk data uploads, assist with infrastructure optimization and design, including identifying bottlenecks, improving responsiveness and reducing single points of failure, develop SQL server integration services packages to facilitate conversion of data from legacy system into SQL server relational database.

QUESTIONS:
Question: Absences greater than two weeks MUST be approved
by CAI management in advance, and contact information must
be provided to CAI so that the resource can be reached
during his or her absence. The Client has the right to
dismiss the resource if he or she does not return to work by
the agreed upon date. Do you accept this requirement?

Question: Please list candidates email address that will be
used when submitting E-RTR.

Question: Please tell me about a project that you worked on
where you were responsible for technical design activities,
optimizing data access for web portal applications and
leveraging features in SQL to reduce latency.

Question: What is your experience with both navigational
databases and relational databases?

Question: What experience do you have creating processes to
replicate production databases?

Question: Please include a paragraph re: candidates
availability, location, applicable skills, and other
pertinent information in the Summary of Qualifications tab,
when submitting. Thank you.

Question: In person interviews preferred.

Question: Candidate must have their own vehicle and cover
transportation/parking costs. Please confirm you have
discussed this with your candidate and he/she accepts this
requirement.

Are you Looking for a IT Training or IT Job?

Quick Apply this Job!

(doc, docx, rtf, pdf, txt were Acceptible)

quick Apply this job - It takes < 1 min to Apply!

Related Jobs

Unix / Linux Administration

Years of Experience:Total : 7+ Years of experienceRelevant : Minimum of 5 years in AIX/Linux Administr..

Mainframe Z/OS Engineer

• Excellent understanding of System z architecture• Strong experience with IBM z/OS operating system and subsystem ..

AS400 Developer

Job title: AS400 DeveloperLocation: Merrill, WI Mode of Hire: Full timeVisa Type: US Citizen/GC Holder<b..

Senior Business Intelligence Analyst

Senior Business Intelligence Analyst: This position will serve as technical lead on projects to design, develop, and QA ..

Oracle iStore Consultant

Position Title: Oracle iStore Consultant with JSP Position Type: Long-term Contract Location: Malvern, PA Job ..

Citrix Virtualization Consultant

• 3-5 years of experience in providing Citrix virtualization solutions. • 3-5 years of experience in Citrix virtuali..

Sr Teradata developer

Hi,Good Morning,Please go through the below requirement and send the matching resumes along with the bel..

Java Developer (Production Support B..

Job Description • Should be well Proficient in MDM Concpets, Core Java, SQL, UNIX Commands and TWS • Application suppo..

Java JBoss Developer

Job Title : Java JBoss Developer Location: Northbrook, IL Hire Type: FTE Only Visa Type: USC / GC / GC EAD Require..

Java Developer

• System knowledge around healthcare. Have good experience in Java, Spring, Hibernate, JDBC, Web Services...