Synechron
Database Developer
Synechron, Jersey City, New Jersey, United States, 07390
The Role:
Database DeveloperLocation:
Jersey city, NJPosition Overview:As a Database Developer specializing in PL/SQL and performance tuning, you will be responsible for the development, optimization, and maintenance of database systems. This role requires a strong understanding of database structures, PL/SQL programming, and performance tuning methodologies to ensure efficient and high-performing database applications.Responsibilities:Design, develop, and implement database systems based on technical requirements and design specifications.Write and maintain clean, well-organized, and optimized PL/SQL code.Perform regular database performance tuning and optimization using Oracle tools and best practices.Analyze and optimize SQL and PL/SQL statements for maximum efficiency and reliability.Collaborate with application developers to integrate databases with existing applications.Proactively identify performance issues and troubleshoot to resolve them.Utilize performance tuning tools such as SQL Trace, TKPROF, AWR, and Oracle Enterprise Manager to monitor database performance.Implement database changes and apply new patches and versions when required.Develop database schemas, tables, dictionaries, and scripts.Create and maintain comprehensive documentation for all implemented databases.Conduct code reviews to ensure that database code meets company standards.Provide support for database issues and incidents to ensure minimal downtime.Work closely with the IT team to develop and improve database deployment and rollback strategies.Keep up-to-date with the latest database programming trends and performance tuning techniques.Required Skills and Qualifications:Bachelor's degree in Computer Science, Information Systems, or a related field.Experience in database development and performance tuning.Advanced proficiency in Oracle PL/SQL programming and database management.Demonstrated experience with Oracle performance tuning and optimization techniques.Strong understanding of Oracle database architecture and its impact on performance.Familiarity with Oracle RAC, ASM, and Data Guard is desirable.Knowledge of SQL profiling and monitoring tools.Excellent problem-solving and analytical skills.Ability to work independently as well as part of a team.Strong verbal and written communication skills.Preferred Skills:Oracle Certified Professional (OCP) for PL/SQL or Database Administration.Experience with ETL processes and tools.Familiarity with Agile and Scrum methodologies.Experience with source control management systems like Git or SVN.Knowledge of Unix/Linux shell scripting.We can offer you:A highly competitive compensation and benefits packageA multinational organization with 55 offices in 20 countries and the possibility to work abroad.Laptop and a mobile phone10 days of paid annual leave (plus sick leave and national holidays)Maternity & Paternity leave plansA comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)Retirement savings plansA higher education certification policyCommuter benefits (varies by region)Extensive training opportunities, focused on skills, substantive knowledge, and personal development.On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated coursesCoaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groupsCutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms.A flat and approachable organizationA truly diverse, fun-loving, and global work cultureSYNECHRON'S DIVERSITY & INCLUSION STATEMENTDiversity & 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.
Database DeveloperLocation:
Jersey city, NJPosition Overview:As a Database Developer specializing in PL/SQL and performance tuning, you will be responsible for the development, optimization, and maintenance of database systems. This role requires a strong understanding of database structures, PL/SQL programming, and performance tuning methodologies to ensure efficient and high-performing database applications.Responsibilities:Design, develop, and implement database systems based on technical requirements and design specifications.Write and maintain clean, well-organized, and optimized PL/SQL code.Perform regular database performance tuning and optimization using Oracle tools and best practices.Analyze and optimize SQL and PL/SQL statements for maximum efficiency and reliability.Collaborate with application developers to integrate databases with existing applications.Proactively identify performance issues and troubleshoot to resolve them.Utilize performance tuning tools such as SQL Trace, TKPROF, AWR, and Oracle Enterprise Manager to monitor database performance.Implement database changes and apply new patches and versions when required.Develop database schemas, tables, dictionaries, and scripts.Create and maintain comprehensive documentation for all implemented databases.Conduct code reviews to ensure that database code meets company standards.Provide support for database issues and incidents to ensure minimal downtime.Work closely with the IT team to develop and improve database deployment and rollback strategies.Keep up-to-date with the latest database programming trends and performance tuning techniques.Required Skills and Qualifications:Bachelor's degree in Computer Science, Information Systems, or a related field.Experience in database development and performance tuning.Advanced proficiency in Oracle PL/SQL programming and database management.Demonstrated experience with Oracle performance tuning and optimization techniques.Strong understanding of Oracle database architecture and its impact on performance.Familiarity with Oracle RAC, ASM, and Data Guard is desirable.Knowledge of SQL profiling and monitoring tools.Excellent problem-solving and analytical skills.Ability to work independently as well as part of a team.Strong verbal and written communication skills.Preferred Skills:Oracle Certified Professional (OCP) for PL/SQL or Database Administration.Experience with ETL processes and tools.Familiarity with Agile and Scrum methodologies.Experience with source control management systems like Git or SVN.Knowledge of Unix/Linux shell scripting.We can offer you:A highly competitive compensation and benefits packageA multinational organization with 55 offices in 20 countries and the possibility to work abroad.Laptop and a mobile phone10 days of paid annual leave (plus sick leave and national holidays)Maternity & Paternity leave plansA comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)Retirement savings plansA higher education certification policyCommuter benefits (varies by region)Extensive training opportunities, focused on skills, substantive knowledge, and personal development.On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated coursesCoaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groupsCutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms.A flat and approachable organizationA truly diverse, fun-loving, and global work cultureSYNECHRON'S DIVERSITY & INCLUSION STATEMENTDiversity & 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.