Postgis Developer

• Min 5 Years of experience Must have skills: Postgres SQL, Postgis, SQL, PL/SQL, Performance tuning, Shell scripting or python scripting
• Good to have: Any Reporting tools
• 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 SQL
• Work with GIS analysts to implement geospatial processes, queries and reports.
• PostGIS proficiency and grasp of core geospatial concepts.
• Ability to efficiently write database code without compromising data quality, privacy or security.
• 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