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

DBA Web TechnologiesSouthbury, CT

job_description.job_card.30_days_ago

serp_jobs.job_preview.job_type

serp_jobs.job_card.full_time

job_description.job_card.job_description

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

serp_jobs.job_alerts.create_a_job

Database Administrator • Southbury, CT