Job Description-
Responsibilities:
- · Development of high-quality database solutions
- · 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
- · Bachelor's degree in IT, Computer science, or related field
- · 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 schema's 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
