What are the responsibilities and job description for the Senior Database Developer - Azure - Remote position at Cardinal Intellectual Property?
We are seeking a highly skilled Senior Database Developer who takes full ownership of their work and drives efficiency and innovation through critical decision-making. This role requires a seasoned developer with extensive expertise in database development, administration, and business intelligence. The ideal candidate will have at least 7 years of experience working with Microsoft SQL Server and cloud-based technologies, with a deep understanding of Azure databases and infrastructure. Hands-on 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 hear from you!
Key Responsibilities
- Database Design & Development – Lead the design, development, and optimization of high-performance databases, ensuring scalable and reliable data structures in Azure and on-premises SQL Server environments
- Advanced SQL/T-SQL Development – Create complex stored procedures, functions, tables, views, triggers, indexes, and constraints, leveraging advanced SQL and T-SQL techniques
- Performance Tuning & Optimization – Enhance database efficiency and responsiveness through performance tuning and query optimization using SQL Profiler, Performance Monitor, and other related tools
- Azure Database Management – Oversee Azure SQL databases, Cosmos DB, and Azure SQL Managed Instances, utilizing Azure’s resource management, security, and high-availability features
- Database Architecture & Collaboration – Work closely with engineering teams to design and implement scalable, efficient database architectures for both on-premises and cloud-based environments, applying best practices for performance and reliability
- Operational Support & Reliability – Ensure data integrity and availability by managing backup, disaster recovery, and high-availability solutions across SQL environments
- Documentation & Process Improvement – Maintain clear database development documentation and contribute to process improvements, enhancing database performance and maintainability
- Provide support for data integration using Azure Data Factory and SSIS and contribute expertise in reporting (SSRS, Power BI) when required
Required Skills
- Experience in Small to Midsize Company Environments – Proven ability to adapt and thrive in smaller, agile teams, where hands-on work and versatility are key
- SQL Server & Azure Database Expertise – 7 years of experience with SQL Server and Azure databases, focusing on Azure SQL, Cosmos DB, and Azure SQL Managed Instances
- Advanced T-SQL & Query Optimization – Expertise in T-SQL development and query optimization to build efficient, scalable database solutions
- Azure Data Factory & DevOps – Proficiency in Azure Data Factory and DevOps practices to support cloud-based data solutions
- Collaboration & Communication – Strong ability to work with cross-functional teams, ensuring seamless database architecture alignment with business objectives
- Bonus Skills – Experience with SSRS, Power BI, and ETL processes using SSIS is a plus but not a primary focus
Qualifications
- 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.
Accommodations are considered for IWD (Individual With Disability) and protected veterans.