Senior Software Developer

Job Description:

Experience and Skillset Requirements:

Mandatory Requirements:

• 5+ year experience working with RDBMS, Azure SQL Server, Database Administration, security management for high-sensitive database, database performance management, query performance analysis & tuning, database quality practice, good understanding of Azure storage concepts and technologies.
• 5+ years of working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
• Proficiency in Azure Data Factory, SSMA, Database Migration Services, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Proficiency in scripting languages, relational data models, data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, and experience with Azure-specific scripting using PowerShell or Azure CLI.
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.

Desired Skills and Experience:

• Experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools (e.g. Azure ADF, SSMA).
• Expertise in data transformation techniques, such as data cleansing, aggregation, enrichment, and normalization using Azure cloud technologies.
• Understanding of data quality management practices, including data profiling, data validation, and error handling within ETL processes.
• Understanding of data governance principles, data privacy regulations, and experience working with high-sensitivity data, and knowledge of best practices for data security and compliance in Azure.
• bility to monitor and troubleshoot ETL processes, optimize query performance, and implement efficient data processing techniques in Azure.
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.
• Experience with SQL Server Management Studio, Azure data management tools, XRM toolbox, data modeling tools (e.g. PowerDesigner, ERWIN).

Resumes Evaluation/Criteria:
Data Migration, ETL:

• Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement.
• Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools (e.g. ADF, SSMA, etc).
• Demonstrated experience working with Azure Data Factory, including knowledge of pipeline creation, data flows, integration runtimes, triggers, and monitoring.
• Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning.
• Demonstrated experience with SQL Server, Oracle, Azure SQL Databases and data modeling tools (e.g. PowerDesigner, ERWIN).
• Demonstrated experience in scripting languages like Python and with Azure-specific scripting using PowerShell or Azure CLI.
• Experience with software development lifecycle, data modeling, physical database design and data flow diagrams.

Database Tuning and Administration:

• Demonstrated experience fine tuning Azure SQL database for security, cost, performance, availability and reliability.
• Demonstrated experience setting up monitors and alerts on critical database metrics to ensure high availability.
• Demonstrated experience to automate operations and supporting a large database in a production environment.

zure Platform and Security:

• Experience with Azure Data Factory (ADF) and Database Migration services and tools.
• Demonstrated experience with Azure data management tools, DevOps.
• Experience in Azure resource configuration and administration such as Azure SQL Database, Blob Storage, Key Vault, Application Insight resources, resource groups and subscriptions.
• Familiar with Azure cloud platform, database security concepts and practices
• (Nice to have) Azure cloud certifications.

DevOps and CI/CD:

• Demonstrated experience with continuous integration/continuous deployment (CI/CD) tools and processes around DevOps, data workflows, Synapse workspaces.