Diverse Lynx
Role: Oracle PL/SQL Developer
Location: NY City, NY
Job Description
Must have: We are seeking a highly experienced Oracle PL/SQL Developer with 10+ years of professional experience in designing, developing, tuning, and monitoring Oracle-based systems. The ideal candidate should be proficient in writing complex queries, managing database objects, and optimizing performance using tools like Oracle Enterprise Manager (OEM). A strong background in SQL, PL/SQL, and Java, along with the ability to work on enterprise-level solutions, is essential for this role. Must-Have Technical / Functional Skills:
Core Database Skills:
10+ years of hands-on experience in Oracle Development. Expert-level proficiency in SQL and PL/SQL. Strong experience in designing database objects such as tables, triggers, procedures, and partitions. Ability to write and optimize complex SQL/PLSQL queries for data analysis and processing. Performance Tuning & Tools: In-depth knowledge of SQL Tuning, SQL traces, SQLLDR, and other Oracle utilities. Hands-on experience with OEM (Oracle Enterprise Manager) for monitoring and performance optimization. Familiarity with transaction monitoring and use of third-party tools. Additional Skills: Experience with Java and integration of database logic with Java-based applications. Strong debugging, troubleshooting, and performance improvement capabilities. Responsibilities:
Design, develop, and maintain robust PL/SQL programs, stored procedures, triggers, and packages. Work with application teams to integrate database solutions and ensure data accuracy and consistency. Tune SQL queries for performance optimization using Oracle tools and best practices. Monitor and troubleshoot database performance issues using OEM and other diagnostic tools. Participate in database design discussions and ensure proper indexing, partitioning, and storage management. Collaborate with QA and DevOps teams to support builds, deployments, and defect resolution. Document technical solutions, queries, and procedures for maintainability and compliance. Provide production support and proactively monitor database health and performance.
Desired Skills: Oracle | SQL | PLSQL
Thanks & Regards,
Shashi Bhushan
Diverse Lynx LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540
Office: +732-452-1006 ext:344
Email: shashi.bhushan@diverselynx.com | URL: http://www.diverselynx.com
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Location: NY City, NY
Job Description
Must have: We are seeking a highly experienced Oracle PL/SQL Developer with 10+ years of professional experience in designing, developing, tuning, and monitoring Oracle-based systems. The ideal candidate should be proficient in writing complex queries, managing database objects, and optimizing performance using tools like Oracle Enterprise Manager (OEM). A strong background in SQL, PL/SQL, and Java, along with the ability to work on enterprise-level solutions, is essential for this role. Must-Have Technical / Functional Skills:
Core Database Skills:
10+ years of hands-on experience in Oracle Development. Expert-level proficiency in SQL and PL/SQL. Strong experience in designing database objects such as tables, triggers, procedures, and partitions. Ability to write and optimize complex SQL/PLSQL queries for data analysis and processing. Performance Tuning & Tools: In-depth knowledge of SQL Tuning, SQL traces, SQLLDR, and other Oracle utilities. Hands-on experience with OEM (Oracle Enterprise Manager) for monitoring and performance optimization. Familiarity with transaction monitoring and use of third-party tools. Additional Skills: Experience with Java and integration of database logic with Java-based applications. Strong debugging, troubleshooting, and performance improvement capabilities. Responsibilities:
Design, develop, and maintain robust PL/SQL programs, stored procedures, triggers, and packages. Work with application teams to integrate database solutions and ensure data accuracy and consistency. Tune SQL queries for performance optimization using Oracle tools and best practices. Monitor and troubleshoot database performance issues using OEM and other diagnostic tools. Participate in database design discussions and ensure proper indexing, partitioning, and storage management. Collaborate with QA and DevOps teams to support builds, deployments, and defect resolution. Document technical solutions, queries, and procedures for maintainability and compliance. Provide production support and proactively monitor database health and performance.
Desired Skills: Oracle | SQL | PLSQL
Thanks & Regards,
Shashi Bhushan
Diverse Lynx LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540
Office: +732-452-1006 ext:344
Email: shashi.bhushan@diverselynx.com | URL: http://www.diverselynx.com
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.