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