sql dba expert - optimization & tuning Jobs in Islamabad

sql dba expert - optimization & tuning

senior database administrator (dba) Jobs in Islamabad

senior database administrator (dba)

senior database administrator (oracle & sql server) Jobs in Islamabad

senior database administrator (oracle & sql server)

senior sqa engineer - performance Jobs in Islamabad

senior sqa engineer - performance

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>

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>

AppInSnap

We are seeking a highly experienced and self-driven Database Administrator (DBA) to manage, support, and optimize enterprise-level Oracle and Microsoft SQL Server environments. The ideal candidate will have 5+ years of hands-on DBA experience, strong leadership capability, and deep expertise in Oracle RAC, Data Guard, Exadata, performance tuning, backup &amp; recovery, and database migrations across multiple platforms.This role is responsible for ensuring high availability, performance, security, and scalability of mission-critical databases in 24/7 production environments.Key ResponsibilitiesOracle Database Administration<ul><li>Install, configure, manage, and support Oracle 10g, 11g, 12c, 19c, and 21c databases</li><li>Manage Oracle RAC (single instance &amp; RAC-to-RAC) environments on Linux, Windows, and AIX</li><li>Configure and administer Oracle Data Guard (Physical &amp; Logical Standby) for DR and failover</li><li>Perform database upgrades, patching, cloning, and cross-platform migrations</li><li>Manage ASM and Grid Infrastructure (11g/12c/19c)</li><li>Administer Oracle Exadata (X6/X7) environments</li></ul>Backup, Recovery &amp; DR<ul><li>Design and manage RMAN-based backup and recovery strategies</li><li>Implement and monitor backups using NetBackup and Veeam</li><li>Perform database restoration and disaster recovery drills</li><li>Plan and maintain high availability and business continuity solutions</li></ul>Performance Monitoring &amp; Tuning<ul><li>Proactively monitor database performance and capacity planning</li><li>Analyze and resolve performance issues using AWR, ASH, ADDM, SQL Developer, TOAD</li><li>Optimize SQL queries, indexing strategies, and database configurations</li><li>Monitor space usage, tablespace growth, and system health</li></ul>Monitoring &amp; Automation<ul><li>Configure and manage Oracle Enterprise Manager (OEM) 11g/12c/13c</li><li>Set up database alerts, monitoring dashboards, and health checks</li><li>Develop and maintain automation scripts for routine DBA tasks</li></ul>SQL Server Administration<ul><li>Install, configure, and manage Microsoft SQL Server 2000&ndash;2019</li><li>Perform SQL Server backups, restores, migrations, and performance tuning</li><li>Develop backup and restore scripts and manage DR procedures</li><li>Support production, development, and testing environments</li></ul>Security &amp; User Management<ul><li>Manage database users, roles, privileges, and security policies</li><li>Ensure compliance with organizational and regulatory requirements</li></ul>Leadership &amp; Support<ul><li>Lead DBA operations and provide 24/7 production support</li><li>Coordinate with application teams, developers, and infrastructure teams</li><li>Support application deployments and resolve database-related issues</li><li>Participate in planning, documentation, and continuous improvement initiatives</li></ul>Required Skills &amp; QualificationsTechnical Skills<ul><li>Strong expertise in Oracle RAC, Data Guard, ASM, RMAN</li><li>Hands-on experience with Oracle Exadata</li><li>Advanced knowledge of performance tuning and capacity planning</li><li>Experience with OEM Grid/Cloud Control</li><li>Proficiency in SQL Server administration and migration</li><li>Experience in cross-platform database migration</li><li>Knowledge of backup tools (NetBackup, Veeam)</li></ul>Certifications (Preferred)<ul><li>Oracle Certified Professional (OCP) 10g / 12c</li><li>Oracle Cloud Infrastructure Foundation Associate</li><li>Oracle Autonomous Database Cloud Specialist</li></ul>Education<ul><li>Bachelor&rsquo;s degree in Computer Science or related field</li></ul>Experience<ul><li>5&ndash;8+ years of enterprise-level database administration experience</li><li>Proven experience in banking, telecom, or large enterprise environments preferred</li></ul>Soft Skills<ul><li>Strong problem-solving and analytical skills</li><li>Excellent communication and documentation abilities</li><li>Ability to work independently and as part of a team</li><li>Leadership mindset with ownership of critical systems</li></ul>Job Type: Full-timeWork Location: In person

