Job Title: Sr. SQL Server Developer with Python

Location: Remote

Duration: Long Term

Position Type: Contract/Remote

Job Description

We are seeking a skilled and experienced Sr. SQL Server Developer with Python to join our team. The ideal candidate will have a strong background in database development, performance tuning, and automation using Python. This role involves working on complex SQL queries, stored procedures, and SSIS packages while leveraging Python for data-related tasks and process automation.

Key Responsibilities

• Develop, enhance, and optimize T-SQL queries, including dynamic queries, sub-queries, and complex joins for stored procedures, triggers, user-defined functions, views, and cursors.
• Perform advanced stored procedures optimization, performance tuning, and index tuning to ensure efficient database operations.
• Design and implement database schemas, ensuring data integrity and scalability.
• Automate database tasks and processes using Python, ensuring robust and efficient workflows.
• Enhance, debug, and deploy SSIS packages from development to production environments using SSIS catalog.
• Collaborate with cross-functional teams using Agile, Scrum, and Waterfall methodologies to deliver high-quality software solutions.
• Analyze and solve complex problems, ensuring system reliability and performance.
  
  

Required Skills And Qualifications

• SQL Server Expertise:
• Proficiency in writing and optimizing T-SQL queries.
• Deep knowledge of stored procedures, performance tuning, and index optimization.
• Python Programming:
• Strong skills in Python programming, including syntax, data structures, and automation capabilities.
• ETL and Data Integration:
• Expertise in creating, enhancing, and deploying SSIS packages.
• Methodologies:
• Strong experience with Agile, Scrum, and Waterfall software development methodologies.
• Problem-Solving:
• Excellent analytical and problem-solving skills with the ability to debug and enhance complex systems.
  

Preferred Qualifications

• Experience with cloud-based databases and services.
• Familiarity with data visualization tools and techniques.
• Certifications in SQL Server or Python-related technologies.