CodeNinja

About the Company
 CodeNinja is a global AI and engineering services company helping enterprises build, scale, and operate intelligent systems. With 350+ engineers across four continents and 400+ successful deployments, CodeNinja enables organizations to harness artificial intelligence through Global Capability Centers, Work AI, Physical AI, and AI Labs. Recognized among Pakistan’s fastest-growing AI firms and a multi-award recipient on Clutch, CodeNinja empowers over 250 clients worldwide to innovate, automate, and compete in the intelligence economy.
 About the Role
 We are seeking a mid–senior level Database Administrator (DBA) to own the reliability, performance, security, and operational excellence of our database platforms. This role goes beyond traditional DBA responsibilities, emphasizing automation, cloud database services, and close collaboration with application teams.
 Key Responsibilities
 <ul>
<li>Administer, maintain, and support production and non-production database environment</li>
<li>Automate routine DBA tasks to reduce manual effort and operational risk</li>
<li>Support and improve CI/CD pipelines for database changes</li>
<li>Operate and support cloud-managed database services</li>
<li>Advise teams on database selection, configuration, and scaling strategies</li>
</ul>
Requirements: 
<ul>
<li>Strong SQL expertise with hands-on experience in performance tuning</li>
<li>Deep knowledge of at least one major database platform (e.g., PostgreSQL, MySQL, SQL Server, Oracle), with working familiarity across others</li>
<li>Experience with cloud database services (AWS, Azure, or GCP)</li>
<li>Infrastructure as Code experience (Terraform preferred) and Git-based workflows</li>
<li>Scripting and automation skills using Python or similar languages</li>
<li>Experience with CI/CD practices for database changes and schema management frameworks</li>
<li>Observability experience, including metrics, logging, and alerting for database systems</li>
</ul>
Disclaimer: CodeNinja is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, & performance. Female and minorities are strongly encouraged and preferred to apply for the role.
 
Benefits: 
<ul>
<li>Provident Fund</li>
<li>Gym Membership</li>
<li>Leaves as per the company policy</li>
<li>Company-paid trips</li>
<li>Easy Loan Facility for Employees</li>
<li>Yearly increment</li>
<li>Maternity Benefits (Leaves & WFH)</li>
<li>Health Insurance (Maternity covered) – includes spouse and parents (till age 80)</li>
</ul>

Database Administrator (DBA)

Oredata Yazılım Anonim Şirketi

<div>OREDATA is a Digital Transformation &amp; IT Consulting firm with 10+ years of proven expertise and hundreds of successfully implemented projects across the EMEA region. When you join the OREDATA team, you'll be working hand-in-hand with experts focused on tackling digital, operational, analytical &amp; data science challenges with the greatest impact. We foster collaboration with proximity, an agile and autonomous approach and best practices and guiding principles.
Read more: https://medium.com/@oredata-engineering
Apply and be part of our exciting journey!
***We are looking for a PostgreSQL Administrator to join our team within a leading company in the banking industry.
Responsibilities<ul>
<li>
Provide operational and architectural support for PostgreSQL databases.</li>
<li>Manage and maintain Couchbase and MySQL environments which is also in the tech stack.</li>
<li>Perform RHEL / Linux system administration activities.</li>
<li>Develop and maintain Ansible playbooks and automation via bash scripting.</li>
<li>Ensure system performance, reliability, and security.</li>
<li>Work closely with engineering teams to ensure smooth project execution.</li>
<li>Support critical issues when necessary</li>
</ul>
Requirements<ul>
<li>
Bachelor&rsquo;s degree in Engineering (Computer Engineering, Software Engineering, Information Systems, or related fields).</li>
<li>4&ndash;8 years of professional experience as a Database Administrator or similar role.</li>
<li>Strong hands-on expertise in PostgreSQL administration.</li>
<li>Working experience with Couchbase and MySQL
</li><li>Solid knowledge of RHEL environments.</li>
<li>Proficiency in Ansible and bash scripting</li>
<li>Ability to take end-to-end ownership of technical projects.</li>
<li>Strong analytical, troubleshooting, and problem-solving skills.</li>
<li>B2&ndash;C1 English proficiency, especially for documentation and verbal/written communication.</li>
</ul>
Get to know us
If you want to know more about us and what we do, then visit our website: www.oredata.com
Why Oredata?<ul>
<li>
Remote working and flexible time off</li>
<li>Opportunity to get company paid Professional Certificates (Google Cloud Platform, Confluent Kafka, etc)</li>
<li>Access to Online Training Platforms (Udemy, Pluralsight, A Cloud Guru, Coursera, etc.)</li>
<li>Opportunity to work on international projects</li>
<li>Private Health Insurance</li>
<li>Birthday Leave Policy</li>
<li>Dynamic work ecosystem where you can take initiative and responsibility</li>
<li>Open communication, flexibility and start-up spirit</li>
Learning &amp; Development opportunities for both personal and professional growth 
<li>
</li>
</ul>Kişisel verileriniz işe alım s&uuml;recinin y&uuml;r&uuml;t&uuml;lebilmesi amacıyla veri sorumlusu sıfatıyla şirketimiz Oredata Yazılım A.Ş. tarafından işlenecektir. Kişisel verilerinizin işlenmesi ve haklarınızla ilgili detaylı bilgiye https://oredata.com/personal-data-protection-policy/ bağlantısı &uuml;zerinden ulaşabilirsiniz.</div>

