sql dba expert - optimization & tuning Jobs in Lahore

sql dba expert - optimization & tuning

mariadb database administrator Jobs in Lahore

mariadb database administrator

sql developer

ai expert – smart software solutions Jobs in Lahore

ai expert – smart software solutions

database administrator

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>

SQL DBA Expert - Optimization & Tuning

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>

<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>
BACqRGKEVv</div>

Gourmet Foods

We are hiring a highly skilled and experienced Database Administrator (DBA) to join our dynamic team. This role involves managing, maintaining, and enhancing multiple database environments including MySQL, MariaDB, SQL Server, and PostgreSQL. The ideal candidate will ensure that all databases remain available, secure, high-performing, scalable, and recoverable, while also conducting R&amp;D initiatives to improve our database tools, architecture, and performance.Key Responsibilities1. Database Administration<ul><li>Install, configure, upgrade, and maintain multiple database systems.</li><li>Perform schema design, object creation, user management, and permission control.</li><li>Manage and optimize database objects such as tables, views, indexes, stored procedures, triggers, and functions.</li><li>Ensure adherence to best practices for all relational database environments.</li></ul>2. Backup, Restore &amp; Disaster Recovery<ul><li>Develop, implement, and monitor incremental and full backup strategies.</li><li>Configure and maintain replication, clustering, mirroring, and other HA/DR solutions.</li><li>Conduct routine restore tests to ensure business continuity and minimal downtime.</li></ul>3. Performance Monitoring &amp; Optimization<ul><li>Monitor database health using monitoring tools; identify and resolve performance bottlenecks.</li><li>Optimize slow queries, indexes, caching, and server configurations.</li><li>Provide recommendations to improve database and application performance.</li></ul>4. Maintenance &amp; Automation<ul><li>Schedule and automate regular maintenance tasks including reindexing, vacuuming, consistency checks, and log cleanup.</li><li>Develop automation scripts using Bash, PowerShell, or Python to reduce manual workloads.</li></ul>Requirements &amp; QualificationsMust-Have Skills<ul><li>5+ years of DBA experience in MySQL, MariaDB, SQL Server, and PostgreSQL.</li><li>Strong expertise in:</li><li>Backup &amp; recovery strategies</li><li>Replication, clustering, and HA/DR</li><li>Performance tuning and query optimization</li><li>Authentication, security, and access control</li><li>Hands-on experience with database tools:</li><li>SSMS, SQLYog, MySQL Workbench, pgAdmin, Toad</li><li>, etc.</li><li>Strong understanding of Linux and Windows Server environments.</li><li>Experience with monitoring tools like Prometheus, Grafana, CloudWatch, Zabbix, SolarWinds, etc.</li><li>Scripting experience in Bash, PowerShell, or Python.Education</li><li>Bachelor&rsquo;s Degree in Computer Science, Computer Engineering, Information Technology, or a related field.</li></ul>Job Type: Full-timePay: Rs200,000.00 - Rs400,000.00 per monthWork Location: In person

Mariadb Database Administrator

HR Professional

