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 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.