sql dba expert - optimization & tuning Jobs in Karachi

sql dba expert - optimization & tuning

database developer (sql)

database engineer

deputy manager/oracle developer Jobs in Karachi

deputy manager/oracle developer

oracle developer

sql dba expert optimization tuning

NorthBay - Pakistan

<div>
 MSSQL DBA/Expert | DB Optimization &amp; SQL Tuning
 <br/>
 <br/>
 Location: Lahore/Islamabad/Karachi
 <br/>
 <br/>
 Experience: 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>


SQL DBA Expert - Optimization & Tuning

NorthBay Solutions

<div><p><b>MSSQL DBA/Expert | DB Optimization &amp; SQL Tuning</b></p><p></p><p><br>
Location: Lahore/Islamabad/Karachi</p><p>
Experience: 8+ years</p><p><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</p><p><b><br>
Requirements:</b></p><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><p><b><br>
Responsibilities:</b></p><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><p><b>
What We Offer</b></p><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><p>
</p><p>8igywgb1B4</p></div>

Afiniti

<div><div><div><div><b>WHO ARE WE?</b></div>
<div>Over the past 16 years, Afiniti's patented technology has paired customers and contact centre agents in real-time based on how well they are likely to interact, leading to better experiences across the entire customer journey. As our products evolve, it is our mission to retain and grow revenue by creating repeatable AI-driven solutions that transition from high-touch managed services to product-led growth.</div>
<div>Afiniti operates throughout the world and has driven billions of dollars of precisely measurable AI value for our telecommunications, banking, insurance, healthcare, and travel customers. To learn more, visit <b>www.afiniti.com</b>.</div><br>
<div></div>
<div><b>Our vision</b></div>
<div>Afiniti&rsquo;s vision is to lead the contact centre industry by delivering innovative AI solutions that uniquely enhance customer lifetime value and operational efficiency, earning us the trust of leading consumer companies worldwide.</div><br>
<div></div>
<div><b>Our Ways of Working</b></div>
<div>At Afiniti, how we work is just as important as what we achieve. Our <b>Ways of Working</b> are ten guiding principles that define the standards and behaviors we hold ourselves accountable to every day. They push us to act with urgency and discipline, to innovate with data and facts, and to always see our work through the eyes of our clients. These principles are not abstract values - they are actionable commitments that shape daily decisions, strengthen collaboration, and ensure we deliver outcomes that matter.</div>
<div>Together, they encourage us to be intentional in how we prioritize and execute, to confront challenges and conversations directly, and to embrace the richness of our global community with respect and openness. They remind us to celebrate excellence, show kindness, and assume good intentions in every interaction. By living these principles consistently, we build the culture we aspire to - one that is ambitious, respectful, and relentlessly focused on creating meaningful impact for our clients and each other.</div><br>
<div></div>
<div><b>THE ROLE</b></div>
<div><b>Senior Analyst, Database Administration (DBA)</b></div>
<div><b>Reporting to:</b> Manager &ndash; Database Administration</div><br>
<div></div>
<div><b>LOCATION</b></div>
<div>Pakistan</div>
<div><b>Work Environment: </b>Hybrid</div><br>
<div></div>
<div><b>ABOUT THE ROLE</b></div>
<div>Afiniti is looking for a Senior Analyst, Database Administration (DBA) who is analytical, detail-oriented, and driven by data accuracy and system reliability. Reporting to the Manager, Database Administration, you will play a key role in maintaining, optimizing, and safeguarding Afiniti&rsquo;s database infrastructure across global environments. This role is critical in ensuring high availability, performance tuning, and seamless integration of data systems that power Afiniti&rsquo;s AI-driven solutions.</div>
<div>Our DBA team collaborates closely with engineering, infrastructure, and data science teams across multiple regions. The environment is fast-paced and collaborative, offering exposure to a range of technologies and complex data challenges while working alongside skilled professionals who will support your technical and professional growth.</div>
<div>What will be your key deliverables</div>
<ul><li>Database Maintenance &ndash; Ensure databases are properly configured, optimized, and backed up to support high availability.</li>
<li>Performance Tuning &ndash; Monitor and improve database performance, identifying and resolving bottlenecks proactively.</li>
<li>Data Security &amp; Compliance &ndash; Implement and maintain security controls to protect sensitive information and ensure compliance with internal policies.</li>
<li>Backup &amp; Recovery &ndash; Manage database backup strategies and perform recovery operations as required.</li>
<li>Collaboration &amp; Support &ndash; Work closely with development and infrastructure teams to support deployments, troubleshoot production issues, and ensure smooth operations.</li></ul><br>
<div>
</div><div><b>Who you are</b></div>
<div><b>Experience:</b> 5+ years of experience in database administration or a related field, preferably within a large-scale or global organization.</div>
<div><b>Education:</b> Bachelor&rsquo;s degree in Computer Science, Information Technology, or a related discipline (certifications in SQL Server, or similar technologies are a plus).</div><br>
<div></div>
<div><b>Skills</b></div>
<ul><li>Strong knowledge of MySQL, PostgreSQL and/or SQL Server database environments.</li>
<li>Experience with database performance tuning, query optimization, and replication.</li>
<li>Hands-on experience in backup, recovery, and database security management.</li>
<li>Proficiency in automation and scripting (PowerShell, Python, Bash).</li>
<li>Excellent problem-solving, analytical, and troubleshooting skills.</li>
<li>Clear communication and collaboration with cross-functional teams.</li>
<li>Ability to prioritize tasks and deliver results under tight deadlines.</li></ul><br>
<div>
</div><div><b>Behavioral Traits:</b> Analytical, dependable, collaborative, and able to thrive in a fast-paced technical environment.</div><br>
<div></div>
<div><b>Nice to have</b></div>
<ul><li>Working knowledge of Python for automation and scripting.</li>
<li>Familiarity with Airflow for workflow orchestration and data pipeline management.</li>
<li>Experience with Greenplum or other Massively Parallel Processing (MPP) databases.</li></ul><br>
<div>
</div><div><b>What success looks like</b></div>
<div>In this role, you will be successful if you:</div>
<ul><li>Maintain consistent database uptime and reliability across environments.</li>
<li>Drive performance improvements through proactive monitoring and tuning.</li>
<li>Collaborate effectively with cross-functional teams to ensure data accuracy, compliance and availability.</li></ul><br>
<div>
</div><div><b>Why should you apply</b></div>
<ul><li>Opportunity to work with cutting-edge database technologies in a global AI-driven company.</li>
<li>Exposure to complex, high-availability environments supporting enterprise applications.</li>
<li>Growth opportunities through technical learning and mentorship from experienced DBA professionals.</li></ul><br>
<div>
</div><div><b>What will make you stand out in the crowd</b></div>
<div>You are someone who thrives on solving complex data challenges, brings a proactive approach to system reliability, and takes ownership of critical operations. Your strong technical foundation, collaboration skills, and drive for excellence will make you an invaluable part of the DBA team.</div><br>
<div></div>
<div><i>We believe that richness in diversity is a huge asset for Afiniti. We value both the similarities and differences in everyone who is a part of the Afiniti team. We believe that this diversity builds a stronger organization and is in keeping with the core values of our company. Our policy, therefore, is to provide equal employment opportunities for all applicants and employees without regard to race, color, religion, sex (including pregnancy, childbirth, related medical conditions, breastfeeding or reproductive health decisions), gender identity or expression, national origin, age, marital status, ancestry, physical or mental disability, sexual orientation, personal appearance, genetic information, family responsibilities, matriculation, political affiliation, military or veteran status, or any other category protected under applicable federal, state or local law. This means that we comply with all applicable human rights and employment legislation, and we do not discriminate in any aspect of employment, including recruiting, hiring, compensation, promotions, reductions in force, or terminations.</i></div></div></div></div>

