GE Vernova logo

Software Engineer-Postgress DBA

GE Vernova
NewPosted yesterday

LOCATION

Bengaluru · Onsite

EXPERIENCE

Not specified

TYPE

FullTime

SKILLS REQUIRED

PostgreSQLDatabase AdministrationPerformance TuningSQLDatabase Backup and RecoveryData Migration

Job description

Overview

Database Administrator role responsible for the maintenance, migration, performance, integrity, security and fine tuning of databases, including PL/SQL and SQL development on Postgres and SQL Server.

What you'll do

  • Maintain, migrate, tune and secure databases so they operate securely and efficiently.
  • Perform complex database migration activities based on customer requirements, including high volumes of data aligned to business use cases.
  • Manage SQL operations on Postgres RDS instances.
  • Create and modify databases, including tables, indexes, views and DB partitions.
  • Monitor and optimize database performance through tuning and indexing.
  • Perform periodic backups and ensure data recoverability during disaster.
  • Troubleshoot and resolve database and SQL problems.
  • Write DB scripts to migrate large volumes of data with entities across multiple databases and schemas.
  • Develop and maintain documentation and operating procedures.
  • Write and optimize PL/SQL code for database procedures, functions, triggers and packages.
  • Develop and maintain database stored procedures and scripts to support application development.
  • Optimize SQL queries for performance and scalability.
  • Collaborate with developers to integrate PL/SQL code with application logic.
  • Write and optimize SQL queries for data retrieval, manipulation and reporting.
  • Develop and maintain database views, stored procedures and functions.
  • Ensure SQL code meets performance and scalability requirements.
  • Debug and troubleshoot SQL code issues independently and sometimes with application developers.
  • Monitor database performance metrics such as CPU usage, memory usage and disk utilization.

What you'll need

  • Good experience with Postgres RDS.
  • Ability to write and help review complex SQL queries to improve system performance.

Nice to have

  • Experience with PL/SQL, preferably in Postgres and SQL Server.

Details

  • Location: Bengaluru.
  • Relocation assistance provided: Yes.

Read the full description and apply on the company’s own careers page.

Stay safe

Hiring on Abekus is free for applicants

We never charge a fee, and employers are prohibited from doing so. If a recruiter asks for payment, please report them right away.

Software Engineer-Postgress DBA