Database Administrator

We are looking for an experienced Database Administrator DBA with strong hands on expertise in Oracle to PostgreSQL database migrations The ideal candidate will have a solid foundation in Oracle and PostgreSQL database administration and be capable of executing migration projects with minimal supervision This role requires a mix of DBA scripting and problem solving skills along with a strong understanding of data integrity performance tuning and cloud database best practices

Key Responsibilities

Plan and execute database migration projects from Oracle to PostgreSQL on prem or cloud

Perform detailed assessments of Oracle schemas PL SQL code stored procedures and triggers for migration feasibility

Use tools like ora2pg AWS DMS or custom scripts to facilitate smooth migration

Convert PL SQL code to equivalent PL pgSQL or compatible PostgreSQL syntax

Optimize and tune PostgreSQL databases post migration for performance and scalability

Ensure data integrity accuracy and performance during and after the migration

Monitor and maintain the PostgreSQL and Oracle environments as required

Automate tasks related to migration monitoring and maintenance using scripting Shell Python etc

Work closely with application data and DevOps teams to ensure minimal downtime and successful deployment

Required Skills and Qualifications

2 6 years of experience as a DBA with at least 1 2 years of hands on experience in Oracle to PostgreSQL migration

Strong working knowledge of Oracle 12c 19c and PostgreSQL 9 x and above

Experience with ora2pg SQL Developer AWS Schema Conversion Tool or other database migration utilities

Solid understanding of SQL PL SQL and PL pgSQL development and conversion techniques

Proficiency in performance tuning indexing and query optimization

Hands on experience in backup recovery user management and security administration

Familiarity with Linux Unix environments and shell scripting

Preferred Skills

Experience with cloud database services AWS RDS Aurora PostgreSQL Azure Database for PostgreSQL

Understanding of database replication and high availability e g streaming replication logical replication

Exposure to DevOps and CI CD pipelines involving database deployments

Experience with data validation and reconciliation post migration

Knowledge of other database platforms MySQL SQL Server MongoDB is a plus

Certification in Oracle PostgreSQL is an advantage

Soft Skills

Strong analytical and problem solving skills

Good communication and documentation abilities

Ability to work independently and collaborate in cross functional teams

Detail oriented with a commitment to quality and continuous improvement

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.