Senior Specialist

Financial Software Systems(FSS); Chennai; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Financial Software Systems in Chennai seeks an engineering-centric Oracle Database Specialist to lead enterprise database design, secure implementation, performance tuning, disaster recovery, and application-driven architectures. Oracle will be the primary focus, with exposure to PostgreSQL, MySQL, SQL Server, AWS RDS, Aurora, or Redshift.

You will drive performance using AWR/ASH, manage deployments, migrations, backups, and DR.

Qualifications

• Strong Oracle DBA expertise including design, administration and tuning.
• Experience with multi-database environments (Oracle + one secondary platform).
• Hands-on with RAC, Data Guard, RMAN, Data Pump, OEM.
• Security, compliance and hardening standards experience.
• Cross-platform migrations using AWS DMS and ETL automation.

Responsibilities

• Lead Oracle database design, schema review, indexing, partitioning and capacity planning.
• Own deployment, configuration, migration, upgrade, patching, backup and DR setup.
• Implement database security, encryption, auditing and vulnerability remediation.
• Drive performance engineering using AWR, ASH, ADDM and SQL tuning.
• Support cross-platform migrations (Oracle to PostgreSQL/MySQL/SQL Server/AWS).
• Collaborate with application, infrastructure, cloud and security teams for RCA.

Skills

Oracle DBA expertise

Multi-database capability

Oracle RAC/DG/RMAN/Data Pump

Security/compliance hardening

AWS DMS/ETL automation

Tools

Data Guard

RMAN

OEM

Oracle Data Pump

AWR/ASH/ADDM

Job description

Role Overview

We are seeking an engineeringcentric Oracle Database Specialist to lead enterprise database design, secure implementation, performance tuning, disaster recovery, and applicationdriven architectures. Oracle Database will be the primary focus, with exposure to secondary platforms such as PostgreSQL, MySQL, SQL Server, AWS RDS, Aurora, or Redshift.

Key Responsibilities

• Lead Oracle database design, schema review, indexing, partitioning, and capacity planning.
• Own deployment, configuration, migration, upgrade, patching, backup & recovery, and DR setup.
• Implement database security, compliance, encryption, auditing, and vulnerability remediation.
• Drive performance engineering using AWR, ASH, ADDM, SQL tuning, and execution plan analysis.
• Support crossplatform migrations (Oracle PostgreSQL/MySQL/SQL Server/AWS RDS/Redshift).
• Collaborate with application, infrastructure, cloud, and security teams for consulting & RCA.

MustHave Skills

• Strong Oracle DBA expertise (design, administration, migration, troubleshooting, performance tuning).
• Multidatabase capability: Oracle + one secondary platform (PostgreSQL/MySQL/SQL Server/AWS RDS/Aurora/Redshift).
• Handson experience with Oracle RAC, Data Guard, RMAN, Data Pump, OEM.
• Expertise in database security, compliance, and hardening standards.
• Experience in crossplatform migrations using AWS DMS, Oracle Data Pump, ETL, Python automation.

GoodtoHave Skills

• OCI Cloud services for Oracle Database.
• Exposure to Oracle Exadata platforms.
• Knowledge of automation/scripting (Shell, PL/SQL, Python, Ansible, Terraform).
• Consulting experience with customerfacing database assessments and architecture reviews.