Hello!
I am a database expert with 13+ years of experience. I have worked with various RDBMS like MySQL, Oracle, MSSQL Server, PostgreSQL, IBM DB2 are few to name.
My core expertise is in writing PL SQL codes considering industry best practices for performance. I also work as data engineer and data analyst. Below is the brief outline of work that I can handle -
- 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
- Creating Shell Scripts for automating complex processes
Since I am quite new to this platform and I haven't earned any reviews or work history here, I would like to provide my services at pretty reasonable rate.
If you have any questions please feel free to get in touch with me, I would be glad to answer all of your questions.
Many Thanks,
Sujay