Immediate openings For SQL DB Architect

Job Title: SQL Database Architect (SQL Server, Azure SQL Server, SSIS, SSRS, Data Migration, Azure Data Factory, Power BI)

Job Summary:

SQL Database Architect

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

Bachelor's or Master's degree in Business, Computer Science, Engineering, or a related field.

Additional information

Bachelor's or Master's degree in Business, Computer Science, Engineering, or a related field.