Karachi, Pakistan
SQL Database Administrator
Job Description:
Database Administrator (DBA)
We are looking for a qualified MS SQL DBA (Microsoft SQL Server Database Administrator)for managing and maintaining Microsoft SQL Server databases based on our company and client needs.
Key Responsibilities:
- Database Installation and Configuration: Setting up new SQL Server instances and configuring them according to organizational needs.
- Security Management: Implementing and maintaining security measures to protect sensitive data from unauthorized access.
- Performance Tuning: Optimizing database performance by analysing queries, indexing, and other performance-related aspects.
- Backup and Recovery: Creating and managing backups of databases and implementing recovery plans in case of data loss or system failures.
- Troubleshooting: Identifying and resolving database-related issues, including performance problems, errors, and connectivity issues.
- Data Management: Ensuring data integrity, consistency, and availability.
- Monitoring: Continuously monitoring the health and performance of SQL Server instances and databases.
- Automation: Automating routine tasks using scripting languages like T-SQL.
- Working with other IT teams: Collaborating with developers, system administrators, and other teams to ensure smooth operation of applications and systems that rely on SQL Server.
- Stay updated: Keeping up with the latest SQL Server versions, features, and best practices.
Skills and Knowledge Required:
- Bachelor's degree in Computer Science or relevant field​
- Minimum of 3 years of proven work experience as a DBA
- Strong understanding of SQL Server: Deep knowledge of SQL Server architecture, features, and functionalities.
- Proficiency in SQL and T-SQL: Ability to write and optimize SQL queries and stored procedures.
- Knowledge of database design principles: Understanding how to design efficient and scalable database structures.
- Experience with SSIS, SSAS, SSRS: Familiarity with SQL Server Integration Services, Analysis Services, and Reporting Services.
- Knowledge of Azure SQL Database and cloud environments: Understanding of cloud-based database solutions like Azure SQL Database.
- Analytical and problem-solving skills: Ability to diagnose and resolve complex database issues.
- Communication and collaboration skills: Ability to effectively communicate with technical and non-technical stakeholders