SQL Developer - Database Design

Description :

- Design, develop, and maintain database structures, including tables, views, indexes, and constraints.

- Write and optimize T-SQL queries, stored procedures, triggers, and user-defined functions (UDFs).

- Perform query performance tuning using indexing strategies (clustered and non-clustered indexes).

- Develop and maintain ETL processes using SSIS, including data extraction from flat files, Excel, XML, and other databases.

- Create and manage SSRS reports based on business requirements.

- Ensure data integrity through proper use of primary keys, foreign keys, and constraints.

- Configure, schedule, and maintain SQL Server Agent jobs.

- Handle data migration and import/export operations using SQL Server tools (Import Wizard, DTS, SSIS).

- Perform data validation, reconciliation, and error handling during ETL processes.

- Provide production support, including troubleshooting, debugging, and performance issue resolution.

- Work closely with cross-functional teams for requirement analysis and implementation.

- Participate in code reviews, deployments, and release activities.

- Strong experience in MS SQL Server (2008 R2 / 2012 / 2014)

- Expertise in T-SQL (DDL, DML, Joins, CTEs, Window Functions, Aggregations)

- Hands-on experience with :

a. Stored Procedures

b. Views

c. Triggers

d. User Defined Functions (UDFs)

- Experience in SSIS (ETL development) and SSRS (reporting)

- Knowledge of DB2 development (preferred)

- Strong understanding of :

a. Indexing strategies

b. Query optimization techniques

c. Referential integrity and constraints

- Experience working with :

a. Temporary tables

b. Rank functions

c. Complex joins and unions

- Familiarity with SQL Server Management Studio (SSMS)

- Experience in handling high-volume transactional systems

Good to Have :

- Experience working with Oracle or heterogeneous data sources

- Knowledge of shell scripting for data operations

- Exposure to XML data processing

- Experience in financial or manufacturing domain

- Strong analytical and problem-solving skills

- Good communication and interpersonal skills

- Ability to work independently and in a team environment

- Experience working in Agile or client-facing environments

- Bachelors degree in computer science / IT / related field