Posted 19 June, 2026
GIS DB- Verizon
ClifyX
Bengaluru,Karnataka,India
Full Time
Reference: 365_594563_25-04853
| Skill/Relevant Exp | 4+ | 6+ | 8+ | Subcon# | JD |
| GIS DB | Yes | 1 | • Sound functional and technical knowledge of SQL, PL/SQL, and Advanced PL/SQL | ||
| • Good knowledge of writing stored Procedure, Functions and Packages, View | |||||
| • Worked on Oracle Collections Nested Tables, VArrays and Associative Arrays to improve the performance of Procedures and Packages. | |||||
| • Ability to migrate large-scale Oracle databases to PostgreSQL, including schema, data, and application-level changes. | |||||
| • Good knowledge on Product Supports, developing and UNIX shell scripting. | |||||
| • Good Knowledge of writing Triggers, Collections, Dynamic Pl/Sql | |||||
| • Worked on DYNAMIC SQL using EXECUTE IMMEDIATE. | |||||
| • Used performance tuning and extensive involvement in development and fine-tuning of PL/SQL scripts and SQL queries and used GTT and IOT tables. | |||||
| • Designed and implemented efficient PostgreSQL database schemas and structures for high-performance applications. | |||||
| • Knowledge of AWS cloud services, including RDS (PostgreSQL, MS SQL), S3, EC2, Lambda, and IAM. | |||||
| • Optimize spatial database performance by managing versioned tables and implementing indexing strategies for faster spatial queries. | |||||
| • Good Knowledge of writing Triggers, Collections, Dynamic Pl/Sql | |||||
| • Developing control files to import the data from legacy system to Oracle tables using oracle utility SQL*LOADER. | |||||
| • Develop stored procedures and functions using PL/pgSQL for business logic implementation. | |||||
| • Implements database replication and GIS versioning in PostgreSQL/PostGIS, allowing multiple users to edit spatial data concurrently while maintaining data integrity. | |||||
| • Strong in self-motivated, proactive, task oriented and quick learner and hard worker. | |||||
| • Ability to work on fast paced work environment. | |||||
| • Ability to quickly grasp new concepts and technologies possessing problem solving skill as well as hard working and above all a good team player. |
