SQL Developer - Database Performance Tuning

Description :

Location-Pune.

Job Type : Contract For Client.

Responsibilities :

Job Description :

- Develop, implement, and optimize stored procedures and functions using SQL.

- Review and interpret ongoing business report requirements.

- Analyze existing SQL queries for performance improvements.

- Gather user requirements and identify new features.

- Provide data management support to users.

- Ensure all database programs meet company and performance requirements.

- Build appropriate and useful reporting deliverables.

- Suggest new queries.

- Provide timely scheduled management reporting.

- Investigate exceptions about asset movements.

- Mentor junior team members as needed.

- Work with data architects to ensure that solutions are aligned with company-wide technology directions.

Required Skills Technical :

- 5+ years of experience as a SQL Developer or similar role.

- Strong proficiency with SQL and its variations among popular databases (Snowflake).

- Strong skills in performance tuning of complex SQL queries, procedure and indexing strategies.

- Experience in designing, OLAP databases using data warehouse patterns and schemas including facts, dimensions, sorting keys, indexes, constraints etc.

- Query design and performance tuning of complex queries for very large data sets Knowledge of best practices when dealing with relational databases.

- Capable of troubleshooting common database issues.

- Translating functional and technical requirements into detailed design.

- Data Analysis experience, for example mapping the source to target rules and fields.