We are currently seeking a PeopleSoft DBA/Administrator.

Job Description

This position implements and maintains complex PeopleSoft databases, including installations, upgrades, and maintenance of PeopleSoft software and providing internal technical support with the ability to work unsupervised in a 24x7 environment.  This position also requires considerable technical experience and knowledge of PeopleSoft (9.x) tables and data structures, and is responsible for managing and planning the overall maintenance and upgrade schedules of PS applications, will ensure that all patches, fixes and upgrades are fully researched and tested before being applied to the production environment, and will perform impact analysis across multiple applications where necessary.

 Responsibilities and Duties

• Designs, implements and maintains complex systems with respect to modeling, quality control, access, auditing, development, etc.
  
• Designs, implements and maintains reporting environments and data warehouses from base PeopleSoft data sources.
• Researches and helps implement more advanced modules and features of the databases (e.g., replication, clustering, partitioning, etc.)
• Develops and documents standards for proper PeopleSoft database administration.
• Leads complex projects which are consistent with the growth of Asplundh, DBA Services and Personal growth.
• Controls and monitors database and application security and integrity.
• Troubleshoots all database and/or application-related performance issues.
• Monitors database/application transaction activity and utilization.
• May assist Application Developers with performance tuning of SQL, queries and database objects.
• May assist Application Developers in developing stored procedures and/or triggers.
• Formulates and documents policies, procedures, and standards relating to PeopleSoft management.
• Prescribes user access requirements based on analysis of system function and end user service needs.
• Provide advice, support, and guidance to the programmers, developers and other DBAs regarding code review, design and problems.
• Reviews database design and integration of systems and makes recommendations regarding enhancements and/or improvements.
• Installs and upgrades PeopleSoft systems.
• Creates and maintains PeopleSoft Application Servers and Web Server.
• Creates and maintains PeopleSoft Process Schedulers.
• Provides 24x7 problem management support when needed.

Skills

• Communication - be readily accessible in order to respond to all reactive calls/emails.  Attend scheduled departmental and business unit calls/ meetings as required.  Provide appropriate and timely feedback to all stakeholders.
• Independent/effective output
• Deliver high quantity/quality of work at all times.  Request assistance when appropriate.  Present thoughtful solutions for consideration.
• Trouble Management.
• Troubleshoot basic to complex problems taking full ownership of problem until resolved - manage trouble and report status to end users according to guidelines Special Projects.
• Integrate into project team according to assignment.
• Participate/lead internal meeting sessions providing project status updates and track open tasks for confirmed completion.
• Provide back-up for IT team members as assigned.

 Technical Skills         

• Must have PeopleSoft 9.x experience.
• Must have a bachelor's degree or equivalent.
• Must have 6-8 years of Oracle DBA experience
• Must have 2 years of Oracle 10g experience
• Must have 6-8 years of UNIX experience with shell scripting (IBM/AIX preferred)
• Must have 4 years of Oracle programming/development (or related) experience
• Must have 4 years of PeoplSoft 9.x implementation/administration experience
• Must have 4 years of application server administration experience (Web Logic preferred)
• Data Communication Experience preferred
• MS SQL experience preferred

Education and Experience

• Bachelor degree preferred with a technical major, such as engineering or computer science

Physical Requirements:

Individuals must be able to perform the essential functions of the position with or without a reasonable accommodation.  Individuals with a disability who desire a reasonable accommodation should contact the ADA Coordinator at 1-800-248-8733, ext 1339.

An Equal Opportunity Employer, including disabled and vets.