Our client, Blinq Solutions, is seeking a highly experienced Senior SQL Server Database Administrator and Infrastructure Engineer based in Karachi. The ideal candidate will have between 6 to 9 years of professional experience managing and optimizing complex SQL Server environments. This role demands expertise in ensuring database performance, reliability, and security, along with strong skills in Windows Server and cloud-based database management. The position requires a self-driven individual capable of working independently as well as collaboratively to support critical database infrastructure essential for business operations.
Key Responsibilities
- Administer and maintain enterprise-level SQL Server databases, ensuring optimal performance, security, and availability.
- Conduct routine and advanced database performance tuning through T-SQL query optimization, execution plan analysis, and index/statistics improvements.
- Implement and manage High Availability and Disaster Recovery solutions, including Always On Availability Groups and automated backup and point-in-time recovery processes.
- Monitor database health proactively, identifying and resolving system bottlenecks or failures to minimize downtime.
- Manage comprehensive backup strategies encompassing full, differential, and transaction log backups.
- Utilize tools such as SQL Server Management Studio and Query Store to monitor query performance and identify optimization opportunities.
- Support Windows Server administration tasks related to SQL Server infrastructure, maintaining system security and compliance with best practices.
- Oversee Azure SQL and cloud database environments, including deployment, monitoring, and performance tuning to support scalable cloud solutions.
- Maintain detailed documentation of database configurations, policies, and procedures to ensure operational transparency and continuity.
- Collaborate closely with development and operations teams to deliver database solutions aligned with business requirements and project deadlines.
- Troubleshoot database and infrastructure issues promptly, minimizing business impact.
- Stay updated on the latest SQL Server features, industry trends, and emerging infrastructure technologies to continuously enhance database systems and processes.
Required Qualifications
- 6 to 9 years of hands-on experience as a SQL Server Database Administrator and Infrastructure Engineer.
- Deep understanding of SQL Server architecture, performance tuning, backup strategies, and disaster recovery methodologies.
- Proven experience with High Availability solutions such as Always On Availability Groups.
- Strong proficiency in T-SQL query optimization and execution plan analysis.
- Experience managing Windows Server environments supporting SQL Server infrastructure.
- Solid knowledge of automated backup and point-in-time recovery techniques.
- Familiarity with cloud database management, particularly Azure SQL.
- Ability to work independently and collaboratively within cross-functional teams.
- Excellent problem-solving skills and attention to detail.
Preferred Qualifications and Benefits
- Experience with cloud infrastructure scaling and integration.
- Knowledge of industry best practices for database security and compliance.
- Commitment to continuous learning and staying current with evolving database technologies.
- Opportunity to work in a dynamic technology environment focused on innovation and growth.
This role offers a challenging and rewarding opportunity to contribute to a forward-thinking organization by ensuring the robustness and scalability of critical database systems. Candidates who meet the above criteria and are eager to advance their careers in database administration and infrastructure engineering are encouraged to apply.