Senior Database Administrator (Oracle & SQL Server)

Job SummaryWe are seeking an experienced Senior Database Administrator (DBA) with 6+ years of hands-on expertise in managing, optimizing, and securing enterprise-level databases. The ideal candidate has strong experience with Microsoft SQL Server, Azure cloud databases, high availability, disaster recovery, and performance tuning in 24&times;7 production environments. The role involves close collaboration with development, BI, and infrastructure teams to ensure scalable and reliable database solutions.Key Responsibilities<ul><li>Manage and maintain SQL Server databases in production environments (24&times;7 support).</li><li>Design, implement, and maintain backup and disaster recovery strategies, including point-in-time recovery.</li><li>Configure and manage High Availability &amp; Disaster Recovery (HA/DR) solutions such as:</li><li>SQL Server Always On Availability Groups</li><li>Database Mirroring</li><li>Transactional Replication</li><li>Plan and execute SQL Server upgrades and migrations (SQL 2005 &rarr; 2019).</li><li>Migrate on-premises databases to Microsoft Azure SQL.</li><li>Perform database performance tuning, troubleshooting, and optimization.</li><li>Review and optimize T-SQL code, stored procedures, and queries.</li><li>Coordinate database and application changes with developers and QA teams.</li><li>Manage and test DR environments to ensure business continuity.</li><li>Configure and manage cloud-based databases for scalability and remote access.</li><li>Write automation and maintenance scripts using PowerShell.</li><li>Support data warehouse environments and upgrades.</li><li>Provide strategic guidance on database scalability and architecture.</li></ul>Required Skills &amp; Technical Expertise<ul><li>6+ years of experience as a Database Administrator.</li><li>Strong expertise in Microsoft SQL Server (2005, 2008, 2012, 2014, 2016, 2017, 2019).</li><li>Hands-on experience with:</li><li>Always On Availability Groups</li><li>Database Mirroring</li><li>Transactional Replication</li><li>Backup &amp; Recovery strategies</li><li>Strong T-SQL and Stored Procedures expertise.</li><li>Experience with SQL Server performance tuning and troubleshooting.</li><li>Experience migrating databases to Microsoft Azure.</li><li>Knowledge of Azure Data Services and Data Lake.</li><li>Experience working in Windows Cluster environments.</li><li>Familiarity with Elastic Search integration.</li><li>Ability to work in high-availability, mission-critical environments.</li></ul>Education<ul><li>Bachelor </li></ul>Soft Skills<ul><li>Strong analytical and problem-solving skills.</li><li>Excellent communication and collaboration abilities.</li><li>Ability to work with global clients and cross-functional teams.</li><li>Proactive, detail-oriented, and performance-focused mindset.</li></ul>Job Type: Full-timeWork Location: In person

Senior Database Administrator (DBA)

Information Tech Consultants

