Azure Data Engineer

Overview

Our Culture & Values: -

We’d describe our culture as human, friendly, engaging, supportive, agile, and super collaborative.

At Kainskep Solutions, our five values underpin everything we do; from how we work, to how we delight and deliver to our customers.

Our values are: -

#TeamMember #Ownership #Innovation #Challenge and #Colloboration

What makes a great team? A Diverse Team!

Don’t be put off if you don’t tick all boxes; we know from research that candidates may not apply if they don’t feel they are 100% there yet; the essential experience we need is the ability to engage clients and build strong effective relationships. If you don’t tick the rest, we would still love to talk.

We’re committed to creating a diverse and inclusive.

Key Responsibilities

Database Performance Tuning and Optimization :

• Analyze and optimize SQL queries, stored procedures, and indexes to improve database performance and execution times.
• Conduct execution plan analysis and resolve performance bottlenecks, deadlocks, and concurrency issues.
• Implement and maintain efficient indexing strategies to ensure quick data retrieval and responsiveness.

Monitoring And Maintenance

• Set up and maintain database monitoring solutions using Azure Monitor, SQL Profiler, Query Store, and other tools to identify and resolve issues proactively.
• Oversee regular maintenance tasks, such as backups, restores, index maintenance, and integrity checks, to ensure database hygiene.
• Monitor database health, performance, and capacity to ensure uptime and scalability.

Cost Management And Optimization

• Evaluate database resource usage and optimize workloads to reduce Azure SQL costs, including resizing databases, consolidating workloads, and optimizing queries.
• Implement strategies to control database provisioning costs and scale resources efficiently based on workload patterns.

High Availability And Disaster Recovery (HA/DR)

• Design, implement, and maintain HA/DR solutions, such as Always On Availability Groups, geo-replication, and failover clusters, to meet uptime and recovery SLAs.
• Develop and test backup and recovery procedures to ensure business continuity.
• Collaborate with engineering teams to minimize downtime during upgrades, migrations, or maintenance activities.

Security And Compliance

• Implement database security best practices, including role-based access control (RBAC), Transparent Data Encryption (TDE), and data masking.
• Ensure compliance with regulatory standards such as GDPR, SOX, and other relevant frameworks.
• Monitor and audit database activity to identify and resolve unauthorized access or security vulnerabilities.

Qualifications

Education: Bachelor's degree in Computer Science, Information Technology, or a related field.

Experience

• 1-3 years of experience as a SQL Server DBA, with a focus on Azure SQL Database and SQL Server Managed Instances.
• Proven expertise in tuning and optimizing queries, stored procedures, and indexing for performance.
• Strong experience with Azure database services, including monitoring, cost optimization, and scaling.
• Hands-on experience designing and implementing HA/DR solutions for critical business applications.

Technical Skills

• Advanced proficiency in managing and optimizing Azure SQL Database and SQL Server (2012/2014/2016/2019).
• Performance Tuning: Strong knowledge of execution plans, query optimization, and index strategies.
• Proficient with Azure Monitor, Log Analytics, Azure Automation, and Application Insights.
• Hands-on experience with T-SQL, PowerShell, and automation scripts.
• Monitoring & Troubleshooting: Expertise with tools such as SQL Profiler, Query Store, and Extended Events.
• Familiarity with TDE, RBAC, and auditing features.
• Knowledge of Always On Availability Groups, geo-replication, and log shipping.

Soft Skills

• Problem Solving: Strong analytical and troubleshooting skills to address database challenges.
• Communication: Excellent verbal and written communication skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
• Organization: Ability to manage multiple priorities and deliver high-quality results in a fast-paced environment.
• Attention to Detail: Focused on maintaining database health, security, and compliance.

Preferred Qualifications

• Experience in financial services or other highly regulated industries.
• Familiarity with modern DevOps practices, such as CI/CD pipelines for database changes.

Certifications Such As

• Microsoft Certified: Azure Database Administrator Associate.
• Microsoft Certified: Azure Solutions Architect Expert (preferred but not required).

Job Type: Full-time

Pay: Up to ₹80,000.00 per month

Benefits:

• Flexible schedule
• Paid sick time

Schedule:

• Monday to Friday

Experience:

• Microsoft SQL Server: 1 year (Required)

Location:

• Jaipur, Rajasthan (Required)

Work Location: In person

Expected Start Date: 01/04/2025