الصفحة الرئيسية المملكة المتحدة Database Administrator
الصفحة الرئيسية المملكة المتحدة Database Administrator
Database Administrator
في Pharmacy2U Ltd
في
United Kingdom
نُشرت يوم January 9, 2024
تفاصيل الوظيفة
Role: Database AdministratorLocation: Leeds, LS15 8GB (with hybrid working after completion of training)Salary: £55,000 - £65,000 per annum plus extensive benefitsContract type: PermanentEmployment type: Full time/Part timeWorking hours: 40 hrs pw, Monday to FridayDo you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 20 years’ experience, helping over 750,000 patients in England manage their NHS prescriptions from request through to delivery.This is a challenging and dynamic opportunity in a small and highly focused team, supporting the business to achieve its goals by working alongside cloud engineers, architects, and developers to deliver projects that support the business. In this Database Administrator (DBA) role you will develop and maintain a highly available, secure, and performant data platform.Optimising and monitoring production databases across an estate of physical, cloud and PaaS environments. Working for a market leading organisation as DBA, you will be responsible for the configuration, availability, integrity and security of all databases and data sources. With a natural ability to identify, assess, prioritise, and deliver improvements to the environments you will be responsible for, you will proactively manage technology and processes to deliver high-quality architecture you can be proud of.What’s in it for you?Occupational sick payDiscounted insurance (Aviva)Employee assistance programmeHealth and wellbeing initiativesGreen car schemeRefer a friend bonusCommitment to CPD/trainingDiscounts & Exclusive offers at The Springs, Leeds25% Discount & health & beauty purchasesEnhanced maternity and paternity payEmployee discount siteIn-house mental health supportSocial events throughout the yearRegistration fees paid (GPhC, NMC, CIPD etc)Blue light cardHybrid working25 days annual leave increasing with serviceContributory pensionDiscounted gymsFree onsite parkingCycle to work schemeLong service bonusWhat you’ll be doing?Ensure all database platforms are highly availableEnsure all data sources are secure and access is controlled, reviewed, and auditedSupport BI developers, application experts and middleware developers in their efforts to integrate and report on data in an accurate and reliable mannerWork with third parties for new installations, upgrades, maintenance, testing, troubleshooting and general advice and guidance as required to ensure all delivered services meet requirementsRespond to support escalations from DevOps and technical colleagues, providing specific expertise for troubleshooting as requiredBuild strong relationships in the business to understand business objectives, specific data requirements and how the data you maintain adds value to the businessControlled execution of data management tasksConfigure, maintenance and get maximum value from proactive monitoring using tools such as Redgate and New RelicWho are we looking for?Proficiency in SQL Server 2019 and Azure SQLStrong operations experience in troubleshooting and root cause analysisExperience of performance tuning and optimisingStrong proficiency with Microsoft T-SQLExcellent written and verbal communication skills at all levelsHighly motivated and patient centricProduces accurate work with high attention to detail and experience of working in a regulated industryExperience using native and third-party performance monitoring tools such as Redgate SQL Monitor and New RelicLogical thinkerWhat happens next?Please click apply and if we think you are a good match, we will be in touch to arrange an interview.Applicants must prove they have the right to live in the UK.All successful applicants will be required to undergo a DBS check.Unsolicited agency applications will be treated as a gift.#INDTECH
Apply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.
Notice (8): Use of undefined constant border - assumed 'border' [APP/View/Jobs/externalview.ctp, line 206]Code Context'title'=> empty($job['Company']['hideName']) ? $job['Company']['name'] : 'Confidential Company','alt'=> empty($job['Company']['hideName']) ? $job['Company']['name'] : 'Confidential Company',border=>"0"$viewFile = '/var/www/html/laimoon/View/Jobs/externalview.ctp' $dataForView = array( 'uaPopup' => '', 'Urls' => array( 'providers' => 'https://providers.laimoon.com', 'recruiters' => 'https://partners.laimoon.com', 'canonical' => 'https://jobs.laimoon.com', 'courses' => 'https://courses.laimoon.com', '7days' => 'http://courses.7daysindubai.com', 'careers' => 'http://careers.7daysindubai.com', 'careerguide' => 'https://laimoon.com', 'jobs' => 'https://jobs.laimoon.com', 'cms' => 'http://cms.laimoon.com', 'profiles' => 'https://profiles.laimoon.com' ), 'availLocations' => array( 'uae' => array( 'name' => 'UAE', 'country_id' => '2', 'country_code' => 'ae', 'slug' => 'uae', 'global_location_id' => '225', 'rel_gloc_ids' => '251,250,249,248,247,246,245,244,225', 'currency' => 'AED', 'currency_name' => 'UAE Dirham', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Dubai', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'saudi' => array( 'name' => 'Saudi Arabia', 'country_id' => '183', 'country_code' => 'sa', 'slug' => 'saudi', 'global_location_id' => '187', 'rel_gloc_ids' => '274,273,272,271,269,268,267,266,265,264,263,262,261,260,259,258,257,256,255,254,253,187', 'currency' => 'SAR', 'currency_name' => 'Saudi Riyal', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Riyadh', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'india' => array( 'name' => 'India', 'country_id' => '99', 'country_code' => 'in', 'slug' => 'india', 'global_location_id' => '100', 'rel_gloc_ids' => '100,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,976,994,1263,1264', 'currency' => 'INR', 'currency_name' => 'Indian Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kolkata', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'south-africa' => array( 'name' => 'South Africa', 'country_id' => '236', 'country_code' => 'za', 'slug' => 'south-africa', 'global_location_id' => '197', 'rel_gloc_ids' => '197,498,499,500,501,502,503,504', 'currency' => 'ZAR', 'currency_name' => 'South African Rand', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Johannesburg', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'egypt' => array( 'name' => 'Egypt', 'country_id' => '61', 'country_code' => 'eg', 'slug' => 'egypt', 'global_location_id' => '64', 'rel_gloc_ids' => '64,955,957,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115', 'currency' => 'EGP', 'currency_name' => 'Egyptian pound', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Africa/Cairo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'singapore' => array( 'name' => 'Singapore', 'country_id' => '188', 'country_code' => 'sg', 'slug' => 'singapore', 'global_location_id' => '192', 'rel_gloc_ids' => '192,382,432,438,445,453', 'currency' => 'SGD', 'currency_name' => 'Singapore Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Singapore', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'qatar' => array( 'name' => 'Qatar', 'country_id' => '178', 'country_code' => 'qa', 'slug' => 'qatar', 'global_location_id' => '176', 'rel_gloc_ids' => '176,252', 'currency' => 'QAR', 'currency_name' => 'Qatar Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Qatar', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'pakistan' => array( 'name' => 'Pakistan', 'country_id' => '169', 'country_code' => 'pk', 'slug' => 'pakistan', 'global_location_id' => '164', 'rel_gloc_ids' => '164,979,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071', 'currency' => 'PKR', 'currency_name' => 'Pakistani rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Karachi', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'kuwait' => array( 'name' => 'Kuwait', 'country_id' => '116', 'country_code' => 'kw', 'slug' => 'kuwait', 'global_location_id' => '116', 'rel_gloc_ids' => '116,276,277,278,279,280,281', 'currency' => 'KWD', 'currency_name' => 'Kuwait Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuwait', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'oman' => array( 'name' => 'Oman', 'country_id' => '163', 'country_code' => 'om', 'slug' => 'oman', 'global_location_id' => '163', 'rel_gloc_ids' => '163,282,283,284,285,286,287,288,289,290,291', 'currency' => 'OMR', 'currency_name' => 'Oman Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Muscat', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'jordan' => array( 'name' => 'Jordan', 'country_id' => '106', 'country_code' => 'jo', 'slug' => 'jordan', 'global_location_id' => '110', 'rel_gloc_ids' => '110,958,959,1101,1247,1246,1245,1244,1243,1242,1241,1240,1239', 'currency' => 'JOD', 'currency_name' => 'Jordanian Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Amman', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'philippines' => array( 'name' => 'Philippines', 'country_id' => '168', 'country_code' => 'ph', 'slug' => 'philippines', 'global_location_id' => '171', 'rel_gloc_ids' => '171,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,1262', 'currency' => 'PHP', 'currency_name' => 'Philippine Peso', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Manila', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'bahrain' => array( 'name' => 'Bahrain', 'country_id' => '23', 'country_code' => 'bh', 'slug' => 'bahrain', 'global_location_id' => '17', 'rel_gloc_ids' => '17,292,293,294,295,314,297,298,299,300,301,302,303,304,1276,1277', 'currency' => 'BHD', 'currency_name' => 'Bahrain Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bahrain', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'sri-lanka' => array( 'name' => 'Sri Lanka', 'country_id' => '123', 'country_code' => 'lk', 'slug' => 'sri-lanka', 'global_location_id' => '200', 'rel_gloc_ids' => '200,1047,1048,1049,1084,1085,1086', 'currency' => 'LKR', 'currency_name' => 'Sri Lankan rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Colombo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'united-kingdom' => array( 'name' => 'United Kingdom', 'country_id' => '74', 'country_code' => 'gb', 'slug' => 'united-kingdom', 'global_location_id' => '226', 'rel_gloc_ids' => '226,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1050,1259,1260,1261,1267', 'currency' => 'GBP', 'currency_name' => 'British Pound', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/London', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'malaysia' => array( 'name' => 'Malaysia', 'country_id' => '149', 'country_code' => 'my', 'slug' => 'malaysia', 'global_location_id' => '131', 'rel_gloc_ids' => '131,131,980,1051', 'currency' => 'MYR', 'currency_name' => 'Ringgit', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuala_Lumpur', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nepal' => array( 'name' => 'Nepal', 'country_id' => '159', 'country_code' => 'np', 'slug' => 'nepal', 'global_location_id' => '151', 'rel_gloc_ids' => '151,981,1096,1097,1098', 'currency' => 'NPR', 'currency_name' => 'Nepalese Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kathmandu', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nigeria' => array( 'name' => 'Nigeria', 'country_id' => '155', 'country_code' => 'ng', 'slug' => 'nigeria', 'global_location_id' => '158', 'rel_gloc_ids' => '158,995,996,997,1095', 'currency' => 'NGN', 'currency_name' => 'Nigerian Naira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Lagos ', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'newzealand' => array( 'name' => 'New Zealand', 'country_id' => '162', 'country_code' => 'nz', 'slug' => 'newzealand', 'global_location_id' => '155', 'rel_gloc_ids' => '155,998,999,1080,1081,1082,1083', 'currency' => 'NZD', 'currency_name' => 'New Zealand Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Pacific/Auckland', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'brasil' => array( 'name' => 'Brasil', 'country_id' => '29', 'country_code' => 'br', 'slug' => 'brasil', 'global_location_id' => '30', 'rel_gloc_ids' => '30,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013', 'currency' => 'BRL', 'currency_name' => 'Brazilian Real', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'America/Sao_Paulo', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'portugal' => array( 'name' => 'Portugal', 'country_id' => '175', 'country_code' => 'pt', 'slug' => 'portugal', 'global_location_id' => '174', 'rel_gloc_ids' => '174,1014,1015,1087,1088,1089,1090', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Europe/Lisbon', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'canada' => array( 'name' => 'Canada', 'country_id' => '36', 'country_code' => 'ca', 'slug' => 'canada', 'global_location_id' => '38', 'rel_gloc_ids' => '38,1019,1020,1021,1022,1023,1024,1025', 'currency' => 'CAD', 'currency_name' => 'Canadian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Canada/Saskatchewan', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'united-states' => array( 'name' => 'United States', 'country_id' => '221', 'country_code' => 'us', 'slug' => 'united-states', 'global_location_id' => '227', 'rel_gloc_ids' => '227,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'America/New_York', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'angola' => array( 'name' => 'Angola', 'country_id' => '9', 'country_code' => 'ao', 'slug' => 'angola', 'global_location_id' => '6', 'rel_gloc_ids' => '6,1016,1091,1092,1093,1094', 'currency' => 'AOA', 'currency_name' => 'Angolan Kwanza', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Africa/Luanda', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'australia' => array( 'name' => 'Australia', 'country_id' => '14', 'country_code' => 'au', 'slug' => 'australia', 'global_location_id' => '13', 'rel_gloc_ids' => '13,1026,1027,1028,1029,1030', 'currency' => 'AUD', 'currency_name' => 'Australian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Australia/Melbourne', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'kenya' => array( 'name' => 'Kenya', 'country_id' => '108', 'country_code' => 'ke', 'slug' => 'kenya', 'global_location_id' => '112', 'rel_gloc_ids' => '112,1031,1032,1075,1076,1077,1078,1079', 'currency' => 'KES', 'currency_name' => 'Kenyan Shilling', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Nairobi', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ghana' => array( 'name' => 'Ghana', 'country_id' => '78', 'country_code' => 'gh', 'slug' => 'ghana', 'global_location_id' => '83', 'rel_gloc_ids' => '83,1033,1034,1072,1073,1074', 'currency' => 'GHS', 'currency_name' => 'Ghanaian Cedi', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Accra', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ireland' => array( 'name' => 'Ireland', 'country_id' => '98', 'country_code' => 'ie', 'slug' => 'ireland', 'global_location_id' => '104', 'rel_gloc_ids' => '104,104,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Dublin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'vietnam' => array( 'name' => 'Vietnam', 'country_id' => '229', 'country_code' => 'vn', 'slug' => 'vietnam', 'global_location_id' => '234', 'rel_gloc_ids' => '234,1170,1171', 'currency' => 'VND', 'currency_name' => 'Vietnamese Dong', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Ho_Chi_Minh', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'cyprus' => array( 'name' => 'Cyprus', 'country_id' => '51', 'country_code' => 'cy', 'slug' => 'cyprus', 'global_location_id' => '55', 'rel_gloc_ids' => '55,1230,1231,1232,1233', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Nicosia', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'malta' => array( 'name' => 'Malta', 'country_id' => '144', 'country_code' => 'mt', 'slug' => 'malta', 'global_location_id' => '134', 'rel_gloc_ids' => '134,1255,1254,1253,1252,1251,1250,1249,1248', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Malta', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'maldives' => array( 'name' => 'Maldives', 'country_id' => '146', 'country_code' => 'mv', 'slug' => 'maldives', 'global_location_id' => '132', 'rel_gloc_ids' => '132,1172', 'currency' => 'MVR', 'currency_name' => 'Maldivian rufiyaa', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Indian/Maldives', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'turkey' => array( 'name' => 'Turkey', 'country_id' => '213', 'country_code' => 'tr', 'slug' => 'turkey', 'global_location_id' => '219', 'rel_gloc_ids' => '219,1173,1174,1175,1176', 'currency' => 'TRY', 'currency_name' => 'Turkish lira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Istanbul', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'thailand' => array( 'name' => 'Thailand', 'country_id' => '206', 'country_code' => 'th', 'slug' => 'thailand', 'global_location_id' => '213', 'rel_gloc_ids' => '213,1177', 'currency' => 'THB', 'currency_name' => 'Baht', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bangkok', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'hong-kong' => array( 'name' => 'Hong Kong', 'country_id' => '91', 'country_code' => 'hk', 'slug' => 'hong-kong', 'global_location_id' => '97', 'rel_gloc_ids' => '97', 'currency' => 'HKD', 'currency_name' => 'Hong Kong dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Hong_Kong', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'germany' => array( 'name' => 'Germany', 'country_id' => '53', 'country_code' => 'de', 'slug' => 'germany', 'global_location_id' => '82', 'rel_gloc_ids' => '82,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Berlin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'netherlands' => array( 'name' => 'Netherlands', 'country_id' => '157', 'country_code' => 'nl', 'slug' => 'netherlands', 'global_location_id' => '152', 'rel_gloc_ids' => '152,1188,1189,1190,1191,1192,1193', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Amsterdam', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'japan' => array( 'name' => 'Japan', 'country_id' => '107', 'country_code' => 'jp', 'slug' => 'japan', 'global_location_id' => '108', 'rel_gloc_ids' => '108,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337', 'currency' => 'YEN', 'currency_name' => 'Japanese yen', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Search Results Web results Asia/Tokyo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'global' => array( 'name' => 'Global', 'country_id' => (int) 251, 'country_code' => 'on', 'slug' => 'global', 'global_location_id' => '275', 'rel_gloc_ids' => '275', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => null, 'job_location' => '0', 'published' => '1', 'show' => '1' ) ), 'currentLocation' => array( 'name' => 'United Kingdom', 'country_id' => '74', 'country_code' => 'gb', 'slug' => 'united-kingdom', 'global_location_id' => '226', 'rel_gloc_ids' => '226,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1050,1259,1260,1261,1267', 'currency' => 'GBP', 'currency_name' => 'British Pound', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/London', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'cityLists' => array( (int) 0 => array( 'name' => 'Dubai', 'slug' => 'dubai' ), (int) 1 => array( 'name' => 'Abu Dhabi', 'slug' => 'abu-dhabi' ), (int) 2 => array( 'name' => 'Ras al Khaimah', 'slug' => 'ras-al-khaimah' ), (int) 3 => array( 'name' => 'Al Ain', 'slug' => 'al-ain' ), (int) 4 => array( 'name' => 'Sharjah', 'slug' => 'sharjah' ), (int) 5 => array( 'name' => 'Fujairah', 'slug' => 'fujairah' ), (int) 6 => array( 'name' => 'Ajman', 'slug' => 'ajman' ), (int) 7 => array( 'name' => 'Umm Al Quwain', 'slug' => 'umm-al-quwain' ) ), 'menuState' => 'loggedoutmenu', 'showCVReviewLink' => true, 'profileInfo' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '10756', 'contributedJobCount' => '24', 'courseCount' => null ), 'environment' => 'production', 'langUrlPrefix' => 'ar/', 'langUrl' => 'https://jobs.laimoon.com/ar/', 'themeUrl' => 'https://jobs.laimoon.com/', 'siteUrl' => 'https://jobs.laimoon.com/', 'staticUrl' => 'https://cdn.laimoon.com/jobs/', 'langCode' => 'ar', 'pageScripts' => array( (int) 0 => 'page_script' ), 'pageName' => 'externalview', 'courseUrl' => 'https://courses.laimoon.com/ar/', 'onlineCourses' => array( (int) 0 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ), (int) 1 => array( 'Course' => array( [maximum depth reached] ), 'CourseProvider' => array( [maximum depth reached] ), 'CourseTranslation' => array( [maximum depth reached] ), 'Profile' => array([maximum depth reached]) ) ), 'job' => array( 'Job' => array( 'id' => '39308583', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'Database Administrator', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<p>Role: Database AdministratorLocation: Leeds, LS15 8GB (with hybrid working after completion of training)Salary: £55,000 - £65,000 per annum plus extensive benefitsContract type: PermanentEmployment type: Full time/Part timeWorking hours: 40 hrs pw, Monday to FridayDo you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 20 years’ experience, helping over 750,000 patients in England manage their NHS prescriptions from request through to delivery.This is a challenging and dynamic opportunity in a small and highly focused team, supporting the business to achieve its goals by working alongside cloud engineers, architects, and developers to deliver projects that support the business. In this Database Administrator (DBA) role you will develop and maintain a highly available, secure, and performant data platform.Optimising and monitoring production databases across an estate of physical, cloud and PaaS environments. Working for a market leading organisation as DBA, you will be responsible for the configuration, availability, integrity and security of all databases and data sources. With a natural ability to identify, assess, prioritise, and deliver improvements to the environments you will be responsible for, you will proactively manage technology and processes to deliver high-quality architecture you can be proud of.What’s in it for you?Occupational sick payDiscounted insurance (Aviva)Employee assistance programmeHealth and wellbeing initiativesGreen car schemeRefer a friend bonusCommitment to CPD/trainingDiscounts & Exclusive offers at The Springs, Leeds25% Discount & health & beauty purchasesEnhanced maternity and paternity payEmployee discount siteIn-house mental health supportSocial events throughout the yearRegistration fees paid (GPhC, NMC, CIPD etc)Blue light cardHybrid working25 days annual leave increasing with serviceContributory pensionDiscounted gymsFree onsite parkingCycle to work schemeLong service bonusWhat you’ll be doing?Ensure all database platforms are highly availableEnsure all data sources are secure and access is controlled, reviewed, and auditedSupport BI developers, application experts and middleware developers in their efforts to integrate and report on data in an accurate and reliable mannerWork with third parties for new installations, upgrades, maintenance, testing, troubleshooting and general advice and guidance as required to ensure all delivered services meet requirementsRespond to support escalations from DevOps and technical colleagues, providing specific expertise for troubleshooting as requiredBuild strong relationships in the business to understand business objectives, specific data requirements and how the data you maintain adds value to the businessControlled execution of data management tasksConfigure, maintenance and get maximum value from proactive monitoring using tools such as Redgate and New RelicWho are we looking for?Proficiency in SQL Server 2019 and Azure SQLStrong operations experience in troubleshooting and root cause analysisExperience of performance tuning and optimisingStrong proficiency with Microsoft T-SQLExcellent written and verbal communication skills at all levelsHighly motivated and patient centricProduces accurate work with high attention to detail and experience of working in a regulated industryExperience using native and third-party performance monitoring tools such as Redgate SQL Monitor and New RelicLogical thinkerWhat happens next?Please click apply and if we think you are a good match, we will be in touch to arrange an interview.Applicants must prove they have the right to live in the UK.All successful applicants will be required to undergo a DBS check.Unsolicited agency applications will be treated as a gift.#INDTECH </p>', 'course_qualifications' => null, 'global_location_id' => '226', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => '', 'salaryFrom' => null, 'salaryTo' => null, 'currency_id' => null, 'hide_salary' => '0', 'benefits' => null, 'salary_type_id' => null, 'travel_type_id' => null, 'travel_id' => null, 'education_id' => null, 'education_background' => null, 'language_id' => null, 'position_level_id' => null, 'position_type' => null, 'number_of_staffs_mange' => null, 'experiance' => null, 'sales_experience' => null, 'sales_focus' => null, 'sales_cycle_id' => null, 'reporting_to' => null, 'otherAssignments' => null, 'otherConsiderations' => null, 'ideal_candidate' => null, 'company_info' => null, 'company_id' => '219258', 'company_name' => 'Pharmacy2U Ltd', 'external_apply_url' => 'https://uk.jooble.org/external/237772428927681566?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_uk&extra_ars_request_id=f37fb1b2b86c8202e78dda5be6eb6d07', 'external_short_url' => '', 'apply_url' => null, 'contributed' => '0', 'created' => null, 'published' => '2024-01-09 07:18:23', 'closed_time' => null, 'updated' => null, 'hideCompany' => null, 'hide_contact_info' => '0', 'application_count' => '0', 'closed' => '0', 'draft' => '0', 'rejected' => '0', 'deleted' => '0', 'moderated' => '1', 'boosted' => '0', 'rejectnote' => null, 'job_extended' => '0', 'purchased' => '0', 'seeder_id' => '8', 'source_id' => 'jooble', 'course_keywords' => null, 'shortlist_magic_applied' => '0', 'shortlist_magic_keywords' => null, 'living_in' => '0', 'age_limit' => null, 'is_managerial' => '0', 'application_email' => null, 'quality_score' => null, 'reopened' => '0', 'quality_type' => 'White', 'promoted' => '0' ), 'Recruiter' => array( 'first_name' => 'Jooble Jobs', 'last_name' => null, 'recruiter_type' => 'company' ), 'GlobalLocation' => array( 'id' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( [maximum depth reached] ) ), 'Company' => array( 'id' => '219258', 'name' => 'Pharmacy2U Ltd', 'website' => null, 'verified' => '0', 'photo' => 'Pharmacy2U_Ltd_aaeda440-d6bb-11e9-8563-8d2b2f614077.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ), 'jobsList' => array(), 'courses' => array(), 'promotedCourses' => array(), 'referer' => '/', 'urlKeyword' => 'Database ', 'profile' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '10756', 'contributedJobCount' => '24', 'courseCount' => null ), 'askLogin' => true, 'jobLinkTitle' => 'Database ', 'renderSchema' => 'yes', 'title_for_layout' => 'Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.', 'page_description' => 'Apply to Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.Find similar vacancies, jobs and salary information in United Kingdom.', 'locationForTitle' => 'United Kingdom', 'currentJobCity' => array( 'id' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( 'name' => 'United Kingdom', 'id' => '74', 'slug' => 'united-kingdom', 'code' => 'GB' ) ), 'jobCompanyPage' => array( 'CompanyPage' => array( 'id' => '12943', 'title' => 'Pharmacy2U Ltd', 'slug' => 'pharmacy2u-ltd' ), 'CompanyPageTranslation' => array( 'id' => null, 'company_page_id' => null, 'title' => null, 'slug' => null, 'summary' => null, 'description' => null, 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'company_matching_keywords' => null, 'draft' => null, 'lang_code' => null ) ), 'location' => 'United Kingdom', 'breadCrumbs' => array( 'Job Details' => '' ), 'relCourseBanner' => array( 'relatedUrl' => 'https://courses.laimoon.com/ar/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'مايكروسوفت إس كيو إل سيرفر', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/ar/online/it-computing-and-technology/database-management/sql-server' ), 'published' => '2024-01-09 07:18:23', 'daysleft' => (float) -78, 'isLoggedIn' => false, 'facebookSession' => null, 'fbConfig' => array( 'AppId' => '151651858238476', 'APIKey' => '1c032aa6c89b302e8ec5dea94dc89104', 'AppSecret' => 'f2b69d3a25fe65601f146efe7178e72a' ), 'linkedInConfig' => array( 'APIKey' => '779yus3aqi524z', 'AppSecret' => 'XCdGJxUokce5Ygf6' ), 'criticalCSSes' => array( 'jobdetail' => 'jobdetail-critical-css', 'companylist' => 'companylist-critical-css', 'companyview' => 'companyview-critical-css', 'agencylist' => 'agencylist-critical-css', 'agencyview' => 'agencyview-critical-css', 'laimoonverified' => 'laimoonverified-critical-css', 'seopages' => 'seopages-critical-css', 'externalview' => 'externalview-critical-css', 'popularjobsearches' => 'popularjobsearches-critical-css' ), 'basicProfileIncomplete' => true ) $uaPopup = '' $Urls = array( 'providers' => 'https://providers.laimoon.com', 'recruiters' => 'https://partners.laimoon.com', 'canonical' => 'https://jobs.laimoon.com', 'courses' => 'https://courses.laimoon.com', '7days' => 'http://courses.7daysindubai.com', 'careers' => 'http://careers.7daysindubai.com', 'careerguide' => 'https://laimoon.com', 'jobs' => 'https://jobs.laimoon.com', 'cms' => 'http://cms.laimoon.com', 'profiles' => 'https://profiles.laimoon.com' ) $availLocations = array( 'uae' => array( 'name' => 'UAE', 'country_id' => '2', 'country_code' => 'ae', 'slug' => 'uae', 'global_location_id' => '225', 'rel_gloc_ids' => '251,250,249,248,247,246,245,244,225', 'currency' => 'AED', 'currency_name' => 'UAE Dirham', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Dubai', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'saudi' => array( 'name' => 'Saudi Arabia', 'country_id' => '183', 'country_code' => 'sa', 'slug' => 'saudi', 'global_location_id' => '187', 'rel_gloc_ids' => '274,273,272,271,269,268,267,266,265,264,263,262,261,260,259,258,257,256,255,254,253,187', 'currency' => 'SAR', 'currency_name' => 'Saudi Riyal', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Riyadh', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'india' => array( 'name' => 'India', 'country_id' => '99', 'country_code' => 'in', 'slug' => 'india', 'global_location_id' => '100', 'rel_gloc_ids' => '100,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,976,994,1263,1264', 'currency' => 'INR', 'currency_name' => 'Indian Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kolkata', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'south-africa' => array( 'name' => 'South Africa', 'country_id' => '236', 'country_code' => 'za', 'slug' => 'south-africa', 'global_location_id' => '197', 'rel_gloc_ids' => '197,498,499,500,501,502,503,504', 'currency' => 'ZAR', 'currency_name' => 'South African Rand', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Johannesburg', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'egypt' => array( 'name' => 'Egypt', 'country_id' => '61', 'country_code' => 'eg', 'slug' => 'egypt', 'global_location_id' => '64', 'rel_gloc_ids' => '64,955,957,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115', 'currency' => 'EGP', 'currency_name' => 'Egyptian pound', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Africa/Cairo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'singapore' => array( 'name' => 'Singapore', 'country_id' => '188', 'country_code' => 'sg', 'slug' => 'singapore', 'global_location_id' => '192', 'rel_gloc_ids' => '192,382,432,438,445,453', 'currency' => 'SGD', 'currency_name' => 'Singapore Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Singapore', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'qatar' => array( 'name' => 'Qatar', 'country_id' => '178', 'country_code' => 'qa', 'slug' => 'qatar', 'global_location_id' => '176', 'rel_gloc_ids' => '176,252', 'currency' => 'QAR', 'currency_name' => 'Qatar Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Qatar', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'pakistan' => array( 'name' => 'Pakistan', 'country_id' => '169', 'country_code' => 'pk', 'slug' => 'pakistan', 'global_location_id' => '164', 'rel_gloc_ids' => '164,979,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071', 'currency' => 'PKR', 'currency_name' => 'Pakistani rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Karachi', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'kuwait' => array( 'name' => 'Kuwait', 'country_id' => '116', 'country_code' => 'kw', 'slug' => 'kuwait', 'global_location_id' => '116', 'rel_gloc_ids' => '116,276,277,278,279,280,281', 'currency' => 'KWD', 'currency_name' => 'Kuwait Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuwait', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'oman' => array( 'name' => 'Oman', 'country_id' => '163', 'country_code' => 'om', 'slug' => 'oman', 'global_location_id' => '163', 'rel_gloc_ids' => '163,282,283,284,285,286,287,288,289,290,291', 'currency' => 'OMR', 'currency_name' => 'Oman Rial', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Muscat', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'jordan' => array( 'name' => 'Jordan', 'country_id' => '106', 'country_code' => 'jo', 'slug' => 'jordan', 'global_location_id' => '110', 'rel_gloc_ids' => '110,958,959,1101,1247,1246,1245,1244,1243,1242,1241,1240,1239', 'currency' => 'JOD', 'currency_name' => 'Jordanian Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Amman', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'philippines' => array( 'name' => 'Philippines', 'country_id' => '168', 'country_code' => 'ph', 'slug' => 'philippines', 'global_location_id' => '171', 'rel_gloc_ids' => '171,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,1262', 'currency' => 'PHP', 'currency_name' => 'Philippine Peso', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Manila', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'bahrain' => array( 'name' => 'Bahrain', 'country_id' => '23', 'country_code' => 'bh', 'slug' => 'bahrain', 'global_location_id' => '17', 'rel_gloc_ids' => '17,292,293,294,295,314,297,298,299,300,301,302,303,304,1276,1277', 'currency' => 'BHD', 'currency_name' => 'Bahrain Dinar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bahrain', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'sri-lanka' => array( 'name' => 'Sri Lanka', 'country_id' => '123', 'country_code' => 'lk', 'slug' => 'sri-lanka', 'global_location_id' => '200', 'rel_gloc_ids' => '200,1047,1048,1049,1084,1085,1086', 'currency' => 'LKR', 'currency_name' => 'Sri Lankan rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Colombo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'united-kingdom' => array( 'name' => 'United Kingdom', 'country_id' => '74', 'country_code' => 'gb', 'slug' => 'united-kingdom', 'global_location_id' => '226', 'rel_gloc_ids' => '226,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1050,1259,1260,1261,1267', 'currency' => 'GBP', 'currency_name' => 'British Pound', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/London', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'malaysia' => array( 'name' => 'Malaysia', 'country_id' => '149', 'country_code' => 'my', 'slug' => 'malaysia', 'global_location_id' => '131', 'rel_gloc_ids' => '131,131,980,1051', 'currency' => 'MYR', 'currency_name' => 'Ringgit', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kuala_Lumpur', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nepal' => array( 'name' => 'Nepal', 'country_id' => '159', 'country_code' => 'np', 'slug' => 'nepal', 'global_location_id' => '151', 'rel_gloc_ids' => '151,981,1096,1097,1098', 'currency' => 'NPR', 'currency_name' => 'Nepalese Rupee', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Kathmandu', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'nigeria' => array( 'name' => 'Nigeria', 'country_id' => '155', 'country_code' => 'ng', 'slug' => 'nigeria', 'global_location_id' => '158', 'rel_gloc_ids' => '158,995,996,997,1095', 'currency' => 'NGN', 'currency_name' => 'Nigerian Naira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Lagos ', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'newzealand' => array( 'name' => 'New Zealand', 'country_id' => '162', 'country_code' => 'nz', 'slug' => 'newzealand', 'global_location_id' => '155', 'rel_gloc_ids' => '155,998,999,1080,1081,1082,1083', 'currency' => 'NZD', 'currency_name' => 'New Zealand Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Pacific/Auckland', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'brasil' => array( 'name' => 'Brasil', 'country_id' => '29', 'country_code' => 'br', 'slug' => 'brasil', 'global_location_id' => '30', 'rel_gloc_ids' => '30,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013', 'currency' => 'BRL', 'currency_name' => 'Brazilian Real', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'America/Sao_Paulo', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'portugal' => array( 'name' => 'Portugal', 'country_id' => '175', 'country_code' => 'pt', 'slug' => 'portugal', 'global_location_id' => '174', 'rel_gloc_ids' => '174,1014,1015,1087,1088,1089,1090', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Europe/Lisbon', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'canada' => array( 'name' => 'Canada', 'country_id' => '36', 'country_code' => 'ca', 'slug' => 'canada', 'global_location_id' => '38', 'rel_gloc_ids' => '38,1019,1020,1021,1022,1023,1024,1025', 'currency' => 'CAD', 'currency_name' => 'Canadian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Canada/Saskatchewan', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'united-states' => array( 'name' => 'United States', 'country_id' => '221', 'country_code' => 'us', 'slug' => 'united-states', 'global_location_id' => '227', 'rel_gloc_ids' => '227,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'America/New_York', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'angola' => array( 'name' => 'Angola', 'country_id' => '9', 'country_code' => 'ao', 'slug' => 'angola', 'global_location_id' => '6', 'rel_gloc_ids' => '6,1016,1091,1092,1093,1094', 'currency' => 'AOA', 'currency_name' => 'Angolan Kwanza', 'languages' => 'pt', 'default_language' => 'pt', 'country_time_zone' => 'Africa/Luanda', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'australia' => array( 'name' => 'Australia', 'country_id' => '14', 'country_code' => 'au', 'slug' => 'australia', 'global_location_id' => '13', 'rel_gloc_ids' => '13,1026,1027,1028,1029,1030', 'currency' => 'AUD', 'currency_name' => 'Australian Dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Australia/Melbourne', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'kenya' => array( 'name' => 'Kenya', 'country_id' => '108', 'country_code' => 'ke', 'slug' => 'kenya', 'global_location_id' => '112', 'rel_gloc_ids' => '112,1031,1032,1075,1076,1077,1078,1079', 'currency' => 'KES', 'currency_name' => 'Kenyan Shilling', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Nairobi', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ghana' => array( 'name' => 'Ghana', 'country_id' => '78', 'country_code' => 'gh', 'slug' => 'ghana', 'global_location_id' => '83', 'rel_gloc_ids' => '83,1033,1034,1072,1073,1074', 'currency' => 'GHS', 'currency_name' => 'Ghanaian Cedi', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Africa/Accra', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'ireland' => array( 'name' => 'Ireland', 'country_id' => '98', 'country_code' => 'ie', 'slug' => 'ireland', 'global_location_id' => '104', 'rel_gloc_ids' => '104,104,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Dublin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'vietnam' => array( 'name' => 'Vietnam', 'country_id' => '229', 'country_code' => 'vn', 'slug' => 'vietnam', 'global_location_id' => '234', 'rel_gloc_ids' => '234,1170,1171', 'currency' => 'VND', 'currency_name' => 'Vietnamese Dong', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Ho_Chi_Minh', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'cyprus' => array( 'name' => 'Cyprus', 'country_id' => '51', 'country_code' => 'cy', 'slug' => 'cyprus', 'global_location_id' => '55', 'rel_gloc_ids' => '55,1230,1231,1232,1233', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Nicosia', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'malta' => array( 'name' => 'Malta', 'country_id' => '144', 'country_code' => 'mt', 'slug' => 'malta', 'global_location_id' => '134', 'rel_gloc_ids' => '134,1255,1254,1253,1252,1251,1250,1249,1248', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Malta', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'maldives' => array( 'name' => 'Maldives', 'country_id' => '146', 'country_code' => 'mv', 'slug' => 'maldives', 'global_location_id' => '132', 'rel_gloc_ids' => '132,1172', 'currency' => 'MVR', 'currency_name' => 'Maldivian rufiyaa', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Indian/Maldives', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'turkey' => array( 'name' => 'Turkey', 'country_id' => '213', 'country_code' => 'tr', 'slug' => 'turkey', 'global_location_id' => '219', 'rel_gloc_ids' => '219,1173,1174,1175,1176', 'currency' => 'TRY', 'currency_name' => 'Turkish lira', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Istanbul', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'thailand' => array( 'name' => 'Thailand', 'country_id' => '206', 'country_code' => 'th', 'slug' => 'thailand', 'global_location_id' => '213', 'rel_gloc_ids' => '213,1177', 'currency' => 'THB', 'currency_name' => 'Baht', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Bangkok', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'hong-kong' => array( 'name' => 'Hong Kong', 'country_id' => '91', 'country_code' => 'hk', 'slug' => 'hong-kong', 'global_location_id' => '97', 'rel_gloc_ids' => '97', 'currency' => 'HKD', 'currency_name' => 'Hong Kong dollar', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Asia/Hong_Kong', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'germany' => array( 'name' => 'Germany', 'country_id' => '53', 'country_code' => 'de', 'slug' => 'germany', 'global_location_id' => '82', 'rel_gloc_ids' => '82,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Berlin', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'netherlands' => array( 'name' => 'Netherlands', 'country_id' => '157', 'country_code' => 'nl', 'slug' => 'netherlands', 'global_location_id' => '152', 'rel_gloc_ids' => '152,1188,1189,1190,1191,1192,1193', 'currency' => 'EUR', 'currency_name' => 'Euro', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/Amsterdam', 'job_location' => '0', 'published' => '1', 'show' => '1' ), 'japan' => array( 'name' => 'Japan', 'country_id' => '107', 'country_code' => 'jp', 'slug' => 'japan', 'global_location_id' => '108', 'rel_gloc_ids' => '108,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337', 'currency' => 'YEN', 'currency_name' => 'Japanese yen', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Search Results Web results Asia/Tokyo', 'job_location' => '1', 'published' => '1', 'show' => '1' ), 'global' => array( 'name' => 'Global', 'country_id' => (int) 251, 'country_code' => 'on', 'slug' => 'global', 'global_location_id' => '275', 'rel_gloc_ids' => '275', 'currency' => 'USD', 'currency_name' => 'US Dollar', 'languages' => 'en,ar', 'default_language' => 'en', 'country_time_zone' => null, 'job_location' => '0', 'published' => '1', 'show' => '1' ) ) $currentLocation = array( 'name' => 'United Kingdom', 'country_id' => '74', 'country_code' => 'gb', 'slug' => 'united-kingdom', 'global_location_id' => '226', 'rel_gloc_ids' => '226,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1050,1259,1260,1261,1267', 'currency' => 'GBP', 'currency_name' => 'British Pound', 'languages' => 'en', 'default_language' => 'en', 'country_time_zone' => 'Europe/London', 'job_location' => '1', 'published' => '1', 'show' => '1' ) $cityLists = array( (int) 0 => array( 'name' => 'Dubai', 'slug' => 'dubai' ), (int) 1 => array( 'name' => 'Abu Dhabi', 'slug' => 'abu-dhabi' ), (int) 2 => array( 'name' => 'Ras al Khaimah', 'slug' => 'ras-al-khaimah' ), (int) 3 => array( 'name' => 'Al Ain', 'slug' => 'al-ain' ), (int) 4 => array( 'name' => 'Sharjah', 'slug' => 'sharjah' ), (int) 5 => array( 'name' => 'Fujairah', 'slug' => 'fujairah' ), (int) 6 => array( 'name' => 'Ajman', 'slug' => 'ajman' ), (int) 7 => array( 'name' => 'Umm Al Quwain', 'slug' => 'umm-al-quwain' ) ) $menuState = 'loggedoutmenu' $showCVReviewLink = true $profileInfo = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '10756', 'contributedJobCount' => '24', 'courseCount' => null ) $environment = 'production' $langUrlPrefix = 'ar/' $langUrl = 'https://jobs.laimoon.com/ar/' $themeUrl = 'https://jobs.laimoon.com/' $siteUrl = 'https://jobs.laimoon.com/' $staticUrl = 'https://cdn.laimoon.com/jobs/' $langCode = 'ar' $pageScripts = array( (int) 0 => 'page_script' ) $pageName = 'externalview' $courseUrl = 'https://courses.laimoon.com/ar/' $onlineCourses = array( (int) 0 => array( 'Course' => array( 'id' => '136187', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => '99997993', 'title' => 'SQL Programming Complete Bundle', 'external_link' => 'https://www.apexlearning.org.uk/course/sql-programming-complete-bundle', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 8 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Apex Learning', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '18', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '21', 'nondiscounted_base_price' => '210', 'currency' => 'GBP', 'discount' => '90% Off for Laimoon Users!', 'free_trial_text' => '', 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br> <br> Acquire the language of databases with this SQL Programming Complete Bundle course. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundle course will teach you the language of databases, SQL, and help you gain proficiency in SQL tools.<br> <br> <strong>How will I get my certificate?</strong><br> <br> At the end of the SQL Programming Complete Bundle course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.<br> <br> <strong>Who is this SQL Programming Complete Bundle course for?</strong><br> <br> There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds.<br> <br> <strong>Course Curriculum</strong><br> <br> <strong>Introduction</strong> <ul> <li>Introduction</li> <li>Course Curriculum Overview</li> <li>Overview of Databases</li> </ul> <strong>SQL Environment Setup</strong> <ul> <li>MySQL Installation</li> <li>MySQL Workbench Installation</li> <li>Connecting to MySQL using Console</li> </ul> <strong>SQL Statement Basics</strong> <ul> <li>Overview of Challenges</li> <li>SQL Statement Basic</li> <li>SELECT Statement</li> <li>SELECT DISTINCT</li> <li>Column AS Statement</li> <li>COUNT built-in Method usage</li> <li>SELECT WHERE Clause – Part One</li> <li>SELECT WHERE Clause – Part Two</li> <li>SQL Statement Basic</li> <li>SQL Limit Clause Statement</li> <li>SQL Using BETWEEN with Same Column Data</li> <li>How to Apply IN Operator</li> <li>Wildcard Characters with LIKE and ILIKE</li> </ul> <br> <strong>GROUP BY Statements</strong> <ul> <li>Overview of GROUP BY</li> <li>Aggregation function SUM()</li> <li>Aggregation MIN() and MAX()</li> <li>GROUP BY – One</li> <li>GROUP BY – Two</li> <li>HAVING Clause</li> </ul> <strong>JOINS</strong> <ul> <li>Overview of JOINS</li> <li>Introduction to JOINS</li> <li>AS Statement table</li> <li>INNER Joins</li> <li>FULL Outer Join</li> <li>LEFT Outer JOIN</li> <li>RIGHT JOIN</li> <li>Union</li> </ul> <strong>Advanced SQL Commands / Statements</strong> <ul> <li>Timestamps</li> <li>EXTRACT from timestamp</li> <li>Mathematical Functions</li> <li>String Functions</li> <li>SUBQUERY</li> </ul> <strong>Creating Database and Tables<br> Databases and Tables<br> Assignment</strong><br> <br> <strong>Career path</strong><br> <br> Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.', 'outline' => '', 'who_should_take_this_course' => '', 'eligibility' => 'Our SQL Programming Complete Bundle is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace.', 'about_school' => '', 'keywords' => 'Mysql,PHP,Sqlserver,SQL,Microsoft, SQL Programming Complete Bundle', 'job_matching_keywords' => 'SQL Programming Complete Bundle', 'instructor_bio' => '', 'external_course_info' => null, 'eligibility_criteria' => '', 'career_opportunity' => '', 'targetted_roles' => '', 'targetted_industries' => '', 'targetted_locations' => '', 'gender' => '0', 'targetted_course_categories' => '142,395,396', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '11708', 'trainer_ids' => '', 'created' => '2022-06-20 09:30:19', 'updated' => '2024-01-10 11:05:14', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@apexlearning.org.uk', 'cc_emails' => '', 'phone_number' => '', 'pri_line_number' => '', 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'part-time-sql-programming-complete-bundle-apex-learning', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => '2022-06-22 15:34:00', 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => '0', 'accreditation_logos' => 'IAO,CPD Group', 'invoice_type' => 'CPC', 'payment_mode' => 'paid', 'invoice_value' => '5', 'invoice_click_value' => '0.1', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Part Time', 'study_timings' => '2', 'language_program_covers' => '', 'language_program_level' => '', 'language_program_type' => '', 'language_study_mode' => '', 'badge_url' => null, 'last_revision_status' => 'New', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'Mysql Developer,Senior PL/SQL Developer,SQL Coordinator,Microsoft SQL Server Administrator', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"128172_en_c":350000000,"128170_en_c":350000000,"124982_en_c":350000000,"124984_en_c":350000000,"128171_en_c":350000000,"5153_en_c":350000000,"121813_en_c":350000000,"128027_en_c":350000000,"121812_en_c":350000000,"47622_ar_c":350000000,"65240_ar_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '0', 'course_certificate' => '', 'bundle_id' => null, 'randomizer' => '99534510', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '11708', 'name' => 'Apex Learning', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'apex-learning', 'location' => null, 'customer_name' => 'Cody Mason', 'seeder_id' => '43', 'phone_number' => '020 4532 9785', 'pri_line_number' => '', 'address_street' => '', 'address_building' => '', 'address_city' => '', 'address_country' => 'United Arab Emirates', 'addresss' => 'United Arab Emirates', 'invoice_email' => 'info@apexlearning.org.uk', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '40', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => 'CPC', 'intl_leads_enabled' => '0', 'invoice_notification' => '0', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1624347777-Apex-Learning-Logo.png', 'logo_size' => '{"width":776,"height":457}', 'description' => 'Apex Learning aims to be an online education that provides the necessary support to the learners and facilitates educators' work and contributes to professional development. We offer innovative pedagogical resources and training in a planned, updated, and oriented way.<br /> <br /> At Apex Learning we share the goal of millions of people to make the world better and we are aware that, as a company, our actions have a great influence on society. For this reason, at Apex Learning we actively evolve to bring knowledge to everyone, through technology, based on efficiency, quality, credibility, and innovation.<br /> <br /> Our mission is to offer innovative and quality education through distance education, allowing everyone easy access through technology and the development of a sustainable society.<br /> <br /> Our vision to be an educational portal of reference in distance education, innovative in its proposals and practices and in the formation of critical, conscious, and entrepreneurial learners.', 'website' => 'https://apexlearning.org.uk/', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => null, 'video_embed_code' => '', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@apexlearning.org.uk', 'contact_phone_number' => '+44 020 4532 9785', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => '1', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => 'No', 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier3', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2021-06-22 10:43:03', 'modified' => '2021-07-07 17:06:48', 'pageview_enabled' => '1', 'timezone' => 'Europe/London', 'provider_status' => 'performance', 'cpc_direct_linking' => 'yes', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Converted', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2021-06-22 10:47:47', 'profile_completed_time' => '2021-06-22 11:42:58', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => 'https://providers.laimoon.com/courses?status=all&search=Food+Hygiene+And+Safety+Level+3', 'course_type_ids' => '2', 'trusted' => '0', 'legacy' => '0', 'moderation_status' => 'verified', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '1', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '0', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1624726134_apex-learn.jpg', 'lead_filters' => null, 'repeat_email_lead_alerts' => '1', 'load_blncr_weight' => '1', 'remote_option' => null, 'classroom_status' => 'pending', 'topup_info' => null, 'provider_rank' => '{"default":502,"rndm":800219,"r_81":502,"r_382":502,"r_592":502,"r_79":502,"r_95":502,"r_82":502,"r_394":502,"r_66":502,"r_255":502,"r_419":502,"r_589":502,"r_759":502,"r_10":502,"r_527":502,"r_253":502,"r_867":502,"r_847":502,"r_541":502,"r_439":502,"r_791":502,"r_403":502,"r_204":502,"r_436":502,"r_313":502,"r_432":502,"r_926":502,"r_320":502,"r_408":502,"r_440":502,"r_309":502,"r_9":502,"r_324":502,"r_142":502,"r_653":502,"r_126":502,"r_14":502,"r_646":502,"r_12":502,"r_234":502,"r_231":502,"r_918":502,"r_585":502,"r_656":502,"r_84":502,"r_172":502,"r_265":502,"r_267":502,"r_332":502,"r_314":502,"r_94":502,"r_97":502,"r_317":502,"r_328":502,"r_256":502,"r_190":502,"r_374":502,"r_636":502,"r_762":502,"r_597":502,"r_652":502,"r_954":502,"r_146":502,"r_617":502,"r_523":502,"r_122":502,"r_821":502,"r_404":502,"r_312":502,"r_953":502,"r_266":502,"r_792":502,"r_373":502,"r_412":502,"r_768":502,"r_20":502,"r_163":502,"r_637":502,"r_322":502,"r_528":502,"r_931":502,"r_682":502,"r_690":502,"r_871":502,"r_90":502,"r_248":502,"r_401":502,"r_599":502,"r_511":502,"r_531":502,"r_794":502,"r_17":502,"r_354":502,"r_80":502,"r_114":502,"r_610":502,"r_111":502,"r_346":502,"r_86":502,"r_387":502,"r_69":502,"r_88":502,"r_215":502,"r_89":502,"r_225":502,"r_944":502,"r_941":502,"r_763":502,"r_851":502,"r_87":502,"r_203":502,"r_199":502,"r_315":502,"r_933":502,"r_441":502,"r_113":502,"r_809":502,"r_703":502,"r_852":502,"r_900":502,"r_845":502,"r_658":502,"r_629":502,"r_725":502,"r_840":502,"r_85":502,"r_180":502,"r_181":502,"r_868":502,"r_616":502,"r_383":502,"r_143":502,"r_890":502,"r_691":502,"r_891":502,"r_899":502,"r_666":502,"r_375":502,"r_700":502,"r_790":502,"r_391":502,"r_583":502,"r_141":502,"r_145":502,"r_737":502,"r_188":502,"r_249":502,"r_257":502,"r_614":502,"r_378":502,"r_581":502,"r_241":502,"r_582":502,"r_52":502,"r_242":502,"r_887":502,"r_631":502,"r_323":502,"r_956":502,"r_174":502,"r_807":502,"r_195":502,"r_396":502,"r_395":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '212766', 'course_id' => '136187', 'title' => 'SQL Programming Complete Bundle', 'slug' => 'part-time-sql-programming-complete-bundle-apex-learning', 'external_link' => 'https://www.apexlearning.org.uk/course/sql-programming-complete-bundle', 'summary' => '<strong>Overview</strong><br> <br> Acquire the language of databases with this SQL Programming Complete Bundle course. In this data-driven world, data is used to make strategies, find solutions and do a thousand other tasks. Businesses across the world are using big and related data, which makes a basic knowledge of SQL a remarkable skill not only for data scientists but for everyone. This SQL Programming Complete Bundle course will teach you the language of databases, SQL, and help you gain proficiency in SQL tools.<br> <br> <strong>How will I get my certificate?</strong><br> <br> At the end of the SQL Programming Complete Bundle course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price.<br> <br> <strong>Who is this SQL Programming Complete Bundle course for?</strong><br> <br> There is no experience or previous qualifications required for enrolment on this SQL Programming Complete Bundle. It is available to all students, of all academic backgrounds.<br> <br> <strong>Course Curriculum</strong><br> <br> <strong>Introduction</strong> <ul> <li>Introduction</li> <li>Course Curriculum Overview</li> <li>Overview of Databases</li> </ul> <strong>SQL Environment Setup</strong> <ul> <li>MySQL Installation</li> <li>MySQL Workbench Installation</li> <li>Connecting to MySQL using Console</li> </ul> <strong>SQL Statement Basics</strong> <ul> <li>Overview of Challenges</li> <li>SQL Statement Basic</li> <li>SELECT Statement</li> <li>SELECT DISTINCT</li> <li>Column AS Statement</li> <li>COUNT built-in Method usage</li> <li>SELECT WHERE Clause – Part One</li> <li>SELECT WHERE Clause – Part Two</li> <li>SQL Statement Basic</li> <li>SQL Limit Clause Statement</li> <li>SQL Using BETWEEN with Same Column Data</li> <li>How to Apply IN Operator</li> <li>Wildcard Characters with LIKE and ILIKE</li> </ul> <br> <strong>GROUP BY Statements</strong> <ul> <li>Overview of GROUP BY</li> <li>Aggregation function SUM()</li> <li>Aggregation MIN() and MAX()</li> <li>GROUP BY – One</li> <li>GROUP BY – Two</li> <li>HAVING Clause</li> </ul> <strong>JOINS</strong> <ul> <li>Overview of JOINS</li> <li>Introduction to JOINS</li> <li>AS Statement table</li> <li>INNER Joins</li> <li>FULL Outer Join</li> <li>LEFT Outer JOIN</li> <li>RIGHT JOIN</li> <li>Union</li> </ul> <strong>Advanced SQL Commands / Statements</strong> <ul> <li>Timestamps</li> <li>EXTRACT from timestamp</li> <li>Mathematical Functions</li> <li>String Functions</li> <li>SUBQUERY</li> </ul> <strong>Creating Database and Tables<br> Databases and Tables<br> Assignment</strong><br> <br> <strong>Career path</strong><br> <br> Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Mysql Developer,Senior PL/SQL Developer,SQL Coordinator,Microsoft SQL Server Administrator', 'eligibility' => 'Our SQL Programming Complete Bundle is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace.', 'school' => 'Apex Learning', 'keywords' => 'Mysql,PHP,Sqlserver,SQL,Microsoft, SQL Programming Complete Bundle', 'location' => 'Online', 'duration' => 'Upto 8 Hours', 'timing' => null, 'cost' => null, 'discount' => '90% Off for Laimoon Users!', 'eligibility_criteria' => null, 'job_matching_keywords' => 'SQL Programming Complete Bundle', 'boosted' => null, 'lang_code' => 'ar', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ), (int) 1 => array( 'Course' => array( 'id' => '97533', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '0', 'title' => 'Administering a SQL Database Infrastructure', 'external_link' => 'https://www.globaledulink.co.uk/course/microsoft-70-764-administering-a-sql-database-infrastructure-live-practice-lab/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 22 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Global Edulink', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '79', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '106', 'nondiscounted_base_price' => '706.666666667', 'currency' => 'GBP', 'discount' => '%85 خصم لعملاء ليمون!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-764 Administering a SQL Database Infrastructure Practice Lab course.<br /> <br /> Microsoft Practice Lab courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. To gain a Microsoft certification, you’ll need to take a theory course, and a Practice Lab course. This Global Edulink 70-764 Practice Lab will provide excellent training which will guarantee your success in your chosen exam. For those hoping to take the 70-764 exam, this Practice Lab is a must.<br /> <br /> The 70-764 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the Practice Lab tasks, you will improve your practical skills in configuring access to data and auditing, managing backups and restoring a database, managing and monitoring SQL Server instances, managing high availability and disaster recovery. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-764 Administering a SQL Database Infrastructure exam.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Configure data access and auditing (20–25%)</li> <li>Manage backup and restore of databases (20–25%)</li> <li>Manage and monitor SQL Server instances (35–40%)</li> <li>Manage high availability and disaster recovery (20–25%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>Course Curriculum:</strong><br /> <br /> <strong>Module 01:</strong> Data Encryption<br /> <strong>Module 02:</strong> Backup and Connection Encryption<br /> <strong>Module 03:</strong> Manage Database Object Permissions<br /> <strong>Module 04:</strong> Configuring Security Options<br /> <strong>Module 05:</strong> Configuring Audits for SQL Server<br /> <strong>Module 06:</strong> Backing Up Databases<br /> <strong>Module 07:</strong> Piecemeal Restore of Database and File Groups<br /> <strong>Module 08:</strong> Working with Restore Options<br /> <strong>Module 09:</strong> Maintaining Database Integrity<br /> <strong>Module 10:</strong> Monitoring the Database Activity<br /> <strong>Module 11:</strong> Configuring Data Collection and UCP<br /> <strong>Module 12:</strong> Managing a Query Store<br /> <strong>Module 13:</strong> Using Trace and Extended Events<br /> <strong>Module 14:</strong> Managing Indexes<br /> <strong>Module 15:</strong> Managing Statistics<br /> <strong>Module 16:</strong> Managing Operators<br /> <strong>Module 17:</strong> Monitoring SQL Server<br /> <strong>Module 18:</strong> Configuring Log Shipping<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-764 Administering a SQL Database Infrastructure certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and skills.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'about_school' => '', 'keywords' => 'Mysql,PHP,Database,Sqlserver,SQL', 'job_matching_keywords' => null, 'instructor_bio' => '', 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '395', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '7646', 'trainer_ids' => null, 'created' => '2018-05-09 14:25:14', 'updated' => '2018-05-17 13:29:50', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@globaledulink.co.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'upto-twenty-two-hours-administering-a-sql-database-infrastructure-global-edulink', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '0', 'accreditation' => '0', 'accreditation_logos' => 'CPD,iAP', 'invoice_type' => 'Free', 'payment_mode' => 'free', 'invoice_value' => '5', 'invoice_click_value' => '0.12', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Full Time', 'study_timings' => '1', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'None', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'Senior Database Administrator,Windows Server Administrator,Network Engineer,Systems Analyst', 'rank' => '{"default":8,"uae_rank":8,"saudi_arabia_rank":8,"oman_rank":8,"singapore_rank":8,"jordan_rank":8}', 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"128170_en_c":350000000,"128171_en_c":350000000,"124982_en_c":350000000,"121811_en_c":350000000,"124983_en_c":350000000,"66677_ar_c":350000000,"132095_en_c":350000000,"5153_en_c":350000000,"56631_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99290535', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '7646', 'name' => 'Global Edulink', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'global-edulink', 'location' => null, 'customer_name' => 'Rushan Arachchige', 'seeder_id' => '43', 'phone_number' => '2034097966', 'pri_line_number' => '', 'address_street' => ' CityPoint, 1 Ropemaker Street,', 'address_building' => '', 'address_city' => 'London, EC2Y 9HU.', 'address_country' => 'United Kingdom', 'addresss' => ' CityPoint, 1 Ropemaker Street,, London, EC2Y 9HU., United Kingdom', 'invoice_email' => 'info@globaledulink.co.uk', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '50', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => 'CPC', 'intl_leads_enabled' => '0', 'invoice_notification' => '0', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1578472083-go (White Background).jpg', 'logo_size' => '{"width":3461,"height":1200}', 'description' => 'Global Edulink is a leading online learning and training provider. We believe that everyone should have the opportunity to learn, no matter what their situation, which is why we strive to keep our resources cutting edge and easy-to-understand.<br /> <br /> Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.<br /> <br /> Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.<br /> ', 'website' => 'http://www.globaledulink.co.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528980709-8-06-14 at 4.52.50 PM.png', 'video_embed_code' => '<iframe width="854" height="480" src="https://www.youtube.com/embed/bn_ZJ_0B2jM" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@globaledulink.co.uk', 'contact_phone_number' => '+44 2034097966', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"3";s:7:"dec_avg";d:3;s:9:"whole_avg";d:3;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => null, 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier2', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2017-11-24 20:50:10', 'modified' => '2022-09-05 13:45:10', 'pageview_enabled' => '1', 'timezone' => 'Europe/London', 'provider_status' => 'performance', 'cpc_direct_linking' => 'no', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2018-08-17 18:12:33', 'profile_completed_time' => '2017-11-24 20:57:46', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => '/', 'course_type_ids' => '2', 'trusted' => '0', 'legacy' => '0', 'moderation_status' => 'verified', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '1', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1662371099_Sample_Cer.jpg', 'lead_filters' => null, 'repeat_email_lead_alerts' => '1', 'load_blncr_weight' => '1', 'remote_option' => null, 'classroom_status' => 'pending', 'topup_info' => null, 'provider_rank' => '{"default":502,"rndm":677211,"r_84":502,"r_174":502,"r_777":502,"r_82":502,"r_401":502,"r_89":502,"r_229":502,"r_80":502,"r_114":502,"r_610":502,"r_615":502,"r_609":502,"r_66":502,"r_614":502,"r_805":502,"r_79":502,"r_374":502,"r_682":502,"r_636":502,"r_88":502,"r_215":502,"r_17":502,"r_357":502,"r_86":502,"r_388":502,"r_221":502,"r_81":502,"r_382":502,"r_592":502,"r_541":502,"r_193":502,"r_95":502,"r_762":502,"r_656":502,"r_85":502,"r_180":502,"r_113":502,"r_809":502,"r_255":502,"r_808":502,"r_253":502,"r_254":502,"r_389":502,"r_618":502,"r_593":502,"r_599":502,"r_738":502,"r_743":502,"r_387":502,"r_12":502,"r_231":502,"r_10":502,"r_528":502,"r_931":502,"r_527":502,"r_843":502,"r_111":502,"r_112":502,"r_122":502,"r_823":502,"r_912":502,"r_149":502,"r_83":502,"r_167":502,"r_657":502,"r_237":502,"r_236":502,"r_168":502,"r_256":502,"r_739":502,"r_312":502,"r_511":502,"r_588":502,"r_332":502,"r_313":502,"r_439":502,"r_385":502,"r_811":502,"r_183":502,"r_227":502,"r_329":502,"r_225":502,"r_944":502,"r_223":502,"r_169":502,"r_597":502,"r_526":502,"r_818":502,"r_884":502,"r_268":502,"r_269":502,"r_27":502,"r_830":502,"r_531":502,"r_794":502,"r_347":502,"r_755":502,"r_780":502,"r_779":502,"r_524":502,"r_148":502,"r_94":502,"r_419":502,"r_589":502,"r_847":502,"r_725":502,"r_840":502,"r_125":502,"r_226":502,"r_391":502,"r_15":502,"r_207":502,"r_652":502,"r_694":502,"r_270":502,"r_760":502,"r_507":502,"r_508":502,"r_403":502,"r_204":502,"r_272":502,"r_515":502,"r_519":502,"r_97":502,"r_918":502,"r_195":502,"r_432":502,"r_142":502,"r_691":502,"r_393":502,"r_722":502,"r_398":502,"r_872":502,"r_394":502,"r_395":502,"r_400":502,"r_887":502,"r_196":502,"r_194":502,"r_345":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '157866', 'course_id' => '97533', 'title' => 'Administering a SQL Database Infrastructure', 'slug' => 'upto-twenty-two-hours-administering-a-sql-database-infrastructure-global-edulink', 'external_link' => 'https://www.globaledulink.co.uk/course/microsoft-70-764-administering-a-sql-database-infrastructure-live-practice-lab/', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-764 Administering a SQL Database Infrastructure Practice Lab course.<br /> <br /> Microsoft Practice Lab courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. To gain a Microsoft certification, you’ll need to take a theory course, and a Practice Lab course. This Global Edulink 70-764 Practice Lab will provide excellent training which will guarantee your success in your chosen exam. For those hoping to take the 70-764 exam, this Practice Lab is a must.<br /> <br /> The 70-764 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the Practice Lab tasks, you will improve your practical skills in configuring access to data and auditing, managing backups and restoring a database, managing and monitoring SQL Server instances, managing high availability and disaster recovery. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-764 Administering a SQL Database Infrastructure exam.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Configure data access and auditing (20–25%)</li> <li>Manage backup and restore of databases (20–25%)</li> <li>Manage and monitor SQL Server instances (35–40%)</li> <li>Manage high availability and disaster recovery (20–25%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>Course Curriculum:</strong><br /> <br /> <strong>Module 01:</strong> Data Encryption<br /> <strong>Module 02:</strong> Backup and Connection Encryption<br /> <strong>Module 03:</strong> Manage Database Object Permissions<br /> <strong>Module 04:</strong> Configuring Security Options<br /> <strong>Module 05:</strong> Configuring Audits for SQL Server<br /> <strong>Module 06:</strong> Backing Up Databases<br /> <strong>Module 07:</strong> Piecemeal Restore of Database and File Groups<br /> <strong>Module 08:</strong> Working with Restore Options<br /> <strong>Module 09:</strong> Maintaining Database Integrity<br /> <strong>Module 10:</strong> Monitoring the Database Activity<br /> <strong>Module 11:</strong> Configuring Data Collection and UCP<br /> <strong>Module 12:</strong> Managing a Query Store<br /> <strong>Module 13:</strong> Using Trace and Extended Events<br /> <strong>Module 14:</strong> Managing Indexes<br /> <strong>Module 15:</strong> Managing Statistics<br /> <strong>Module 16:</strong> Managing Operators<br /> <strong>Module 17:</strong> Monitoring SQL Server<br /> <strong>Module 18:</strong> Configuring Log Shipping<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-764 Administering a SQL Database Infrastructure certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and skills.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Senior Database Administrator,Windows Server Administrator,Network Engineer,Systems Analyst', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'school' => 'Global Edulink', 'keywords' => 'Mysql,PHP,Database,Sqlserver,SQL', 'location' => 'Online', 'duration' => 'Upto 22 Hours', 'timing' => null, 'cost' => null, 'discount' => '%85 خصم لعملاء ليمون!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'ar', 'status' => 'active', 'auto_translated' => '1', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ) ) $job = array( 'Job' => array( 'id' => '39308583', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'Database Administrator', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<p>Role: Database AdministratorLocation: Leeds, LS15 8GB (with hybrid working after completion of training)Salary: £55,000 - £65,000 per annum plus extensive benefitsContract type: PermanentEmployment type: Full time/Part timeWorking hours: 40 hrs pw, Monday to FridayDo you want to work for the nation’s largest online pharmacy ensuring excellence for all our patients? We’re a market leader in the pharmacy world, with 20 years’ experience, helping over 750,000 patients in England manage their NHS prescriptions from request through to delivery.This is a challenging and dynamic opportunity in a small and highly focused team, supporting the business to achieve its goals by working alongside cloud engineers, architects, and developers to deliver projects that support the business. In this Database Administrator (DBA) role you will develop and maintain a highly available, secure, and performant data platform.Optimising and monitoring production databases across an estate of physical, cloud and PaaS environments. Working for a market leading organisation as DBA, you will be responsible for the configuration, availability, integrity and security of all databases and data sources. With a natural ability to identify, assess, prioritise, and deliver improvements to the environments you will be responsible for, you will proactively manage technology and processes to deliver high-quality architecture you can be proud of.What’s in it for you?Occupational sick payDiscounted insurance (Aviva)Employee assistance programmeHealth and wellbeing initiativesGreen car schemeRefer a friend bonusCommitment to CPD/trainingDiscounts & Exclusive offers at The Springs, Leeds25% Discount & health & beauty purchasesEnhanced maternity and paternity payEmployee discount siteIn-house mental health supportSocial events throughout the yearRegistration fees paid (GPhC, NMC, CIPD etc)Blue light cardHybrid working25 days annual leave increasing with serviceContributory pensionDiscounted gymsFree onsite parkingCycle to work schemeLong service bonusWhat you’ll be doing?Ensure all database platforms are highly availableEnsure all data sources are secure and access is controlled, reviewed, and auditedSupport BI developers, application experts and middleware developers in their efforts to integrate and report on data in an accurate and reliable mannerWork with third parties for new installations, upgrades, maintenance, testing, troubleshooting and general advice and guidance as required to ensure all delivered services meet requirementsRespond to support escalations from DevOps and technical colleagues, providing specific expertise for troubleshooting as requiredBuild strong relationships in the business to understand business objectives, specific data requirements and how the data you maintain adds value to the businessControlled execution of data management tasksConfigure, maintenance and get maximum value from proactive monitoring using tools such as Redgate and New RelicWho are we looking for?Proficiency in SQL Server 2019 and Azure SQLStrong operations experience in troubleshooting and root cause analysisExperience of performance tuning and optimisingStrong proficiency with Microsoft T-SQLExcellent written and verbal communication skills at all levelsHighly motivated and patient centricProduces accurate work with high attention to detail and experience of working in a regulated industryExperience using native and third-party performance monitoring tools such as Redgate SQL Monitor and New RelicLogical thinkerWhat happens next?Please click apply and if we think you are a good match, we will be in touch to arrange an interview.Applicants must prove they have the right to live in the UK.All successful applicants will be required to undergo a DBS check.Unsolicited agency applications will be treated as a gift.#INDTECH </p>', 'course_qualifications' => null, 'global_location_id' => '226', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => '', 'salaryFrom' => null, 'salaryTo' => null, 'currency_id' => null, 'hide_salary' => '0', 'benefits' => null, 'salary_type_id' => null, 'travel_type_id' => null, 'travel_id' => null, 'education_id' => null, 'education_background' => null, 'language_id' => null, 'position_level_id' => null, 'position_type' => null, 'number_of_staffs_mange' => null, 'experiance' => null, 'sales_experience' => null, 'sales_focus' => null, 'sales_cycle_id' => null, 'reporting_to' => null, 'otherAssignments' => null, 'otherConsiderations' => null, 'ideal_candidate' => null, 'company_info' => null, 'company_id' => '219258', 'company_name' => 'Pharmacy2U Ltd', 'external_apply_url' => 'https://uk.jooble.org/external/237772428927681566?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_uk&extra_ars_request_id=f37fb1b2b86c8202e78dda5be6eb6d07', 'external_short_url' => '', 'apply_url' => null, 'contributed' => '0', 'created' => null, 'published' => '2024-01-09 07:18:23', 'closed_time' => null, 'updated' => null, 'hideCompany' => null, 'hide_contact_info' => '0', 'application_count' => '0', 'closed' => '0', 'draft' => '0', 'rejected' => '0', 'deleted' => '0', 'moderated' => '1', 'boosted' => '0', 'rejectnote' => null, 'job_extended' => '0', 'purchased' => '0', 'seeder_id' => '8', 'source_id' => 'jooble', 'course_keywords' => null, 'shortlist_magic_applied' => '0', 'shortlist_magic_keywords' => null, 'living_in' => '0', 'age_limit' => null, 'is_managerial' => '0', 'application_email' => null, 'quality_score' => null, 'reopened' => '0', 'quality_type' => 'White', 'promoted' => '0' ), 'Recruiter' => array( 'first_name' => 'Jooble Jobs', 'last_name' => null, 'recruiter_type' => 'company' ), 'GlobalLocation' => array( 'id' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( 'name' => 'United Kingdom', 'id' => '74', 'slug' => 'united-kingdom', 'code' => 'GB' ) ), 'Company' => array( 'id' => '219258', 'name' => 'Pharmacy2U Ltd', 'website' => null, 'verified' => '0', 'photo' => 'Pharmacy2U_Ltd_aaeda440-d6bb-11e9-8563-8d2b2f614077.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ) $jobsList = array() $courses = array() $promotedCourses = array() $referer = '/' $urlKeyword = 'Database ' $profile = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '10756', 'contributedJobCount' => '24', 'courseCount' => null ) $askLogin = true $jobLinkTitle = 'Database ' $renderSchema = 'yes' $title_for_layout = 'Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.' $page_description = 'Apply to Database Administrator jobs in Pharmacy2U Ltd in United Kingdom.Find similar vacancies, jobs and salary information in United Kingdom.' $locationForTitle = 'United Kingdom' $currentJobCity = array( 'id' => '226', 'display_name' => 'United Kingdom', 'name_ar' => null, 'country_id' => '74', 'Country' => array( 'name' => 'United Kingdom', 'id' => '74', 'slug' => 'united-kingdom', 'code' => 'GB' ) ) $jobCompanyPage = array( 'CompanyPage' => array( 'id' => '12943', 'title' => 'Pharmacy2U Ltd', 'slug' => 'pharmacy2u-ltd' ), 'CompanyPageTranslation' => array( 'id' => null, 'company_page_id' => null, 'title' => null, 'slug' => null, 'summary' => null, 'description' => null, 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'company_matching_keywords' => null, 'draft' => null, 'lang_code' => null ) ) $location = 'United Kingdom' $breadCrumbs = array( 'Job Details' => '' ) $relCourseBanner = array( 'relatedUrl' => 'https://courses.laimoon.com/ar/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'مايكروسوفت إس كيو إل سيرفر', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/ar/online/it-computing-and-technology/database-management/sql-server' ) $published = '2024-01-09 07:18:23' $daysleft = (float) -78 $isLoggedIn = false $facebookSession = null $fbConfig = array( 'AppId' => '151651858238476', 'APIKey' => '1c032aa6c89b302e8ec5dea94dc89104', 'AppSecret' => 'f2b69d3a25fe65601f146efe7178e72a' ) $linkedInConfig = array( 'APIKey' => '779yus3aqi524z', 'AppSecret' => 'XCdGJxUokce5Ygf6' ) $criticalCSSes = array( 'jobdetail' => 'jobdetail-critical-css', 'companylist' => 'companylist-critical-css', 'companyview' => 'companyview-critical-css', 'agencylist' => 'agencylist-critical-css', 'agencyview' => 'agencyview-critical-css', 'laimoonverified' => 'laimoonverified-critical-css', 'seopages' => 'seopages-critical-css', 'externalview' => 'externalview-critical-css', 'popularjobsearches' => 'popularjobsearches-critical-css' ) $basicProfileIncomplete = true $seeAllJobLink = 'https://jobs.laimoon.com/ar/united-kingdom/Database ' $csaKeywords = array( (int) 0 => 'Database Administrator' ) $allowLoginClass = 'notlogin' $jobLocSlug = 'united-kingdom' $jobLocName = 'United Kingdom' $pfBackgrounds = '' $jobLink = 'https://jobs.laimoon.com/jobs/externalview/39308583' $companyName = ' at Pharmacy2U Ltd' $twitterText = 'Hiring now! Database Administrator at Pharmacy2U Ltd. Please apply or share https://jobs.laimoon.com/jobs/externalview/39308583' $emailText = 'Hiring now! Database Administrator at Pharmacy2U Ltd. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/39308583' $sCompanyName = false $csaSearchKey = 'Database Administrator' $jobDetails = 'تفاصيل الوظيفة' $btn_text = 'Apply on company website' $confidentialExists = false $showCompany = (int) 1 $mainCheck = (int) 1 $confidentialThumbClass = '' $cdnImageThumbPath = 'https://cdn.laimoon.com/profileimages/thumbnail/' $companyPageTitle = 'Pharmacy2U Ltd'include - APP/View/Jobs/externalview.ctp, line 206 View::_evaluate() - CORE/Cake/View/View.php, line 948 View::_render() - CORE/Cake/View/View.php, line 910 View::render() - CORE/Cake/View/View.php, line 471 Controller::render() - CORE/Cake/Controller/Controller.php, line 948 Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 194 Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 162 [main] - APP/webroot/index.php, line 115
الشركة المعلنة عن الوظيفة
Pharmacy2U Ltd
تحسين فرصتك لحصول على وظيفة
خذ دورة عبر الإنترنت على مايكروسوفت إس كيو إل سيرفر ابتداءً من الآن.
-
SQL Programming Complete Bundle Apex Learning83 درهم
771 درهممدة الدورة التدريبية: Upto 8 Hours -
Administering a SQL Database Infrastructure Global Edulink362 درهم
2,596 درهممدة الدورة التدريبية: Upto 22 Hours
X
لماذا تقوم بالإبلاغ عن هذه الوظيفة؟
Job has expired لا يمكن عرض هذه الصفحةبدلًا من ذلك، يمكنك النقر على الرابط أدناه أو نسخ/لصق الرابط في متصفح الإنترنت الخاص بك.
https://uk.jooble.org/external/237772428927681566?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_uk&extra_ars_request_id=f37fb1b2b86c8202e78dda5be6eb6d07