Performance Management & Reporting System (PMRS) Administrator

Job Description

The candidate should work as a Performance Management Reporting System administrator within a team environmentor as autonomously as a sole project resource.PMRS Administrator should be capable of leading requirements gathering workshops as well as designing, developing,modifying, adapting, and implementing solutions based on customer needs through new and existing applications andinfrastructure.The applicant will apply advanced technical knowledge to analyse and solve a range of straightforward problems using standard procedures, with a low to moderate level of guidance and direction. Individuals at this level should have a broad range of knowledge and experience in the field of database administration and ensure that the performance of companys assets and Service provider is accurately monitored using PMRS database tools and Business Intelligence solutions, while still acquiring higher level technical expertise and project management capabilities.Duties & Responsibilities:

• Ensures PMRS (Performance Management Reporting System) accurately monitors and reports the
• performance of companys assets and services, service providers (including KPRs calculations) and companys deps business related activities.
• Develop new workflows and reports as required by end users and implement any required PMRS tool enhancements
• Manage patching, cloning, workflow, implementation and review of security controls, backup and recovery procedures, and replication activities for system and database
• Installing, patching, maintaining, and upgrades Oracle applications using Oracle utilities and monitoring tools.
• Setup and monitor backups, implement and test recovery techniques, diagnose and correct performance problems.
• Installation, configuration, tuning, and maintaining production, development, training, and test environments.
• Manage clustering, standby databases, physical and logical replication and database management and monitoring.
• Database installation, configuration, performance tuning and troubleshooting.
• Database Backup and Recovery, hot and cold backups, export backups, and backup scripting.
• Database storage planning.
• Implement data protection and privacy controls on the database wherever applicable.
• Monitors PMRS reliability and manage any troubleshooting required with SAP.
• Monitor the accuracy of the data from the sources and trouble shoot and liase as necessary with sub- contractors when anomalies are observed.
• Extract data from database and validates with RKH that it is accurate and fit for purpose.
• Source and input any manual data and validate that it is accurate and fit for purpose.
• Develop new system generated queries/ reports as required by business using workflows and Microsoft BI Tool.
• Maintain the entire MicroStrategy or Power BI platform including Infrastructure, security (users, groups, content), portal customization, mobile content enablement, etc.
• Train staff when required
• Communicate regularly with executive management and all users of information services and systems
• Check and analyze all data, logs, reports and suggest improvement action plans
• Implement and follow KPIs
• Support end-users with Dashboard and Reporting creation including top level management

• Display ownership and independent trouble shooting on systems and databased related issues
• Make routine decisions guided by policies, procedures, with guidance from manager
• As delegated by line manager

• Review system requirements and business processes; code, test, debug and implement solutions
• Participate in medium to high complexity BI developments (using front-end or back-end tools) at an advanced level while following best practice principles with minimal guidance
• Demonstrate advanced data management knowledge using Kimball methodology to create data warehouses to support decision making in an organization and/or data marts for a single department or function
• Utilize query optimization based on specifics of each database engine as well as distinctive statements and features of the most the common databases in the market
• Lead conversations with technical and business users to gather both technical and functional requirements
• Gather business and technical requirements autonomously and translate into Business Requirements Document and Technical Design Specifications Document
• Able to develop and present a project plan for a project of medium complexity.
• Able to work autonomously in a medium complexity customer project with day-to-day project management responsibilities
• Comply with the Company Quality, Health and Safety, Environmental Policies and Management

Keyskills :