Senior SQL Developer/ADF

INSPYR Solutions - Coral Gables, FL

Full-time - Senior

Hybrid - Coral Gables, FL

Administrative and Support Services

About the position

The Senior SQL Developer/ADF role involves designing, developing, and optimizing complex database schemas and SQL scripts to meet application functionality and performance requirements. This position requires collaboration with various stakeholders, including data, design, product, and executive teams, to address data-related technical issues and ensure the successful delivery of data-driven solutions. The role also emphasizes the implementation of processes for product development and release, promoting data integrity, and participating in code reviews to maintain high-quality standards.

Responsibilities

• Design, develop and optimize large, complex DB schemas, SQL scripts and objects to meet application functionality and performance requirements.
• Work cohesively with stakeholders including data, design, product, and executive teams to assist with data-related technical issues.
• Collaborate closely with application developers and business teams to ensure successful design and delivery of data-driven solutions.
• Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment.
• Provide solutions to promote data integrity in enterprise systems.
• Participate in code reviews to validate effectiveness and quality of code.
• Liaise with Developers to improve applications and establish best practices.
• Publish documentation and collaborative information using internal tools.

Requirements

• Expertise in Database Architecture in an environment that handles large volumes of data.
• Experience with Azure Cloud & Azure Data Factory.
• Strong analytical and organizational skills for analyzing existing databases and developing effective data-driven solutions.
• Demonstrated expertise in performance tuning including both query and server optimization utilizing SQL tools and/or third-party solutions.
• Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, and stored procedures.
• Expertise in understanding complex business needs and developing solutions accordingly.
• Experience in troubleshooting and resolving data-related issues.
• Excellent oral and written communication skills.
• Expertise in performance tuning, especially tuning complex queries, procedures, and indexing strategies.
• Monitor and perform tuning on complex ETL jobs.
• Audit compliance experience in a highly regulated environment.
• Familiarity with Continual Improvement processes.

Benefits

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan
• and much more!