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?