SQL Server Database Administrator (T-SQL, Tuning, Stored Procedures, Database Design, Logical DBA) in Fairfield, Iowa

SQL Server Database Administrator (T-SQL, Tuning, Stored Procedures, Database Design, Logical DBA) in Fairfield, Iowa

Query Optimization, SQL, SQL Server DBA, SSIS, SSRS, stored procedures, T-SQL, Tuning

Location: Iowa

Job Function: Database Administration

Date Of Job Posting: 09-02-2017

SQL Server Database Administrator (T-SQL, Tuning, Stored Procedures, Database Design, Logical DBA) in Fairfield, Iowa

Position: SQL Server Database Administrator (T-SQL, Tuning, Stored Procedures, Database Design, Logical DBA)
Location: Fairfield, Iowa
Duration: Full-Time Permanent positions (no contracts, no corp to corp, no remote)
Salary: Excellent Compensation with benefits + relocation + interview travel
SKILLS: SQL Server DBA, Logical DBA, Database Design, T-SQL, Stored Procedures, Replication, SSIS, SSRS, IIS, XML, SQL Server Performance Monitoring tools, OLAP

DESCRIPTION:

Summary of Job Responsibilities:

Assist with the department’s mission including implementing improved reliability, availability and security; major functional enhancements to application software; daily operational support; as well a technical re-design to migrate to SQL Server 2016.

Essential Duties and Responsibilities:

The Database Administrator will provide key technical skills in support of our database administration, including:

• Support, administer, and maintain production, testing, and development SQL Server environments.
• Provide 24x7-production support. Support responsibilities are rotated among the members of the Production Support team.
• Data modeling for new and existing distributed and replicated SQL Server databases; administration of enterprise data dictionary.
• Work with SCRUM teams to provide support for database deployments and upgrades.
• Administer SQL Server security and protect sensitive data
• Create and maintain SQL Server Integration Services (SSIS) packages.
• Review, deploy, and administer security for SQL Server Reporting Services (SSRS) reports.
• Design, implement and monitor optimal backup strategies for each database to achieve maximum required data protection.
• Participate in peer code reviews and design reviews.
• Administer database configuration controls for development, test, demo and production environments.
• Monitor and report on SQL Server database performance, backups, security, errors; validate database restore procedures; provide emergency system restore support.
• Design and implement automated data ETL processes
• Perform ad hoc queries per user requests
• Identify data integrity issues; convert data to more normalized and structured models.
• Provide coordination and programming leadership for other database designers and programmers.
• Document data integration processes and database configurations

Professional Experience:

Very strong experience required in:

• Relational database design;
• MS SQL Server administration;
• T-SQL programming with complex stored procedures and triggers
• Experience desired in SharePoint, Replication, SSIS, SSRS, IIS, XML, SQL Server Performance Monitoring tools, OLAP

Education/Experience:

BS Degree in Computer Science or equivalent experience
AND:
1. For Intermediate level: 4+ years related experience
2. For Senior level: 8+ years related experience

Ideal Candidate:

• Candidate MUST relocate to Fairfield, Iowa or be located in Fairfield, Iowa and MUST work onsite.
• Must have experience in SQL Server as a DBA
• SQL Certifications and Microsoft Certified is a plus!
• Prefer Logical DBA background (versus. Physical DBA)
• Ideal candidate will have very strong experience in relational database design, MS SQL Server administration, TSQL programming with complex stored procedures and triggers
• Be available for on call rotation - 1 week every 3 months
• MUST be self-directed and interested in database systems and have the ability to work in a fast-paced environment and multitask
===========================================================

Apply for this job