We are seeking an experienced SQL Developer to join our dynamic team.. The ideal candidate will have extensive experience in SQL development, database management, and a deep understanding of data structures and optimization techniques.

Responsibilities :

- Design, develop, and maintain SQL databases and applications.

- Write complex SQL queries for data retrieval and analysis.

- Optimize SQL queries for performance improvements.

- Collaborate with application developers to integrate SQL databases with applications.

- Ensure data integrity and security in SQL databases.

- Monitor and troubleshoot database performance issues.

- Perform database backups and recovery as needed.

- Writing T-SQL Queries using joins and Sub queries in MS SQL Server.

- T-SQL development skills to write complex queries involving multiple tables, Joins.

- Experience in Extracting, Transforming and Loading (ETL) data from Excel Flat file to MS SQL Server.

- Creating primary objects (tables, views, indexes)

- Generating various reports by querying from database as per need.

- Customer support for environmental issues and maintenance

- Data conversions from different sources

- Hands on Experience with SQL commands (DDL, DML & TCL etc) and SQL Scripts;

- Knowledge of creating packages, triggers, stored procedures Oracle Schema, Locks, SGA and materialized views;

- Hands on experience on Oracle types, User defined data types/ Arrays and Collections;

- Binding, Exception handling; Performance Tuning of queries using Explain Plan and other methods.

- Help write and optimize in-application SQL statements

- Ensure performance, security, and availability of databases

- Prepare documentations and specifications

- Profile server resource usage, and optimize and tweak as necessary

- Collaborate with other team members and stakeholders

- Translate business needs to technical specifications

- Design, build and deploy BI solutions (e.g. reporting tools)

- Maintain and support data analytics platforms (e.g. MicroStrategy)

- Create tools to store data (e.g. OLAP cubes)

- Conduct unit testing and troubleshooting

Skills and Qualifications

- 5-15 years of experience in SQL development and database management.

- Proficient in SQL and experience with various database systems (e.g., MySQL, SQL Server, Oracle).

- Strong understanding of database design principles and normalization.

- Experience with performance tuning and optimization of SQL queries.

- Familiarity with database backup and recovery techniques.

- Ability to write efficient and effective stored procedures, triggers, and functions.

- Knowledge of data modeling and ETL processes.

- Experience with version control systems and collaborative development tools.