PostgreSQL DBA

Arthur Grand

Arthur Grand Technologies is currently seeking a highly motivated and skilled DMS 2200 Database Administrator (DBA)for one of our clients.Position: DMS 2200 Database Administrator (DBA)Location: RemoteEnvironment: UNISYS ClearPath OS 2200 Mainframe Database Type: DMS 2200 (Network/Hierarchical Database)Position SummaryThe DMS 2200 Database Administrator is responsible for the administration, maintenance, performance tuning, and operational support of the DMS 2200 network database system operating on a UNISYS OS 2200 mainframe. This role supports mission-critical legacy applications, ensures data integrity and reliability, and collaborates closely with system administrators, developers, and operations teams.Key ResponsibilitiesDatabase Administration &amp; Maintenance<ul><li>Install, configure, and maintain DMS 2200 database structures, schemas, subschemas, and sets.</li><li>Manage hierarchical and network database relationships, record types, and access paths.</li><li>Perform routine database health checks, reorganization, cleanup, and optimization.</li><li>Maintain journaling, recovery, and backup processes to ensure data integrity and system stability.</li></ul>Performance Monitoring &amp; Optimization<ul><li>Monitor database performance, identify bottlenecks, and implement tuning strategies to enhance throughput and efficiency.</li><li>Optimize buffering, indexing, and access methods for batch and online workloads.</li><li>Work with application teams to refine data access logic for improved performance.</li></ul>Security &amp; Compliance<ul><li>Administer user access rights, permissions, and database-level security functions.</li><li>Ensure compliance with organizational and federal data protection standards.</li><li>Monitor and audit database activity for security and operational consistency.</li></ul>Support for Application Development<ul><li>Provide technical guidance to developers working in COBOL, ALGOL, FORTRAN, or other OS 2200-supported languages.</li><li>Assist in designing efficient subschemas and data calls for transactional and batch applications.</li><li>Troubleshoot database-related issues in production, test, and development environments.</li></ul>Data Migration &amp; Modernization (as applicable)<ul><li>Support data conversion efforts from DMS 2200 to relational or cloud databases when modernization projects are initiated.</li><li>Map hierarchical/network structures to relational schemas.</li><li>Assist with ETL extraction, transformation, and integration workflows.</li></ul>System Collaboration<ul><li>Work closely with OS 2200 system administrators to coordinate updates, performance tuning, and operational scheduling.</li><li>Participate in change control processes and maintain documentation for database configurations and procedures.</li></ul>Required Qualifications<ul><li>5+ years of experience administering DMS 2200 or similar hierarchical/network database systems.</li><li>Hands-on experience with UNISYS ClearPath OS 2200 mainframe environments.</li><li>Strong understanding of DMS 2200 indexing, sets, subschemas, record locking, journaling, and recovery.</li><li>Familiarity with COBOL and other legacy languages commonly used on OS 2200.</li><li>Experience with performance analysis, debugging, and system tuning on mainframe platforms.</li><li>Ability to troubleshoot complex database issues in production environments.</li></ul>Preferred Qualifications<ul><li>Experience supporting modernization or migration projects from DMS 2200 to relational databases (Oracle, SQL Server, PostgreSQL, etc.).</li><li>Knowledge of ETL processes and data mapping between hierarchical and relational structures.</li><li>Background in high-availability, mission-critical operational systems in government or regulated environments.</li><li>Strong documentation, communication, and coordination skills.</li></ul>Soft Skills<ul><li>Analytical problem-solving and attention to detail.</li><li>Ability to work independently and in cross-functional teams.</li><li>Strong communication with both technical and non-technical stakeholders.</li><li>Adaptability to legacy environments and modernization challenges.</li></ul>About Arthur Grand Technologies: Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.At Arthur Grand Technologies, we value our employees &amp; contractors and strive to provide them with challenging, interesting work, market-relevant benefits, and opportunities for professional growth. If you have the necessary qualifications, and are excited to join a dynamic team, please send your resume to Wasim.j@arthurgrand.com for immediate consideration.Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.Best regards, Mohamed wasim Wasim.j@arthurgrand.com Arthur Grand Technologies Inc www.arthurgrand.com Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)Job Types: Full-time, ContractWork Location: Remote

