Over 6 years of programming experience as an PostgreSQL Developer in Requirement Gathering & Elicitation, Process Mapping, Development & Manual Testing.
Have excellent domain knowledge on IOT System, CRM and Ceramic Manufacturing domain.
Developed materialized view for data replication in distributed environments.
Enforced data integrity using integrity constraint and database triggers.
Developed complex database objects like Triggers, Functions, Stored Procedures using SQL and PL/SQL.
Wrote complex SQL using joins, sub-queries, and correlated sub-queries.
Experience in Report development using iReport Designer & Jaspersoft.
Experience in leveraging diverse PostgreSQL extensions like plpython, pgbadger, pgstattuple, pg_cron, plpgsql, pg_repack, postgis, intarray etc.
Have basic knowledge of writing shell scripts for automating tasks, enhance operational efficiency, and streamline processes.
Assisted in the creation of unit, integration, function, and performance test scripts to improve application quality and ensure fulfillment of requirements.
Coordinating with the front-end design team for framework enhancements & providing them required SQL queries and PL/SQL functions.
Effective communication, analytical, interpersonal, presentation, and coaching skills equally balanced for all tiers of business. Strong time management, independent as well as skilled and experienced in leading teams of functional and technical consultants.