SQL DBA

Our client in the Cleveland area has an immediate need for a SQL DBA.  This is a 3-6 month project that could get extended.

JOB TITLE

The SQL Server DBA is responsible for all database administration functions.   

The candidate will collaborate with a cross-section of internal organizations, including application developers and business analysts, as well as external software vendors, to complete all project milestones within established timelines.  The candidate must be able to analyze, troubleshoot and solve technical issues in a highly visible, mission critical environment.  An emphasis is placed on skills such as installation and customization of packaged applications, database protection strategies, hardware and storage capacity planning, and maintaining application response time in a high volume and high concurrency system.

TECHNICAL EXPERIENCE/SKILLS REQUIRED

3 - 5 years experience working with SQL Server database technologies.

Good understanding of SQL Server architecture, instances and databases.

Experience with Log Shipping, Mirroring, and High Availability (Failover Clustering).

Experience with implementing and supporting maintenance plans.

Experience using SQL Profiler to diagnose and resolve response time issues.

Experience with activity monitoring, session management, ODBC connectivity.

Experience with implementing and supporting SQL, SSIS.

Experience with Transact-SQL.

Working knowledge of key Windows packages and utilities including SSMS.

Performance monitoring and tuning of development, test and production environments including identification and tuning of poor-performing application code and/or database configuration.

Identify and automate regular database and application maintenance tasks.

Work with Developers, System and Network administrators to support and improve system performance and stability.

Create schemes, tables, procedures, permissions and indexes.

Monitor systems and platforms for availability.

Oversee backups, clustering, mirroring, replication and failover.

Restore and recover corrupted databases.

Refresh development databases from production databases.

Install and test upgrades and patches.

Work with vendor support on technical issues. 

NON-TECHNICAL SKILLS REQUIRED

Strong analytical, conceptual, and problem-solving abilities.

Strong written and oral communication skills.

Ability to present ideas in user-friendly language.

Able to prioritize and execute tasks in a high-pressure environment.

Experience working in a team-oriented, collaborative environment.

The positions requires flexible work hours to accommodate scheduled off-hour installations and support.