<div>
 
 🌟 Senior Data Scientist SME /
 
 Data Science SME (Subject matter expert)
 
 🧠
 
 
 
 
 
 
 Location : London (Relocation required - Sponsorship will be provided)
 
 
 
 
 Experience : 9-12 years
 
 
 
 
 CTC- 40-45 lacs
 
 
 
 
 
 
 We are seeking a highly accomplished and results-oriented
 
 Senior Data Scientist Subject Matter Expert (SME)
 
 with over
 
 10 years of experience
 
 to lead our advanced analytics and AI initiatives. This is a pivotal role requiring deep technical mastery across large-scale Big Data technologies, multi-cloud environments, and cutting-edge specialized AI domains, including
 
 Generative AI, Computer Vision, and Natural Language Processing (NLP)
 
 .
 
 
 You will be the principal technical leader, driving strategy, setting standards, and delivering high-impact solutions that transform business outcomes.
 
 
 
 
 
 Key Responsibilities
 
 
 
 
 <ul>
 <li>
 
 AI/ML Strategy &amp; Architecture:
 
 Define the technical roadmap and architectural standards for deploying and scaling complex AI systems, particularly those involving
 
 Generative AI (GenAI)
 
 , large language models (
 
 LLMs
 
 ), and specialized models in Computer Vision and NLP.
 </li>
 <li>
 
 Big Data Engineering:
 
 Design, build, and optimize high-throughput, distributed data pipelines and features using
 
 Apache Spark (Scala)
 
 and
 
 Hive
 
 on massive datasets to support model training and inference.
 </li>
 <li>
 
 Cross-Cloud Execution:
 
 Lead the design and deployment of ML models and data infrastructure across multiple major cloud providers (
 
 AWS, Azure, and GCP
 
 ), ensuring portability, scalability, and cost efficiency.
 </li>
 <li>
 
 Specialized Model Development:
 
 Lead hands-on development, fine-tuning, and deployment of production-grade models in key specialized areas:
 </li>
 <li>
 
 Computer Vision:
 
 Developing and optimizing models for image recognition, object detection, and video analytics.
 </li>
 <li>
 
 NLP:
 
 Building sophisticated systems for sentiment analysis, entity extraction, semantic search, and RAG architectures leveraging LLMs.
 </li>
 <li>
 
 Generative AI:
 
 Exploring and implementing cutting-edge GenAI techniques for content creation, data augmentation, and innovative product features.
 </li>
 <li>
 
 SME Consulting &amp; Mentorship:
 
 Act as the internal authority and consultant, providing technical guidance, architectural review, and mentorship to junior data scientists and engineering teams.
 </li>
 <li>
 
 MLOps &amp; Governance:
 
 Establish best practices for MLOps, model monitoring, version control, and model risk governance in a multi-cloud production environment.
 </li>
 </ul>
 
 
 
 
 Required Skills and Expertise (10+ Years)
 
 
 
 
 
 
 
 
 1. Big Data and Cloud Mastery
 
 
 
 
 <ul>
 <li>
 
 Programming &amp; Big Data:
 
 10+ years of extensive, hands-on experience with
 
 Apache Spark
 
 , with strong preference for production development using
 
 Scala
 
 . Deep expertise with
 
 Apache Hive
 
 for data querying and management.
 </li>
 <li>
 
 Cloud Proficiency:
 
 Demonstrated expertise in deploying and managing data/ML workloads across
 
 at least two
 
 of the three major cloud platforms:
 
 AWS
 
 (Sagemaker, EMR, S3),
 
 Azure
 
 (Azure ML, Synapse Analytics), and
 
 GCP
 
 (Vertex AI, BigQuery).
 </li>
 <li>
 
 Data Architecture:
 
 Expert knowledge of distributed systems, data partitioning, optimization techniques, and data warehousing concepts in a cloud-native context.
 </li>
 </ul>
 
 
 
 
 2. Advanced AI/ML Specialization
 
 
 
 
 <ul>
 <li>
 
 Generative AI (GenAI) &amp; LLMs:
 
 Proven experience with the architecture and implementation of Generative AI solutions, including prompt engineering, fine-tuning, and deploying
 
 Large Language Models (LLMs)
 
 .
 </li>
 <li>
 
 Computer Vision:
 
 In-depth knowledge of deep learning frameworks (TensorFlow, PyTorch) and experience with Computer Vision tasks (e.g., CNNs, object detection models like YOLO).
 </li>
 <li>
 
 NLP:
 
 Expert practical experience in NLP techniques, including transformer models, embedding generation, and building complex text-based applications.
 </li>
 </ul>
 
 
 
 
 3. Leadership &amp; Soft Skills
 
 
 
 
 <ul>
 <li>
 
 Technical Leadership:
 
 Proven track record of leading complex data science projects from research to production deployment.
 </li>
 <li>
 
 Communication:
 
 Exceptional ability to translate complex technical findings into clear, strategic recommendations for technical and executive audiences.
 </li>
 <li>
 
 Mentorship:
 
 Experience mentoring and training senior engineers and data scientists.
 </li>
 </ul>
 
 
 
 
 Education and Certification
 
 
 
 
 <ul>
 <li>
 Master&rsquo;s or Ph.D. in Computer Science, Data Science, Engineering, or a highly quantitative field.
 </li>
 <li>
 Relevant professional cloud certifications (e.g., AWS Certified Machine Learning Specialty, Google Cloud Professional Data Engineer) are highly desirable.
 </li>
 </ul>
 
 
