SQL Developer

Role/Title 4C/ Technical Specialist

Primary Skills/expertise MS SQL My SQL SSIS

Preferred skills/expertise

Role & Responsibilities Key Responsibilities Database Design & Architecture: Design and implement robust database schemas tables indexes and relationships following best practices and normalization principles Query Optimization: Write optimize and tune complex SQL queries and stored procedures for maximum performance Stored Procedure Development: Develop maintain and optimize stored procedures triggers and functions for various business processes SSIS Package Development: Design develop and maintain SQL Server Integration Services (SSIS) packages for data extraction transformation and loading (ETL) Performance Tuning: Monitor and analyze database performance identify bottlenecks and implement optimization strategies Database Administration Support: Support database administration tasks including backups recovery maintenance and security Data Migration: Plan and execute data migration projects between systems and databases Documentation: Create and maintain comprehensive technical documentation for database designs and SSIS processes Testing & Quality Assurance: Perform unit testing and ensure data integrity and quality Collaboration: Work with business analysts application developers and stakeholders to understand requirements and implement solutions Required Qualifications 5 years of professional experience as an MS SQL Developer or Database Developer Strong expertise in SQL Server database design and architecture Proven experience designing and creating database tables schemas and relationships Advanced T-SQL skills (queries stored procedures functions triggers) Demonstrated expertise in SSIS package development and maintenance Strong experience with query and stored procedure performance tuning Experience with SQL Server Management Studio (SSMS) Solid understanding of database indexing strategies and execution plans Experience with version control systems (Git TFS etc.)

Excellent troubleshooting and problem-solving skills Preferred Qualifications MySQL experience (data modeling query development administration) Microsoft SQL Server certifications (MCSA MCSE) Experience with Power BI or SQL Server Reporting Services (SSRS) Knowledge of Azure SQL Database or cloud database solutions Experience with NoSQL databases (MongoDB Cosmos DB) would be added advantage Background in ETL tools and frameworks Experience with CI/CD pipelines for database deployments Understanding of data warehouse design and star schema modeling Experience with advanced SSIS features (Script Task Script Component error handling) Technical Skills SQL Server (or later) T-SQL (Advanced Level) SSIS (SQL Server Integration Services) Database Design & Normalization Performance Tuning & Optimization SQL Server Query Execution Plans Indexing Strategies Stored Procedures Functions & Triggers MySQL SQL Server Management Studio (SSMS) Visual Studio for SSIS Development Backup & Recovery Procedures Database Security & Permissions Data Migration Tools Database-Specific Knowledge Relational Database Management Systems (RDBMS) Data normalization and schema design ACID properties and transaction management Locks deadlocks and concurrency control Query optimization and execution plan analysis Index types (Clustered Non-clustered Columnstore etc.) Partitioning strategies Change Data Capture (CDC) Replication and high availability concepts Soft Skills Strong analytical and problem-solving abilities

Attention to detail and precision Excellent communication and documentation skills Ability to work independently and in team environments Time management and ability to prioritize multiple tasks Passion for continuous learning and staying current with database technologies