Database Design: Architect and implement relational database models, schemas, and tables using industry best practices for normalization and performance
Advanced Development: Write complex stored procedures, triggers, views, and user-defined functions to support application logic
Performance Tuning: Proactively identify and resolve performance bottlenecks through index optimization, query refactoring, and execution plan analysis
ETL & Integration: Design and maintain robust Data Integration/ETL processes using SSIS (SQL Server Integration Services) to consolidate data from disparate sources
Data Security: Implement and manage security protocols, including encryption, data masking, and granular access controls, to protect sensitive information
Reporting & Analytics: Develop and optimize complex reports using SSRS (SQL Server Reporting Services) or Power BI to provide actionable business insights
Requirements
1. Oracle Development
Proficiency in PL/SQL
Experience with Oracle Forms & Reports
Strong understanding of Oracle database structures, stored procedures, and performance tuning
2. Microsoft SQL Server
Handson experience with MS SQL Server
Ability to develop and optimize TSQL queries, triggers, and stored procedures
3. Additional Requirements
Strong analytical and problemsolving skills
Ability to work with crossfunctional teams
Experience in banking/financial systems is preferred
