Job ID :
1211
Company :
State of Delaware
Location :
new castle, DE
Type :
Contract
Duration :
6 Months
Status :
Active
Openings :
1
Posted :
6 years ago
Job Seekers, Please send resumes to resumes@hireitpeople.com or Call: (202) 719-0200 Ext: 127

Short Description:

This Database Administrator is responsible for administration of production, test and development databases.

 

Complete Description:

The Database Administrator is responsible for data analysis and database management. Database Administrators typically are involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Database Administrators have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team.

 

DBA

Years of Relevant Experience: 3 to 5 years

Preferred Education:  4 year college degree or equivalent technical study

Role Description:

All roles specified  plus the following:

•Business systems analysis and design experience.

•Logical data modeling techniques.

•Production environment Tools/Utilities.

•Knowledgeable in data analysis and database management techniques.

•Execution of all responsibilities with little direct supervision of Team Lead.

•Administration and scripting experience in SQLServer 2008 (r2 is preferable)

•Supervise performance tuning.

•Author shell scripts to perform back up, restore, and monitoring tasks.

•Anticipate and resolve issues specific to the team.

•Determine time estimates and schedule for own work and resolve issues in a timely manner.

•Identify and track issues, risks and action items.

• Experience with SQLServer 2008 or higher in a Microsoft Cluster environment

• Experience with Microsoft Team Foundation Server

• A solid understanding of Multi-tiered Application environment

• An understanding of firewall concepts.

 

• Work hours are 8:00 AM to 4:30 PM Monday to Friday.

 

• May need to travel within the State of Delaware at their own expense.

 

• Ability to flex schedule or work overtime as work load dictates.

 

• Should possess strong organizational and management skills and be able to apply them while working on a large complex technical assignment. 

 

• Must be able to communicate effectively both written and verbally.

 

• Must be able to work with a team but also take initiative on their own.

 

This is an ongoing position that will run at least until the end of the fiscal year.

 

Skills:

Experience with Administration of SQL Server 2008

Required 5 Years

 

Experience with SQLServer 2008 in a Microsoft Cluster Environment

Required 2 Years

 

Work as a Production DBA

Required 3 Years

 

Work as a Development DBA

Required 3 Years

 

Work as a Test DBA

Required 2 Years

 

Experience with SQL Server 2008 R2

Highly desired 2 Years

 

Experience with Microsoft Team Foundation Server

Highly desired 2 Years

 

Experience migrating from DB2 to SQL Server 2008 and above

Highly desired 2 Years

 

Prior work with Data Validation/compare tools

Highly desired 2 Years

 

Experience or exposure with SQL Server 2012

Desired 1 Years

 

Experience with Red Gate - Data Compare Tools

Desired 1 Years

 

Questions:

Question 1

Is the candidate able to attend a round one, in-person interview?

 

Question 2

If applicable, where has the candidate functioned as a DBA during a migration from DB2 to SQL Server?

 

Question 3

Where has the candidate worked with Data Compare tools? Which products were used?

 

Question 4

Where did the candidate gain knowledge of SQL Server 2012

 

Question 5

Over the last 5 years, what is the percentage breakdown of the candidate's work as a Production/Test/Development DBA?