SQL Developer

Job Description :

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

ref : hirist.tech)