• Expertise in Database Design, SQL Tuning, Storage Optimization, Cost Optimizer, Data Modelling, ETL, Indexing, Joins, Partitioning, Analytical Queries, Parallel Queries, Bulk operations, Managing & engineering Database, Data Compression, Data Cleaning, Integrity and Quality, Database Scaling, and Availability
• Expert in Oracle SQL, PL/SQL, etc. for Oracle 19c,12c,11g,10g,9i, etc.
• Proficient in MySQL 8, PostgreSQL 13, and orientation with NoSQL MongoDB etc.
• Acquainted with public cloud infra like Azure for data engineering
• Python 3 for Data engineering & some part of Web development with Django
• Supported the Bank’s important, critical, multi-terabyte Databases and Data Warehousing platforms, Database migrations and Database cost optimization programs, and automation of database deployments and release processes
• Defining and maintaining best practice guidelines and standards for data, metadata, Data Modeling, and management and best practices that support the firm’s data governance program
• Oversee the firm’s data governance maturity model and encourage data stewards to take the steps necessary to adhere to guidelines provided for data management, data quality and overall data stewardship
• Built, maintained, and managed scalable OLTP, OLAP, Analytical and Reporting data platforms, and Data-Driven Business applications
• Strong people management skills; mentoring techies as Database SME, Active in effective Recruitment-drives
• Have successfully led and managed deliveries of critical importance, having stringent timelines and dynamic requirements in highly agile development environments.
• Proficiency in debugging, diagnosing, and code fixing for performance issues in data-centric operations within established protocols, guidelines, standards & Documenting
• Evaluation for the enhancements with a Feasibility Study, Proof of concept & prototype
• Knowledge of the Incident, Problem, and Change Management processes within the Service Now framework
• Experience in all phases of SDLC for waterfall and agile methodologies. Agile tools like JIRA, Confluence, and version controlling using GitHub, Etc.