Anderraytinq və təkrarsığorta üzrə mütəxəssis

You will lead the technical direction of the Ateshgah Insurance mobile application (Flutter), guiding the team through architecture decisions, code quality standards, and production delivery — while actively contributing code and mentoring junior developers.

Key Responsibilities System Administration & Support: Manage, monitor, and maintain our on-premise infrastructure, including VMware vSphere clusters, Windows Servers, and Linux servers. Core Services Management: Administer and ensure the high availability of critical services such as Microsoft Active Directory, MS Exchange, and HAProxy. Data Protection: Oversee and manage backup and recovery operations using Veeam Backup & Replication. Cloud Migration: Actively participate in the "lift-and-shift" migration of on-premise virtual machines and applications to cloud. Application & Collaboration Tools: Manage and provide support for corporate systems like Jira, Confluence, and an on-premise instance of Bitrix24 or Creatio CRM, including data migration and user administration tasks. Documentation: Create and maintain comprehensive documentation for all managed systems, configurations, and operational procedures. Troubleshooting: Serve as an escalation point for complex infrastructure-related issues, providing timely resolution and root cause analysis. IT Projects: Leading the IT projects like Bitrix24/Creatio integration, VM migrations, on-premises to cloud and back migrations, etc.

Responsibilities Develop high-quality database solutions using MS SQL Server. Write and optimize complex T-SQL queries, stored procedures, and functions. Analyze and improve performance of existing SQL queries. Investigate and resolve locking/blocking issues in the database. Monitor and tune query execution using execution plans and performance metrics. Design and maintain optimal indexes; regularly review and adjust indexing strategies. Analyze application-side queries to ensure efficient interaction with the database. Perform data analysis to support application and business logic. Collaborate with developers and system analysts to improve database structure and performance. Document database logic, procedures, and data models. Maintaining specifications with Confluence, draw.io, MD, etc. Requirements Bachelor’s degree in Computer Science, Engineering, or related field. Minimum 2–3 years of hands-on experience as an SQL Developer. Advanced knowledge of T-SQL and Microsoft SQL Server internals. Strong experience with query tuning and execution plan analysis. Deep understanding of index design and maintenance strategies. Ability to identify and resolve performance bottlenecks, blocking, and deadlocks. Solid knowledge of database normalization and schema design. Familiarity with version control tools (e.g., Git). Language skills: Fluency in Azerbaijani, English (B2), Russian (B1).