PL/SQL Developer - Database Management and Optimization

PL/SQL Developer – Data Management, Optimization & Security in Enterprise Environments

Job Summary

Synechron is seeking a dedicated PL/SQL Developer to support database design, development, and troubleshooting within enterprise environments. This role involves maintaining database performance, ensuring data integrity and security, and supporting project initiatives involving data management. Your expertise will ensure efficient data operations, support business requirements, and uphold standards of data security and reliability across regulated industries.

Software Requirements

Required:

• Experience with Oracle, SQL Server, or MySQL (1-2 years) in database development and management

• Strong SQL knowledge for database design, query optimization, and troubleshooting

• Ability to write complex stored procedures, functions, and triggers

• Experience with database backup, recovery, and security best practices

• Familiarity with data migration, data analysis, and performance tuning

• Working knowledge of programming languages such as SQL, Python, or Java (preferred)

Preferred:

• Experience with cloud databases or data lakes (AWS, Azure, GCP) supporting enterprise projects

• Knowledge of data governance and compliance standards (e.g., GDPR, HIPAA)

Overall Responsibilities

• Develop, maintain, and optimize database objects, including stored procedures, functions, and triggers

• Support data migration, validation, and reporting activities to ensure data accuracy and consistency

• Monitor database performance and implement tuning strategies to improve response times and throughput

• Collaborate with cross-functional teams to support data-related initiatives and project goals

• Perform routine database backups and recoveries, supporting disaster recovery plans

• Troubleshoot and resolve database issues efficiently, minimizing downtime

• Ensure database security, access control, and compliance with organizational standards

• Document database configurations, processes, and data lineage for operational and audit purposes

Technical Skills (By Category)

Languages & Tools (Essential):

• SQL (complex query writing, performance tuning)

• Knowledge of PL/SQL (Oracle) stored procedures, functions, triggers

Preferred:

• Basic scripting skills in Python or Java for automation tasks

Databases & Data Management:

• Oracle, SQL Server, MySQL supporting enterprise data workflows

• Data migration, data quality, and data governance

Deployment & Cloud Support:

• Cloud database support in AWS, Azure, or GCP (preferred)

Backup & Security:

• Data security practices, access control, recovery strategies

• Compliance with data privacy and security standards

Experience Requirements

• 1-2 years of experience supporting enterprise databases

• Proven ability to develop and troubleshoot database objects in Oracle, SQL Server, or MySQL

• Experience working on data migration, performance tuning, and data validation tasks

• Exposure to cloud database environments and security compliance (preferred)

Day-to-Day Activities

• Develop and optimize SQL queries, stored procedures, and triggers supporting business processes

• Support data migration, validation, and reporting activities

• Monitor database performance, troubleshoot issues, and improve response times

• Collaborate with technical teams to support database configuration, security, and backup procedures

• Perform routine database maintenance, including backups and disaster recovery testing

• Document database schemas, configuration changes, and operational procedures

• Assist in data governance, compliance, and auditing efforts

• Support data analysis tasks and generate reports for stakeholders

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field

• 1-2 years of experience in database development, management, and troubleshooting

• Familiarity with enterprise data standards and security practices supporting regulated environments

• Experience supporting data migration, data validation, or performance tuning in enterprise settings

Professional Competencies

• Analytical mindset with strong problem-solving skills in database environments

• Effective communication for collaborating with technical and non-technical teams

• Attention to detail to maintain data integrity and security

• Ability to prioritize tasks and work efficiently under tight deadlines

• Willingness to learn new tools, frameworks, and industry best practices

• Proactive attitude towards process improvement and automation

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

Mid Level