SQL DB Architect - RAC - SFOpp-74215
SQL DB Architect - RAC - SFOpp-74215
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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
Qualifications :
Bachelors or Masters degree in Business Computer Science Engineering or a related field.
Additional Information :
Bachelors or Masters degree in Business Computer Science Engineering or a related field.
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time
