SQL Developer (3 yrs exp ) -Postgres

SQL Developer (3 yrs exp ) -Postgres

Must have skills: Postgres SQL, Postgis, SQL, PL/SQL, Performance tuning, Shell scripting or python scripting.

 Good to have: Any Reporting tools

Responsibilities:

  • Proficient in database modeling, 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 and Postgis 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
  • Excellent communication skills.
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Submit CV