Pakistan Single Window (PSW)
Job Location
__________
Karachi
Job Description
_________________
Main Responsibilities:
Install, configure and manage SQL Server 2019 Databases ensuring optimum performance.
Design, implement and manage processes to ensure availability and integrity of the data stored in databases
Ensure Databases are being properly backed up as per company policy and ensure backup integrity
Implement disaster recovery strategies to meet business's Recovery Point Objectives (RPO), Recovery Time Objectives (RTO)
Set up and monitor DB performance, troubleshoot issues; implement and enforce DB access controls
Manage multiple high-availability SQL Server 2019 failover clusters and Always-On Availability Groups
Setup and manage Replication among different databases/sites
Patch SQL Server installations in accordance with patch management processes
Be available 24/7 to provide technical assistance, in support to critical business operations
Required Skill set:
Implementation and management experience in SQL Server High Availability and Disaster recovery solutions; including clustering, Availability groups and Replication.
Experience with database security design and Database automation.
Well versed in SQL Server Performance tuning & troubleshooting using DMVS, Extended Events, Profiling, Wait Statistics etc.
Good understanding of the database underlying infrastructure such as Storage, Networking components and Server Hardware
Experience in setting up and managing SSIS/SSRS
Self-motivated, quick learner and a responsive team player with ability to work under pressure, and deliver quality outcomes
Write clear, concise, and well-organized technical documentation to maintain standards and procedures
Excellent written/oral communication, presentation, and interpersonal skills.
https://njp.gov.pk/