Job ID :
4096
Company :
State of Iowa
Location :
des moines, IA
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
5 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

 

 

Complete Description:

 

The Database Administrator (DBA) is responsible for data analysis and database management. DBAs are typically involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. DBA’s have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team. DBAs must be able to work in a team environment, follow quality standards and have strong written and verbal communication skills. DBAs coordinate physical changes to computer data bases; and codes, tests, and implements physical data base, applying knowledge of data base management system: Designs logical and physical data bases reviews description of changes to data base design to understand how changes to be made affect physical data base (how data is stored in terms of physical characteristics, such as location, amount of space, and access method). Establishes physical data base parameters. Codes data base descriptions and specifies identifiers of data base to data base management system or directs others in coding data base descriptions. Calculates optimum values for data base parameters, such as amount of computer memory to be used by data base, following manuals and using calculator. Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data. Specifies which users can access data bases and what data can be accessed by user. Estimates time and cost required to accomplish project.   Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. May train users.

 

           

7 or more years of experience.  These consultants are recognized as top professionals in their chosen field and may be considered "Guru" subject-matter experts in IT Professional Services.  Individuals possess multiple years of experience and are extremely competent and will typically hold advanced education degrees or certifications such as a Microsoft Certified Programmer Certified Business Analyst Professional (CBAP) or Project Manager Professional (PMP).  *These advanced degrees and certifications may substitute, at the sole discretion of the State, for experience at this skill set level, and for this skill set level only.  They have worked on multiple critical projects; have demonstrated the judgment to plan and accomplish goals; perform a variety of complicated tasks, and may lead and direct the work of others. This expert may report directly to Director or CIO level management; a wide degree of creativity and latitude is expected. 

 

Responsibilities:

•Experience and knowledge in supporting application system development life cycle.

•Perform performance tuning.

•Monitor database performance and space requirements.

•Communicate accurate and useful status updates.

•Manage and report time spent on all work activities.

•Ability to work in a team environment

•Analyze the current transactional database designs to determine needed improvements

•Document and standardize data structures, procedures and processes

•Ability to comprehend complex technical and logical concepts and adapt quickly to changes

•Strong quantitative, analytics, problem solving, organizational, communication and interpersonal skills are required

•Attention to detail and maintaining high quality standards is a must

•Ability to prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision

•Strong written and verbal communication skills

•Mentor and coach peers

•Provide knowledge transfer to peers

 

 

Skills:

Skill

Required / Desired

Amount

of Experience

 

SQL DBA experience with 2005/2008/2012

Required

7

Years

T-SQL & ANSI SQL

Required

7

Years

Large-scale data migration experience

Required

4

Years

Server optimization, fine-tuning

Required

4

Years

SQL Reporting Services

Required

4

Years

Disaster Recovery/Replication

Required

4

Years

Data Warehousing concepts

Required

3

Years

Architecture Planning experience

Highly desired

 

 

SSIS and SSAS Experience

Highly desired

 

 

Experience with Sharepoint DB's

Desired

 

 

MySQL/PostgreSQL

Desired

 

 

SQL SERVER database troubleshooting and query optimization

Desired

 

 

SQL SERVER Database Design

Desired

 

 

SQL SERVER Stored Procedure Design and implementation

Desired

 

 

SQL SERVER Database Performance monitoring

Desired