Vkore Solutions - San Ramon, CA

posted 2 months ago

Full-time
San Ramon, CA
Professional, Scientific, and Technical Services

About the position

The PL/SQL Developer position involves a comprehensive role focused on the design, development, and optimization of PL/SQL stored procedures, functions, and triggers specifically within Oracle 12c or higher environments. The successful candidate will be responsible for ensuring the high performance, security, and reliability of Oracle databases, which includes performing database tuning and troubleshooting to maintain optimal database functionality. In addition to PL/SQL development, the role requires proficiency in UNIX scripting, where the developer will create and maintain UNIX shell scripts (versions 6/7/8) to automate processes and manipulate data effectively. The position also entails Java development, specifically working with Java version 6 and above, and integrating with JMS (Java Messaging Service) for enterprise messaging solutions. Version control is a critical aspect of this role, as the developer will utilize Git to manage code repositories and collaborate on code changes with team members. Familiarity with AWS services is essential for deploying, scaling, and managing applications in a cloud environment. The candidate will also implement and manage continuous integration and deployment processes using tools such as Harness or Jenkins, ensuring a streamlined development workflow. Effective issue tracking and project management will be conducted using JIRA, and the developer will manage job scheduling through tools like Autosys or Korn Job, with experience in JCL software being a plus. This position is integral to the development team, contributing to the overall success of database management and application deployment.

Responsibilities

  • Design, develop, and optimize PL/SQL stored procedures, functions, and triggers in Oracle 12c or higher.
  • Ensure high performance, security, and reliability of Oracle databases.
  • Perform database tuning and troubleshooting.
  • Develop and maintain UNIX shell scripts (versions 6/7/8) for automation and data manipulation.
  • Work with Java v6 and above, including integration with JMS for enterprise messaging.
  • Utilize Git for version control and manage code repositories.
  • Implement and manage continuous integration and deployment processes using tools such as Harness or Jenkins.
  • Use JIRA for issue tracking and project management.
  • Manage job scheduling using tools like Autosys or Korn Job.

Requirements

  • Proven experience in PL/SQL development with Oracle 12c or higher.
  • Strong understanding of database management, performance tuning, and troubleshooting.
  • Experience in developing UNIX shell scripts (versions 6/7/8).
  • Proficiency in Java v6 and above, with experience in JMS integration.
  • Familiarity with version control systems, particularly Git.
  • Experience with AWS services for application deployment and management.
  • Knowledge of CI/CD tools such as Harness or Jenkins.
  • Experience with issue tracking and project management tools like JIRA.
  • Familiarity with job scheduling tools like Autosys or Korn Job.

Nice-to-haves

  • Experience with JCL software for job control language tasks.
  • Knowledge of additional programming languages or frameworks related to database management.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service