Краснодар
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.