Job Description

Designs, implements, and maintains complex systems with respect to modelling, 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