Senior Database Administrator

LMKR


Date: 3 weeks ago
City: Lahore
Contract type: Full time

Job Summary:

We are seeking a highly experienced Senior Database Administrator (DBA) to join our team in Lahore or Islamabad. The ideal candidate will have 8-10 years of hands-on experience in SQL Server Database Administration. A strong focus on database performance, reporting services, Data Warehousing, and large-scale database migrations is essential. This role is critical for ensuring the optimal performance, integrity, and security of our database systems.


Job Description:

The Senior Database Administrator will be responsible for managing and maintaining SQL Server, ensuring high performance, availability, and security. Key responsibilities include configuring, monitoring, and optimizing SQL Server, along with implementing advanced backup, recovery, and disaster recovery (DR) strategies such as SQL Server Always On, Read Replicas, and DR site management. The role requires expertise in performance tuning, indexing, and query optimization as well as designing and implementing Data Warehousing solutions and supporting reporting services (SSRS, SSIS, SSAS) and developing ETL processes. Additionally, the DBA will lead large-scale database migration projects—both homogeneous (e.g., SQL Server to SQL Server) and heterogeneous (e.g., Oracle to SQL Server)—while managing database replication, high availability, and scalability solutions. A critical aspect of the role is ensuring data security, compliance, and seamless integration with development and operations teams to support business objectives and minimal downtime.


Experience:

The ideal candidate must possess 8-10 years of hands-on SQL Server DBA experience, including installation, configuration, and maintenance, with expertise in high-availability solutions like SQL Server Always On, Read Replicas, and Log Shipping, along with comprehensive disaster recovery setups. Candidates should demonstrate strong capabilities in SQL Server business intelligence tools (SSRS, SSIS, SSAS), along with proven skills in database performance tuning, indexing, and query optimization. Significant experience in large-scale database migrations, both homogeneous and heterogeneous, is essential. Having expertise in Oracle Database administration (11g/12c/19c preferred), including Oracle RAC, Data Guard, RMAN, and performance tuning, will be a plus. General requirements include strong problem-solving and troubleshooting abilities, automation skills, familiarity with cloud database solutions (Azure SQL), and excellent communication, collaboration, and documentation capabilities.


Required Skills:

  • Proficiency in SQL Server Database Administration (installation, configuration, maintenance)
  • Strong knowledge of reporting services (SSRS) and ETL tools (SSIS)
  • Expertise in Data Warehousing solutions, including dimensional modeling and OLAP (SSAS)
  • Database performance tuning and optimization (query plans, indexing, partitioning)
  • Advanced backup/recovery strategies (Always On, Log Shipping, DR site management)
  • Database replication techniques (transactional, merge, snapshot)
  • Large-scale database migration experience:
  • Homogeneous (SQL Server to SQL Server)
  • Heterogeneous (Oracle to SQL Server, cross-platform)
  • Oracle Database administration - a plus
  • Cloud database solutions (Azure SQL DB, AWS RDS, Oracle Cloud) – optional but a plus
  • High availability/scalability solutions (Read Replicas, clustering)
  • Data security and compliance standards (encryption, auditing, GDPR)
  • Automation and scripting (PowerShell, Python, or T-SQL)
  • Collaboration with development and operations teams
  • Strong problem-solving skills
  • Excellent communication and teamwork skills

Education/Qualification: Minimum requirement: Bachelor’s Degree in IT or Computer Science. Preferred: Master’s Degree in IT or Computer Science.


Job Location:

  • Lahore

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

Ecommerce Specialist (Amazon)

MicroAgility APAC, Lahore
3 hours ago
Amazon E-Commerce SpecialistLocation: K-Block, Model Town, LahoreType: Full-Time, OnsiteHours: 5:00 PM – 2:00 AM (EST Hours)Compensation: 70k – 90k (DOE) with higher offers for exceptional talentJoin MicroAgility APAC and be part of a people-first team that values respect, kindness, and growth, driving digital transformation with passion and purpose.Who We AreAt MicroAgility APAC, we’re more than a digital transformation company -...

Junior Quality Assurance Engineer

Jaspi, Lahore
5 hours ago
We are seeking a Junior Quality Assurance Engineer to join our growing team. The ideal candidate will be detail-oriented, analytical, and passionate about ensuring the quality of software applications. As a Junior QA Engineer, you will work closely with developers, product managers, and senior QA team members to test applications, identify issues, and help deliver reliable, high-quality products to our...

Product Manager (Onsite, Lahore, PKR Salary)

HR POD Careers, Lahore
7 hours ago
Requirements:2-4 years of experience in product management or project coordination roles.Strong understanding of requirement gathering and converting them into clear, actionable tasks.Hands-on experience with project management tools.Excellent communication, organizational, and stakeholder management skills.Ability to work in a fast-paced, collaborative environment and manage multiple priorities.Basic understanding of Agile methodologies and product lifecycle.Strong problem-solving skills with attention to detail.Responsibilities:Gather and analyze client...