PL/SQL Developer - Data Migration, Optimization & Security

PL/SQL Developer – Data Migration, Optimization & Security in Financial Systems

Job Summary

Synechron is seeking a skilled PL/SQL Developer to design, develop, and maintain robust database solutions that support our core business applications. In this role, you will leverage your expertise in Oracle PL/SQL programming, query optimization, and database troubleshooting to deliver high-quality, scalable data solutions. You will collaborate with cross-functional teams including application developers, data analysts, and project managers to ensure data integrity, security, and performance in line with organizational standards, supporting our strategic initiatives in data management and analytics.

Software Requirements

Required:

• Strong proficiency in PL/SQL (Oracle 11g/12c/19c or higher, 5-7 years of experience)

• Expertise in SQL query writing, tuning, and performance optimization

• Experience designing and implementing database objects such as tables, views, indexes, and constraints

• Familiarity with ETL processes, data transformation, and data migration activities

• Version control systems like Git or SVN

Preferred:

• Knowledge of Oracle Database architecture and internal mechanisms

• Familiarity with data warehousing concepts and tools

• Experience with cloud-based database environments (e.g., Oracle Autonomous, Cloud SQL)

• Exposure to reporting solutions and business intelligence tools

Overall Responsibilities

• Develop, test, and deploy PL/SQL procedures, functions, triggers, and packages aligned with project requirements

• Optimize and tune SQL queries, database objects, and indexing strategies to improve performance and scalability

• Collaborate with application developers to integrate PL/SQL code within business solutions

• Perform data validation, transformation, and migration activities to ensure accurate and reliable data management

• Troubleshoot and resolve database-related issues promptly, ensuring high system availability

• Document technical specifications, database design, and operational procedures

• Review code quality, perform peer code reviews, and ensure adherence to best practices and standards

• Support continuous improvement initiatives for database processes and deployment methods

• Maintain compliance with security policies, data privacy regulations, and organizational standards

Technical Skills (By Category)

Programming Languages (Essential):

• PL/SQL (Oracle 11g/12c/19c preferred, 5-7 years of hands-on experience)

• SQL

Preferred:

• Additional scripting languages such as Python or Shell scripting for automation

Databases / Data Management:

• Oracle database architecture, schema design, and stored procedures

• Data transformation, ETL, and data migration experience

• Familiarity with NoSQL databases like MongoDB or Cassandra (preferred)

Development & Version Control:

• Git or SVN for source code management

Tools & Methodologies:

• Data modeling and query optimization techniques

• Data warehousing concepts and tools

• Agile methodology and basic project management tools (Jira, Confluence)

Security & Compliance:

• Data security best practices, access controls, and compliance standards such as GDPR, PCI DSS, or organizational policies

Experience Requirements

• 5-7 years of professional experience developing and optimizing PL/SQL solutions in enterprise environments

• Proven experience supporting data migration, ETL, and complex query tuning activities

• Experience working with large-scale databases supporting business-critical applications

• Familiarity with financial, trading, or enterprise data systems is a plus

• Experience troubleshooting high-volume transactions and ensuring data integrity and security

Day-to-Day Activities

• Develop and optimize PL/SQL procedures, functions, triggers, and packages to support business processes

• Collaborate with developers and data analysts to implement data transformation and migration activities

• Troubleshoot and resolve database issues with minimal impact on business operations

• Perform query tuning, index analysis, and performance monitoring

• Conduct code reviews and maintain technical documentation for database components

• Participate in project planning, daily scrums, and sprint reviews in Agile settings

• Support deployment, backup, recovery, and data security operations

• Stay updated on new database features, best practices, and industry standards in data management

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience)

• 5-7 years of full-time experience in Oracle PL/SQL development in enterprise environments

• Knowledge of data warehousing, ETL, and reporting tools is advantageous

• Experience working within regulated or financial environments preferred

Professional Competencies

• Strong analytical and troubleshooting skills for resolving complex database issues

• Excellent attention to detail and commitment to data accuracy and security

• Effective communication skills to coordinate with technical and non-technical stakeholders

• Ability to prioritize tasks and manage workload effectively in a fast-paced environment

• Willingness to learn new tools and methodologies for continuous improvement

• Organized with a focus on adhering to standards and delivering high-quality solutions

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice

Experience Level

Senior Level