Sr Database Administrator

Pivotize Consulting

<p><b>Technology Stack:</b></p><p>Angular 12+, .NET Core 8, SQL Server 2019 Enterprise Edition, Redis, SQL Lite, OData</p><p><b>Role Summary:</b></p><p>We are seeking a highly experienced Full-Stack Engineer responsible for end-to-end performance, security, and release optimization across frontend, backend, and infrastructure layers. This role will focus on improving system speed, scalability, and resilience while ensuring compliance with modern white-box, grey-box, and black-box testing standards.</p><p><b>Key Responsibilities</b>:</p><p>&middot; Profile and optimize Angular 12+ components, applying lazy loading, OnPush strategy, and efficient data handling.</p><p>&middot; Analyze and refactor .NET Core 8 APIs for performance, scalability, and security.</p><p>&middot; Optimize SQL Server queries, stored procedures, indexes, and implement advanced features like partitioning, materialized views, columnstore Indexes, In-Memory OLTP, Query Store, controls (CPU, memory, and I/O resource allocation), Scale-Out with Sharding.</p><p>&middot; Conduct release management optimization: IIS tuning, caching strategies, connection pooling, and CI/CD performance improvements.</p><p>&middot; Collaborate with product leadership to define and achieve measurable performance goals.</p><p>&middot; Conduct and close pen testing issues ensuring adherence to OWASP standards.</p><p>&middot; Design scalable microservices-ready architecture for long-term growth.</p><p><b>Required Skills</b></p><p>&middot; 8+ years of full-stack development experience in Angular, .NET Core, and SQL Server.</p><p>&middot; Expert in SQL Server performance tuning, query optimization, indexing, and partitioning.</p><p>&middot; Strong understanding of IIS performance configuration and Redis caching.</p><p>&middot; Hands-on with performance profiling tools (.NET Profiler, SQL Profiler, Chrome DevTools, Lighthouse).</p><p>&middot; Experience in microservices design, Docker, Kubernetes, and cloud deployment pipelines.</p><p>&middot; Knowledge of OWASP and security testing tools (Burp Suite, OWASP ZAP).</p><p>Preferred Skills / Experience</p><p>&middot; Experience optimizing enterprise-grade web platforms handling large data sets.</p><p>&middot; Background in DevOps and CI/CD pipeline performance tuning.</p><p><b>Key Performance Indicators (KPIs)</b></p><p>&middot; Reduce page load time to under 2 seconds for major modules.</p><p>&middot; Achieve 60% reduction in average API response time.</p><p>&middot; Resolve 100% of identified pen testing issues within SLA.</p><p>&middot; Implement database improvements reducing query execution time below 2 second</p><p>Job Type: Full-time</p><p>Pay: From Rs250,000.00 per month</p><p>Application Question(s):</p><ul><li>What is your current salary?</li><li>What is your expected salary?</li><li>What is your notice period?</li><li>Since it's an on-site role, would you be able to commute to Bahria Complex 1, Lalazar, M.T.Khan Road for interview &amp; job?</li></ul><p>Work Location: In person</p>

