{"id":27566,"date":"2026-02-18T12:27:21","date_gmt":"2026-02-18T12:27:21","guid":{"rendered":"https:\/\/doyensys.com\/jobs\/?post_type=awsm_job_openings&#038;p=27566"},"modified":"2026-04-02T08:56:38","modified_gmt":"2026-04-02T08:56:38","slug":"oracle-sql-pl-sql-consultant","status":"publish","type":"awsm_job_openings","link":"https:\/\/doyensys.com\/jobs\/jobs\/oracle-sql-pl-sql-consultant\/","title":{"rendered":"Oracle SQL \/ PL\/SQL Consultant"},"content":{"rendered":"<p><strong>About Doyensys:<\/strong><\/p>\n<p>\nDoyensys is a Management &amp; Technology Consulting company with expertise in Enterprise Applications, Infrastructure Platform Support, and IT solutions. Doyensys helps clients harness the power of innovation to thrive in a rapidly changing business environment. The company leverages its technology expertise, global talent, and extensive industry experience to deliver powerful next-generation IT services and solutions. Doyensys Inc has operations in India, the US, Mexico, and Canada.\n<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Job Requirement<\/strong><\/p>\n<ul>\n<li><strong>Project Role:<\/strong> Oracle SQL \/ PL\/SQL Consultant<\/li>\n<li><strong>Work Experience:<\/strong> 3 \u2013 5 Years<\/li>\n<li><strong>Work Location:<\/strong> Chennai<\/li>\n<\/ul>\n<p><strong>Project Role Description:<\/strong><\/p>\n<p>\nWe are seeking an experienced Oracle SQL \/ PL\/SQL Consultant with strong expertise in Oracle Database development and support. The ideal candidate should have 3 to 5 years of hands-on experience in SQL, PL\/SQL programming, database design, performance tuning, and application support. The consultant will be responsible for developing, optimizing, and maintaining database logic while working closely with business users and application teams to deliver reliable and scalable solutions.\n<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Technical Expertise:<\/strong><\/p>\n<ul>\n<li><strong>Must Have Skills<\/strong>\n<ul>\n<li>3\u20135 years of hands-on experience in Oracle SQL and PL\/SQL development<\/li>\n<li>Strong proficiency in complex SQL queries (joins, subqueries, CTEs, analytical functions)<\/li>\n<li>Expertise in stored procedures, functions, packages, and triggers<\/li>\n<li>Experience in writing high-performance and scalable SQL\/PLSQL code<\/li>\n<li>Strong knowledge of Oracle Database concepts (schemas, constraints, indexes, views, materialized views)<\/li>\n<li>Understanding of transaction management (commit, rollback, savepoints)<\/li>\n<li>Experience in performance tuning (Explain Plan analysis, index optimization, query refactoring)<\/li>\n<li>Hands-on experience with bulk processing techniques (BULK COLLECT, FORALL)<\/li>\n<li>Experience with Oracle Database versions 11g, 12c, 19c and above<\/li>\n<li>Ability to analyze and debug production issues and perform root cause analysis<\/li>\n<li>Experience in data migration, cleansing, and validation activities<\/li>\n<li>Good understanding of relational data modeling and database design<\/li>\n<li>Exposure to backend support for ERP, web, and reporting applications<\/li>\n<li>Ability to translate business requirements into efficient database solutions<\/li>\n<li>Excellent verbal and written communication skills<\/li>\n<\/ul>\n<\/li>\n<li><strong>Good To Have Skills<\/strong>\n<ul>\n<li>Exposure to Oracle APEX applications<\/li>\n<li>Experience supporting ERP systems (Oracle EBS \/ Fusion \/ custom applications)<\/li>\n<li>Knowledge of reporting tools such as BI Publisher, Oracle Analytics, Power BI, Crystal Reports, Jasper<\/li>\n<li>Experience with Agile \/ Scrum methodologies<\/li>\n<li>Basic knowledge of Unix\/Linux commands<\/li>\n<li>Experience with DBMS_SCHEDULER and job scheduling<\/li>\n<li>Version control exposure (Git \/ SVN)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Key Responsibilities:<\/strong><\/p>\n<ul>\n<li><strong>Database Development<\/strong>\n<ul>\n<li>Design, develop, and maintain SQL and PL\/SQL components including procedures, functions, packages, and triggers<\/li>\n<li>Write optimized SQL queries to support reporting and application requirements<\/li>\n<li>Ensure adherence to coding standards and performance best practices<\/li>\n<\/ul>\n<\/li>\n<li><strong>Database Integration<\/strong>\n<ul>\n<li>Support backend integrations with application teams<\/li>\n<li>Develop and maintain database logic for ERP, web, and reporting systems<\/li>\n<li>Handle data extraction, transformation, and loading processes<\/li>\n<\/ul>\n<\/li>\n<li><strong>Performance &amp; Optimization<\/strong>\n<ul>\n<li>Identify and resolve performance bottlenecks<\/li>\n<li>Optimize indexes, materialized views, and large data queries<\/li>\n<li>Support high-volume data processing and batch jobs<\/li>\n<\/ul>\n<\/li>\n<li><strong>Application Support &amp; Maintenance<\/strong>\n<ul>\n<li>Provide L2\/L3 support for database-related issues<\/li>\n<li>Perform root cause analysis and implement permanent fixes<\/li>\n<li>Support production deployments and controlled database changes<\/li>\n<\/ul>\n<\/li>\n<li><strong>Business Interaction<\/strong>\n<ul>\n<li>Collaborate with business users to understand functional requirements<\/li>\n<li>Translate business needs into scalable database solutions<\/li>\n<li>Support UAT and production validation activities<\/li>\n<\/ul>\n<\/li>\n<li><strong>Documentation<\/strong>\n<ul>\n<li>Create and maintain technical documentation<\/li>\n<li>Document coding standards, operational procedures, and best practices<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Professional Attributes:<\/strong><\/p>\n<ul>\n<li>Ability to work independently on assigned tasks<\/li>\n<li>Strong team player willing to support peers<\/li>\n<li>Solution-oriented mindset<\/li>\n<li>Proactive in identifying improvements<\/li>\n<li>Strong analytical and troubleshooting skills<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Educational Qualification:<\/strong><\/p>\n<ul>\n<li>BCA, B.Sc, MCA, B.E, M.Sc (Computer Science) or equivalent degree with relevant experience<\/li>\n<li>Oracle Certification (SQL \/ PL\/SQL) \u2013 Preferred<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Behavioral Attributes:<\/strong><\/p>\n<ul>\n<li>Passionate about database technologies<\/li>\n<li>Confident in sharing ideas and opinions<\/li>\n<li>Flexible and adaptable to changing project needs<\/li>\n<li>Open to feedback and continuous learning<\/li>\n<li>Willingness to take additional responsibility and extend work hours when required<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>About Doyensys: Doyensys is a Management &amp; Technology Consulting company with expertise in Enterprise Applications, Infrastructure Platform Support, and IT solutions. Doyensys helps clients harness the power of innovation to thrive in a rapidly changing business environment. The company leverages its technology expertise, global talent, and extensive industry experience to deliver powerful next-generation IT services [&hellip;]<\/p>\n","protected":false},"author":2,"template":"","meta":[],"class_list":["post-27566","awsm_job_openings","type-awsm_job_openings","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/doyensys.com\/jobs\/wp-json\/wp\/v2\/awsm_job_openings\/27566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/doyensys.com\/jobs\/wp-json\/wp\/v2\/awsm_job_openings"}],"about":[{"href":"https:\/\/doyensys.com\/jobs\/wp-json\/wp\/v2\/types\/awsm_job_openings"}],"author":[{"embeddable":true,"href":"https:\/\/doyensys.com\/jobs\/wp-json\/wp\/v2\/users\/2"}],"wp:attachment":[{"href":"https:\/\/doyensys.com\/jobs\/wp-json\/wp\/v2\/media?parent=27566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}