DMS 2200 Database Administrator (DBA)

Realign

<div>Job Type: Contract
Job Category: IT
Job Description
<div>Job Title: Neo4j Database Administrator (DBA)</div><div>
Location: Collegeville (Hybrid/Onsite) 
Duration: Long Term Contract</div><div></div><div> 
Experience: 6&ndash;8 Years</div><div></div><div> 
Role Summary</div><div>
Seeking an experienced Neo4j DBA to manage and support Neo4j Enterprise (Aura) graph databases on Microsoft Azure. The role focuses on database administration, high availability, security, performance tuning, and DevOps-enabled deployments.</div><div></div><div> 
Key Responsibilities</div><ul><div>
Install, configure, and maintain Neo4j Enterprise/Aura databases.</div><div>
Manage backup, recovery, and disaster recovery.</div><div>
Monitor performance, troubleshoot issues, and ensure high availability.</div><div>
Deploy and manage Neo4j clusters on Azure (VMs, AKS, networking, storage).</div><div>
Implement security controls (authentication, authorization, encryption).</div><div>
Integrate Azure Key Vault for secrets management.</div><div>
Support application teams with Cypher query optimization.</div><div>
Automate operations and support CI/CD pipelines.</div></ul><div></div><div> 
Required Skills</div><ul><div>
Strong experience as a Neo4j DBA / Graph Database Administrator.</div><div>
Hands-on with Neo4j Enterprise / Aura and Cypher.</div><div>
Solid Azure experience (VMs, AKS, networking, storage).</div><div>
Knowledge of Azure Key Vault.</div><div>
Linux administration and scripting (Bash/Python).</div><div>
Experience with DevOps, CI/CD, Docker, Kubernetes.</div><div>
Strong problem-solving and communication skills.</div></ul><div>
Preferred</div><ul><div>
Enterprise-scale Neo4j environments.</div><div>
Azure monitoring and alerting tools.</div><div>
Graph database performance tuning.</div></ul>
Required Skills
DATABASE ADMINISTRATOR</div>

Neo4j Database Administrator (DBA)-3

NorthBay - Pakistan

<div>
 MSSQL DBA/Expert | DB Optimization &amp; SQL Tuning
 
 
 Location: Lahore/Islamabad/Karachi
 
 
 Experience: 8+ years
 
 
 NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the performance, stability, and availability of multiple clustered SQL Server environments running on AWS Windows-based EC2. The role is focused on assessment/discovery, deep-dive/troubleshooting &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting
 
 
 
 Requirements
 
 
 
 <ul>
 <li>
 Overall 8+ years of experience with at least 5 years of Core SQL Server hands-on experience as a SQL Server DBA / Engineer, with a strong focus on performance and HA/DR in mission-critical environments
 </li>
 <li>
 Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).
 </li>
 <li>
 Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design
 </li>
 <li>
 Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.
 </li>
 <li>
 Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues
 </li>
 <li>
 Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
 </li>
 <li>
 Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication
 </li>
 <li>
 Experience with AWS Cloud, EC2, Instance Families/Sizes, EBS Volumes, IOPS, Throughput, Networking, and Multi‑AZ Designs in relation to MSSQL Server Performance, HA/DR &amp; Monitoring &amp; Observability
 </li>
 <li>
 Strong experience with database monitoring tools and enterprise level monitoring/observability expectations, including SQL Server dashboards (performance, waits, blocking, deadlocks, availability), Focus on Implementing actionable Alerting to reduce the noise
 </li>
 <li>
 Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.
 </li>
 <li>
 Having experience with Reporting Services (SSRS) performance and optimization will be preferred
 </li>
 <li>
 Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.
 
 
 </li>
 </ul>
 
 Responsibilities
 
 
 
 <ul>
 <li>
 Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices
 </li>
 <li>
 Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
 </li>
 <li>
 Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
 </li>
 <li>
 Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
 </li>
 <li>
 Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
 </li>
 <li>
 Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
 </li>
 <li>
 Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
 </li>
 <li>
 Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks
 </li>
 <li>
 Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
 </li>
 <li>
 Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).
 </li>
 <li>
 Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues
 </li>
 <li>
 Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices
 </li>
 <li>
 Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans
 </li>
 <li>
 Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving
 </li>
 <li>
 Contribute to documentation, standards, and knowledge sharing for DB usage across teams
 
 
 </li>
 </ul>
 What We Offer
 
 
 <ul>
 <li>
 Competitive salary and benefits
 </li>
 <li>
 Fuel expense reimbursement
 </li>
 <li>
 Paid holidays and vacations
 </li>
 <li>
 Medical outpatient reimbursement &amp; health insurance facility
 </li>
 <li>
 Career path to make a difference in a highly productive environment
 </li>
 </ul>
