Pakistan Single Window (PSW), Islamabad Qualification:
- Bachelor’s degree in Computer Science, Software engineering, or a similar relevant degree
Experience:
- implementation and management experience in SQL Server High Availability and Disaster recovery solutions; including clustering, Availability groups and Replication and 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 and Write clear, concise, and well-organized technical documentation to maintain standards and procedures.
- Good understanding of the database underlying infrastructure such as Storage, Networking components and Server Hardware
Roles:
- 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 and Patch SQL Server installations in accordance with patch management processes.
- Be available 24/7 to provide technical assistance, in support to critical business operations
