Sterling 5 - Houston, TX

posted 3 months ago

Full-time - Mid Level
Houston, TX
Professional, Scientific, and Technical Services

About the position

The Oracle PL/SQL Developer position is a critical role within our organization, focusing on the planning, design, development, testing, migration to production, and maintenance of applications utilizing Oracle and third-party tools. The ideal candidate will have over 10 years of hands-on experience in advanced PL/SQL programming, specifically with Oracle Database versions 11g and 12c. This role requires a deep understanding of complex query writing, advanced PL/SQL concepts, and performance tuning. The developer will be responsible for analyzing and converting business requirements into technical specifications, designing and implementing effective solutions, and participating in defect triage and resolution planning. In addition to technical skills, the Oracle PL/SQL Developer will support team members, including DBAs and database developers, in understanding data and meeting user requirements. The role involves collaboration with Subject Matter Experts and stakeholders to gather data-specific needs and participate in performance tuning activities. The developer will also provide production deployment and support as necessary, demonstrating a comprehensive understanding of the software development life cycle. The position is set in a hybrid work environment, requiring three days onsite and two days remote, and is expected to last for 6-8 months with the potential for a contract-to-hire transition. The successful candidate will thrive in an agile, rapid development environment, showcasing strong written, oral, and interpersonal communication skills. They will also be expected to conduct research into software-related issues and products, working both independently and collaboratively within a team.

Responsibilities

  • Perform planning, design, development, testing, migration to production, and maintenance of applications using Oracle and third-party tools.
  • Write complex queries using advanced PL/SQL concepts and perform performance tuning.
  • Assist in defect triage, impact analysis, resolution planning, and implementation.
  • Analyze and convert business requirements to technical requirements, followed by designing and implementing solutions.
  • Review Oracle ADDM and AWR reports and recommend query optimization based on analysis.
  • Leverage Oracle 12C features on a large-scale multi-terabyte system.
  • Support team members including DBAs, database developers, and requirements analysts in understanding data and meeting user requirements.
  • Participate in project work groups with Subject Matter Experts and stakeholders to understand data-specific needs.
  • Participate in performance tuning activities.
  • Provide production deployment and production support as needed.
  • Involved in all aspects of the software development life cycle, demonstrating abilities to learn both business processes and new technologies.
  • Work on a sprint team in an agile, rapid development and deployment environment.

Requirements

  • 10+ years of hands-on experience in advanced PL/SQL programming using Oracle Database versions 11g and 12c.
  • Proficiency in TOAD/SQL Developer and operating systems such as Linux, Unix, and Windows.
  • Ability to participate in multiple projects simultaneously.
  • Bachelor's degree in computer science or related discipline preferred.
  • Training or Certification on Oracle PL/SQL Language is an added plus.

Nice-to-haves

  • Experience with MS SQL Server, Java, and Fusion Middleware 11g (BPEL, B2B, Spring Bean, OSB).
  • Familiarity with WebLogic, Visual Studio, .NET Framework, and Cloud Computing.
  • Knowledge of Team Foundation Server and internet technologies like HTML, DHTML, XML, CSS, XSLT, SOAP, WSDL, SOA.
  • Experience with scripting languages and ServiceNow.
  • Knowledge of SDLC activities on development projects and Electric/Gas industry experience.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service