Senior IT Software Developer

JOB SUMMARY

• This is the advanced journey level position performing Senior Information Technology Software

Developer job duties.

DISTINGUISHING CHARACTERISTICS

Positions at this level are recognized as technical specialist using initiative and resourcefulness in deviating from traditional methods or researching trends and patterns to develop new methods, criteria, or proposed new policies. Decisions regarding what needs to be done include interpreting data, planning of the work, or refining the methods and techniques to be used. The work involves establishing criteria; leading projects; assessing service effectiveness; or analyzing variety of unusual conditions, problems, or questions. The work product or service may affect activities or other operations.

OVERSIGHT

• Supervision Received: The supervisor sets the overall objectives and resources available. The employee and supervisor, in consultation, develop the deadlines, projects, and work to be done. At this level, the employee, having developed expertise in the line of work, is responsible for planning and carrying out the assignment; resolving most of the conflicts that arise; coordinating the work with others as necessary; and interpreting policy on own initiative in terms of established objectives. In some assignments, the employee also determines the approach to be taken and the methodology to be used.
• The employee keeps the supervisor informed of progress, potentially controversial matters, or farreaching implications. Completed work is reviewed only from an overall standpoint in terms of feasibility, compatibility with other work, or effectiveness in meeting requirements or expected results.
• Supervision Given: Acts as a lead. Coordinates and reviews work assignments of employees performing the same general work as the lead on a day-to-day basis. Responsibilities may involve solving problems and providing instructions on work procedures.

JOB DUTIES

1. Defines, designs, develops, and deploys new or modified custom software that generates reports and sub reports accessing multiple data bases.

2. Defines, designs, develops, and deploys new or modified custom software, programming language, and structured query language for relational databases.

3. Reviews deliverables, provides technical advice, and makes recommendations.

4. Defines, designs, develops, and deploys new or modified data marts for specific business domains, Extraction Transformation Load scripts, and Business Intelligence dashboards. Optimizes and tunes new or modified data marts.

5. Acts as Project Manager; plans, coordinates, and conducts projects within area of responsibility, including monitoring scope, quality, budget, and schedule.

6. Performs other related Application Software Developer job duties as required. Required Knowledge of: Reporting tools concepts and tool specific functions; relational database; Relational Data Base - Data Definition Language create tables, indexes, views; Unified Modeling Language Concepts; Object Oriented Concepts; reporting tools functions; relational data base objects: triggers, stored procedures and packages; coding data base query statements; instantiate Object Oriented classes extending HTTP protocol; reports, sub-reports and advanced reporting functions and stored procedure calls; design, code, test and deploy relational database sub queries, out joins, unions, cursors and exception handling; code and implement middle tier classes and interfaces; multi-threaded and collection of objects processing; dynamic reporting applications using incoming parameters; designee, code, test and deploy relational data base objects: Data base security, firewall technologies, roles and user privileges; web services technology; Data warehouse star schema, dimensions, fact table. Data warehouse data management tools; Extraction Transformation Load processors; Business intelligence dash boarding; Data warehouse tuning and establish the most efficient dimensions, fact table and Extraction Transformation Load processes for high system availability; and current office technology and equipment.

Required Skills and Abilities to:

• Tune reports process, anticipate potential performance problems, determine and implement solutions; tune relational data base applications, integrate multi data base schemas, and provide technical advice; tune and enhance distributed software applications; integrate transactional data with data warehouse for strategic planning applications; produce reports, understand reporting tools and access vendor site; work with relational database triggers, stored procedures, cursors and referential integrity objects; access relational database vendor web tutorials and training documentation; instantiate existing Object Oriented classes; invoke business logic objects from Graphic
• User Interface objects; provide strategic and tactical planning for enterprise information systems; develop prototypes; perform data warehouse tuning and consolidation of multiple data marts into an Enterprise Data warehouse; use independent judgment and exercise discretion; problem solve; prioritize and multitask; communicate clearly and concisely, both verbally and in writing; establish and maintain effective working relationships with those contacted in the course of work; work independently and in a team environment; lead and train; and operate current office equipment including computers and supporting applications.

EMPLOYMENT STANDARDS

MINIMUM QUALIFICATIONS

• Education and Experience: Bachelor s degree from an accredited college or university in a related
• field and six years of relevant experience; or Master s degree from an accredited college or university in a
• related field and four years of relevant experience.
• Experience with IBM Maximo EAM technology and providing Maximo technical support in areas such as: application configuration, database configuration, automation scripts, MIF (Maximo Integration Framework) interfaces, security, escalation, workflows, migration manager, etc. REQUIRED
• Proficient knowledge of relational database and Maximo's data model. REQUIRED
• Experience using programming languages such as: Oracle PL-SQL, Oracle SQL, Jython, Java, C#, xaml, xml, SOAP and/or REST APls.
• Demonstrates a positive attitude, customer service skills, problem solving skills, and the ability to work collaboratively with teammates and business stakeholders.

Maximo skills REQUIRED:

• Maximo Application configuration
• Maximo Database configuration
• Maximo Automation scripts
• MIF (Maximo Integration Framework) interfaces
• Maximo Security Groups
• Maximo Workflows
• Migration Manager
• Proficient knowledge of relational database and Maximo's data model.

CERTIFICATIONS, LICENSES, AND REGISTRATION REQUIREMENTS

• Employees in this position may be required to obtain and maintain the following certifications, licensing and registrations:
• e Valid California Class C Driver License that allows you to drive in the course of your employment

PHYSICAL DEMANDS, WORK ENVIRONMENT, AND VISION REQUIREMENTS

• The physical demands and work environment characteristics described here are representative of those that must be met or may be encountered by an employee to successfully perform the job duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the job duties.
• Physical Demands: The work is sedentary. Typically, the employee may sit comfortably to do the work. However, there may be some walking; standing; bending; carrying of light items such as paper, books, or small parts; driving an automobile, etc. No special physical demands are required to perform the work.
• Work Environment: The work environment involves everyday risks or discomforts that require normal safety precautions typical of such places as offices, meeting and training rooms, libraries, and residences or commercial vehicles, e.g., use of safe work practices with office equipment, avoidance of trips and falls, observance of fire regulations and traffic signals, etc. The work area is adequately lighted, heated, and ventilated.
• Vision Requirements: No special vision requirements.