Responsibilities
- Design and implement database architectures with hands-on management and administration.
- Create scalable Azure SQL solutions tailored to application demands.
- Evaluate and suggest optimal database structures based on workload, concurrency, and data size.
- Execute large-scale database migrations using Azure Database Migration Service (DMS).
- Manage and optimize handling of large data volumes efficiently.
- Restructure database schemas to improve performance and scalability.
- Apply trade-offs between normalization and denormalization, and implement partitioning and archiving strategies.
- Establish data lifecycle management policies and practices.
- Develop solutions for systems with high concurrency and bursty workloads.
- Advise on compute models including vCore vs DTU, serverless vs provisioned, and elastic pooling.
- Assess current resource usage and design appropriately sized compute tiers with auto-scaling capabilities.
- Suggest serverless options for irregular workloads and optimize elastic pool resources based on I/O patterns.
- Build integrations with Azure Data Factory, Synapse Analytics, and event-driven pipelines using Event Hub or Service Bus.
- Ensure fast and efficient data transfer with minimal latency across systems.
- Implement CI/CD pipelines for automated database deployments.
- Handle database provisioning, configuration, and version upgrades.
- Utilize monitoring tools such as Azure Monitor, Log Analytics, and Query Performance Insight.
- Diagnose and resolve database issues including connectivity, performance, and failures.
- Evaluate and enhance query performance, particularly stored procedures and slow-running queries.
- Develop and apply effective indexing strategies to improve data access speed.
- Track and analyze resource consumption including CPU, memory, and I/O usage.
- Tune database configurations to balance cost efficiency and performance.
- Create and document business process models showing current and target states.
- Examine data to uncover trends, patterns, and actionable insights for decision-making.
- Design and propose technical and procedural solutions aligned with business goals.
