Database Administrator (BS-16)

Social Welfare &; Lahore; On-site; PKR 1,200,000 - 2,400,000; Full time

Job summary

Social Welfare & Bait ul Maal in Lahore seeks a Database Administrator (BS-16) to serve as the primary custodian of all structured data supporting provincial welfare programs, Zakat disbursement, Bait-ul-Maal funds, and beneficiary management systems.

The role ensures data integrity, availability, and security across centralized SQL Server and Oracle environments that underpin policy decisions, audit compliance, and transparent service delivery to vulnerable populations.

Qualifications

• Experience administering SQL Server and Oracle databases.
• Proficient in database maintenance, backups, and DR readiness.
• Familiar with Punjab Government IT policies.
• Documentation in CMDB and change management.

Responsibilities

• Design, implement, and maintain normalized database schemas for welfare registries, fund disbursement ledgers, and program monitoring modules.
• Configure and manage AlwaysOn Availability Groups and Data Guard for high availability.
• Develop and test automated backup strategies with offsite replication meeting RPO < 15 minutes and RTO < 4 hours.
• Optimize slow-running queries and stored procedures through analysis, indexing, and tuning.
• Enforce data security via encryption and audit logging per policy.
• Collaborate with vendors and internal developers on schema migrations, ETL processes, and reporting data marts for Power BI dashboards.

Skills

Database administration

SQL performance tuning

Security

Power BI

Education

MCS

BS Computer Science

Tools

SQL Server

Oracle DB

AlwaysOn Availability Groups

Data Guard

SolarWinds

CMDB

Power BI

Job description

The Database Administrator (BS-16) at Social Welfare & Bait ul Maal serves as the primary technical custodian of all structured data repositories supporting provincial welfare programs, Zakat disbursement, Bait-ul-Maal funds, and beneficiary management systems. The role ensures data integrity, availability, and security across centralized SQL Server and Oracle environments that underpin policy decisions, audit compliance, and transparent service delivery to vulnerable populations.

Daily workflows include monitoring database health via SolarWinds and native DMVs, executing scheduled maintenance plans (index rebuilds, statistics updates, integrity checks), managing user access through role-based security models aligned with Punjab Government IT Policy, and coordinating with application developers on schema changes for the Integrated Welfare Management System (IWMS). The incumbent maintains 99.5% uptime SLAs, documents all changes in the Configuration Management Database (CMDB), and participates in quarterly disaster recovery drills. Career progression follows the BS-17/18 promotion track upon passing departmental promotion examinations and acquiring advanced certifications (MCSE Data Platform, OCP).

Selection follows a transparent merit-based pathway: (1) 100-mark MCQ written screening examination covering database concepts, SQL, administration, and general IT knowledge; (2) merit list preparation at 1:5 ratio for shortlisting; (3) document verification of educational degrees (MCS/BS Computer Science), domicile, and experience certificates; (4) final interview by the Departmental Selection Committee comprising the Director General, Director IT, and a technical subject specialist, assessing technical depth, situational judgment, and communication skills.

Key duties and responsibilities:

• Design, implement, and maintain normalized database schemas for welfare beneficiary registries, fund disbursement ledgers, and program monitoring modules
• Configure and manage AlwaysOn Availability Groups and Data Guard for zero-data-loss high availability across primary and DR sites
• Develop and test automated backup strategies (full, differential, log) with offsite replication meeting RPO < 15 minutes and RTO < 4 hours
• Optimize slow-running queries and stored procedures through execution plan analysis, index tuning, and query rewriting
• Enforce data security via Transparent Data Encryption, column-level encryption for CNIC/bank details, and audit logging per Punjab Information Security Policy
• Collaborate with software vendors and internal developers on schema migrations, ETL processes, and reporting data marts for dashboarding in Power BI