Job Description
Job description
Summary/Objective
We are seeking a highly skilled and experienced Senior Oracle PL/SQL Developer to join our team. In this role, you will be instrumental in designing, developing, and maintaining robust and high-performance database applications on the Oracle platform. You will leverage your expertise in SQL and PL/SQL to deliver critical software solutions, ensure data integrity, and optimize database efficiency.
Essential Functions/ Responsibilities
• Design, develop, implement, and maintain complex PL/SQL code, including packages, stored procedures, functions, and triggers.
• Write and optimize intricate SQL queries for maximum performance and scalability.
• Analyze business requirements and translate them into effective technical designs and programming specifications.
• Perform comprehensive code reviews, unit testing, debugging, and bug-fixing of SQL and PL/SQL codes.
• Manage and create database objects such as tables, views, and triggers.
• Diagnose and resolve complex database issues, performance bottlenecks, and production problems.
• Collaborate effectively with cross-functional teams, project managers, and clients throughout the software development life cycle.
• Ensure data integrity, security, and compliance with company policies and standards.
• Contribute to technical documentation, process workflows, and production support processes.
Education and Experience
• Bachelor's degree in Computer Science, Engineering, or a related field.
• Minimum of 5+ years of hands-on experience in Oracle SQL/PL/SQL development (Oracle 11g-19c).
• Profound understanding of database management systems, indexing, and performance tuning techniques.
• Proven experience with database development tools (e.g. Oracle SQL Developer).
• Strong analytical and problem-solving abilities with a keen eye for detail.
• Experience with data analysis, manipulation, and troubleshooting.
• Familiarity with software development life cycle (SDLC) methodologies (Agile, Waterfall).
• Excellent communication and interpersonal skills, capable of interacting with both technical and non-technical stakeholders.
• Experience with SQLLoader.
• Exposure to NoSQL databases is beneficial.
If you are a proactive and results-oriented professional with a passion for database development and optimization, we encourage you to apply.
Work Environment
This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers, photocopiers and smartphones.
Physical Demands
Prolonged periods sitting at a desk and working on a computer. Specific vision abilities required by this job include close vision and ability to adjust focus. Must be able to lift up to 15 pounds at times.
Position Type/Expected Hours of Work
This is a full-time position. Days and hours of work are Monday through Friday, during normal business hours. Occasional evening and weekend work may be required as job duties demand.
Travel
Little to no travel is expected for this position.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
EEO Statement
Paymentus is an equal opportunity employer. We enthusiastically accept our responsibility to make employment decisions without regard to race, religious creed, color, age, sex, ****** orientation, national origin, ancestry, citizenship status, religion, marital status, disability, military service or veteran status, genetic information, medical condition including medical characteristics, or any other classification protected by applicable federal, state, and local laws and ordinances. Our management is dedicated to ensuring the fulfillment of this policy with respect to hiring, placement, promotion, transfer, demotion, layoff, termination, recruitment advertising, pay, and other forms of compensation, training, and general treatment during employment.
Reasonable Accommodation
Paymentus recognizes and supports its obligation to endeavor to accommodate job applicants and employees with known physical or mental disabilities who are able to perform the essential functions of the position, with or without reasonable accommodation. Paymentus will endeavor to provide reasonable accommodations to otherwise qualified job applicants and employees with known physical or mental disabilities, unless doing so would impose an undue hardship on the Company or pose a direct threat of substantial harm to the employee or others.
An applicant or employee who believes he or she needs a reasonable accommodation of a disability should discuss the need for possible accommodation with the Human Resources Department, or his or her direct supervisor.
Summary/Objective
We are seeking a highly skilled and experienced Senior Oracle PL/SQL Developer to join our team. In this role, you will be instrumental in designing, developing, and maintaining robust and high-performance database applications on the Oracle platform. You will leverage your expertise in SQL and PL/SQL to deliver critical software solutions, ensure data integrity, and optimize database efficiency.
Essential Functions/ Responsibilities
• Design, develop, implement, and maintain complex PL/SQL code, including packages, stored procedures, functions, and triggers.
• Write and optimize intricate SQL queries for maximum performance and scalability.
• Analyze business requirements and translate them into effective technical designs and programming specifications.
• Perform comprehensive code reviews, unit testing, debugging, and bug-fixing of SQL and PL/SQL codes.
• Manage and create database objects such as tables, views, and triggers.
• Diagnose and resolve complex database issues, performance bottlenecks, and production problems.
• Collaborate effectively with cross-functional teams, project managers, and clients throughout the software development life cycle.
• Ensure data integrity, security, and compliance with company policies and standards.
• Contribute to technical documentation, process workflows, and production support processes.
Education and Experience
• Bachelor's degree in Computer Science, Engineering, or a related field.
• Minimum of 5+ years of hands-on experience in Oracle SQL/PL/SQL development (Oracle 11g-19c).
• Profound understanding of database management systems, indexing, and performance tuning techniques.
• Proven experience with database development tools (e.g. Oracle SQL Developer).
• Strong analytical and problem-solving abilities with a keen eye for detail.
• Experience with data analysis, manipulation, and troubleshooting.
• Familiarity with software development life cycle (SDLC) methodologies (Agile, Waterfall).
• Excellent communication and interpersonal skills, capable of interacting with both technical and non-technical stakeholders.
• Experience with SQLLoader.
• Exposure to NoSQL databases is beneficial.
If you are a proactive and results-oriented professional with a passion for database development and optimization, we encourage you to apply.
Work Environment
This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers, photocopiers and smartphones.
Physical Demands
Prolonged periods sitting at a desk and working on a computer. Specific vision abilities required by this job include close vision and ability to adjust focus. Must be able to lift up to 15 pounds at times.
Position Type/Expected Hours of Work
This is a full-time position. Days and hours of work are Monday through Friday, during normal business hours. Occasional evening and weekend work may be required as job duties demand.
Travel
Little to no travel is expected for this position.
Other Duties
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
EEO Statement
Paymentus is an equal opportunity employer. We enthusiastically accept our responsibility to make employment decisions without regard to race, religious creed, color, age, sex, ****** orientation, national origin, ancestry, citizenship status, religion, marital status, disability, military service or veteran status, genetic information, medical condition including medical characteristics, or any other classification protected by applicable federal, state, and local laws and ordinances. Our management is dedicated to ensuring the fulfillment of this policy with respect to hiring, placement, promotion, transfer, demotion, layoff, termination, recruitment advertising, pay, and other forms of compensation, training, and general treatment during employment.
Reasonable Accommodation
Paymentus recognizes and supports its obligation to endeavor to accommodate job applicants and employees with known physical or mental disabilities who are able to perform the essential functions of the position, with or without reasonable accommodation. Paymentus will endeavor to provide reasonable accommodations to otherwise qualified job applicants and employees with known physical or mental disabilities, unless doing so would impose an undue hardship on the Company or pose a direct threat of substantial harm to the employee or others.
An applicant or employee who believes he or she needs a reasonable accommodation of a disability should discuss the need for possible accommodation with the Human Resources Department, or his or her direct supervisor.
💡 Quick Summary
Seeking a career-building opportunity? The Oracle Database Developer position is now open for candidates interested in the Database Administrator sector. This role in Richmond Hill offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.