Senior Database Developer

Job Purpose

As Senior Database Developer, you will provide technical leadership and management of production and development servers for an Application Development Team that supports an MGA business (7+- developers, 10+ BA/ QA, and 10+ application systems). Requires DevOps and SQL Server technical experience. Must have strong analytical and communications skills and able to work well in an agile team environment.

Essential Duties and Responsibilities

• Expertise in Database development, advanced TSQL, Stored Procedure, views, etc.
• Strong knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
• Performance tuning and optimization (PTO), using native monitoring and troubleshooting tools.
• Troubleshooting and resolving database problems.
• Experience managing database backups, restores, and recovery models.
• Experience implementing operational automation using scripts (especially Powershell).
• Strong knowledge of indexes, index management, and statistics.
• Knowledge of implementing security in classified databases.
• Windows server experience, including Active Directory and proper disk configurations.
• Good communication and documentation skills.
• Strong knowledge of SSIS and SSRS
• Strong knowledge of Data warehouse architectures and implementations
• Strong knowledge of Data Mart implementations

Key Responsibilities/Essential Functions

• Manage SQL Server and Cache databases through multiple product life-cycle environments, from development to mission-critical production systems in accordance with established IT policies and procedures.
• Develops and promotes standard operating procedures, evaluates new systems and ensures that all current systems are configured in compliance with applicable security standards (e.g. HIPAA, HITRUST, ISO 27001/ISO 27799).
• Proactively engages with IT leadership to recommend enhancements and mitigate risks within the environment.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Assist developers with complex query tuning and schema refinement
• Design and implement procedures for monitoring, configuration management and reporting functions
• Ensure compliance with applicable security standards and requirements
• Conduct Disaster Recovery planning and testing
• Assist with hardware and software evaluations
• Define and document best practices and support procedures
• Develop and implement project plans, risk assessments and contingency plans
• Provide after-hours support for infrastructure related emergencies as well as occasional weekend maintenance
• Provide end-user support and training as needed

Qualifications and Education / Preferred Skills

• 8 - 10 years of experience in IT operations with a strong understanding of database structures, theories, principles, and practices.
• 8 - 10 years Microsoft SQL Server Experience.
• Hands-on experience with SSDT, Visual Studio, and VS Code.
• Certifications a plus; MCSA, MCSE, MCITP, MVP.