Database Administrator (DBA)

posted:
Location
Lafayette, Louisiana
Industry
Information Technology
Job Type
Temporary
Salary
US$ 25.22 - US$ 36.57 per hour, DOE
Ref. Number
z00004MG7
Contact
Maurie White, Spherion
Phone
337-269-0508
Apply Now

Job Description

Spherion is recruiting for a Database Administrator (DBA) for a large company in Lafayette.
This position is  temporary, lasting 3-6 months.  
Essential Functions
 ·         Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
 ·         Configure SQL Server monitoring utilities to minimize false alarms
 ·         As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
 ·         Install and configure new SQL Servers
 ·         Deploy database change scripts provided by third party vendors
 ·         When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
·         Conduct SQL Server lunch-and-learn sessions for application developers
 ·         Document the company’s database environment
·         Ensure that new database code meets company standards for readability, reliability, and performance
 ·         Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
 ·         Design indexes for existing applications, choosing when to add or remove indexes
·         When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
 ·         Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
 ·         Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)

Apply online at www.SpherionLA.com then call the office at 337-269-0508.

Skills

Experience should include:
 ·         On-call troubleshooting experience with at least one production SQL Server for a year. You don’t have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working.
 ·         Finding DMV queries to answer questions about server-level performance
·         Writing and improving SQL Server T-SQL queries for at least a year. You may have technically had “C# Developer” or “Java Developer” on your job title, but you were known amongst the office as the go-to person for T-SQL questions.
 ·         Designing tables and picking data types
 ·         Tuning T-SQL queries to improve performance
 ·         Using Profiler traces and other tools to find the most frequently run queries

Qualification

Qualifications
Education Bachelor's Degree in Computer Science, Information Systems, or other related field. 
Or equivalent work experience.
Experience
Four to six years in systems analysis/programming experience.
ETL and EDW experience .

Apply Now