Be overall responsible for the development and management of a Unified Beneficiary Registry under the overall direction of Additional Director, IT Infrastructure.
Acquire full familiarization with the PSPA mandate, structure and activities including all government and donor funded programs and their data requirements.
Interface with PSPA management team and user wings develop requirements and protocols for a data analysis exercise for informing the design of a Unified Beneficiary Registry.
Perform data analysis activities to capture data requirements for Unified Beneficiary Registry clearly, completely, and accurately while, at the same time, representing them in a formal and visual way through data models.
Finalize design and operationalize a Unified beneficiary Registry for PSPA.
Prepare/assist in development of System Requirement Specifications (SRS).
Design and develop the required operational database procedures, ancillary processes as well as selection of appropriate hardware systems to ensure an effective and efficient continued operation of database environment.
Assist in developing policies and procedures for data security including rules for approving/disapproving data requests and their compliances, maintaining log files and others associated functions.
Provide database related essential support to other MIS staff and user wings in accordance with design requirements and implementation of application systems, database(s) and other data files. The support may include the use of data dictionaries, database, table designs, database modelling and development of technical procedures to support the application’s implementation process.
Develop and implement disaster recovery policies/plans and procedures.
Design, install and maintain current databases.
Perform routine data backups and restore functions.
Perform a wide range of database administration functions such as configuring database tables, views, and stored procedures; running test queries; troubleshooting database problems; maintaining version control and proper security policies and procedures.
Conduct periodic maintenance of database(s), tuning to optimize data management processes, perform load balancing, redundancy, fault tolerance and system optimization.
Produce regular analytical reports on database performance to identity gaps and improve overall quality in terms of data reliability, data security and maintenance, including the use of periodic data backups and data restoration procedures.
Provide lead support in the development of service level agreements (SLAs) for common needs, especially, cross government services (Like NADRA, PITB etc); ToRs/Requirement Specifications for procurement of IT equipment and technical software development. Participate in technical pre-bid and negotiation meetings, as well as manage contracts. Maintain software licensing and maintenance agreements.
Perform any other task assigned by Additional Director, IR Infrastructure and/or CEO PSPA in furtherance of PSPA mandate and objectives.