Senior Database Developer | Azure | Remote

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

Job summary

An established industry player is seeking a Senior Database Developer to lead the design and optimization of high-performance databases. The ideal candidate will have over 7 years of experience in Microsoft SQL Server and cloud-based technologies, particularly Azure databases. This role involves collaborating with engineering teams, optimizing database performance, and ensuring data integrity and availability. If you're a proactive problem solver who thrives in dynamic environments and is passionate about database solutions, this opportunity is perfect for you.

Qualifications

• 7+ years experience in database development and administration.
• Proven expertise in Microsoft SQL Server and Azure technologies.

Responsibilities

• Lead the design and optimization of high-performance databases.
• Conduct performance tuning and query optimization for efficiency.

Skills

Microsoft SQL Server

Azure SQL

T-SQL

Azure Data Factory

Cosmos DB

Performance Tuning

Collaboration

Education

Bachelor's degree in Computer Science

Tools

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.