Deputy Director (Database Administrator) MIS, PAKISTAN

•Play a crucial role in the design and implementation of databases, collaborating with sub-contractors and consultants to ensure efficient and scalable structures that meet the organization’s data requirements
• Prepare/ update standard SOPs for administering data, databases, test, development and production environment. Get them updated/approved.
• Maintain all databases and related documentation as approved and inline to organizational policy.
•Perform data analysis, based on requirements articulated by PSPA management and relevant wings, 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.
•Prepare/assist in development of System Requirement Specifications (SRS) and data model.
•Design and develop the required operational database procedures, ancillary processes documentation to ensure an effective and efficient continued operation of database environment.
• Develop & enforce policies and procedures for data security (such as strong passwords, two factor authentications, restricted data accessibility within controlled environment, CCTV monitoring), and data sharing mechanisms (e.g. emails/CD/USB etc.) including rules for approving/disapproving data requests and their compliances, maintaining log files and others associated functions.
•Closely coordinate with Manager database for data consistency, security, availability, optimization and best practices for administering the database(s). Keep the documentation current and consistent to implementation.
•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 automated backup procedures related to PHCI systems.
• Update and Maintain required databases for PHCI project.
• Perform/Automate routine data backups and restore functions.
• Perform all of required database administration functions such as installation, 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 support IT related contracts. Maintain software licensing and maintenance agreements.
• Generate reports as per user requirements
• Perform any other task assigned by management
•Perform database tuning and performance monitoring.
• Monitoring the application related products like oacore, oafm apache, Concurrent.

Job Details

Preferred Candidates

Qualifications
• At least, Master’s degree or equivalent (16 years of education) in Computer Science, Information Systems, or related discipline, from a foreign or local university, duly recognized by the Higher Education Commission (HEC) of Pakistan.
•Any additional Certification, such as PostgreSQL, Oracle, SQL Database Administration or related certification, shall be accorded due weightage.
•International certification from product owner on any major databases (Oracle/MySQL/SQL Server) optimization, security & redundancy will be given additional weightage.
Experience
•At least, five years of documentary verifiable progressive experience, after acquiring the stipulated qualification, as a database administrator in addition to having experience in applications software analysis, design, and development.
•Knowledge and experience of relational databases, PostgreSQL, Oracle, or SQL Server (applications running these backend DBs) with redundancy and automated backup are required.
•Opensource technology and implementation experience of Analytic tools will be accorded due weightage.
Skills
• Database Administration and management
•Performance tuning
• PL/SQL
• Backup and recovery, replication services
• Audit Vault & DB Firewall
• Installation and configuration of Oracle EBS Application Server.
•Upgradation of Oracle EBS server software and related products
•Administration of Oracle EBS R12 Application.
•EBS Cloning, Patching for fixing bugs

Degree Level

• Masters/Bachelors (Hons)
• Years of Education

Degree Area

• Computer Engineering/Sciences
• Information Systems

Required Skills

• Database Management
• Performance Tuning

Required Tools

• Sql
• Oracle