Job Description:
We are looking for an experienced and skilled SQL Developer to join our team. The ideal candidate will have deep expertise in SQL development with hands-on experience in Azure SQL Database, Azure Parallel Data Warehouse, Linked Servers, and Database Replication. You will be responsible for optimizing database performance, implementing and managing linked servers, and ensuring the smooth replication of data across various systems.
As a key player in our development team, you will contribute to the design, development, and management of our Azure database infrastructure and SQL-based applications.
Key Responsibilities:
- Design, develop, and maintain complex SQL queries, stored procedures, triggers, and views for Azure SQL and other database systems.
- Implement and maintain Linked Servers to connect Azure SQL Database with external data sources and on-premise databases.
- Configure and manage SQL Server Replication (Transactional, Merge, Snapshot) in both Azure SQL Database and on-premise environments.
- Develop, optimize, and troubleshoot SQL Server performance, focusing on query optimization and database indexing.
- Work with Azure Parallel Data Warehouse (PDW) and ensure smooth integration with existing systems.
- Monitor and optimize the performance of Azure SQL Servers, ensuring scalability and high availability.
- Collaborate with cross-functional teams to design and implement data migration strategies between on-premise and cloud-based platforms.
- Ensure data security, backup strategies, and disaster recovery plans for databases.
- Maintain documentation for database development, replication configurations, and performance tuning.
Required Skills & Qualifications:
- Proven experience as an SQL Developer, Database Developer, or similar role.
- Strong hands-on experience with Azure SQL Database, Azure Data Services, and Azure Parallel Data Warehouse (PDW).
- In-depth knowledge of SQL Server Replication, including Transactional, Merge, and Snapshot replication.
- Expertise in configuring and maintaining Linked Servers in SQL Server environments.
- Strong performance tuning skills for SQL Server and Azure SQL environments, including query optimization, indexing, and troubleshooting.
- Experience with Azure SQL Server performance monitoring, troubleshooting, and optimization tools.
- Strong understanding of T-SQL for developing stored procedures, triggers, and complex queries.
- Familiarity with SQL Server Integration Services (SSIS) or other ETL tools for data migration and transformation.
- Knowledge of Azure Active Directory integration with databases and cloud security best practices.
- Ability to work collaboratively in a fast-paced, team-oriented environment.
Preferred Skills:
- Certifications in Microsoft SQL Server or Azure SQL Database.
- Experience with Power Shell scripting for automation of Azure SQL tasks.
- Familiarity with Azure Data Factory for data orchestration.
- Knowledge of No SQL databases or hybrid data storage solutions.
- Agile/Scrum experience in a database development environment.
