admin assistant

database administrator

php developer

ms-sql dba expert - optimization & tuning Jobs in Lahore

ms-sql dba expert - optimization & tuning

php laravel developer

mysql dba

Contour Software

<div><div>About Contour</div><div></div><div><div>
Contour Software</div> has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years.</div><div><br>
As a subsidiary of Constellation Software Inc., we are proud to be part of a global enterprise software conglomerate that has grown to become one of the top 10 software companies in the world, with employees and customers in 100+ countries. With a broad-based and ever-growing portfolio of market-leading, vertical-market enterprise solutions covering more than 100 industry domains in predominantly mature markets, CSI's recipe creates the perfect environment for professionals to build fulfilling, long-term careers.</div><div><br>
What started as an R&amp;D &amp; Accounting back-office, has progressed into a full-service Global Centre serving all functions and departments, at the divisional as well as operating group/corporate level. Today Contour employees, located in Karachi, Lahore &amp; Islamabad, are serving CSI divisions located in time zones spanning the globe, from Sydney to Vancouver. With the global growth of Constellation as the wind in our sails, we are only just getting started!</div><div></div><div>
We are looking for a talented individual to join our team in the role of a Database Administrator who will focus improving the efficiency and performance of our data infrastructure, largely implemented in MySQL. This candidate must have strong analysis and troubleshooting skills with experience supporting enterprise class applications and infrastructure. Strong experience with open source technologies is required.<br>
<br>
Duties and Responsibilities:<br>
<ul><li>Design and implement effective database solutions and models to store and retrieve company data.</li><li>Examine and identify database structural necessities by evaluating client operations, applications, and programming.</li><li>Develop and oversee periodic maintenance plans ensuring health and performance of data infrastructure</li><li>Assess database implementation procedures to ensure they comply with internal and external regulations.</li><li>Provide operational support for production and non-production data infrastructure, including but not limited to MySQL, MS SQL, DynamoDB, etc.</li><li>Prepare accurate database design, models, and architecture reports for engineering, management, and executive teams.</li><li>Design and oversee the migration and replication of data between systems.</li><li>Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.</li></ul>
Participate in release process to develop and execute SQL scripts related to product releases.<br>
<ul><li>Recommend solutions to improve new and existing database systems.</li><li>Develop and enforce database development standards</li><li>Develop reports for the business as needed utilizing SQL scripts, PowerBI, etc.</li><li>Educate staff members through training and individual support.</li><li>Offer support by responding to system problems in a timely manner.</li></ul><br>
Required Skills:<br>
<ul><li>Bachelor's degree in computer science, computer engineering, or relevant field.</li><li>3+ years experience working with database systems</li><li>2+ years experience working with MySQL</li><li>2+ years experience writing SQL functions, procedures, and complex queries</li><li>Expert knowledge of database structure systems including schema design</li><li>Strong experience analyzing and resolving MySQL performance issues in the data layer</li><li>Prior demonstrated experience with ETL</li><li>Experience creating and maintaining business intelligence reports &amp; data visualization</li><li>Excellent organizational and analytical abilities.</li><li>Outstanding problem solver.</li><li>Good written and verbal communication skills.</li></ul>
Desired Skills<br>
<ul><li>Prior experience working with cloud data technologies (examples: Amazon RDS, Azure Factory, DynamoDB, Snowflake)</li><li>Experience with data analysis platforms and tools (examples: Tableau, PowerBI, DataBricks, R</li></ul></div><div>
Exciting Benefits we offer:</div><ul><li><div>
Market-leading Salary</div></li><li><div>
Medical Coverage &ndash; Self &amp; Dependents</div></li><li><div>
Parents Medical Coverage</div></li><li><div>
Provident Fund</div></li><li><div>
Employee Performance-based bonuses</div></li><li><div>
Home Internet Subsidy</div></li><li><div>
Conveyance Allowance</div></li><li><div>
Profit Sharing Plan [Tenured Employees Only]</div></li><li><div>
Life Benefit</div></li><li><div>
Child Care Facility</div></li><li><div>
Company Provided Lunch/Dinner</div></li><li><div>
Professional Development Budget</div></li><li><div>
Recreational area for in-house games</div></li><li><div>
Sporadic On-shore training opportunities</div></li><li><div>
Friendly work environment</div></li><li><div>
Leave Encashment</div></li></ul><div></div><div><i>
Disclaimer:</i><i> At Contour, we attribute our success to the unique contributions of our diverse staff. We&rsquo;re committed to fostering a culture of respect that thrives on the varied perspectives and experiences of all individuals we recruit, employ, promote, and compensate. Since day one, we&rsquo;ve adhered to a policy that champions a work environment honoring the worth and dignity of each person while being free from all forms of employment discrimination.</i></div><div></div><div><i>
In our continuous effort to promote inclusivity, we extend our commitment to individuals with special needs by providing reasonable accommodations. We actively encourage qualified individuals with special needs to apply for the various openings within our company. Should you require assistance in completing the application process or have any inquiries regarding special facilities, please do not hesitate to contact our HR team. Your unique talents and abilities are welcomed and valued here.</i></div></div><div></div>

MySQL DBA

<div>
 <strong>
  About Contour
  <br/>
  <br/>
 </strong>
 Contour Software has grown from a dozen people to over 2,000 staff across 3 cities, in less than 14 years.
 <br/>
 <br/>
 As a subsidiary of Constellation Software Inc., we are proud to be part of a global enterprise software conglomerate that has grown to become one of the top 10 software companies in the world, with employees and customers in 100+ countries. With a broad-based and ever-growing portfolio of market-leading, vertical-market enterprise solutions covering more than 100 industry domains in predominantly mature markets, CSI's recipe creates the perfect environment for professionals to build fulfilling, long-term careers.
 <br/>
 <br/>
 What started as an R&amp;D &amp; Accounting back-office, has progressed into a full-service Global Centre serving all functions and departments, at the divisional as well as operating group/corporate level. Today Contour employees, located in Karachi, Lahore &amp; Islamabad, are serving CSI divisions located in time zones spanning the globe, from Sydney to Vancouver. With the global growth of Constellation as the wind in our sails, we are only just getting started!
 <br/>
 <br/>
 We are looking for a talented individual to join our team in the role of a
 <strong>
  Database Administrator
 </strong>
 who will focus improving the efficiency and performance of our data infrastructure, largely implemented in MySQL. This candidate must have strong analysis and troubleshooting skills with experience supporting enterprise class applications and infrastructure. Strong experience with open source technologies is required.
 <br/>
 <br/>
 <strong>
  Duties And Responsibilities
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Design and implement effective database solutions and models to store and retrieve company data.
  </li>
  <li>
   Examine and identify database structural necessities by evaluating client operations, applications, and programming.
  </li>
  <li>
   Develop and oversee periodic maintenance plans ensuring health and performance of data infrastructure
  </li>
  <li>
   Assess database implementation procedures to ensure they comply with internal and external regulations.
  </li>
  <li>
   Provide operational support for production and non-production data infrastructure, including but not limited to MySQL, MS SQL, DynamoDB, etc.
  </li>
  <li>
   Prepare accurate database design, models, and architecture reports for engineering, management, and executive teams.
  </li>
  <li>
   Design and oversee the migration and replication of data between systems.
  </li>
  <li>
   Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
   <br/>
   <br/>
  </li>
 </ul>
 Participate in release process to develop and execute SQL scripts related to product releases.
 <br/>
 <br/>
 <ul>
  <li>
   Recommend solutions to improve new and existing database systems.
  </li>
  <li>
   Develop and enforce database development standards
  </li>
  <li>
   Develop reports for the business as needed utilizing SQL scripts, PowerBI, etc.
  </li>
  <li>
   Educate staff members through training and individual support.
  </li>
  <li>
   Offer support by responding to system problems in a timely manner.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Required Skills
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Bachelor's degree in computer science, computer engineering, or relevant field.
  </li>
  <li>
   3+ years experience working with database systems
  </li>
  <li>
   2+ years experience working with MySQL
  </li>
  <li>
   2+ years experience writing SQL functions, procedures, and complex queries
  </li>
  <li>
   Expert knowledge of database structure systems including schema design
  </li>
  <li>
   Strong experience analyzing and resolving MySQL performance issues in the data layer
  </li>
  <li>
   Prior demonstrated experience with ETL
  </li>
  <li>
   Experience creating and maintaining business intelligence reports &amp; data visualization
  </li>
  <li>
   Excellent organizational and analytical abilities.
  </li>
  <li>
   Outstanding problem solver.
  </li>
  <li>
   Good written and verbal communication skills.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Desired Skills
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Prior experience working with cloud data technologies (examples: Amazon RDS, Azure Factory, DynamoDB, Snowflake)
  </li>
  <li>
   Experience with data analysis platforms and tools (examples: Tableau, PowerBI, DataBricks, R
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Exciting Benefits We Offer
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Market-leading Salary
  </li>
  <li>
   Medical Coverage &ndash; Self &amp; Dependents
  </li>
  <li>
   Parents Medical Coverage
  </li>
  <li>
   Provident Fund
  </li>
  <li>
   Employee Performance-based bonuses
  </li>
  <li>
   Home Internet Subsidy
  </li>
  <li>
   Conveyance Allowance
  </li>
  <li>
   Profit Sharing Plan [Tenured Employees Only]
  </li>
  <li>
   Life Benefit
  </li>
  <li>
   Child Care Facility
  </li>
  <li>
   Company Provided Lunch/Dinner
  </li>
  <li>
   Professional Development Budget
  </li>
  <li>
   Recreational area for in-house games
  </li>
  <li>
   Sporadic On-shore training opportunities
  </li>
  <li>
   Friendly work environment
  </li>
  <li>
   Leave Encashment
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  <em>
   Disclaimer:
  </em>
 </strong>
 <em>
  At Contour, we attribute our success to the unique contributions of our diverse staff. We&rsquo;re committed to fostering a culture of respect that thrives on the varied perspectives and experiences of all individuals we recruit, employ, promote, and compensate. Since day one, we&rsquo;ve adhered to a policy that champions a work environment honoring the worth and dignity of each person while being free from all forms of employment discrimination.
  <br/>
  <br/>
 </em>
 <em>
  In our continuous effort to promote inclusivity, we extend our commitment to individuals with special needs by providing reasonable accommodations. We actively encourage qualified individuals with special needs to apply for the various openings within our company. Should you require assistance in completing the application process or have any inquiries regarding special facilities, please do not hesitate to contact our HR team. Your unique talents and abilities are welcomed and valued here.
 </em>
</div>


HR Professional

<p>We are looking for an experience &quot;<b>Database Administrator (DBA)</b>&rdquo; to join our dynamic Cloud and Managed Services team. A database administrator's (DBA) primary job is to ensure that data is available, protected from loss and corruption, secure and easily accessible as needed.</p><p><b>Job Duties &amp; Responsibilities</b></p><ul><li>Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, users, backup/recovery, patches, monitoring, export/imports, and SQL loader.</li><li>Write fast and high-performing database queries and/or fine-tune existing queries</li><li>Should be create &amp; schedule increment and full backups</li><li>Proactively monitor DB Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible</li><li>Make recommendations for system architecture per MariaDB Server best practices</li><li>Perform scheduled maintenance and support release deployment activities.</li><li>Data Extraction, Transformation, and Loading</li><li>Specialized Data Handling</li><li>Database Backup, restoration, Recovery and Security</li><li>Authentication</li><li>Capacity Planning</li><li>Performance Monitoring</li><li>Database Tuning</li></ul><p><b>REQUIREMENTS</b></p><ul><li>Minimum 3 to 5 years of experience as a DBA (MySQL/MariaDB ,SQL Server and Postgres</li><li>Bachelor&rsquo;s Degree in Computer Science / Computer Engineering / Information</li><li>SQL Server, Workbench, SQLYOG, Toad etc. tools</li><li>Experience with Performance Tuning and Optimization (PTO)</li><li>Experience of High Availability (HA) and Disaster Recovery (DR) options for DB Server</li><li>Experience and knowledge with Data Management Tools.</li></ul><p>Job Type: Full-time</p><p>Pay: Rs200,000.00 - Rs300,000.00 per month</p><p>Work Location: In person</p>

Database Administrator (MySQL)

<p>We are seeking a highly skilled and experienced <b>Database Administrator (DBA)</b> to join our dynamic team. This role involves managing, maintaining, and enhancing multiple database environments including <b>MySQL, MariaDB, SQL Server, and PostgreSQL</b>. The ideal candidate will ensure that all databases remain <b>available, secure, high-performing, scalable, and recoverable</b>, while also conducting <b>R&amp;D initiatives</b> to improve our database tools, architecture, and performance.</p><p><b>Key Responsibilities</b></p><p><b>1. Database Administration</b></p><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><p><b>2. Backup, Restore &amp; Disaster Recovery</b></p><ul><li>Develop, implement, and monitor <b>incremental and full backup strategies</b>.</li><li>Configure and maintain <b>replication, clustering, mirroring, and other HA/DR solutions</b>.</li><li>Conduct routine restore tests to ensure business continuity and minimal downtime.</li></ul><p><b>3. Performance Monitoring &amp; Optimization</b></p><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><p><b>4. Maintenance &amp; Automation</b></p><ul><li>Schedule and automate regular maintenance tasks including reindexing, vacuuming, consistency checks, and log cleanup.</li><li>Develop automation scripts using <b>Bash, PowerShell, or Python</b> to reduce manual workloads.</li></ul><p><b>5. Data Management &amp; ETL</b></p><ul><li>Execute data extraction, transformation, and loading (ETL) processes.</li><li>Handle database version upgrades and data migrations with integrity and minimal downtime.</li><li>Ensure secure, auditable handling of sensitive data.</li></ul><p><b>6. Security &amp; Compliance</b></p><ul><li>Implement and maintain database security policies including authentication, authorization, encryption, and auditing.</li><li>Identify vulnerabilities and apply patches/fixes.</li><li>Ensure compliance with internal data governance and regulatory requirements.</li></ul><p><b>7. Research &amp; Development (R&amp;D)</b></p><ul><li>Research new database technologies, tools, and performance strategies.</li><li>Conduct POCs on monitoring tools, database features, or scaling architectures.</li><li>Document findings and implement improvements to the database environment.</li></ul><p><b>8. Cross-Functional Support</b></p><ul><li>Collaborate closely with <b>DevOps, Cloud, Development, and Security</b> teams.</li><li>Support application deployments, migrations, and performance incident troubleshooting.</li><li>Participate in an on-call rotation to support critical database-related incidents.</li></ul><p><b>Requirements &amp; Qualifications</b></p><p><b>Must-Have Skills</b></p><ul><li><b>5+ years</b> 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><p><b>SSMS, SQLYog, MySQL Workbench, pgAdmin, Toad</b>, etc.</p><ul><li>Strong understanding of <b>Linux and Windows Server</b> environments.</li><li>Experience with monitoring tools like <b>Prometheus, Grafana, CloudWatch, Zabbix, SolarWinds, etc.</b></li><li>Scripting experience in <b>Bash, PowerShell, or Python</b>.</li></ul><p><b>Education</b></p><ul><li>Bachelor&rsquo;s Degree in <b>Computer Science, Computer Engineering, Information Technology</b>, or a related field.</li></ul><p><b>Preferred Qualifications </b></p><ul><li>Experience with cloud-managed databases (AWS RDS, Azure SQL, Cloud SQL).</li><li>Knowledge of NoSQL databases (MongoDB, Redis, Cassandra).</li><li>Experience with Kubernetes, containerized DB deployments, and operators.</li><li>Familiarity with CI/CD pipelines and DevOps practices.</li><li>Professional certifications in MySQL, SQL Server, PostgreSQL, or cloud platforms.</li></ul><p>Job Type: Full-time</p><p>Pay: Rs250,000.00 - Rs320,000.00 per month</p><p>Work Location: In person</p>

Mysql Database Administrator

Taraki

<div>
 This job is with
 <strong>
  Gicoh.
 </strong>
 Their expertise covers all major platforms and technology stacks, enabling to provide customized and comprehensive solutions that address our clients specific requirements.
 <br/>
 <br/>
 <strong>
  About The Role
  <br/>
  <br/>
 </strong>
 We are seeking a highly skilled and experienced
 <strong>
  Database Administrator
 </strong>
 <strong>
  (
 </strong>
 <strong>
  DBA)
 </strong>
 to join our dynamic team. This role involves managing, maintaining, and enhancing multiple database environments including
 <strong>
  MySQL, MariaDB, SQL Server, and PostgreSQL
 </strong>
 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.
 <br/>
 <br/>
 <strong>
  Key Responsibilities
  <br/>
  <br/>
 </strong>
 <strong>
  1. Database Administration:
  <br/>
  <br/>
 </strong>
 <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.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  2. Backup, Restore &amp; Disaster Recovery
  <br/>
  <br/>
 </strong>
 <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.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  3. Performance Monitoring &amp; Optimization
  <br/>
  <br/>
 </strong>
 <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.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  4. Maintenance &amp; Automation
  <br/>
  <br/>
 </strong>
 <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.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  5. Data Management &amp; ETL
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Execute data extraction, transformation, and loading (ETL) processes.
  </li>
  <li>
   Handle database version upgrades and data migrations with integrity and minimal downtime.
  </li>
  <li>
   Ensure secure, auditable handling of sensitive data.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  6. Security &amp; Compliance
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Implement and maintain database security policies including authentication, authorization, encryption, and auditing.
  </li>
  <li>
   Identify vulnerabilities and apply patches/fixes.
  </li>
  <li>
   Ensure compliance with internal data governance and regulatory requirements.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  7. Research &amp; Development (R&amp;D)
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Research new database technologies, tools, and performance strategies.
  </li>
  <li>
   Conduct POCs on monitoring tools, database features, or scaling architectures.
  </li>
  <li>
   Document findings and implement improvements to the database environment.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  8. Cross-Functional Support
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Collaborate closely with DevOps, Cloud, Development, and Security teams.
  </li>
  <li>
   Support application deployments, migrations, and performance incident troubleshooting.
  </li>
  <li>
   Participate in an on-call rotation to support critical database-related incidents.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Requirements &amp; Qualifications
  <br/>
  <br/>
 </strong>
 <strong>
  Must-Have Skills
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   5+ years of DBA experience in MySQL, MariaDB, SQL Server, and PostgreSQL.
  </li>
  <li>
   Strong expertise in:
  </li>
  <ul>
   <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
    <br/>
   </li>
  </ul>
  <li>
   Hands-on experience with database tools:
  </li>
  <li>
   SSMS, SQLYog, MySQL Workbench, pgAdmin, Toad, 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.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Education
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Bachelors Degree in Computer Science, Computer Engineering, Information Technology, or a related field.
   <br/>
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Preferred Qualifications
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Experience with cloud-managed databases (AWS RDS, Azure SQL, Cloud SQL).
  </li>
  <li>
   Knowledge of NoSQL databases (MongoDB, Redis, Cassandra).
  </li>
  <li>
   Experience with Kubernetes, containerized DB deployments, and operators.
  </li>
  <li>
   Familiarity with CI/CD pipelines and DevOps practices.
  </li>
  <li>
   Professional certifications in MySQL, SQL Server, PostgreSQL, or cloud platforms.
   <br/>
  </li>
 </ul>
</div>


Sr. Database Administrator (Mysql) - Gicoh

TCP Software

<div>
 <em>
  TCP is committed to cultivating a diverse and inclusive team. However, we are not able to sponsor visas for this role.
 </em>
 <br/>
 <br/>
 <strong>
  About TCP (TimeClock Plus):
  <br/>
  <br/>
 </strong>
 For more than 30 years, TCP has helped organizations engage their people by providing flexible, mobile timekeeping and workforce management solutions. Trusted by tens of thousands of customers and millions of users, TCP delivers best-in-class technology and personalized support to organizations of all sizes in the public and private sector to meet their complex timekeeping, employee scheduling, leave management and other workforce needs. Growth is happening and our vision for a successful future is clear - We'd love for you to join us on this journey! For more information on TCP, visit www.tcpsoftware.com or follow us on LinkedIn or Facebook.
 <br/>
 <br/>
 <strong>
  Job Overview:
  <br/>
  <br/>
 </strong>
 A Microsoft SQL Server (MSSQL) Database Administrator (DBA) is responsible for the design, implementation, maintenance, and performance of SQL Server databases. The role of an MSSQL DBA may varied, but typical job duties include:
 <br/>
 <br/>
 <ul>
  <li>
   Installing and configuring SQL Server instances and databases.
  </li>
  <li>
   Managing database security, including creating users and roles, assigning permissions, and implementing data encryption.
  </li>
  <li>
   Ensuring database backups and recovery procedures are in place and working effectively.
  </li>
  <li>
   Optimizing database performance by monitoring system resources, analyzing query execution plans, and fine-tuning indexes and database configurations.
  </li>
  <li>
   Troubleshooting and resolving database issues, such as locking and blocking, connectivity problems, and performance bottlenecks.
  </li>
  <li>
   Designing and implementing database replication, high availability, and disaster recovery solutions.
  </li>
  <li>
   Planning and executing database migrations and upgrades.
  </li>
  <li>
   Developing and implementing database maintenance plans, including data archiving and data purging.
  </li>
  <li>
   Providing technical support and guidance to developers and end-users on database-related issues.
  </li>
  <li>
   Documenting and building database configurations, procedures, and best practices.
  </li>
  <li>
   Reviewing database-related code built by software teams.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Benefits:
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Competitive salary
  </li>
  <li>
   PTO and Sick leaves
  </li>
  <li>
   In-Patient Health insurance
  </li>
  <li>
   Provident fund and EOBI
  </li>
  <li>
   The work/life setup you need to be successful
  </li>
  <li>
   A creative, collaborative, supportive environment that gives you the autonomy to explore new ideas, grow your skill set and create outstanding results
  </li>
  <li>
   The chance to make a genuine impact on the company's growth
  </li>
  <li>
   Plenty of challenging work and the opportunity to stretch yourself
  </li>
  <li>
   The opportunity to work with amazing talent in a fast-growing company that really values their team
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Requirements
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   To be successful in this role, an MSSQL DBA should have a strong understanding of database design and management principles, as well as proficiency in SQL Server administration tools and techniques.
  </li>
  <li>
   4-5+ years of an experience as DBA
  </li>
  <li>
   Can work in fast paced environment
  </li>
  <li>
   Excellent problem-solving skills, attention to detail, and the ability to work independently or as part of a team are also essential.
  </li>
  <li>
   Additionally, strong communication and interpersonal skills are necessary, as MSSQL DBAs may be required to interact with various stakeholders, including developers, project managers, and business users.
   <br/>
   <br/>
  </li>
 </ul>
 <em>
  <strong>
   Physical Requirements:
   <br/>
   <br/>
  </strong>
 </em>
 <ul>
  <li>
   Prolonged periods sitting at a desk and working on a computer.
  </li>
  <li>
   Must be able to lift up to 15 pounds at times.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Benefits
  <br/>
  <br/>
 </strong>
 <ul>
  <li>
   Competitive salary
  </li>
  <li>
   PTO and Sick leaves
  </li>
  <li>
   In-Patient &amp; Out-Patient Health insurance
  </li>
  <li>
   Provident fund and EOBI
  </li>
  <li>
   The work/life set up you need to be successful
  </li>
  <li>
   A creative, collaborative, supportive environment that gives you the autonomy to explore new ideas, grow your skill set and create outstanding results
  </li>
  <li>
   The chance to make a genuine impact on the company's growth
  </li>
  <li>
   Plenty of challenging work and the opportunity to stretch yourself
  </li>
  <li>
   The opportunity to work with amazing talent in a fast-growing company that really values their team
   <br/>
   <br/>
  </li>
 </ul>
 <em>
  TCP is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
 </em>
</div>


Database Administrator

NorthBay - Pakistan

<div>
 <strong>
  Location:
 </strong>
 Lahore/Islamabad/Karachi
 <br/>
 <br/>
 <strong>
  Experience:
 </strong>
 8+ years
 <br/>
 <br/>
 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
 <br/>
 <br/>
 <strong>
  Requirements
  <br/>
  <br/>
 </strong>
 <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.
   <br/>
   <br/>
  </li>
 </ul>
 <strong>
  Responsibilities
  <br/>
  <br/>
 </strong>
 <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
   <br/>
   <br/>
  </li>
 </ul>
 What We Offer
 <br/>
 <br/>
 <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>


MS-SQL DBA Expert - Optimization & Tuning

Explore 113+ Mysql dba in Lahore this December. Find roles across top companies and apply now to boost your career.

113 mysql dba jobs IN Lahore

MySQL DBA

MySQL DBA

Database Administrator (MySQL)

Mysql Database Administrator

Sr. Database Administrator (Mysql) - Gicoh

Database Administrator

MS-SQL DBA Expert - Optimization & Tuning