Database Administrator

Title: Database Administrator Location: Islamabad /Onsite) Experience: 2 - 4 Years Employment Type: Full-Time Role Overview We are looking for a highly experienced and proactive Database Administrator who can take full ownership of our data infrastructure. This role requires deep expertise in database administration, performance tuning, high availability systems, and large-scale data management. The ideal candidate is not just a DBA — but who can manage mission-critical databases. Core Responsibilities Performance Tuning & Optimization Analyze and optimize complex queries, stored procedures, and execution plans Design advanced indexing strategies (clustered, non-clustered, composite) Monitor database performance metrics and proactively resolve bottlenecks Optimize high-traffic systems handling millions of records Data Integrity, Security & Compliance Implement robust data security (encryption at rest & in transit) Manage authentication, authorization, and access control Ensure compliance with data protection standards Prevent data anomalies and ensure consistency Backup, Recovery & High Availability Design and implement disaster recovery strategies Manage automated backup systems (full, incremental, differential) Implement high availability solutions (replication, clustering, failover) Ensure minimal downtime and data loss Transactions & Concurrency Control Handle concurrency issues (deadlocks, locking, blocking) Implement transaction management strategies ensuring ACID compliance Optimize isolation levels based on application needs Query Optimization & Indexing Deep understanding of query execution plans Implement advanced indexing (B-Tree, covering indexes) Optimize joins, subqueries, and aggregations for performance Cloud & Modern Data Systems Manage cloud databases (Azure SQL, AWS RDS) Work with distributed databases and scaling strategies Optimize cloud cost and performance Collaboration & Leadership Work closely with backend developers and architects Guide developers on writing optimized queries Review database-related code and design decisions Mentor junior DBAs and engineers Required Skills (Must-Have) Core Expertise Strong experience with SQL Server (or equivalent RDBMS) Deep knowledge of: DBMS Architecture Relational Model & ER Modeling Normalization (1NF → BCNF) Functional Dependencies & Keys Advanced Technical Skills Expert in SQL (complex queries, joins, optimization) Strong experience with: Stored Procedures, Triggers Indexing & Query Optimization Execution Plan Analysis Database Internals Knowledge Transactions & Concurrency Control Deadlocks, Locking Mechanisms Query Processing & Optimization Techniques Backup & Recovery Hands-on experience with: Backup strategies Disaster recovery Failover systems Apply: [Upgrade to PRO to see contact]