Senior Database Developer | Azure Database Expert

We’re seeking a highly skilled Senior Database Developer with a minimum of 7 years of experience, particularly in Microsoft SQL Server and cloud-based technologies. This role is ideal for someone with advanced database development expertise, strong analytical and problem-solving skills, and excellent communication abilities. Hands-on experience with Azure Data Factory, Azure SQL, Cosmos DB, and Azure Managed Instances is a major plus. If you're passionate about driving data solutions in a cutting-edge environment, we’d love to hear from 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.

Why Join Us?

• Comprehensive Benefits: Health, Dental, Vision, STD, LTD, Critical Illness, Accident Coverage, Teladoc, and V-Life Insurance for full-time employees.
• Paid Time Off & Holidays: Generous PTO and paid company holidays.
• Retirement Plan: Profit-sharing contributions to help secure your future.

Cardinal Intellectual Property, Inc. provides equal opportunity in employment to all employees and applicants for employment. No person will be discriminated against in employment because of race, religion, color, sex, gender, age, national origin, ancestry, citizenship status, disability, sexual orientation, military status, marital status, genetic information, or any other characteristic protected by applicable Federal, State or local statute or ordinance.