SQL DB Architect - RAC - SFOpp-74215

About Sutherland: 

Artificial Intelligence. Automation. Cloud engineering. Advanced analytics. For business leaders, these are key factors of success. For us, they’re our core expertise.

We work with iconic brands worldwide. We bring them a unique value proposition through market-leading technology and business process excellence.

We’ve created over 200 unique inventions under several patents across AI and other critical technologies. Leveraging our advanced products and platforms, we drive digital transformation, optimize critical business operations, reinvent experiences, and pioneer new solutions, all provided through a seamless “as a service” model.

For each company, we provide new keys for their businesses, the people they work with, and the customers they serve. We tailor proven and rapid formulas, to fit their unique DNA. We bring together human expertise and artificial intelligence to develop digital chemistry. This unlocks new possibilities, transformative outcomes and enduring relationships.

Sutherland

Unlocking digital performance. Delivering measurable results

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

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

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