ADMINISTRATOR, DATABASE (PEOPLESOFT)

Fort Bend Independent School District - Sugar Land, TX (30+ days ago)4.0


  • Bachelor’s degree required; Bachelor’s degree in Computer Science preferred
  • Associate’s degree or high school diploma with a minimum of 6 years of information technology experience will be considered in lieu of degree requirement
  • Minimum of 5 years in information technology, specifically software development, required
  • Minimum of 2 years’ experience of SQL and SQL programming techniques required
  • Minimum of 2 years of Windows Servers Administration experience required
  • Minimum of 2 years performing PeopleSoft Administration and DBA functions required; PeopleSoft v9.x and PeopleTools v8.5.x preferred
  • Minimum of 2 years of experience with any PeopleSoft supported RDBMS required; SQL Server experience preferred
  • Demonstrated experience using PS Portal with at least 2 other PS applications including, HCM, FSCM, CRM, EPM)
  • Demonstrated knowledge of PeopleSoft Upgrade Manager, EM HUB, Change Assistant, IB/Application Messaging and Tracing
  • Demonstrated knowledge of scripting including, data migration, Windows batch and SQL job, required
  • Demonstrated understanding of load balancing in web and application server tiers required
  • Troubleshooting skills in resolving performance, code migration, upgrades and operating system issues required
  • Excellent communication skills, both orally and in writing, required
  • Ability to establish, follow and enforce documentation standards and implement repeatable processes required
  • Ability to work in a team environment and in a proactive manner required
  • Ability to efficiently manage multiple tasks and meet deadlines required
JOB PURPOSE SUMMARY
The Database Administrator (PeopleSoft) will be responsible for working as part of a team to support the entire PeopleSoft Suite and its third party products. The Database Administrator (PeopleSoft) will be responsible for supporting the application development team in designing, modeling and creating databases, stored procedures, triggers etc., and moving all database objects to the production environment. The incumbent will ensure that development and staging production database environments are maintained, up-to-date and a disaster recovery plan is in place. The Database Administrator (PeopleSoft) must also design, develop and implement mappings/transformations based on source-to-target specifications.

ESSENTIAL DUTIES & RESPONSIBILITIES
  • Refresh development and test environments
  • Apply delivered updates including, Tax Updates, Maintenance Packs, PeopleTools patchsets, Fusion Middleware critical fixes, etc
  • Migrate customizations through proper environments and into production
  • Perform PeopleSoft Application and PeopleTools upgrades as planned and agreed with development team
  • Use tuning tools to improve database performance
  • Review audits to ensure system integrity regularly
  • Ensure the backup and recovery plans for the application database remain up to date and tested on a reoccurring basis
  • Conduct capacity planning for server hardware utilization (CPU, RAM, disk)
  • Manage security for direct access to RDBMS and servers
  • Build new PeopleSoft servers and/or environments
  • Manage outages and server upgrades
  • Prepare project plans and schedules for database-related implementation and support efforts
  • Communicate regularly with internal technical, applications and operational staff in order to ensure the database integrity, security and availability
  • Implement and maintain physical database systems
  • Perform other duties as assigned
KNOWLEDGE, SKILLS AND ABILITIES