Senior Database Developer | Azure | Remote

Cardinal Intellectual Property; Chicago (IL); Remote; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a Senior Database Developer to drive efficiency and innovation in database solutions. This role demands a proactive problem solver with at least 7 years of experience in Microsoft SQL Server and cloud technologies, particularly Azure. You'll lead the design and optimization of databases, ensuring high performance and reliability. Collaborating with engineering teams, you'll implement scalable architectures and oversee critical operations. If you're passionate about database management and thrive in dynamic environments, this opportunity is perfect for you!

Qualifications

• 7+ years of experience in database development and administration.
• Proficient in Azure SQL, Cosmos DB, and performance tuning.

Responsibilities

• Lead the design and optimization of high-performance databases.
• Manage Azure SQL databases and ensure data integrity and availability.

Skills

Microsoft SQL Server

Azure SQL

Cosmos DB

Azure Data Factory

T-SQL

Performance Tuning

Database Design

Collaboration

Education

Bachelor's degree in Computer Science

Tools

Azure Data Factory

SSRS

Power BI

SSIS

Job description

We are looking for a highly skilled Senior Database Developer who takes ownership of their work and makes critical decisions to drive efficiency and innovation. This role requires a well-versed developer with a strong background in database development, administration, and business intelligence . The ideal candidate will have at least 7 years of experience in Microsoft SQL Server and cloud-based technologies, with a deep understanding of Azure databases and infrastructure. Practical experience with Azure Data Factory, Azure SQL, Cosmos DB, and Azure Managed Instances is a significant advantage.

If you're a proactive problem solver who thrives in a dynamic environment and is passionate about optimizing database solutions, we'd love to connect with you!

Key Responsibilities:

• Database Design & Development: Lead the design, development, and optimization of high-performance databases, creating scalable and reliable data structures in both Azure and on-premises SQL Server environments.


• Advanced SQL/T-SQL Development: Develop complex stored procedures, functions, tables, views, triggers, indexes, and constraints to support robust and dynamic database solutions, utilizing advanced SQL and T-SQL techniques.


• Performance Tuning & Optimization: Conduct performance tuning and query optimization using SQL Profiler, Performance Monitor, and related tools to improve database efficiency and responsiveness.


• Azure Database Management: Manage and optimize Azure SQL databases, Cosmos DB, and Azure SQL Managed Instances, leveraging Azure's capabilities for resource management, security, and high availability.


• Database Architecture & Collaboration: Collaborate with engineering teams to design and implement efficient, scalable database architectures for both on-premises and cloud-based environments, applying best practices for performance and reliability.


• Operational Support & Reliability: Oversee critical database operations, including backup, disaster recovery, and high-availability solutions, to ensure data integrity and availability across SQL environments.


• Documentation & Process Improvement: Document database development processes and contribute to continuous improvement initiatives, enhancing overall database performance and maintainability.


• Plus: Provide support for data integration using Azure Data Factory and SSIS and offer expertise in reporting with SSRS and Power BI when required.

Required Skills:

• Experience in Small to Midsize Company Environments: Proven ability to adapt and thrive in smaller, agile teams where versatility and hands-on work are essential.


• SQL Server & Azure Database Expertise: 7+ years of hands-on experience with SQL Server and Azure databases, with a focus on Azure SQL, Cosmos DB, and Azure SQL Managed Instances.


• Advanced T-SQL & Query Optimization: Deep expertise in T-SQL development and advanced query optimization, enabling efficient and scalable database solutions.


• Azure Data Factory & DevOps: Proficiency in Azure Data Factory and DevOps practices to support cloud-based data solutions.


• Collaboration & Communication: Strong collaboration and communication skills, essential for working effectively with cross-functional teams on database architecture.


• Bonus Skills: Experience with SSRS, Power BI, and ETL processes using SSIS is beneficial but not a primary focus.

Qualifications:

• Education: Bachelor's degree in computer science, Software Engineering, or a related field.