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