Job
Description
Job Title: SQL Database Architect (SQL Server, Azure SQL Server, SSIS, SSRS, Data Migration, Azure Data Factory, Power BI) Job Summary: We are seeking a highly skilled SQL Database Architect with expertise in SQL Server, Azure SQL Server, SSIS, SSRS, Data Migration, and Power BI to design, develop, and maintain scalable database solutions. The ideal candidate will have experience in database architecture, data integration, ETL processes, cloud-based solutions, and business intelligence reporting. Excellent communication and documentation skills are essential for collaborating with cross-functional teams and maintaining structured database records. Key Responsibilities: Database Design & Architecture: Develop highly available, scalable, and secure database solutions using Azure SQL Server. ETL & Data Integration: Design and implement SSIS packages for data movement, transformations, and automation. Data Migration: Oversee database migration projects, including on-premises to cloud transitions and cloud to cloud transitions, data conversion, and validation processes. Azure Data Factory (ADF): Build and manage data pipelines, integrating various data sources and orchestrating ETL workflows in cloud environments Reporting & Business Intelligence: Develop SSRS reports and leverage Power BI for creating interactive dashboards and data visualizations. Performance Optimization: Analyze and optimize query performance, indexing strategies, and database configurations. Cloud Integration: Architect Azure-based database solutions, including Azure SQL Database, Managed Instances, and Synapse Analytics. Security & Compliance: Ensure data security, encryption, and compliance with industry standards. Backup & Disaster Recovery: Design and implement backup strategies, high availability, and disaster recovery solutions. Automation & Monitoring: Utilize Azure Monitor, SQL Profiler, and other tools to automate and monitor database performance. Collaboration & Communication: Work closely with developers, BI teams, DevOps, and business stakeholders, explaining complex database concepts in a clear and concise manner. Documentation & Best Practices: Maintain comprehensive database documentation, including design specifications, technical workflows, and troubleshooting guides. Required Skills & Qualifications: Expertise in SQL Server & Azure SQL Database. Experience with SSIS for ETL processes, data transformations, and automation. Proficiency in SSRS for creating, deploying, and managing reports. Strong expertise in Data Migration, including cloud and on-premises database transitions. Power BI skills for developing dashboards, reports, and data visualizations. Database modeling, indexing, and query optimization expertise. Knowledge of cloud-based architecture, including Azure SQL Managed Instance. Proficiency in T-SQL, stored procedures, Triggers, and database scripting. Understanding of security best practices, including role-based access control (RBAC). Excellent communication skills to explain database solutions to technical and non-technical stakeholders. Strong documentation skills to create and maintain database design specs, process documents, and reports. Preferred Qualifications: Knowledge of CI/CD pipelines for database deployments. Familiarity with Power BI and other data visualization tools. Experience with Azure Data Factory and Synapse Analytics for advanced data engineering workflows Bachelors or Masters degree in Business, Computer Science, Engineering, or a related field.
