SQL Server - Azure Database Developer

Key Responsibilities:

1. Database Design and Development:

6.Cloud Platform Expertise:

Desired Skills:

• Writing complex queries, stored procedures, functions, and triggers, along with expertise in performance tuning, indexing, and query analysis.
• Understanding relational database principles, data modeling, normalization, and schema design for efficient and scalable databases.
• Experience with Extract, Transform, Load (ETL) processes and data integration techniques, potentially using tools like Azure Data Factory or SQL Server Integration Services (SSIS).
• Database Administration and Security
• Knowledge of database security best practices, user management, backup and recovery strategies, and monitoring database health and performance.
• Azure SQL Database - In-depth understanding of Azure SQL Database, including deployment options (single database, elastic pools, Hyperscale, serverless), performance tiers, and scaling.
• Azure Data Platform Services - Familiarity with other relevant Azure data services like Azure Synapse Analytics, Azure Cosmos DB, Azure Data Lake Storage, and Azure Data Factory.
• Azure Networking and Security - Understanding of Azure networking concepts for secure database connectivity and implementing security features like firewalls, virtual networks, and private endpoints.
• Azure Tools and Management - Proficiency in using Azure Portal, Azure CLI, Azure PowerShell, and Azure Data Studio for managing and interacting with Azure SQL databases.
• Cloud Development Practices - Experience with developing data-driven applications in a cloud environment, including understanding of REST APIs, application authentication/authorization, and integration with Azure compute services.
• Ability to monitor Azure SQL Database performance using Azure Monitor and troubleshoot database-related issues within the Azure environment.Preferred:Microsoft Certified: Azure Database Administrator Associate

Personal Skills:

• Excellent analytical and problem solving skills
• Excellent verbal and written communication skills
• Ability to articulate and present different points-of-views on various topics related to project and otherwise.
• Eager to learn and continuously develop personal and technical capabilities.

Required Qualifications:

• MCA or Bachelors in Engineering, Computer Science or equivalent.