Senior Database Agent

Automios; Chennai; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

Automios is hiring for a Senior Database Agent based in Chennai, Tamil Nadu, requiring 15-20 years of expertise in Oracle and PostgreSQL databases along with cloud-based database migration experience. The successful candidate will lead database migration projects, design relational schemas, develop PL/SQL and PgSQL procedures, and ensure high database performance and availability across enterprise applications. Ideal candidates possess a degree in Computer Science/IT and significant technical leadership experience.

Qualifications

• 15–20 years of experience in Database Development, Management, Administration, and Migration projects.
• Strong expertise in Oracle (11g–19c) and PostgreSQL databases.
• Proven hands-on experience in Oracle to PostgreSQL migration in AWS cloud environment.

Responsibilities

• Architect, design, develop, and administer Oracle and PostgreSQL databases for complex enterprise applications.
• Design and optimize relational database schemas to meet business and performance requirements.
• Lead Oracle to PostgreSQL database migration projects in cloud environments.

Skills

Database Development

Database Administration

Oracle

PostgreSQL

PL/SQL

PgSQL

AWS RDS

Education

Bachelor’s / Master’s degree in Computer Science / Information Technology

Tools

Terraform

Pentaho

Job description

Overview

We are seeking an experienced Senior Database Agent with 15–20 years of expertise in database design, development, administration, and management. The role requires strong hands-on experience in Oracle and PostgreSQL databases, cloud-based database migration (Oracle to PostgreSQL on AWS RDS), project leadership, and delivering robust, high-performance database solutions for enterprise applications in domains such as Healthcare, Airlines, and ERP systems.

Responsibilities

• Architect, design, develop, and administer Oracle and PostgreSQL databases for complex enterprise applications.
• Design and optimize relational database schemas to meet business and performance requirements.
• Lead Oracle to PostgreSQL database migration projects in cloud environments (AWS RDS / Aurora) using tools such as HVR and DMS.
• Develop and maintain complex PL/SQL and PgSQL stored procedures, functions, and packages for backend business logic and data validation.
• Manage database administration tasks including user/role management, security, backup & recovery, and performance tuning to ensure high availability and zero-downtime operations.
• Handle project management activities covering initiation, planning, execution, monitoring, risk assessment, and timely delivery.
• Gather requirements from business users, prepare functional and technical design documents, and provide end-to-end solution architecture.
• Oversee ETL processes and data migration with thorough validation of objects, record counts, and constraints.
• Provide technical guidance and mentoring to development teams throughout the project lifecycle (development, testing, UAT, and post go-live support).
• Ensure data security and compliance by implementing encryption methods and best practices for sensitive information.
• Monitor and improve database processes, suggest operational enhancements, and deliver high-quality solutions within agreed timelines.

Requirements

• 15–20 years of experience in Database Development, Management, Administration, and Migration projects.
• Strong expertise in Oracle (11g–19c) and PostgreSQL databases.
• Proven hands-on experience in Oracle to PostgreSQL migration in AWS cloud environment.
• Extensive knowledge of AWS RDS for both Oracle and PostgreSQL.
• Deep experience in PL/SQL, PgSQL, database design, and performance optimization.
• Experience in leading technical teams and managing projects independently.
• Bachelor’s / Master’s degree in Computer Science / Information Technology (M.Sc. IT preferred).

Preferred Attributes

• Experience working in Healthcare
• Exposure to Terraform, Pentaho, and other ETL/migration tools.
• Strong problem-solving, troubleshooting, and client communication skills.
• Ability to work independently while leading and mentoring technical teams.