Postgis, PostGre SQL, PL/SQL, Performance tuning, Shell scripting or python scripting
Contract W2, Contract Corp-To-Corp, 24 Months
Depends on Experience
Work from home available
Must have skills: Strong Postgis, PostGre SQL, PL/SQL, Performance tuning, Shell scripting or python scripting
Good to have: Any Reporting tools
Responsibilities:
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 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.