Position Title
Senior Oracle PL/SQL Developer – PostgreSQL Specialist
Key Responsibilities
● Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures,
functions, triggers, and views.
● Develop and optimize PostgreSQL database objects, queries, stored procedures, and
performance tuning activities.
● Participate in database architecture discussions and solution design.
● Analyze existing Oracle database applications and support migration/conversion to
PostgreSQL.
● Perform SQL query optimization, indexing, partitioning, and execution plan analysis.
● Develop ETL/data integration solutions for enterprise applications.
● Troubleshoot production database issues and provide performance improvements.
● Collaborate with developers, business analysts, QA teams, and DevOps teams.
● Ensure database security, integrity, backup, and recovery best practices.
● Create technical documentation, deployment scripts, and operational procedures.
● Mentor junior developers and conduct code reviews.
Required Skills & Qualifications
Technical Skills
● Strong hands-on experience in
○ Oracle Database (11g/12c/19c)
○ PL/SQL programming
○ PostgreSQL development and administration concepts
● Knowledge of
○ Indexing strategies
○ Partitioning
○ Materialized views
○ Execution plans and explain analyze
● Familiarity with
○ Git/SVN version control
○ CI/CD deployment processes
○ Agile/Scrum methodologies
Preferred Skills
● Experience with cloud platforms (AWS RDS/PostgreSQL, Azure, OCI)
● Exposure to Python or Java-based backend systems
● Knowledge of Liquibase/Flyway database versioning tools
● Experience with performance monitoring tools
Educational Qualifications
● Bachelor’s degree in Computer Science, Information Technology, Engineering, or
related field.
● Relevant Oracle/PostgreSQL certifications are a plus.
Desired Candidate Profile
● Strong analytical and problem-solving skills.
● Excellent communication and stakeholder management abilities.
● Ability to work independently in a fast-paced environment.
● Experience handling enterprise-scale transactional systems.
● Proactive mindset with attention to detail and quality.
Virtusa is a global product and platform engineering services company that makes experiences better with technology. We help organizations grow faster, more profitably, and more sustainably by reimagining enterprises through domain-driven solutions. We combine strategy, design, and engineering, backed by unmatched expertise at the intersection of industry, business, and technology to generate real-world business impact for clients.
Headquartered in Massachusetts with global delivery centers, Virtusa provides a broad range of services, solutions, and assets, including strategy and design, AI advisory and services, digital engineering, data and analytics, digital assurance, cloud and security, cx transformation and managed services across industries such as financial services, healthcare, communications, media, entertainment, travel, manufacturing, and technology.