Senior Full-Stack Engineer (Angular & .Net Only)

Bikter tech

<p><b>Experience: </b>04 Years+<br/><b>Location: </b>On-site, Karachi<br/><b>Job Type:</b> Contractual<br/><b>Duration: </b>Short term<b>, </b>06 Months</p><p><b>What we&rsquo;re Looking For?</b></p><p>We are seeking a highly skilled Oracle E-Business Suite (EBS) Developer &amp; SQL Developer with strong hands-on experience in Oracle EBS modules, PL/SQL development, and database optimization. The ideal candidate should be able to develop, customize, maintain, and support Oracle EBS applications while ensuring high performance, security, and data integrity.</p><p><b>Job Responsibilities:</b></p><ul><li>Develop, customize, and maintain Oracle EBS modules (Financials, SCM, HRMS or related modules).</li><li>Design and write complex PL/SQL procedures, functions, triggers, packages, and views.</li><li>Perform EBS R12 customizations, extensions, interfaces, conversions, and reports (CEMLI).</li><li>Troubleshoot and resolve application and database issues related to EBS.</li><li>Work closely with business users to gather requirements and translate them into technical solutions.</li><li>Optimize SQL queries and database structures for performance improvement.</li><li>Develop Oracle Forms, Oracle Reports, BI Publisher reports, and OAF pages (if required).</li><li>Support month-end, year-end, and business-critical processes.</li><li>Ensure data accuracy, integrity, and system reliability across EBS modules.</li><li>Collaborate with cross-functional teams, DBAs, and business analysts for seamless operations.</li><li>Prepare technical documents, design specifications, and unit test plans.</li></ul><p><b>Skills and Qualifications</b></p><ul><li>Bachelor&rsquo;s degree in Computer Science, Software Engineering, IT, or related field.</li><li>Strong command of PL/SQL, SQL tuning, and relational database concepts.</li><li>Experience with Oracle Forms, Oracle Reports, XML/BI Publisher.</li><li>Experience in building Interfaces, Conversions, Workflows, and Extensions.</li><li>Solid understanding of EBS modules such as AP, AR, GL, PO, INV, HRMS, or others.</li><li>Strong analytical, debugging, and problem-solving skills.</li><li>Familiarity with OAF (Oracle Application Framework) is a plus.</li><li>Ability to work under pressure and meet strict deadlines.</li><li>Excellent communication and coordination skills.</li><li>Ability to work independently as well as part of a team in an on-site environment.</li></ul><p>Interested candidates can send your resumes at <b>hr@bikter.com</b></p><p>Job Type: Contract<br/>Contract length: 06 months</p><p>Pay: Rs400,000.00 - Rs600,000.00 per month</p><p>Work Location: On the road</p>

Oracle EBS Developer

VIDIZMO LLC