</div>

SQL DBA Expert - Optimization & Tuning

NorthBay Solutions

<div>
 &nbsp;
 
 
 
 
 
 
 
 MSSQL DBA/Expert | DB Optimization &amp; SQL Tuning
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 Location: Lahore/Islamabad/Karachi
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 Experience: 8+ years
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 
 NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the performance, stability, and availability of multiple clustered SQL Server environments running on AWS Windows-based EC2. The role is focused on assessment/discovery, deep-dive/troubleshooting &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 
 Requirements:
 
 
 
 
 
 
 
 <ul>
 <li>
 
 
 
 
 
 
 Overall 8+ years of experience with at least 5 years of Core SQL Server hands-on experience as a SQL Server DBA / Engineer, with a strong focus on performance and HA/DR in mission-critical environments
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Experience with AWS Cloud, EC2, Instance Families/Sizes, EBS Volumes, IOPS, Throughput, Networking, and Multi‑AZ Designs in relation to MSSQL Server Performance, HA/DR &amp; Monitoring &amp; Observability
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Strong experience with database monitoring tools and enterprise level monitoring/observability expectations, including SQL Server dashboards (performance, waits, blocking, deadlocks, availability), Focus on Implementing actionable Alerting to reduce the noise
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Having experience with Reporting Services (SSRS) performance and optimization will be preferred
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.
 
 
 
 
 
 
 </li>
 </ul>
 &nbsp;
 
 
 
 
 
 
 
 Responsibilities:
 
 
 
 
 
 
 
 <ul>
 <li>
 
 
 
 
 
 
 Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans
 
 
 
 
 
 
 </li>
 </ul>
 <ul>
 <li>
 
 
 
 
 
 
 Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Contribute to documentation, standards, and knowledge sharing for DB usage across teams
 
 
 
 
 
 
 </li>
 </ul>
 
 
 
 
 
 
 
 What We Offer&nbsp;
 
 
 
 
 
 
 
 <ul>
 <li>
 
 
 
 
 
 
 Competitive salary and benefits
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Fuel expense reimbursement
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Paid holidays and vacations
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Medical outpatient reimbursement &amp; health insurance facility
 
 
 
 
 
 
 
 
 
 
 
 
 &nbsp;
 
 
 
 
 
 
 </li>
 <li>
 
 
 
 
 
 
 Career path to make a difference in a highly productive environment
 
 
 
 
 
 
 </li>
 </ul>
</div>