</div>

Senior Data Scientist SME & AI

Cloudelligent

<div>Position Title: Sr. AWS Data Engineer 
Job Timings: 8:00 AM &ndash; 5:00 PM CST (6:00 PM- 3:00 AM PKT) 
Location: Islamabad 
 
About Cloudelligent 
 
Cloudelligent is Cloud-native consultancy and AWS Advanced consulting partner! We specialize in providing bespoke cloud solutions to Startups &amp; SMBs. Being a next-gen cloud service provider, Cloudelligent helps businesses to make the most out of their cloud investment. We have an international footprint with a diverse team of domain experts, and we are customer obsessed. 
 
Job Objective 
 
We are seeking an experienced Sr. Data Engineer with a strong background in data engineering, database optimization, and cloud-based data solutions, particularly on AWS. The ideal candidate will have hands-on experience with both SQL and NoSQL databases and be proficient in migrating, managing, and modernizing data platforms. You should be skilled in designing and maintaining scalable, secure, and high-performance data infrastructure in the cloud. 
 
Responsibilities<ul><li>
Design, implement, and manage cloud-based data infrastructure using Amazon RDS, Aurora, and EC2-hosted databases.</li><li>
Administer and optimize PostgreSQL, MySQL, and Oracle databases, ensuring high availability, performance, and cost-efficiency.</li><li>
Perform data migrations and transformations using AWS Database Migration Service (DMS) and other tools.</li><li>
Collaborate with data architects, engineers, and DevOps teams to deliver reliable and scalable data solutions.</li><li>
Support developers by analyzing and optimizing SQL queries and data workflows for performance and efficiency.</li><li>
Monitor and troubleshoot data issues, ensuring availability, security, and compliance.</li><li>
Implement data automation, infrastructure as code (IaC), and CI/CD pipelines for database and data pipeline deployments.</li><li>
Ensure data security, encryption, and compliance with industry best practices and internal policies.</li><li>
Maintain comprehensive documentation on data architecture, processes, and procedures.</li><li>
Stay up to date with emerging AWS features, data engineering tools, and industry best practices.</li></ul> 

Requirements<ul><li>
Bachelor&rsquo;s or Master&rsquo;s degree in Computer Science, Information Technology, or a related field.</li><li>
5+ years of experience in data engineering or database engineering, including hands-on experience with databases on AWS.</li><li>
Strong experience with AWS data services such as RDS, Aurora, and DMS.</li><li>
Proficient in performance tuning, indexing strategies, partitioning, and query optimization.</li><li>
Strong scripting and automation experience using Python, Bash, or similar tools.</li><li>
Experience with infrastructure as code tools like Terraform or CloudFormation.</li><li>
Solid understanding of backup strategies, monitoring tools, and security best practices.</li><li>
Familiarity with multi-account AWS environments and cross-region replication.</li><li>
Excellent communication and problem-solving skills.</li></ul> 

Highly Desirable<ul><li>
AWS Certification (e.g., AWS Certified Data Engineer &ndash; Associate, AWS Certified Solutions Architect &ndash; Associate).</li><li>
Experience with large-scale on-prem to AWS data migrations.</li><li>
Familiarity with data governance, compliance, and auditing tools.</li><li>
Exposure to data lake architecture and AWS services like Glue, Athena, or Kinesis is a plus.</li></ul>
TvhPiCaQjI</div>

Sr. AWS Data Engineer

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

255 sql dba expert optimization tuning jobs IN Islamabad

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

Senior Database Administrator (Oracle & SQL Server)

Senior Database Administrator (DBA)

Senior Data Scientist SME & AI

Sr. AWS Data Engineer