SQL Server DBA

Integrated Resources Inc.; Southlake (TX); On-site; USD 85,000 - 120,000; Full time

Job summary

A leading staffing firm is seeking a SQL Server DBA to join their Commercial Data Systems team for a year-long engagement in Southlake, Texas. The ideal candidate will have extensive experience in database administration, strong organizational skills, and a commitment to high availability and service excellence.

Qualifications

• 5+ years of SQL Server DBA experience in an enterprise environment.
• Strong experience in monitoring and tuning SQL Server databases.
• Excellent organizational skills and ability to support multiple projects.

Responsibilities

• Maintain and optimize SQL Server databases.
• Provide on-call support on a rotational basis.
• Mentor other DBAs and document requirements for system designs.

Skills

SQL Server replication

Database optimization

Relational Database design

SSIS

SSRS

Communication

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server

Windows OS

MS Excel

MS Word

MS PowerPoint

MS Access

Job description

Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.

Job Description

Position: SQL Server DBA

Duration: 1 Year

Location: TX-500 W Dove Rd-Southlake (TX0549)

Direct Client: Immediate interview

Job Responsibilities

Planning, building, implementing, administering, and maintaining SQL SERVER databases in the Commercial Data Systems (CDS) organization. Builds and successfully integrates complex, multi-Terabyte OLTP databases with minimal supervision. Ensures optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring. Troubleshoots issues to resolution.

Maintains database security and enterprise policy guidelines according to best practices. Recommends new and improved guidelines to ensure high availability and stability

Works directly with internal customers to plan, evaluate, and design network databases in accordance with team and company standards. Conducts benchmark tests to gauge hardware capacity and meet application capacity requirements. Documents business and technical requirements. Creates technically viable, cost-effective system designs and develops customer-focused implementation strategies. Mentors other DBAs in the group.

Provides tasks and timelines to support the creation of project plans with appropriate updates for those tasks throughout the project lifecycle.

Performs On-Call duties as assigned on a rotational basis. Occasional overnight travel to other company work locations as required.

Qualifications

Minimum Bachelor’s degree in Computer Science, Electrical Engineering or other related degree, relevant military experience.

Sql Server DBA with 5+ years of SQL Expertise in SQLServer release 2008. At least 5 years of sql server DBA experience in an enterprise environment supporting all aspects of a sql server Database Server with emphasis on 2-tiered and 3-tiered architecture.

Experience in newer SQL Server releases/high availability solutions and release upgrades is strongly desired.

Strong experience in monitoring and tuning sql server databases for optimum performance and assistance in capacity planning of sql server database servers. Deep knowledge about Relational Database design and analysis; extremely proficient in SQL.

A minimum of 5 years of experience is required in the following skillset:

SQL Server replication

Setup bi-directional replication technology

Create and maintain table partitions

Ensure changes are deployed without impacting replication.

Design, develop and maintain SSIS packages and SSRS reports

Windows operating system and storage to be able to design high performance environment

SQL development including package/ procedure/ trigger/ XML/scripting development in a multi-user production environment.

Development experience in either development environment or automation of production activities would be a plus.

Must possess excellent organization skills.

Must be able to prioritize and support multiple concurrent projects with inputs from multiple groups.

Able to work independently with accuracy and attention to detail.

Proficiency with MS Excel, Word, PowerPoint, and Access.

Must have the ability to function in a tight knit team environment and must be willing to work Change Control Windows on a very regular basis.

Must be willing to challenge yourself with regard to learning new applications as well as new Oracle components that support new platforms on fairly short timelines.

Must have strong verbal and written communication skills.

Must be able to work independently with accuracy and attention to detail.