PeopleSoft DBA
Role 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