Who are we
Fulcrum Digital is an agile and nextgeneration digital accelerating company providing digital transformation and technology services right from ideation to implementation. These services have applicability across a variety of industries including banking & financial services insurance retail higher education food healthcare and manufacturing.
Key Skills:Azure Data Analytics Azure Data Factory Synapse Data Lake Gen2 CICD DevOps. SQL Server DB SQL Server Data Warehouse
Role & Responsibilities:
- Developand optimize complex SQL queries in Oracle and SQL Server to ensure efficientdata retrieval.
- Improve query performance using indexing partitioning materialized views andquery rewriting techniques.
- Identify and resolve performance bottlenecks in SQL queries ensuring optimalexecution plans.
- Develop and optimize data models to support analytical and operationalreporting.
- Ensure best practices for normalization and denormalization.
- Perform query plan analysis to reduce resource consumption.
- Work closely with data architects business analysts and reporting teams todefine requirements.
- Provide technical guidance on SQL best practices indexing strategies andperformance tuning.
- Conduct knowledge transfer sessions to upskill teams in SQL optimization andDSS best practices.
- Ensure data security by implementing rolebased access control (RBAC) andencryption
Requirements
Required Experience:
Senior IC