Senior Oracle Developer

The Sr Analyst Application Services/Technical is a high-level individual contributor in the Application Services area of the Information Services (I/S) department. This position leads, modifies, configures, tests, implements, and maintains third-party computer application software and/or designs and develops specialized fit-to-purpose programs utilizing Company standards and practices. The position analyzes business needs, translates needs into requirements, and develops or recommends software solutions with the aim of optimizing operational efficiency. This position also supports business operations by providing guidance, training, and system support while continuously analyzing current business processes against related policies and procedures to promote technology innovations aimed to maximize productivity and standardization across the organization. This position performs work with a high degree of latitude and independently at times and handles the most complex issues and problems using advanced theories, methods, and techniques to complete work. Provides leadership, coaching, and/or mentoring to Analyst I/Application Services and Analyst II/Application Services.

POSITION DIMENSIONS

The incumbent does not have accountability for budgets but may have accountability for direct reports. The incumbent frequently exchanges information with senior management, Information Services support staff, vendors, and consultants.

QUALIFICATIONS

There are clear precedents and practices which the incumbent uses to determine how this job is

performed. Possesses expert technical knowledge of subject matter. Requires four to six years of

relevant work experience and a bachelor’s degree in a related field from an accredited university, or

equivalent combination of education and experience sufficient to successfully perform the essential

job responsibilities.

Competencies required: Ability to work as part of a team; Problem management; Problem-solving

skills; Analytical thinking skills; Technical expertise; Debugging skills; Computer skills; Detail

oriented; Ability to meet deadlines; Project management skills; In-depth experience with two or more

programming languages or frameworks.

Industry recognized certification(s) relevant to responsibilities are preferred. Incumbents performing

activities requiring government, regulatory or vendor certification must keep those certifications

current.

ESSENTIAL JOB RESPONSIBILITIES

• Design, develop and maintain front end GUI screens for a custom application using Oracle Fusion Middleware Development Tools. Proficiency and experience with Oracle Forms and Oracle Reports is required for this position.

• Design and maintain Oracle RDBMS and related objects (tables, views, stored procedures, triggers, packages).

• Design, develop and maintain complex PL/SQL code within procedures, functions, packages, triggers.

• Design, develop and debug complex SQL queries including dynamic SQL.

• Participate in established software system testing and validation procedures and documentation.

• Plan, design, and conduct appropriate levels of application or infrastructure testing, including preparation of test plans, scripts, data, and expected results.

• Support production environment by troubleshooting issues and working rapidly to provide a workaround or resolution to the stated issue.

• Consult with business support group and application users to understand business requirements and translate those concepts into a formal technical design.

• Select and utilize appropriate troubleshooting approaches to address customer specific issues in a comprehensive and useful manner, display a broad grasp of the relevant technical concepts, and incorporate these concepts into pragmatic solutions for customers.

• Take part in peer code reviews and ensure adherence to coding standards, security and compliance rules.

• Work within the constructs of the Software Development Life Cycles (SDLC) and/or Agile/Scrum philosophy.

• Troubleshoot, debug, and fix performance bottlenecks in application database queries, application GUI screen, packages or procedures.

• Work with project management and/or business area personnel to determine functional needs and identify technical application requirements, including requirements for security, recovery and integration with related applications.

• Participate in the analysis and prioritization of system enhancements and upgrades and ensure appropriate coordination and communication.

• Confer with other teams such as system architects, middleware analysts to design systems and perform tasks related to enhancements, performance and security.

• Work closely with DBAs and infrastructure teams to ensure system stability and scalability.

• Support modernization initiatives.

• Implement proper application software version control related tasks.

• Work independently or in a team construct to produce results in timely and efficient manner.

SALARY DETAILS

Las Vegas: $95,248.00 - $142,871.00

At Southwest Gas, attracting the best talent is key to our strategy and success as a company. We use flexibility to develop competitive compensation offers to ensure we are able to hire the best candidates. The quoted salary range represents the minimum and maximum of the pay range for the position. It is provided as a good faith estimate as to what our ideal candidates are likely to expect, as we tailor our offers within the range based on the selected candidate's experience, industry knowledge, location, technical and communication skills and other factors that may prove relevant during the interview and selection process.

Our History

Southwest Gas Corporation was founded in 1931 and is a subsidiary of Southwest Gas Holdings Inc (https://www.swgasholdings.com/) . We provide natural gas service to Arizona, Nevada, and portions of California. Our communities, and the more than 2 million customers we serve, are the reasons why we've been heating things up for decades. So, whether you’re enjoying a backyard barbeque with friends, getting cozy indoors during the winter, or preparing an epicurean delight in your new restaurant, Southwest Gas is here to support your comfort and your lifestyle.

Southwest Gas is an equal opportunity employer, disability/veteran, and an at-will employer.