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.