Proficient in database modelling, Data extraction and storage logic building, Convert the business requirement into technical solutions
Proficient in writing Stored Procedures, Functions, Packages and Triggers using PL/SQL
Proficient in Postgres Database design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships
Resolve database performance and scalability issues
Implement DB performance tuning and optimization
Design and implement scalable database schemas and configuration
Expertise in using Bulking techniques, Analytical Functions, Hierarchical Queries, Partition utilization to increase performance
Automating data loading, extraction, reports generation using UNIX Shell scripting or Python scripting
Efficient in Optimizing, Debugging and testing SQL queries, views and stored procedures written in Oracle and SQL Server