We are hiring a highly skilled and experienced Database Administrator (DBA) to join our dynamic team. This role involves managing, maintaining, and enhancing multiple database environments including MySQL, MariaDB, SQL Server, and PostgreSQL. The ideal candidate will ensure that all databases remain available, secure, high-performing, scalable, and recoverable, while also conducting R&amp;D initiatives to improve our database tools, architecture, and performance.Key Responsibilities1. Database Administration<ul><li>Install, configure, upgrade, and maintain multiple database systems.</li><li>Perform schema design, object creation, user management, and permission control.</li><li>Manage and optimize database objects such as tables, views, indexes, stored procedures, triggers, and functions.</li><li>Ensure adherence to best practices for all relational database environments.</li></ul>2. Backup, Restore &amp; Disaster Recovery<ul><li>Develop, implement, and monitor incremental and full backup strategies.</li><li>Configure and maintain replication, clustering, mirroring, and other HA/DR solutions.</li><li>Conduct routine restore tests to ensure business continuity and minimal downtime.</li></ul>3. Performance Monitoring &amp; Optimization<ul><li>Monitor database health using monitoring tools; identify and resolve performance bottlenecks.</li><li>Optimize slow queries, indexes, caching, and server configurations.</li><li>Provide recommendations to improve database and application performance.</li></ul>4. Maintenance &amp; Automation<ul><li>Schedule and automate regular maintenance tasks including reindexing, vacuuming, consistency checks, and log cleanup.</li><li>Develop automation scripts using Bash, PowerShell, or Python to reduce manual workloads.</li></ul>Requirements &amp; QualificationsMust-Have Skills<ul><li>3+ years of DBA experience in MySQL, MariaDB, SQL Server, and PostgreSQL.</li><li>Strong expertise in:</li><li>Backup &amp; recovery strategies</li><li>Replication, clustering, and HA/DR</li><li>Performance tuning and query optimization</li><li>Authentication, security, and access control</li><li>Hands-on experience with database tools:</li></ul>SSMS, SQLYog, MySQL Workbench, pgAdmin, Toad, etc.<ul><li>Strong understanding of Linux and Windows Server environments.</li><li>Experience with monitoring tools like Prometheus, Grafana, CloudWatch, Zabbix, SolarWinds, etc.</li><li>Scripting experience in Bash, PowerShell, or Python.</li></ul>Education<ul><li>Bachelor&rsquo;s Degree in Computer Science, Computer Engineering, Information Technology, or a related field.</li></ul>Job Type: Full-timePay: Rs200,000.00 - Rs400,000.00 per monthWork Location: In person

Great Sys

Who are we?Great Computer Solutions is a Chicago-based organization that provides IT Solutions. Our services range from consultancy and support to forming networks. Since 1996, we have helped a lot of small and medium organizations grow. We have operations in the US as well as Pakistan. For our Pakistan office, we are on the lookout for an ambitious candidate to join our team as a SQL DeveloperWhat you&rsquo;ll be doing?&middot; Manage Microsoft SQL Server databases&#8239;&middot; Configure and maintain database servers and processes&middot; Monitor system's health and performance&middot; Ensure high levels of performance, availability, sustainability and security&middot; Analyze, solve, and correct issues in real time&middot; Provide suggestions for solutions&middot; Refine and automate regular processes, track issues, and document changes&middot; Assist developers with query tuning, and schema refinement, develop queries, update database&middot; Provide 24x7 support for critical production systems&middot; Perform scheduled maintenance and support release deployment activities after hours&middot; Read agency manuals/requirements and develop database design and scripts. Develop queries to extract and update data based on requirements in the agency manualMust-Have:&middot; Must know SSIS (SQL Server Integration Services)&middot; Must know Crystal Reports&middot; Must be able to write scripts / stored procedures&middot; 2 years of experience as a SQL Server DBA or similar role&middot; 2 years of experience with Performance Tuning and Optimization (PTO)&middot; 2 years of experience with backups, restores and recovery models&middot; 1 year of experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server&middot; 2 years of experience with Windows server, including Active Directory&middot; Sense of ownership and pride in your performance and its impact on company&rsquo;s success&middot; Great interpersonal and communication skills&middot; MCTS, MCITP, and/or MVP certifications a plus&middot; Familiarity with PHP and ASP.net programming languages will be a plus&middot; Familiarity with Python will be a plusWhy join us?&middot; We give our employees exposure to US culture&middot; We offer market-competitive salaries&middot; Our benefits include EOBI and Health Insurance offered to individuals and their families&middot; We give paid time off, birthdays off as well as maternity and paternity leaves&middot; We believe in fostering a friendly culture and giving our resources autonomy to make decisionsIf you think you are a good fit for the role, please share your resume at jobs@greatsys.com.Job Type: Full-timeWork Location: In person

SQL Developer

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)

Explore 613+ Sql dba expert optimization tuning in Lahore this January. Find roles across top companies and apply now to boost your career.

613 sql dba expert optimization tuning jobs IN Lahore

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

Mariadb Database Administrator

Mariadb Database Administrator

SQL Developer

Database Administrator (DBA)