<div><p>We're seeking passionate, driven, and self-motivated individuals to join our team. If you're eager to grow in a dynamic environment and be part of a company that&rsquo;s at the forefront of AI innovation, this is your chance to hit the ground running.</p><p></p><p><br>
VIDIZMO is a USA-based technology company headquartered in Tysons, Virginia, and a <b>Microsoft Solutions Partner</b> in <b>Data &amp; AI</b>, <b>Infrastructure</b>, and <b>Digital &amp; App Innovation</b>. Offering a <b>AI-Powered Intelligence Hub</b>, we empower <b>Fortune 500 companies</b>, <b>large enterprises</b>, governments, and the <b>public sector</b> to securely manage, analyze, and govern their data with complete control and compliance.</p><p></p><p><br>
Our <b>Multimodal AI Data Intelligence Platform</b> leverages <b>Large Language Models (LLMs)</b> and <b>RAG (Retrieval-Augmented Generation)</b> to deliver powerful capabilities such as <b>auto-tagging</b>, <b>redaction</b>, <b>content summarization</b>, <b>OCR</b>, <b>translation</b>, <b>subtitle creation</b>, <b>object detection and tracking</b>, <b>content search</b>, <b>sentiment and emotion analysis</b>, <b>topic extraction</b>, <b>document classification</b>, and <b>facial attribute detection.</b></p><p></p><p><b><br>
About the Role:</b></p>
<p>
We are seeking a motivated and detail-oriented <b>Junior Database Engineer</b> to join our dynamic engineering team. The ideal candidate will have hands-on experience in <b>SQL Server</b> and a strong understanding of database design, optimization, and maintenance. This role offers an excellent opportunity to grow your technical expertise while working on real-world data challenges in a collaborative environment.</p><p></p><p><b><br>
Key Responsibilities:</b></p>
<ul>
<li>Design, develop, and maintain SQL Server databases to support business applications and reporting needs.</li>
<li>Write and optimize complex SQL queries, stored procedures, triggers, and functions.</li>
<li>Ensure database performance, integrity, and security.</li>
<li>Support database backup, restore, and recovery processes.</li>
<li>Monitor database performance and troubleshoot issues proactively.</li>
<li>Assist in data migration, ETL processes, and integration between systems.</li>
<li>Collaborate with software engineers, QA, and DevOps teams to ensure seamless data flow and reliability.</li>
<li>Participate in database documentation and version control practices.</li></ul><br>
<p></p>
<p><b>
Requirements:</b></p>
<ul>
<li>Bachelor&rsquo;s degree in Computer Science, Software Engineering, or a related field.</li>
<li>Minimum <b>1 year of hands-on experience</b> with <b>Microsoft SQL Server</b>.</li>
<li>Strong command over <b>T-SQL</b>, including query writing, joins, indexing, and optimization.</li>
<li>Basic understanding of <b>database normalization</b>, <b>data modeling</b>, and <b>ER diagrams</b>.</li>
<li>Knowledge of <b>backup and recovery</b>, <b>database security</b>, and <b>performance tuning</b>.</li>
<li>Familiarity with <b>SSMS (SQL Server Management Studio)</b> or similar tools.</li>
<li>Understanding of <b>ETL concepts</b> and exposure to data integration workflows is a plus.</li>
<li>Good analytical, problem-solving, and communication skills.</li></ul><br>
<p></p>
<p><b>
Preferred Qualifications (Good to Have):</b></p>
<ul>
<li>Exposure to <b>cloud-based databases (Azure SQL, AWS RDS)</b>.</li>
<li>Experience with <b>Power BI</b> or other reporting tools.</li>
<li>Understanding of <b>NoSQL databases</b> or data warehousing concepts.</li></ul><br>
<p></p>
<p><b>
Essential Skills:</b></p>
<p>
The ideal candidate demonstrates strong business acumen, can translate objectives into impactful solutions, and is proficient in leveraging AI tools&mdash;including mandatory use of platforms like ChatGPT&mdash;to enhance efficiency. An ownership mindset and the ability to drive outcomes with minimal task-level direction are essential.</p><p></p><p><br>
Benefits: Health Insurance (OPD/IPD), Separate Maternity Cover, Leave encashment, Car Support Program, Referral Bonus, EOBI, Bi-Annual Increment. Provident Fund, Career Growth, Bonus (benefits vary based on location)</p><br>
<p></p>
<p>
Multiple Locations: Pakistan, India, UAE, Australia, Canada &amp; USA</p></div>

Database Engineer

Database Developer (SQL)

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

495 sql dba expert optimization tuning jobs IN Karachi

SQL DBA Expert - Optimization & Tuning

SQL DBA Expert - Optimization & Tuning

Sr Database Administrator

Senior Full-Stack Engineer (Angular & .Net Only)

Oracle EBS Developer

Database Engineer

Database Developer (SQL)