Senior SQL Database Administrator

This position is responsible for the planning, design and engineering of the Company's RDBMS environment (Microsoft SQL Server); acts as technical resource and as technical advisor to the development group; responsible for the tracking and resolution to SQL related problems and the communication of status to appropriate individuals; responsible for the stability of the Company's SQL replication model; manages the development of preventative maintenance procedures and methods; consults with development group on a variety of issues and provides support as required.

DUTIES & RESPONSIBILITIES

Database Architecture & Engineering:

Design, plan, and engineer the Company's Microsoft SQL Server environment

Implement and maintain SQL replication models for data accuracy

Develop stored procedures, triggers, views, and other SQL objects

Perform code reviews for all SQL changes

Performance & Optimization:

Optimize database performance through indexing, query tuning, and configuration

Design and test SQL Server business continuity plans

Establish connectivity and access standards for SQL environments

Standards & Documentation:

Create installation/software implementation standards for SQL systems

Develop preventative maintenance procedures and methods

Document database architectures and troubleshooting guides

Collaboration & Support:

Act as technical advisor to development teams

Resolve SQL-related problems and communicate status updates

Consult on development projects requiring database expertise

REQUIREDQUALIFICATIONS:

Knowledge and Skills:

Technical Expertise

Microsoft SQL Server (2012+ including Availability Groups)

Transact-SQL programming (stored procedures, triggers, views)

Replication, linked servers, and backup strategies

ODBC/MDAC connectivity

Windows Active Directory/SQL security integration

DB2 SQL/400 (preferred)

Soft skills

Excellent verbal/written communication

Strong technical analysis and problem-solving

Ability to work independently and collaboratively

Education and Experiences:

Required:

Bachelor's degree

5+ years as Microsoft SQL Database Administrator

Experience designing/implementing complex SQL projects

#J-18808-Ljbffr