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

. 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