Key skills
AzureCloudSQLData LakeAnalyticsAzure DevOpsAzure SQLVersion ControlAgileCommunicationCollaboration
About this role
Role Overview
- Design and implement robust data models to support application and business requirements, ensuring scalability and efficiency.
- Define and maintain database schemas, ensuring proper structure and adherence to best practices.
- Develop and optimize indexing strategies to enhance query performance and database efficiency.
- Manage data ingestion processes, ensuring seamless integration of data from various sources into the database.
- Oversee data export processes to support reporting, analytics, and external system integration needs.
- Act as the primary owner of all database systems, ensuring their reliability, security, and performance.
- Review and validate database-related work committed by other team members to ensure quality, consistency, and adherence to standards.
- Provide mentorship and guidance to team members on database design, development, and optimization practices.
- Establish and enforce database governance policies, including naming conventions, documentation, and access controls.
- Monitor and analyze database performance, identifying and addressing bottlenecks or issues proactively.
- Design, develop, and maintain complex SQL stored procedures to support application development and data processing.
- Perform performance tuning and optimization of SQL queries and databases to ensure efficient data retrieval and processing.
- Integrate with Azure Data Lake Storage (ADLS) for seamless data storage and retrieval.
- Manage and maintain Azure SQL databases, ensuring high availability and security.
- Implement data lake integration strategies to support data analytics and reporting needs.
- Develop and manage Azure Data Factory (ADF) pipelines for data movement and transformation.
- Oversee database management and sharding concepts to ensure scalability and performance.
- Utilize SQL dacpac projects for streamlined database deployment and version control.
- Manage deployment pipelines using Azure DevOps, ensuring smooth and efficient release processes.
- Coordinate and manage production deployments, providing support and troubleshooting as needed.
- Collaborate with cross-functional teams in an agile development environment to deliver high-quality solutions.
- Provide ongoing support and maintenance for database systems, addressing issues and implementing improvements.
- Stay updated with the latest industry trends and best practices in database management and cloud technologies.
- Act with integrity, professionalism, and personal responsibility to uphold the firm’s respectful and courteous work environment.
Requirements
- Proven experience as a SQL Developer/DBA with expertise in stored procedures and performance tuning.
- Strong knowledge of Azure SQL, ADLS, and data lake integration.
- Experience with Azure Data Factory and pipeline management.
- Familiarity with database sharding concepts and practices.
- Proficiency in using SQL dacpac projects for database deployment.
- Experience with Azure DevOps for managing deployment pipelines.
- Strong problem-solving skills and attention to detail.
- Excellent communication and collaboration skills in an agile development setting.
- Ability to manage multiple tasks and projects simultaneously, meeting deadlines and ensuring quality.
- Any Microsoft Azure certification is a plus.
Tech Stack
- Azure
- Cloud
- SQL