Senior SQL Server DBA and Infrastructure Engineer - TJ / 1916269

Our client Blinq Solutions is looking for a Senior SQL Server DBA and Infrastructure Engineer in Karachi

Blinq Solutions is seeking a highly skilled Senior SQL Server Database Administrator and Infrastructure Engineer with 6 to 9 years of professional experience. This role focuses on the management, optimization, and maintenance of robust SQL Server environments to ensure database performance, reliability, and security. The successful candidate will have a deep understanding of SQL Server architecture, performance tuning, backup strategies, and disaster recovery methodologies, combined with strong Windows Server and cloud database management skills. Although this position does not involve managing a team, it requires an individual who can work independently and collaboratively to support critical database infrastructure vital to business operations.

The role requires advanced expertise in SQL Server Administration and infrastructure engineering, ensuring highly available and recoverable database systems. The individual will actively monitor and optimize database systems using tools such as SQL Server Management Studio and Query Store, analyze execution plans, and apply index and statistics optimizations. Familiarity with Always On Availability Groups for high availability solutions as well as automated backup and point-in-time recovery processes are essential. Additionally, experience with Azure SQL and cloud-based database management will enable seamless integration and scaling of services as Blinq Solutions continues to innovate in their technology ecosystem.

Responsibilities

• Administer and maintain enterprise-level SQL Server databases, ensuring optimal performance, security, and availability.
• Perform routine and advanced database performance tuning using T-SQL query optimization, execution plan analysis, and index optimization techniques.
• Implement and manage High Availability and Disaster Recovery strategies including Always On Availability Groups and automated backup and recovery processes.
• Monitor database health and proactively resolve system bottlenecks or failures to minimize downtime.
• Manage backup strategies including full, differential, and transaction log backups, and perform point-in-time recovery when required.
• Utilize tools such as SQL Server Management Studio and Query Store to track query performance and identify areas for improvement.
• Support Windows Server administration tasks related to SQL Server infrastructure, ensuring system security and compliance with best practices.
• Manage Azure SQL and cloud database environments including deployment, monitoring, and performance tuning to support scalable cloud solutions.
• Maintain documentation of database configurations, policies, and procedures to ensure operational transparency and continuity.
• Collaborate with development and operations teams to provide database solutions that support business requirements and project timelines.
• Troubleshoot database and infrastructure issues, providing timely resolutions to minimize business impact.
• Stay current with new SQL Server features, industry trends, and innovative infrastructure technologies to continuously improve database systems and processes.