İşin təsviri
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).
Tələblər
Skills
- Advanced SQL development (T-SQL).
- Performance tuning and execution plan analysis.
- Locking and blocking investigation and resolution.
- Index optimization and monitoring.
- Stored procedures, views, functions.
- Strong analytical and problem-solving skills.
- Effective collaboration and communication abilities.
- Clean and structured technical documentation habits.
Nice to Have
- Exposure to NoSQL/NewSQL technologies.
- Experience with Azure SQL or cloud-based DB environments.
- Familiarity with DevOps/CI pipelines involving databases