The incumbent is responsible for ensuring data is accurately transferred from legacy systems to Fusion Human Capital Management's database during the data migration processes, diagnosing and resolving database-related problems and maintaining thorough and accurate documentation of the database environment, configurations, procedures and troubleshooting steps.
Unit
Portfolio Management Office
Working relationships
Internal
1. Project Implementation Team
2. Data Management Unit
3. All Project Units
External
1. MPA Stakeholders
2. Subject Matter Experts
Physical Requirements and Work Environment
High demand, project based work environment.
Oversees and executes the accurate migration of data from legacy systems to the new Human Capital Management's database during migration processes, ensuring data integrity and minimizing disruptions to operations.
Utilizes troubleshooting skills and SQL/Unix/Linux/Oracle mastery to diagnose and resolve database-related problems efficiently, minimizing downtime and optimizing database performance.
Maintains thorough and accurate documentation of the database environment, configurations, procedures and troubleshooting steps, ensuring that information is readily available for reference and compliance purposes.
Implements and maintains database security measures, utilizing knowledge of database security principles to protect sensitive data and ensure compliance with regulatory requirements.
Provides training and support to technical staff, including developers and administrators working with Fusion HCM, to ensure effective use of the database environment.
Applies project management knowledge to effectively plan, organize and execute database-related projects, ensuring timelines and deliverables are met within budget constraints.
Provides leadership and supervision to database administration team members, while ensuring alignment with organizational goals.
Performs other related duties as required.
1. Eight to Ten (8-10) years’ experience working with PeopleSoft Databases in a high quality data driven environment.
2. Four to Five (4-5) years’ operating at a supervisory level.
3. Proficiency in database querying, optimization and management using SQL.
4.Proficiency in Unix/Linux operating systems for system-level administration and scripting.
Technical Competencies
Project Management Knowledge
Knowledge of Database Security
Troubleshooting Skills
Database Management and Migration
Coaching and Technical Training
SQL/Unix/Linux/Oracle Mastery
HTML Knowledge
Behavioural Competencies
Leadership and Supervisory Skills
Organizing and Executing Skills
Adaptability and Flexibility
Communication, Interpersonal Relations and Stakeholder Relations Skills
Collaboration and Relationship-building Skills
Problem-solving and Analytical Skills
Academic Qualifications
1.Bachelor Degree in Information Technology or Computer Science from a recognised University.
2. Database Certification.
3. Post graduate qualifications would be an asset.