What are the responsibilities and job description for the Senior Database Developer | Azure | Remote position at Cardinal Intellectual Property?
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:
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.
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.
- 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.
- Education: Bachelor’s degree in computer science, Software Engineering, or a related field.
- 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.
