Programmer/Analyst Senior (Oracle)

Print


Programmer/Analyst Senior (Oracle)

Salary

$70,600.00 - $108,200.00 Annually

Location

St. Louis, MO

Job Type

Full-Time

Job Number

15-1855-2

Department

Information Technology

Division

IS - Application Services

Opening Date

01/30/2015

Closing Date

2/22/2015 11:59 PM Central

Description

Under general direction, perform work of considerable difficulty in designing, programming, testing and implementing major computer based information systems.

Examples of Duties

Essential Functions: Reviews, analyzes, designs and programs information systems including encoding, testing, debugging and documenting programs; familiar with and highly skilled in a variety of JAVA or .NET concepts and web based technologies, practices, and procedures; able to create advanced documentation in support of work performed including sequence diagrams, integrated test plans and test data, design and program documentation as well as implementation documentation; demonstrated experience with databases such as Oracle and SQL Server; able to provide technical leadership and direction to less experienced programmers within work group; relies on experience and judgment to plan and accomplish goals and project tasks; utilizes a wide degree of creativity and latitude in performing work

Additional Responsibilities: Maintains confidentiality and integrity of District records and procedures;  prepares reports and updates documentation & project plans; may lead and direct the work of others; may report directly to a project leader/manager or manager; performs related work as required or as delegated by supervisor.

Minimum Qualifications

Training and Experience: Bachelor's degree in Information Systems or related degree; five years of progressively responsible experience in development across multiple platforms as well as related development life cycle methodology experience.  Experience in mobile platform development will be a plus.

Desirable Knowledge, Skills and Abilities: Extensive knowledge of the system development cycle, including systems analysis and design, programming (Java or .NET technologies), testing, and implementation; knowledge and experience with ERP applications (Oracle EBS suite and Maximo) is desirable; extensive knowledge of relational data base(s) (Oracle or SQL Server) is required; ability to consider and utilize new techniques and tools as part of the development cycle is important;  thorough knowledge of the principles and practices of information systems including considerable familiarity with project management principles; considerable skill in leading projects and getting quality work done through others; demonstrated kill in preparing and delivering oral presentations; ability to maintain effective working relationships with others; ability to communicate effectively; ability to develop the appropriate documentation to support all job tasks and assignments.

Competencies:

District Core: Action Oriented, Building Effective Teams, Customer Focus, Ethics and Values, Functional/Technical Skills, Informing, Integrity and Trust, Interpersonal Savvy, Listening, Managing Diversity, and Peer Relationships

Position-Specific:Time Management, Career Ambition, Timely Decision Making, Presentation Skills, Planning, Drive for Results, Self-Development, Standing Alone, and Technical Learning.

Additional Information

Employees of MSD must have a proficient or higher overall rating on last review.

ALL OF THE BELOW BENEFITS ARE AVAILABLE TO REGULAR, FULL-TIME EMPLOYEES.

WAGE AND SALARY - Our policy is to pay competitive wages. Advancement within a pay grade is based upon merit, in accordance with the provisions of the Compensation Plan.
 
PROMOTIONAL OPPORTUNITIES - It is the policy of MSD to promote from within whenever possible. Employees who meet the qualifications and apply for promotion are placed on the eligibility list upon receiving a passing score on a qualifying examination for that class.
 
WORKING HOURS - MSD Headquarters has a core workday ranging from 7:30 a.m. to 5:30 p.m. Working hours depend upon position/department. For Operations the hours are 8:00 a.m. to 4:30 p.m., except for those employees assigned to work other specified shifts. For certain positions the District offers a Flexible Working Schedule that would allow for either a whole or half day off in a two-week pay period.
 
VACATION - Vacation is accrued at the rate of ten (10) days per year up to five years of service; 15 days per year with 5-9 years of service; 20 days per year with 10-19 years of service; and 25 days per year with 20 or more years of service. Employees begin to accrue vacation when hired, but may not use it until satisfactorily completing six months of employment.   Vacation time can be carried over from year to year within MSD guidelines. Vacation may be used in whole, half-day or hourly increments; and under certain conditions the District allows for sellback of vacation.
 
HOLIDAYS - MSD grants employees 12 holidays per year, which are the ten federal holidays plus two personal holidays. In addition, an employee can earn up to three additional personal holiday each year for good attendance or perfect attendance.
 
SICK LEAVE - Sick leave is granted to all employees for excused absences because of illness. Sick leave is accrued at rates of 10 to 12 days per year, depending upon the length of service, and there is no maximum number of days that can be accumulated. A percentage of accumulated but unused sick leave is paid to a vested employee upon retirement. Employees begin to accrue sick leave when hired, but may not use it until three months of service has been completed.
 
MEDICAL COVERAGE - Group medical coverage in a Point-of-Service plan is available upon one month (30 days) of service. The District currently pays 80% of employee only coverage and 70% of employee with dependent coverage. Payroll deducted employee contributions are on a pre-tax basis. MSD offers a choice of two (2) medical plan options, Traditional or High Deductible and four coverage categories: employee only; employee and spouse; employee and child(ren); and family. Open Enrollment is held each year in January for changes, which become effective February 1.
 
DENTAL COVERAGE - Group dental coverage is available upon one month (30 days) of service. The District contributes $10.00 per month toward the cost of dental coverage. Payroll deducted employee contributions are on a pre-tax basis.   MSD offers two (2) dental plan options to employees and their dependents. Open Enrollment is held each year in January for changes, which become effective February 1.
 