<div>MSSQL DBA/Expert | DB Optimization &amp; SQL Tuning 
Location: Lahore/Islamabad/Karachi
Experience: 8+ years 
NorthBay is looking for a hands-on Microsoft SQL Server expert who can own the performance, stability, and availability of multiple clustered SQL Server environments running on AWS Windows-based EC2. The role is focused on assessment/discovery, deep-dive/troubleshooting &amp; performance optimization against high-volume production systems. You will be the go-to expert for identifying bottlenecks, tuning SQL &amp; T‑SQL (Including SPs/Functions), Stabilizing Cluster/DR failovers, and designing/improving observability including proactive monitoring and alerting 
Requirements:<ul><li>
Overall 8+ years of experience with at least 5 years of Core SQL Server hands-on experience as a SQL Server DBA / Engineer, with a strong focus on performance and HA/DR in mission-critical environments</li><li>
Deep understanding of SQL Server internals (storage engine, query optimizer, plan cache, buffer pool, TempDB behavior etc.).</li><li>
Expert-level experience in diagnosing Wait stats, DMVs, Extended Events, Profiler/Tracing, Execution plan analysis, query rewrites, indexing strategy design</li><li>
Troubleshooting CPU spikes, I/O bottlenecks, memory pressure, TempDB contention, log bottlenecks (e.g. WRITELOG waits) etc.</li><li>
Expert in SQL &amp; T‑SQL optimizations including SPs, Triggers, Views, Functions etc. along with in depth understanding of locking, blocking, deadlocks, and transaction-related performance issues</li><li>
Ability to identify &amp; analyze resource-heavy queries/processes and systematically optimize them (indexing, hints, plan guides, code refactoring, re-architecture where needed)</li><li>
Hands-on expertise in designing, deploying, and troubleshooting Windows Failover Clustering (WSFC), Always On Availability Groups (AGs), Failover Cluster Instances (FCI), Log Shipping, Mirroring &amp; Replication</li><li>
Experience with AWS Cloud, EC2, Instance Families/Sizes, EBS Volumes, IOPS, Throughput, Networking, and Multi‑AZ Designs in relation to MSSQL Server Performance, HA/DR &amp; Monitoring &amp; Observability</li><li>
Strong experience with database monitoring tools and enterprise level monitoring/observability expectations, including SQL Server dashboards (performance, waits, blocking, deadlocks, availability), Focus on Implementing actionable Alerting to reduce the noise</li><li>
Experience with T-SQL, PowerShell &amp; SQL Server Agent etc.</li><li>
Having experience with Reporting Services (SSRS) performance and optimization will be preferred</li><li>
Strong communication skills with the ability to explain complex database issues to non-DBA stakeholders and mentor developers on SQL best practices.</li></ul> 
Responsibilities:<ul><li>
Optimize database architecture, configuration, indexing strategy, statistics, TempDB, log &amp; data file layout in line with SQL Server best practices</li><li>
Review MS SQL Server Configurations, Analyze and resolve performance bottlenecks across CPU, memory, I/O, and network</li><li>
Conduct wait stats, DMVs, execution plans, and XEvents analysis to identify root causes</li><li>
Review and refine MAXDOP, cost threshold for parallelism, memory settings, TempDB configuration, and disk layout to improve performance and stability</li></ul><ul><li>
Review, tune, and refactor complex SQL and T‑SQL stored procedures, views, and functions</li><li>
Identify and resolve locking, blocking, deadlocks, transactional contentions, and long-running queries by optimizing indexing and/or query tuning and rewrites</li></ul><ul><li>
Assess and document existing HA/DR implementations across clusters, Troubleshoot and stabilize cluster switchovers/failovers, including issues seen during planned and unplanned events</li><li>
Define and implement HA/DR designs to meet RPO/RTO targets &amp; Develop/Test failover/runbooks</li><li>
Improve the Proactive &amp; Reactive Monitoring / Observability with recommending/implementing comprehensive monitoring &amp; alerting across SQL Server health and performance, HADR/Cluster state, sync latency etc.</li></ul><ul><li>
Recommend and implement best-fit monitoring tools (e.g. advanced Datadog usage, plus tools such as SQL Sentry, Redgate SQL Monitor, SolarWinds DPA, native SQL tools, etc.).</li><li>
Incident Response &amp; Root Cause Analysis as lead on critical incident investigations for production performance and availability issues</li><li>
Recommendations based on Architecture, Design Best Practices by reviewing existing SQL Server architecture, and configurations and bring them in line with current best practices</li><li>
Advise on capacity planning, scaling strategies, backup/restore strategy, indexing &amp; maintenance plans</li></ul><ul><li>
Automate repetitive tasks e.g., index maintenance, stats updates, log cleanups, data archiving</li><li>
Contribute to documentation, standards, and knowledge sharing for DB usage across teams</li></ul>
What We Offer<ul><li>
Competitive salary and benefits</li><li>
Fuel expense reimbursement</li><li>
Paid holidays and vacations</li><li>
Medical outpatient reimbursement &amp; health insurance facility</li><li>
Career path to make a difference in a highly productive environment</li></ul>
mE5HagbcO1</div>

Search 137+ Dba jobs near you this January. New roles added regularly across leading industries. Apply today.

137 dba jobs NEAR_ME

Database Administrator (DBA)

PostgreSQL DBA

DMS 2200 Database Administrator (DBA)

Neo4j Database Administrator (DBA)-3

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning