58 Sql jobs in Saudi Arabia

SQL developer

Jaish Global Tech Private Limited

Posted 22 days ago

Job Viewed

Tap Again To Close

Job Description

Join to apply for the SQL developer role at Jaish Global Tech Private Limited

Join to apply for the SQL developer role at Jaish Global Tech Private Limited

Jaish Global Tech Private Limited provided pay range

This range is provided by Jaish Global Tech Private Limited. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

Established in 2019, Jaish Global has rapidly evolved into a distinguished solution provider in the cybersecurity space and SI integrator in Digital Transformation using Machine Learning & Artificial Intelligence. Jaish Global Consultancy is an Umbrella company certified by ISO 9001:2015 and ISO 27001. Our unwavering focus on quality and innovative niche technology solutions creates a true edge. Our commitment to excellence has positioned us as a trusted technology-driven organization, safeguarding customer businesses from the ever-evolving landscape of cyber threats and creating business values in customers' enterprise portfolios using our AI tools and services. We never stop pushing the boundaries of what is possible. We are always learning, growing, and re-skilling in Technology solutions and process mapping to stay at the forefront of the industry. Our dynamic culture reflects our drive to be the best. We are providing the services to our customers keeping in view to -> Quick response to change and support for enterprise agility aligned with the business strategy -> Organizational transformation, adopting new trends in business and technology -> Organizational change to support Digital Transformation -> Organizational and operating model changes to improve efficiency and effectiveness -> Lower business operation costs Improved business productivity -> Extending the effective reach of the enterprise (e.g., through digital capability)

The Role

Role Overview

We are seeking a skilled and enthusiastic SQL Developer to join our growing data team. In this role, you will be responsible for designing, developing, and maintaining databases and data solutions. The ideal candidate will have a strong understanding of SQL and database principles, with a proven track record of optimizing database performance and ensuring data integrity.

Responsibilities

  • Design, develop, and implement database solutions, including tables, views, stored procedures, and functions.
  • Write complex SQL queries to retrieve, manipulate, and analyze data.
  • Optimize database performance for speed and efficiency.
  • Ensure data quality, accuracy, and consistency.
  • Troubleshoot and resolve database issues.
  • Collaborate with developers, analysts, and other stakeholders to understand data requirements.
  • Create and maintain database documentation.
  • Participate in database design and code reviews.
  • Stay up-to-date with the latest SQL Server features and database technologies.
  • Develop ETL processes to move data between databases.

Ideal Profile

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • 2-3 years of experience as a SQL Developer.
  • Strong proficiency in SQL (e.g., T-SQL, PL/SQL).
  • Experience with database management systems such as SQL Server, MySQL, or Oracle.
  • Understanding of database design principles and normalization.
  • Experience with query optimization and performance tuning.
  • Knowledge of data warehousing concepts.
  • Excellent analytical and problem-solving skills.
  • Strong communication and collaboration skills.
  • Ability to work independently and as part of a team.

Preferred Skills

  • Knowledge of database administration tasks.
  • Familiarity with cloud-based database services (e.g., Azure SQL Database, Amazon RDS, Snowflake).
  • Experience with data visualization tools (e.g., Power BI, Tableau).
  • Knowledge of scripting languages (e.g., Python, PowerShell).

What's on Offer?

  • Fantastic work culture

Seniority level
  • Seniority level Mid-Senior level
Employment type
  • Employment type Full-time
Job function
  • Job function Information Technology
  • Industries Manufacturing, Industrial Machinery Manufacturing, and Maritime Transportation

Referrals increase your chances of interviewing at Jaish Global Tech Private Limited by 2x

Get notified about new SQL Developer jobs in Saudi Arabia .

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.

SQL Database Administrator

Riyadh, Riyadh RMG | مجموعة ريناد المجد (لتقنية المعلومات)

Posted today

Job Viewed

Tap Again To Close

Job Description

Senior Human Resources Specialist @ Company | Enhancing Employee Experience

Job Description:

We are seeking a highly skilled Database Administrator (DBA) to manage, optimize, and secure our MS SQL database environments. The ideal candidate will ensure high availability, performance tuning, disaster recovery, and data security while adhering to best practices in database management.

Key Responsibilities:

  • Administer and maintain MS SQL Server databases, ensuring optimal performance and reliability.
  • Configure and manage MS SQL Always On Availability Groups for high availability.
  • Perform performance tuning, monitoring, and troubleshooting of database systems.
  • Implement backup, recovery, and disaster recovery (DR) strategies (RMAN, native backup, clustering, replication).
  • Manage database patching, upgrades, and migrations .
  • Ensure data security through encryption (TDE), SSL, and data masking .
  • Collaborate with IT teams to support business applications and cloud integrations.

Qualifications & Requirements:

  • Bachelor’s degree in Computer Science, Computer Engineering , or related field.
  • 10+ years of hands-on experience in database administration (MS SQL).
  • High Availability (HA) and Disaster Recovery (DR) solutions.
  • Performance tuning , query optimization, and monitoring tools.
  • Backup/Restore , clustering , and replication .
  • Database security (TDE, SSL, data masking).
  • Certifications like Microsoft Certified: Azure Database Administrator or MCSA: SQL Server are a plus.
  • Strong analytical, problem-solving, and communication skills.

Why Join Us?

  • Opportunity to work on mission-critical systems in a dynamic environment.
  • Competitive salary and benefits package.
  • Career growth and professional development support.

Location: Riyadh, Saudi Arabia

#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.

Ms SQL Database Administrator

Riyadh, Riyadh CCDS

Posted today

Job Viewed

Tap Again To Close

Job Description

**SQL Server Database Administrators will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems.**

**Responsibilities**:

- Manage SQL Server databases
- Configure and maintain database servers and processes
- Monitor system's health and performance
- Ensure high levels of performance, availability, sustainability and security
- Analyze, solve, and correct issues in real time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide 24x7 support for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours

**Requirements**:

- 4 years of experience as a SQL Server DBA or similar role
- 4 years of experience with Performance Tuning and Optimization (PTO)
- 4 years of experience with backups, restores and recovery models
- 4 years of experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- 4 years of experience with Windows server, including Active Directory
- Sense of ownership and pride in your performance and its impact on company’s success
- Critical thinker and problem-solving skills
- Team worker
- Good time-management skills
- Great interpersonal and communication skills
- MCTS, MCITP, and/or MVP certifications a plus
- Saudi Nationality are preferred.
- Inside Saudi Region are preferred.
This advertiser has chosen not to accept applicants from your region.

SQL & Oracle DB Engineer

Riyadh, Riyadh DXC Consulting & Engineering Services

Posted today

Job Viewed

Tap Again To Close

Job Description

Responsibilities
  • Assist in the management and operation of infrastructure services, providing support to the team.
  • Contribute to the implementation of infrastructure strategies and projects.
  • Help maintain the performance and availability of infrastructure systems while troubleshooting issues.
  • Collaborate with other teams to understand their infrastructure requirements and support design and/or implementation.
  • Participate in the implementation of best practices and process improvements within the infrastructure services.
  • Assist in the development of infrastructure documentation, including policies, procedures, and reports.
  • Contribute to the optimization of resource allocation for infrastructure tasks and projects.
  • Effective communication to provide support and collaborate with team members.
Basic Qualifications
  • Bachelor's degree in a relevant field or equivalent combination of education and experience
  • Typically, 6+ years of relevant work experience in industry, with a minimum of 2+ years in a similar role
  • Proven experience in infrastructure technology management
  • Proficiencies in technical knowledge and teamwork
  • A continuous learner that stays abreast with industry knowledge and technology
Other Qualifications
  • An advanced degree in a relevant field is a plus
  • Relevant certifications, such as CompTIA A+, Microsoft Certified: Azure Fundamentals, or Certified Cloud Practitioner, are a plus
Seniority level
  • Mid-Senior level
Employment type
  • Full-time
Job function
  • Information Technology
Industries
  • IT Services and IT Consulting
#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.

SQL And .Net Programmer

Riyadh, Riyadh Imtiaz Al Arabia Co. Ltd

Posted 22 days ago

Job Viewed

Tap Again To Close

Job Description

  • Making a web Portal and design different reports to access the data from anywhere. (Top Priority)
  • Microsoft GP Customization time to time according to Accounts requirement (Only we can do it in .net)
  • SQL database Optimization
  • Maintenance of RMS & GP Integration if needed
  • IT Administrator (Additional Skills, Second Priority)
  • Network Administrator (Additional Skills, Second Priority)
Job Specification
  • Crystal Reports XI
  • SQL 2005, 2008/2012 DB administration & Back End programming
  • Optionally having Knowledge on Microsoft Great Plains, Microsoft Retail Management System
  • Windows Desktop
  • Anti-Virus, Backup
  • Local Area Networking
  • Simple Troubleshooting on Router, Firewall/VPN

Location: Riyadh, Saudi Arabia

#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.

Lead SQL & Oracle DB Engineer

Riyadh, Riyadh DXC Technology

Posted 8 days ago

Job Viewed

Tap Again To Close

Job Description

Join to apply for the Lead SQL & Oracle DB Engineer role at DXC Technology

Join to apply for the Lead SQL & Oracle DB Engineer role at DXC Technology

Get AI-powered advice on this job and more exclusive features.

  • Serve as SME (subject matter expert) for Microsoft SQL Server, PostgreSQL and other database technologies
  • Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On
  • Participates in SQL code-reviews for the application teams to enforce SQL coding standards
  • Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance
  • Assist in the technical analysis and design for current and future projects
  • Writes appropriate SQL scripts to extract data efficiently and in a timely manner
  • Install database software on servers as needed
  • Monitor databases for performance and issues using monitoring tools
  • Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
  • Architect and maintain Oracle RAC, Data Guard, ASM, and backup/restore strategies
  • Lead performance tuning, patch management, and complex incident resolution
  • Ensure high availability and replication readiness across DCs
  • Implement automation for routine tasks using Ansible or PL/SQL scripting
  • Ensure NCA and NDMO compliance, secure data handling, and auditing
  • Mentor L2 Oracle engineers and interface with solution architects

Job Description

Essential Job Functions:

  • Serve as SME (subject matter expert) for Microsoft SQL Server, PostgreSQL and other database technologies
  • Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On
  • MS SQL production database level performance tuning
  • Participates in SQL code-reviews for the application teams to enforce SQL coding standards
  • Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance
  • Assist in the technical analysis and design for current and future projects
  • Writes appropriate SQL scripts to extract data efficiently and in a timely manner
  • Install database software on servers as needed
  • Monitor databases for performance and issues using monitoring tools
  • Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
  • Architect and maintain Oracle RAC, Data Guard, ASM, and backup/restore strategies
  • Lead performance tuning, patch management, and complex incident resolution
  • Manage Oracle database lifecycle: provisioning, migration, upgrades
  • Ensure high availability and replication readiness across DCs
  • Implement automation for routine tasks using Ansible or PL/SQL scripting
  • Ensure NCA and NDMO compliance, secure data handling, and auditing
  • Mentor L2 Oracle engineers and interface with solution architects

Basic Qualifications

  • Bachelor's degree in a relevant field or equivalent combination of education and experience
  • Typically, 6+ years of relevant work experience in industry, with a minimum of 2+ years in a similar role
  • Advanced skills in Oracle 19c+, RAC, Data Guard, RMAN, OEM
  • Expertise in SQL optimization and schema tuning
  • Experience in hybrid cloud database setups
  • Knowledge of Ansible or Terraform for automation
  • Strong knowledge of industry-standard database management practices and methodologies

Other Qualifications

  • An advanced degree in a relevant field is a plus
  • Oracle Certified Professional (OCP)
  • Professional certification in database administration

At DXC Technology, we believe strong connections and community are key to our success. Our work model prioritizes in-person collaboration while offering flexibility to support wellbeing, productivity, individual work styles, and life circumstances. We’re committed to fostering an inclusive environment where everyone can thrive.

Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf. More information on employment scams is available here. Seniority level
  • Seniority level Mid-Senior level
Employment type
  • Employment type Full-time
Job function
  • Job function Other
  • Industries IT Services and IT Consulting

Referrals increase your chances of interviewing at DXC Technology by 2x

Get notified about new Lead jobs in Riyadh, Riyadh, Saudi Arabia .

Senior Reporting & Process Improvement Manager Senior Manager - People Development & Learning Operational Excellence Senior Supervisor

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.

Lead SQL & Oracle DB Engineer

Riyadh, Riyadh DXC Technology Inc.

Posted 11 days ago

Job Viewed

Tap Again To Close

Job Description

Lead SQL & Oracle DB Engineer page is loadedLead SQL & Oracle DB Engineer Apply locations SAU - RIYADH time type Full time posted on Posted 30+ Days Ago job requisition id

Job Description:

Essential Job Functions:

  • Serve as SME (subject matter expert) for Microsoft SQL Server, PostgreSQL and other database technologies.

  • Responsible for database backup and restore functions including scheduled tests of DR availability, including knowledge of MS SQL restoration and availability technologies such as Clustering, Replication and especially Always-On.

  • MS SQL production database level performance tuning.

  • Participates in SQL code-reviews for the application teams to enforce SQL coding standards.

  • Builds and reports on SQL environment performance and availability metrics and takes appropriate actions to implement best practices and optimize performance.

  • Assist in the technical analysis and design for current and future projects.

  • Writes appropriate SQL scripts to extract data efficiently and in a timely manner.

  • Install database software on servers as needed.

  • Monitor databases for performance and issues using monitoring tools.

  • Ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).

  • Architect and maintain Oracle RAC, Data Guard, ASM, and backup/restore strategies.

  • Lead performance tuning, patch management, and complex incident resolution.

  • Manage Oracle database lifecycle: provisioning, migration, upgrades.

  • Ensure high availability and replication readiness across DCs.

  • Implement automation for routine tasks using Ansible or PL/SQL scripting.

  • Ensure NCA and NDMO compliance, secure data handling, and auditing.

  • Mentor L2 Oracle engineers and interface with solution architects.

Basic Qualifications:

  • Bachelor's degree in a relevant field or equivalent combination of education and experience

  • Typically, 6+ years of relevant work experience in industry, with a minimum of 2+ years in a similar role

  • Advanced skills in Oracle 19c+, RAC, Data Guard, RMAN, OEM.

  • Expertise in SQL optimization and schema tuning.

  • Experience in hybrid cloud database setups.

  • Knowledge of Ansible or Terraform for automation.

  • Strong knowledge of industry-standard database management practices and methodologies.

Other Qualifications:

  • An advanced degree in a relevant field is a plus

  • Oracle Certified Professional (OCP)

  • Professional certification in database administration

At DXC Technology, we believe strong connections and community are key to our success. Our work model prioritizes in-person collaboration while offering flexibility to support wellbeing, productivity, individual work styles, and life circumstances. We’re committed to fostering an inclusive environment where everyone can thrive.

Recruitment fraud is a scheme in which fictitious job opportunities are offered to job seekers typically through online services, such as false websites, or through unsolicited emails claiming to be from the company. These emails may request recipients to provide personal information or to make payments as part of their illegitimate recruiting process. DXC does not make offers of employment via social media networks and DXC never asks for any money or payments from applicants at any point in the recruitment process, nor ask a job seeker to purchase IT or other equipment on our behalf.More information on employment scams is available here .

Similar Jobs (12) Buisness Continuity SME locations SAU - RIYADH time type Full time posted on Posted 30+ Days AgoRR- - Associate Manager Infrastructure Services locations SAU - RIYADH time type Full time posted on Posted 5 Days AgoLinuxAIXContainer Jr Lead locations SAU - RIYADH time type Full time posted on Posted 30+ Days Ago

DXC Technology (NYSE: DXC) helps global companies run their mission-critical systems and operations while modernizing IT, optimizing data architectures, and ensuring security and scalability across public, private and hybrid clouds. The world's largest companies and public sector organizations trust DXC to deploy services to drive new levels of performance, competitiveness, and customer experience across their IT estates. Learn more about how we deliver excellence for our customers and colleagues atDXC.com .

#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.
Be The First To Know

About the latest Sql Jobs in Saudi Arabia !

Oracle and SQL Server Core DBA

Riyadh, Riyadh Saudi Networkers Services

Posted 2 days ago

Job Viewed

Tap Again To Close

Job Description

The Role
We are seeking an experienced Core Database Administrator with strong expertise in both Oracle and Microsoft SQL Server database platforms. The candidate will be responsible for ensuring database performance, availability, integrity, and security across business-critical systems. This includes installation, configuration, patching, backup and recovery, high availability setup, and performance tuning in both environments. Oracle DBA Responsibilities: • Install, configure, patch, and upgrade Oracle databases. • Manage Real Application Clusters (RAC), ASM, and Oracle Data Guard. • Perform RMAN-based backup and recovery, cloning, and export/import operations. • Monitor performance using AWR, ADDM, ASH, and OEM (Enterprise Manager). • Administer users, roles, profiles, tablespaces, and storage. • Troubleshoot ORA errors, memory issues, and locking/blocking problems. SQL Server DBA Responsibilities: • Install, configure, and upgrade SQL Server (2000–2019 and above). • Implement high availability solutions: Always On Availability Groups, Log Shipping, Mirroring. • Perform backups and restores using native tools or third-party solutions. • Monitor system performance using SQL Profiler, Extended Events, and DMVs. • Manage SQL Server security, roles, and permissions. • Create, monitor, and troubleshoot SQL Agent jobs and SSIS packages. Common Core DBA Responsibilities: • Ensure 24/7 availability and health of production, test, and development environments. • Automate routine administrative tasks using scripting (PowerShell, Shell, PL/SQL, T-SQL). • Implement disaster recovery and business continuity strategies. • Collaborate with developers and support teams for query tuning and schema design. • Maintain and update database documentation and standard operating procedures. • Conduct audits and support compliance requirements (data protection, access control).

Requirements
• 10+ years of hands-on DBA experience supporting Oracle and SQL Server. • Strong expertise in RMAN, OEM, SQL Server Management Studio (SSMS), and performance tuning. • Proficiency in PL/SQL, T-SQL, and scripting languages (Shell, PowerShell). • Solid understanding of high availability, clustering, and replication technologies. • Experience with Linux and Windows Server environments. • Strong troubleshooting and root cause analysis skills.

About the company
Saudi Networkers Services, incorporated in 2001 with an aim to provide the world class business and consulting services through a combination of market insight, technical excellence and unrivalled agile methodology. Our success stems from building strong relationships and trusted partners, which enabled us delivering exceptional services to public sector, as well as some world's leading organizations, in Telecommunication, Information Technology, Cyber Security, Banking, Energy, Utilities and various other industry arenas. We collaborate closely, ideate that how the work gets done, while working alongside businesses to collaborate on growth and applying breakthrough innovations, that drive exponential impact, managed by teams specialized in their assigned industry sectors.
This advertiser has chosen not to accept applicants from your region.

Senior Oracle APEX Developer (with PL/SQL Expertise)

Riyadh, Riyadh 700apps

Posted 15 days ago

Job Viewed

Tap Again To Close

Job Description

Senior Oracle APEX Developer (with PL/SQL Expertise) Senior Oracle APEX Developer (with PL/SQL Expertise)
  • Develop and maintain PL/SQL code for various applications
  • Design and implement Oracle Forms and Reports to meet user requirements
  • Collaborate with business analysts and users to gather requirements and translate them into technical specifications
  • Optimize and tune SQL queries and PL/SQL code for performance
  • Create and manage Oracle APEX applications, ensuring functionality and user experience
  • Conduct unit testing and debugging of applications and databases
  • Maintain documentation of database designs, processes, and procedures
  • Provide support for database-related issues and assist in troubleshooting

  • Develop and maintain PL/SQL code for various applications
  • Design and implement Oracle Forms and Reports to meet user requirements
  • Collaborate with business analysts and users to gather requirements and translate them into technical specifications
  • Optimize and tune SQL queries and PL/SQL code for performance
  • Create and manage Oracle APEX applications, ensuring functionality and user experience
  • Conduct unit testing and debugging of applications and databases
  • Maintain documentation of database designs, processes, and procedures
  • Provide support for database-related issues and assist in troubleshooting

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field
  • Minimum of 5 years of experience in PL/SQL programming, 5 years of experience with Oracle Forms and Reports, and at least 2 years of experience in Oracle APEX development
  • Strong proficiency in Oracle Database and PL/SQL
  • Experience with Oracle Forms and Reports development
  • Familiarity with Oracle APEX for application development
  • Knowledge of performance tuning and optimization techniques
  • Understanding of database design and architecture principles
  • Oracle Certified Professional (OCP) certification
  • Experience with additional programming languages or technologies related to database management
Seniority level
  • Seniority level Mid-Senior level
Employment type
  • Employment type Full-time
Job function
  • Job function Information Technology
  • Industries IT Services and IT Consulting

Referrals increase your chances of interviewing at 700apps by 2x

Get notified about new Senior Oracle Developer jobs in Riyadh, Riyadh, Saudi Arabia .

Oracle HCM Consultant - E-Business Suite (EBS) Senior Software Developer "Saudi National Only" Senior Software Engineer - packaging - optimize Ubuntu Server Senior Software Engineer - packaging - optimize Ubuntu Server Senior Software Engineer - packaging - optimize Ubuntu Server

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.

Moving Database Files on SQL Server Always On

Riyadh, Riyadh mostafaelmasry

Posted 21 days ago

Job Viewed

Tap Again To Close

Job Description

I think all of us know how to move files for SQL Server databases from disk to another disk but today I will explain how we can do it on SQL Server always on to reduce the downtime and taking new backup to return the database to always-on again. Let us start on the technical steps.

  • Preparations Steps
  • Check the current DB Files locations
  • Check Always on Health Status
  • Disable all backup jobs on Primary and secondary servers
  • Suspend the data movement on Secondary server
  • Remove Database from Primary server
  • Update DB files by new disk location on secondary server
  • Stop SQL Server instance on Secondary server
  • Move (CUT) DB Files from old location to new Location (Past)
  • Start the SQL Server instance again
  • Verify the DB File Location Using T-SQL on the post
  • Join the DB to availability group from Primary server
  • Check SQL Server always on Health Status Using T-SQL on the post
  • Enable the SQL Server Jobs
  • Failover the SQL Server for Primary (X) to Secondary Server (Y) and do the same steps on (X)

Let’s Start The Technical Demo

Preparations Steps
  • Prepare your new disks
  • Make sure the security copied from old disk to new disk
Check the current DB Files locations Check Always on Health Status

SELECT sadc.database_name, ag.name AS ag_name, dhrs.is_local, dhrs.is_primary_replica, dhrs.synchronization_state_desc, dhrs.is_commit_participant, dhrs.synchronization_health_descFROM sys.dm_hadr_database_replica_states AS dhrs INNER JOIN sys.availability_databases_cluster AS sadc ON dhrs.group_id = sadc.group_id AND dhrs.group_database_id = sadc.group_database_id INNER JOIN sys.availability_groups AS ag ON ag.group_id = dhrs.group_id INNER JOIN sys.availability_replicas AS sar ON dhrs.group_id = sar.group_id AND dhrs.replica_id = sar.replica_id;

Now we will do our Activity on the secondary then after it, you can do failover and do the same steps on the primary node that it will be secondary node after failover

Disable all backup jobs on Primary and secondary servers

You should stop the backup to avoid any new log backup can be taken during this activity otherwise you will need to do restore for logs backup on secondary server to be able to join the Db again to availability IF you are taking backup using SQL Server native mode use below script and if you are using any third-party tool disable the SQL account of this tool in all nodes.

USE MSDB;GOUPDATE MSDB.dbo.sysjobsSET Enabled = 0WHERE Enabled = 1and name = 'backup Job Name'GO

Suspend the data movement on Secondary server

USE MASTERGOALTER DATABASE (DEMO_MOVE_DB) SET HADR SUSPENDGOALTER DATABASE (DEMO_MOVE_DB) SET HADR OFF;

Remove Database from Primary server

USE MASTERGOALTER AVAILABILITY GROUP (DEMO_HAG) REMOVE DATABASE (DEMO_MOVE_DB);

Update DB files by new disk location on secondary server

USE MASTERGOALTER DATABASE DEMO_MOVE_DB MODIFY FILE (NAME = DEMO_MOVE_DBlog, FILENAME = 'F:logdbfilesDEMO_MOVE_DB.ldf');

LAST STEPS
  • Stop SQL Server instance on Secondary server
  • Move (CUT) DB Files from old location to new Location (Past)
  • Start the SQL Server instance again
  • Verify the DB File Location Using T-SQL on the post
  • Join the DB to availability group from Primary server
  • Check SQL Server always on Health Status Using T-SQL on the post
  • Enable the SQL Server Jobs
  • Failover the SQL Server for Primary (X) to Secondary Server (Y) and do the same steps on (X)

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page View all posts by Mustafa EL-Masry

One thought on “ Moving Database Files on SQL Server Always On ” #J-18808-Ljbffr
This advertiser has chosen not to accept applicants from your region.
 

Nearby Locations

Other Jobs Near Me

Industry

  1. request_quote Accounting
  2. work Administrative
  3. eco Agriculture Forestry
  4. smart_toy AI & Emerging Technologies
  5. school Apprenticeships & Trainee
  6. apartment Architecture
  7. palette Arts & Entertainment
  8. directions_car Automotive
  9. flight_takeoff Aviation
  10. account_balance Banking & Finance
  11. local_florist Beauty & Wellness
  12. restaurant Catering
  13. volunteer_activism Charity & Voluntary
  14. science Chemical Engineering
  15. child_friendly Childcare
  16. foundation Civil Engineering
  17. clean_hands Cleaning & Sanitation
  18. diversity_3 Community & Social Care
  19. construction Construction
  20. brush Creative & Digital
  21. currency_bitcoin Crypto & Blockchain
  22. support_agent Customer Service & Helpdesk
  23. medical_services Dental
  24. medical_services Driving & Transport
  25. medical_services E Commerce & Social Media
  26. school Education & Teaching
  27. electrical_services Electrical Engineering
  28. bolt Energy
  29. local_mall Fmcg
  30. gavel Government & Non Profit
  31. emoji_events Graduate
  32. health_and_safety Healthcare
  33. beach_access Hospitality & Tourism
  34. groups Human Resources
  35. precision_manufacturing Industrial Engineering
  36. security Information Security
  37. handyman Installation & Maintenance
  38. policy Insurance
  39. code IT & Software
  40. gavel Legal
  41. sports_soccer Leisure & Sports
  42. inventory_2 Logistics & Warehousing
  43. supervisor_account Management
  44. supervisor_account Management Consultancy
  45. supervisor_account Manufacturing & Production
  46. campaign Marketing
  47. build Mechanical Engineering
  48. perm_media Media & PR
  49. local_hospital Medical
  50. local_hospital Military & Public Safety
  51. local_hospital Mining
  52. medical_services Nursing
  53. local_gas_station Oil & Gas
  54. biotech Pharmaceutical
  55. checklist_rtl Project Management
  56. shopping_bag Purchasing
  57. home_work Real Estate
  58. person_search Recruitment Consultancy
  59. store Retail
  60. point_of_sale Sales
  61. science Scientific Research & Development
  62. wifi Telecoms
  63. psychology Therapy
  64. pets Veterinary
View All Sql Jobs