SR ORACLE APPLICATIONS SYS ADMINISTRATOR.7000200
Dallas, TX
| Employer: | Dallas County |
Description | |
|
Brief Description Secures, Reviews, Analyzes, Designs, Implements and Maintains Oracle Applications (E-Business Suite - Financials, CLASS-Countywide Receipting, FAMIS, and KRONOS). Gathers requirements from users for new or enhanced programs and systems and creates specifications and recommendations. Writes, tests, debugs, and documents programs and systems for database access, modification, and reporting. Manages and controls the security and access, and ensures adherence to change management policies and procedures; converts third-party applications; and supports third-party applications. Detailed Description E-Business Suite - Implements the EBS security model by defining menus, responsibilities, request groups, functions, password resets, and menu exclusions including, but not limited to: Function Security, Data Security, Oracle User Management, Profile Options, Printer, Password Resets, Oracle Applications Manager (OAM), Concurrent Programs and Requests, and Oracle Workflow.CLASS (Countywide Receipting) System generates proper accounting to reflect impacts to revenue and cash accounts within the General Ledger. Configure the Receipting Menu definitions and setups, train departments, password resets, and engage in user acceptance testing (UAT). Edit and/or perform update Department's Receipting Menu as requested. FAMIS - Enterprise Facilities Management system provides software products and services to help organizations maintain and operate facilities assets. Create new users, administer security groups, oversee self-service security, perform password resets, and administer personnel configuration. Edit/Update user access upon request.KRONOS - Trouble shoot time clock issues: reset clocks, program new clocks, trouble shoot punches, restart server, and administer patches.HEAT TICKET SYSTEM - Monitors Oracle queue, quickly addressing issues. Job Requirements Education, Experience and Training:Education and experience equivalent to a Bachelor's degree from an accredited college or university in Computer Science, Information Technology, Mathematics, Engineering, Business Administration, Public Administration or in a technical job related field of study. Four (4) years of related work experience in a large enterprise systems environment; using Oracle platform, SQL and PL/SQL skills.Special Requirements/Knowledge, Skills & Abilities:Ability to effectively communicate, both verbally and in writing, and establish and maintain effective working relationships with employees, departments and the general public. Experience working on AIX platform to perform required job functions. Experience with Oracle Applications version 12 or higher financials, human relations, and payroll. Experience using Oracle APIs for Oracle Applications version 12 or higher required. Experience with Unix shell scripting, and TOAD. Query tuning experience. Oracle Certified Developer preferred. Knowledgeable of database requirements for high availability environments. Knowledge of creating new tables, indexes, views, synonyms, and constraints. Experience interfacing and converting to and from Oracle Applications objects required. Must possess a valid Texas Drivers License and good driving record. Will be required to provide a copy of 10-year driving history. Must maintain a good driving record and remain in compliance with Article II, Subdivision II of Chapter 90 of the Dallas County Code."Individuals holding or considered for a position which has, or may have, access to criminal justice databases including the FBI Criminal Justice Information Systems, NCIC/TCIC and similar databases, must pass a national fingerprint-based records check prior to placement in such position and may be denied placement in such positions and/or access to such systems. Incumbents must also maintain the ability to pass the records check while in the position or until such time that the Commissioners Court and the County Civil Service Commission deem this position no longer has this requirement."Must have a valid Texas Drivers License and good driving record. Will be required to provide a copy of 10-year driving history. Must maintain a good driving record and remain in compliance with Article II, Subdivision II of Chapter 90 of the Dallas County Code.Physical/Environmental Requirements:Standard office environment. Must be able to work varied days and shift schedules, to include weekends and holidays. Requires prolonged sitting, standing, walking. Additional Details An extensive pre-employment background investigation will be conducted on all applicants who have been offered a position with Dallas County. The hiring process involves successful completion of each step. The steps include: Criminal History Review, Traffic Violations Record, Review of Personal History Statement and Documents, Physical Examination, and Background Investigation. Dallas County is an Equal Employment Opportunity Employer.AmeriCorps, Peace Corps, National Service Alumni volunteers, and persons with a criminal background are encouraged to apply. | |