Cardinal Intellectual Property
Senior Database Developer - Full-Time
Cardinal Intellectual Property, Chicago, Illinois, United States, 60290
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr