
KEY RESPONSIBILITIES
• Design, implement, and maintain relational and NoSQL databases to support enterprise-grade applications.
• Develop and optimize complex T-SQL queries, stored procedures, and indexes to handle high transactional workloads.
• Work with software engineers to design database schemas aligned with business requirements and application logic.
• Ensure high availability, performance, and scalability of database components across environments (on-prem and Azure).
• Implement best practices for data modeling, indexing, partitioning, and concurrency handling.
• Configure and manage Azure SQL Database and on-premises SQL Server instance.
• Integrate and manage NoSQL solutions, with a preference for Azure Cosmos DB.
• Participate in code reviews, design discussions, and performance troubleshooting sessions.
• Develop and maintain database scripts, schema migration files, and deployment scripts using CI/CD pipelines.
• Collaborate with DevOps engineers to automate database deployments and monitoring.
REQUIRED QUALIFICATIONS
• 5+ years of experience in data engineering or back-end database development.
• Strong hands-on experience with Microsoft SQL Server and Azure SQL Database.
• Expert-level knowledge of T-SQL, query optimization techniques, and transaction handling.
• Experience with high-throughput, high-concurrency applications and systems.
• Practical experience with at least one NoSQL database, preferably Cosmos DB; MongoDB or others also acceptable.
• Strong understanding of database normalization, denormalization, indexing strategies, and schema design.
• Familiarity with CI/CD tools like Azure DevOps, Git, and database deployment pipelines.
• Solid understanding of data access patterns in software systems.
• Strong communication, documentation, and troubleshooting skills.