Hello,
I have been working with various RDBMS for notable 12 years and have experience in managing production, development and test databases for a broad range of corporate IT applications. Excellent technical and analytical skills with clear
understanding of ER modeling for OLTP and OLAP systems. Proficient in database analysis, scalable design, development, deployment and support databases. Demonstrate multi-tasking capability, contingency planning, risk assessment and cost benefit analysis.
As a database expert I have been working on
- Creating and Maintaining E-R Data Model
- Maintaining Database Schema Objects for Backward compatibility
- Performance Tuning
- Triaging Production Issues like Deadlocks, Bad SQLs, CPU spikes
- Developing Complex queries using CTEs, Analytical Functions, Joins, and views
- Creating GTTs, Constraints and Index (B Tree, Bitmap and Function Based)
- Writing PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System
- Reference cursor, Dynamic SQL
- Managing and facilitating right database version as per the product release version for Testing Team
- Code versioning, maintaining version control, code branching and code merging
- Documentation, Functional Specifications, Knowledge Transfer, and Standard Operating Procedure
I would further like to request an opportunity to discuss the project and how my skills are exact match for this project.
Many Thanks,
Sujay Patole
NiSh Data Solutions