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 skilled 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 (2016, 2019, 2022 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

📌 4C/ Technical Specialist (Hyderabad)
🏢 TalentOla
📍 Hyderabad