Senior SQL Developer

About the Company

This organization specializes in delivering innovative data and technology solutions to help businesses harness the power of their information. With expertise in areas such as data engineering, business intelligence, and analytics, they provide tailored solutions that enable organizations to make data-driven decisions effectively. Their team combines technical excellence with a client-focused approach, ensuring scalable, efficient, and high-quality outcomes for a diverse range of industries.

The Role

The Senior SQL Developer will be responsible for designing, developing, and maintaining robust SQL solutions. This role involves creating stored procedures, functions, and SQL jobs to handle data imports and migrations efficiently. The ideal candidate will have a strong command of T-SQL and SQL Server, with the ability to manage complex database operations and optimize performance.

Key Responsibilities

• Design and develop stored procedures, functions (table and scalar), and synonyms for efficient database operations.
• Implement and manage SQL jobs for importing flat files (e.g., CSV, TSV) into the database.
• Optimize indexing, triggers, and CTEs for performance and scalability.
• Collaborate with cross-functional teams to ensure database solutions align with business requirements.
• Support data migration projects, adapting schemas and managing data transformations.

Essential Skills and Experience

• Strong expertise in T-SQL (Transact SQL) and SQL Server.
• Proven experience in developing stored procedures, functions, synonyms, and managing indexing.
• Proficiency in creating and maintaining SQL jobs for flat file imports.
• At least 5 years of experience in SQL development.

Desirable Skills

• Experience in migrating data between different schemas or database systems.
• Strong understanding of database architecture and performance tuning.