Senior SQL Server DBA & Infrastructure Engineer
Blinq Solutions
Published Date: • Karachi, Pakistan (On-Site)
Description
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.
Experience
6 Years
Apply By
Required Skills
- Execution Plan Analysis
- System troubleshooting and diagnostics
- Database Security Best Practices
- SQL Server Management Studio (SSMS)
- Index and Statistics Optimization
- SQL Server Administration
- T-SQL Query Performance Tuning
- Windows Server Administration
- T-SQL
- Backup And Recovery
- High Availability and Disaster Recovery
- SQL Server Performance Tuning
Nice to Have Skills
- Azure SQL And Cloud Database Management
- Query Store
- Always On Availability Groups
- Point-in-Time Recovery and Backup Automation
- PowerShell Scripting
- Performance Monitoring Tools