LIFE / ACCIDENTAL DEATH & DISMEMBERMENT INSURANCE - MSD provides basic life insurance and accidental death and dismemberment insurance equal to the employee's annual base salary rounded up to the next thousand dollars. This insurance is effective upon one month (30 days) of service.
 
OPTIONAL LIFE INSURANCE - Employees have the option of purchasing additional life insurance at their cost in an amount up to five (5) times their annual base salary rounded up to the next thousand dollars, with a maximum of $400,000. This optional life insurance offers the opportunity to purchase $10,000 coverage for their spouse and $5,000 coverage for each dependent child. In order to purchase insurance on a spouse and/or children, the employee must purchase insurance on himself/herself.    Employees must complete one month (30 days) of service to be eligible for this insurance. Coverage is subject to medical approval.
 
VOLUNTARY ACCIDENTAL DEATH & DISMEMBERMENT (VAD&D) INSURANCE
Employees have the option to purchase additional accidental death and dismemberment insurance at group rates. Employees may purchase insurance up to $500,000 in increments of $10,000.   Employees may elect to purchase this coverage on an individual basis, or elect a family plan that includes their spouse and dependent children. The dependent coverage is based on a percentage of the employee's elected insured amount. Employees must complete one month (30 days) of service to be eligible for this insurance.

VOLUNTARY BENEFIT PLANS – Accident Insurance, Hospital Indemnity Insurance, and Critical Illness and Cancer Insurance
 
LONG TERM DISABILITY INSURANCE
The District provides long term disability insurance to all employees upon one month (30 days) of service. This benefit provides partial income replacement up to age 65 for an employee who is deemed disabled under the plan due to injury or illness for an extended period of time.   The District pays 100% of the cost of this coverage.
 
VISION PLAN
Upon one month (30 days) of service, the District will reimburse employees up to $100 per fiscal year (7/1 - 6/30) for the cost of employee, spouse, or dependents' prescription eye ware. Any amount of the $100 that is not used in a fiscal year is rolled over to the next fiscal year up to a maximum of $300.
 
REIMBURSEMENT ACCOUNTS - Employees may elect to participate in the Health Care Reimbursement Account and/or Dependent Care Account and use pre-tax dollars to pay for non-reimbursed medical, dental and child care expenses. Employees must complete one month (30 days) of service to participate in these accounts. Open Enrollment is held each year in January for changes, which become effective February 1.
 
DEFINED CONTRIBUTION RETIREMENT PLAN
This defined contribution plan offers employees the opportunity to build a retirement fund by combing a Fixed Contribution of 7% of covered wages contributed by the District for all participants with the opportunity for employees to make a Voluntary Contribution of up to an additional 4% of covered wages and receive a District Matching Contribution of 50%. Employees have the option to invest more than 4% on a tax deferred basis up to IRS limit; however, amounts over 4% will not qualify for the matching contribution percentage. Employees are always 100% vested in the Employee Voluntary Contribution and the District's Matching Contribution. The District's Fixed Contribution is subject to a 20% per year vesting schedule. Employees can invest the District's Fixed Contribution, the Employee Voluntary Contribution and the District's Match Contribution in the Vanguard investment options.
 
CREDIT UNION - MSD employees and their family members may join the American Eagle Credit Union and participate in their programs.
 
DIRECT DEPOSIT - Employees must have their paychecks deposited directly into their bank account or credit union. MSD offers various options that allow portions of the paycheck to be deposited into checking and/or savings accounts.
 
EDUCATIONAL ASSISTANCE - MSD encourages its employees to further their education by taking courses that will help in their job and career development. Approved courses are paid in advance. An employee receives full tuition for an "A", "B" or "C" grade. The maximum amount of Educational Assistance per employee for each fiscal year is $3,500.   An employee must satisfactorily complete six months of employment to participate in this program.
 
EMPLOYEE ASSISTANCE PROGRAM (EAP) - MSD provides an Employee Assistance Program to help employees deal with personal issues while maintaining their privacy. This program is offered to employees and all eligible members of the employee's household. Assessment and referral service is offered at no cost. EAP counselors will assist the employee in utilizing their health insurance for all outside referrals.
 
PRE-PAID LEGAL PLAN - Provides employees, their spouse, and dependents access to legal services for a monthly fee, which is paid through the convenience of payroll deduction. Open Enrollment is held each year in January for changes that become effective February 1.

01
Do you have a Bachelor's degree in Information Systems or related degree?
  • Yes
  • No
02
How many total years of IT experience do you have?
  • Less than 2 years
  • 2-4 years
  • 4-6 years
  • 6-10 years
  • More than 10 years
03
Do you have experience in Object Oriented Programming?
  • Yes
  • No
04
Check your total number of Oracle database years of experience.
  • None
  • Less than 2 years
  • 2-4 years
  • 4-6 years
  • More than 6 years
05
How many years of experience do you have in supporting an enterprise application?
  • None
  • Less than 2 years
  • 2-4 years
  • 4-6 years
  • More than 6 years
06
Do you have experience supporting finance and procurement?
  • Yes
  • No
07
If yes to question #6 then give details of your job responsibility. If you answered no to #6, then enter N/A.
08
Do you have experience in Crystal Reports or Oracle OBIEE?
  • Yes
  • No

Required Question

Agency
Metropolitan St. Louis Sewer District
Address
2350 Market Street

St. Louis, Missouri, 63103
Phone
(314) 768-6237 Option #2 for Talent Development
Website
https://www.msdprojectclear.org/careers
External Job Opportunities
Account
Terms Of Use
Cookie Settings
Copyright © 2024