GIS DB- Verizon

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.