Tech Stack
AzureCloudETLMongoDBMS SQL ServerNoSQLSQLSSIS
About the role
- Develop, deploy, and maintain SQL databases ensuring performance and security across platforms.
- Design, develop, and maintain SQL databases to ensure optimal performance, availability, and reliability.
- Perform routine database administration tasks, including upgrades, backups, and recovery processes.
- Optimize and tune database systems for enhanced performance.
- Implement and configure robust database security measures.
- Collaborate with development teams to design effective schema and manage development of stored procedures, functions, and triggers.
- Lead and participate in projects requiring database solutions, ensuring adherence to industry best practices.
Requirements
- Experience in Agile/Scrum environments.
- Advanced SQL programming and optimization.
- Experience with Microsoft SQL Server, including stored procedures, functions, triggers, temporal tables, and versioned data handling.
- Proficiency in Azure SQL Database development, deployment, and maintenance.
- Expertise in ETL processes and tools (e.g., SSIS, Azure Data Factory) and integration between heterogeneous systems (on-prem/cloud).
- Strong understanding of dimensional modeling fundamentals and data warehousing concepts and implementation.
- Knowledge of SQL development best practices: code modularity, performance tuning, indexing strategies, error handling, and transaction management.
- Strong communication and stakeholder management skills.
- Proficient in analytical thinking and problem-solving.
- Well-organized in documentation and knowledge sharing.
- Nice to have: Power BI (ETL Dataflows, data modeling, DAX, reporting), CI/CD/DevOps for databases (Azure DevOps), Infrastructure as Code for DB provisioning, NoSQL (Cosmos DB, MongoDB), security & compliance awareness (encryption, access control, GDPR), performance monitoring tools (SQL Profiler, Extended Events, Query Store).