GIS Database Specialist

Tekskills; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Tekskills is seeking a GIS Database Specialist / DBA with strong Oracle and PostgreSQL expertise. The role focuses on migrating data between Oracle and PostgreSQL in AWS, while ensuring data parity and efficient GIS data handling.

The ideal candidate will develop and optimize queries and stored procedures across both databases and collaborate with client teams to meet requirements. AWS experience is a plus, and independent work is valued.

Qualifications

• Proven experience with Oracle and PostgreSQL databases.
• Experience migrating data Oracle to PostgreSQL in AWS.
• GIS data handling and related database changes.
• Ability to work independently with client teams.

Responsibilities

• Migrate data from Oracle to PostgreSQL in AWS, ensuring accuracy and minimal downtime.
• Manage and migrate GIS-related data during the transition.
• Develop and optimize queries and stored procedures in both Oracle and PostgreSQL.
• Utilize AWS database services for deployment and management.
• Collaborate with client teams to understand and deliver on requirements.

Skills

Oracle

PostgreSQL

GIS data handling

AWS

Database migration

SQL

Stored Procedures

Tools

AWS services

Job description

Role: GIS Database Specialist / Database Administrator (Oracle & PostgreSQL)

Job Description: We are seeking a highly skilled GIS Database Specialist with strong expertise in Oracle and PostgreSQL databases. The ideal candidate will have extensive experience in database queries, stored procedures, and data management. You should be able to analyze and ensure data parity between Oracle and PostgreSQL, and successfully migrate data from Oracle to PostgreSQL within the AWS environment.

Key Responsibilities:

• Database Migration: Migrate data from Oracle to PostgreSQL in AWS, ensuring accuracy and minimal downtime.
• GIS Data Handling: Manage and migrate GIS-related data, incorporating necessary changes during the transition.
• Database Management: Develop and optimize database queries and stored procedures in both Oracle and PostgreSQL.
• AWS Experience: Utilize AWS database services for deployment and management.
• Client Collaboration: Work independently with client teams to understand and deliver on requirements.

Desired Skills:

• Strong experience with Oracle and PostgreSQL databases.
• Proven track record in database migration, especially Oracle to PostgreSQL.
• Expertise in managing GIS data and related database changes.
• Experience with AWS database services is a plus.
• Ability to work independently and collaboratively with client teams