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