Oracle PL​/SQL Developer

Job Description

Must Have Technical/Functional Skills

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.

• 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/PL/SQL queries for data analysis and processing.

• 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.

• Experience with Java and integration of database logic with Java‑based applications.
• Strong debugging, troubleshooting, and performance improvement capabilities.

• 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 Dev Ops 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.

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage:
  Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support:
  Maternal & Parental Leaves.
• Insurance Options:
  Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth:
  Commuter Benefits & Certification & Training Reimbursement.
• Time Off:
  Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance:
  Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
• Salary Range: $100,000-$115,000 a year

Bachelor of Computer Science.