Job details
Job Description
As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus.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' => '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' ), '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' => false, 'profileInfo' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12299', 'contributedJobCount' => '24', 'courseCount' => null ), 'environment' => 'production', 'langUrlPrefix' => '', 'langUrl' => 'https://jobs.laimoon.com/', 'themeUrl' => 'https://jobs.laimoon.com/', 'siteUrl' => 'https://jobs.laimoon.com/', 'staticUrl' => 'https://cdn.laimoon.com/jobs/', 'langCode' => 'en', 'pageScripts' => array( (int) 0 => 'page_script' ), 'pageName' => 'externalview', 'courseUrl' => 'https://courses.laimoon.com/', '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' => '43108239', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'SQL Developer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<h2> Job Description </h2><p> As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus. </p>', 'course_qualifications' => null, 'global_location_id' => '64', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => 'Full time', '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' => '52091', 'company_name' => 'Capgemini', 'external_apply_url' => 'https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=3281ee33432858cc0e6a191118534a7a', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:20', 'published' => '2024-04-20 03:28:20', 'closed_time' => null, 'updated' => '2024-04-20 03:28:20', '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' => '113', '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' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( [maximum depth reached] ) ), 'Company' => array( 'id' => '52091', 'name' => 'Capgemini', 'website' => 'https://www.capgemini.com/in-en/', 'verified' => '0', 'photo' => 'Capgemini_e08058a0-f1f5-11e9-bbf3-15f76e7ed41e.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ), 'jobsList' => array(), 'courses' => array(), 'promotedCourses' => array(), 'referer' => '/', 'urlKeyword' => 'SQL ', 'profile' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12299', 'contributedJobCount' => '24', 'courseCount' => null ), 'askLogin' => true, 'jobLinkTitle' => 'SQL ', 'renderSchema' => 'yes', 'title_for_layout' => 'SQL Developer jobs in Capgemini in Egypt.', 'page_description' => 'Apply to SQL Developer jobs in Capgemini in Egypt.Find similar vacancies, jobs and salary information in Egypt.', 'locationForTitle' => 'Egypt', 'currentJobCity' => array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ), 'jobCompanyPage' => array( 'CompanyPage' => array( 'id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '28520', 'company_page_id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'summary' => null, 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ), 'location' => 'Egypt', 'breadCrumbs' => array( 'Job Details' => '' ), 'relCourseBanner' => array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'SQL Server', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management/sql-server' ), 'published' => '2024-04-20 03:28:20', 'daysleft' => (float) 16, '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' => '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' ) $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 = false $profileInfo = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12299', 'contributedJobCount' => '24', 'courseCount' => null ) $environment = 'production' $langUrlPrefix = '' $langUrl = 'https://jobs.laimoon.com/' $themeUrl = 'https://jobs.laimoon.com/' $siteUrl = 'https://jobs.laimoon.com/' $staticUrl = 'https://cdn.laimoon.com/jobs/' $langCode = 'en' $pageScripts = array( (int) 0 => 'page_script' ) $pageName = 'externalview' $courseUrl = 'https://courses.laimoon.com/' $onlineCourses = array( (int) 0 => array( 'Course' => array( 'id' => '128869', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => '0', 'title' => 'MCSA Windows Server 2016 (70-740) ', 'external_link' => 'https://lead-academy.org/course/mcsa-windows-server-2016-70-740/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 6 Hours', 'base_duration' => '0', 'timing' => 'Flexible', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Lead Academy', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '20', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '12', 'nondiscounted_base_price' => '390', 'currency' => 'GBP', 'discount' => '97% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this MCSA Windows Server ) course will set you up with a solid foundation to become a confident networking engineer and develop more advanced skills.<br /> <br /> This comprehensive MCSA Windows Server ) course is the perfect way to kickstart your career in the field of windows server and networking. This accredited course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.<br /> <br /> As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This course is crafted by industry experts, to enable you to learn quickly and efficiently, and at your own pace and convenience.<br /> <br /> <strong>How Will I Benefit?</strong> <ul> <li>Boost your career in windows server and networking</li> <li>Deepen your knowledge and skills in your chosen field just in hours not years!</li> <li>Study a course that has been designed by industry professionals.</li> <li>Save money and time by studying your convenient time</li> <li>Have access to a tutor whenever you are in need</li> </ul> So, what are you thinking about! Start getting the benefits by enrolling today!<br /> <br /> <strong>Why Choose Lead Academy:</strong> <ul> <li>Lifetime Access</li> <li>High-quality e-learning study materials </li> <li>The UK and globally recognized qualification</li> <li>Self-paced, no fixed schedules</li> <li>24/7 customer support through email</li> <li>Available to students anywhere in the world</li> <li>No hidden fee</li> <li>Study in a user-friendly, advanced online learning platform</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This comprehensive MCSA Windows Server ) course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of windows server and networking.<br /> <br /> <strong>Certification</strong><br /> <br /> On successful completion of the MCSA Windows Server ) course, you will be eligible to obtain a verifiable certificate as proof of your new qualification. This means that you/your employer can verify your qualification through our website. Certificate can be obtained in PDF version at a cost of £10, and there is an additional fee to obtain a printed copy certificate which is £29.<br /> <br /> <strong>Career path</strong><br /> <br /> This MCSA Windows Server ) course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV, enhance your career, and become more competitive in your chosen industry.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => '<ul> <li>There are no academic entry requirements for this MCSA Windows Server ) course, and it is open to students of all academic ;</li> <li>As long as you are aged seventeen or over and have a basic grasp of English, numeracy, and ICT, you will be eligible to enroll.</li> </ul> ', 'about_school' => '', 'keywords' => 'MCSA,Microsoft,MCSE,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' => '890,395,872', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '10236', 'trainer_ids' => null, 'created' => '2020-10-17 17:52:57', 'updated' => '2020-10-17 18:09:58', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@lead-academy.org', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider_verified', 'slug' => 'part-time-mcsa-windows-server-2016-70-740-lead-academy', '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 Certification Service,IPHM', 'invoice_type' => 'Free', 'payment_mode' => 'paid', 'invoice_value' => '5', 'invoice_click_value' => '0', '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' => 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' => 'Internship Program in MCSA,Windows Engineer,Window Assembler', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"88907_en_f":350000000,"222415_en_c":350000000,"5153_en_c":350000000,"128170_en_c":350000000,"128028_en_c":350000000,"128171_en_c":350000000,"128027_en_c":350000000,"222078_en_c":350000000,"179470_en_c":350000000,"70404_en_f":350000000,"217094_en_c":350000000,"217424_en_c":350000000,"89595_en_f":350000000,"124983_en_c":350000000,"217303_en_c":350000000,"71011_en_f":350000000,"124982_en_c":350000000,"217396_en_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' => null, 'bundle_id' => null, 'randomizer' => '99900425', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '10236', 'name' => 'Lead Academy', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'lead-academy', 'location' => null, 'customer_name' => 'David Foster', 'seeder_id' => '43', 'phone_number' => '+447960579006', 'pri_line_number' => '', 'address_street' => 'Office 15, Pure Offices, Kembrey Park', 'address_building' => '', 'address_city' => 'Swindon', 'address_country' => 'United Kingdom', 'addresss' => 'Office 15, Pure Offices, Kembrey Park, Swindon, United Kingdom', 'invoice_email' => 'info@lead-academy.org', '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_1581072749-d-Academy-New-blackbg.jpg', 'logo_size' => '{"width":1450,"height":310}', 'description' => 'Lead Academy is a leading online training company providing state-of-the-art training and qualifications. At Lead Academy, we know that everyone is different, that’s why we offer a comprehensive range of courses to suit all needs.<br /> <br /> We are committed to providing exceptional learning experiences that support learning and development through the use of innovative online training techniques that not only educate and enhance the skills of our learners but ultimately help them to succeed.<br /> <br /> We work in conjunction with leading industry sector professionals to produce high-quality, affordable courses designed to develop the practical skills and knowledge required to take back to and implement in the workplace, delivering real results for you and your business to thrive.<br /> <br /> <br /> We offer a wide range of courses suitable for all levels. Whether you want to advance your career or simply learn something new, we’ll have the course for you.<br /> ', 'website' => 'https://lead-academy.org/', '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@lead-academy.org', 'contact_phone_number' => '+44 7960579006', '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:2:{s:7:"dec_avg";d:0;s:9:"whole_avg";d:0;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => 'No', 'instant_callback_disabled' => '1', 'show_map' => '0', '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' => '2019-12-04 19:49:20', 'modified' => '2021-08-30 18:28:42', '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' => 'Contacted', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2019-12-20 11:56:45', 'profile_completed_time' => '2019-12-04 19:57:37', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => 'https://partners.laimoon.com/', 'course_type_ids' => '2,7', '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/1630332968_lead-acade.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":580046,"r_79":502,"r_369":502,"r_373":502,"r_98":502,"r_425":502,"r_95":502,"r_419":502,"r_589":502,"r_763":502,"r_852":502,"r_851":502,"r_10":502,"r_94":502,"r_759":502,"r_527":502,"r_441":502,"r_315":502,"r_848":502,"r_776":502,"r_312":502,"r_81":502,"r_382":502,"r_592":502,"r_955":502,"r_126":502,"r_511":502,"r_588":502,"r_795":502,"r_656":502,"r_762":502,"r_12":502,"r_231":502,"r_69":502,"r_52":502,"r_335":502,"r_330":502,"r_332":502,"r_66":502,"r_254":502,"r_884":502,"r_294":502,"r_26":502,"r_17":502,"r_348":502,"r_86":502,"r_183":502,"r_715":502,"r_541":502,"r_725":502,"r_840":502,"r_723":502,"r_89":502,"r_229":502,"r_292":502,"r_378":502,"r_607":502,"r_268":502,"r_269":502,"r_345":502,"r_27":502,"r_847":502,"r_844":502,"r_88":502,"r_217":502,"r_388":502,"r_193":502,"r_85":502,"r_385":502,"r_811":502,"r_80":502,"r_114":502,"r_610":502,"r_596":502,"r_797":502,"r_900":502,"r_111":502,"r_226":502,"r_933":502,"r_14":502,"r_266":502,"r_660":502,"r_439":502,"r_791":502,"r_320":502,"r_82":502,"r_146":502,"r_617":502,"r_490":502,"r_375":502,"r_700":502,"r_383":502,"r_90":502,"r_497":502,"r_313":502,"r_60":502,"r_253":502,"r_112":502,"r_658":502,"r_281":502,"r_83":502,"r_927":502,"r_257":502,"r_757":502,"r_707":502,"r_611":502,"r_814":502,"r_846":502,"r_845":502,"r_209":502,"r_367":502,"r_523":502,"r_760":502,"r_929":502,"r_901":502,"r_415":502,"r_148":502,"r_195":502,"r_87":502,"r_198":502,"r_657":502,"r_170":502,"r_168":502,"r_670":502,"r_167":502,"r_314":502,"r_122":502,"r_821":502,"r_113":502,"r_778":502,"r_838":502,"r_831":502,"r_829":502,"r_614":502,"r_945":502,"r_502":502,"r_689":502,"r_897":502,"r_299":502,"r_255":502,"r_839":502,"r_830":502,"r_128":502,"r_120":502,"r_747":502,"r_142":502,"r_143":502,"r_799":502,"r_507":502,"r_508":502,"r_859":502,"r_381":502,"r_736":502,"r_590":502,"r_539":502,"r_697":502,"r_807":502,"r_888":502,"r_216":502,"r_221":502,"r_215":502,"r_119":502,"r_911":502,"r_609":502,"r_222":502,"r_514":502,"r_227":502,"r_96":502,"r_823":502,"r_912":502,"r_639":502,"r_749":502,"r_819":502,"r_861":502,"r_857":502,"r_850":502,"r_223":502,"r_943":502,"r_914":502,"r_798":502,"r_403":502,"r_404":502,"r_655":502,"r_118":502,"r_809":502,"r_237":502,"r_512":502,"r_786":502,"r_256":502,"r_329":502,"r_125":502,"r_910":502,"r_854":502,"r_866":502,"r_70":502,"r_500":502,"r_147":502,"r_387":502,"r_922":502,"r_779":502,"r_20":502,"r_163":502,"r_166":502,"r_164":502,"r_401":502,"r_599":502,"r_196":502,"r_123":502,"r_204":502,"r_731":502,"r_802":502,"r_633":502,"r_820":502,"r_930":502,"r_233":502,"r_110":502,"r_582":502,"r_15":502,"r_207":502,"r_188":502,"r_860":502,"r_97":502,"r_370":502,"r_709":502,"r_316":502,"r_683":502,"r_812":502,"r_882":502,"r_374":502,"r_636":502,"r_816":502,"r_394":502,"r_397":502,"r_84":502,"r_174":502,"r_194":502,"r_187":502,"r_230":502,"r_705":502,"r_251":502,"r_436":502,"r_180":502,"r_354":502,"r_380":502,"r_399":502,"r_826":502,"r_351":502,"r_703":502,"r_671":502,"r_959":502,"r_124":502,"r_784":502,"r_923":502,"r_127":502,"r_867":502,"r_190":502,"r_953":502,"r_813":502,"r_785":502,"r_746":502,"r_587":502,"r_531":502,"r_794":502,"r_887":502,"r_788":502,"r_864":502,"r_865":502,"r_956":502,"r_349":502,"r_808":502,"r_9":502,"r_496":502,"r_242":502,"r_581":502,"r_323":502,"r_421":502,"r_91":502,"r_261":502,"r_259":502,"r_734":502,"r_755":502,"r_780":502,"r_726":502,"r_267":502,"r_265":502,"r_652":502,"r_954":502,"r_201":502,"r_679":502,"r_199":502,"r_161":502,"r_353":502,"r_352":502,"r_672":502,"r_777":502,"r_236":502,"r_918":502,"r_205":502,"r_364":502,"r_608":502,"r_665":502,"r_389":502,"r_618":502,"r_593":502,"r_890":502,"r_395":502,"r_398":502,"r_872":502,"r_400":502,"r_653":502,"r_694":502,"r_357":502,"r_597":502,"r_396":502,"r_738":502,"r_743":502,"r_521":502,"r_832":502,"r_203":502,"r_241":502,"r_745":502,"r_842":502,"r_516":502,"r_232":502,"r_526":502,"r_761":502,"r_818":502,"r_898":502,"r_781":502,"r_309":502,"r_412":502,"r_769":502,"r_843":502,"r_754":502,"r_748":502,"r_121":502,"r_758":502,"r_169":502,"r_319":502,"r_668":502,"r_822":502,"r_420":502,"r_328":502,"r_218":502,"r_192":502,"r_234":502,"r_645":502,"r_533":502,"r_181":502,"r_868":502,"r_362":502,"r_211":502,"r_619":502,"r_391":502,"r_691":502,"r_408":502,"r_724":502,"r_393":502,"r_637":502,"r_43":502,"r_172":502,"r_615":502,"r_805":502,"r_626":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '201462', 'course_id' => '128869', 'title' => 'MCSA Windows Server 2016 (70-740) ', 'slug' => 'part-time-mcsa-windows-server-2016-70-740-lead-academy', 'external_link' => 'https://lead-academy.org/course/mcsa-windows-server-2016-70-740/', 'summary' => '<strong>Overview</strong><br /> <br /> Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this MCSA Windows Server ) course will set you up with a solid foundation to become a confident networking engineer and develop more advanced skills.<br /> <br /> This comprehensive MCSA Windows Server ) course is the perfect way to kickstart your career in the field of windows server and networking. This accredited course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.<br /> <br /> As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This course is crafted by industry experts, to enable you to learn quickly and efficiently, and at your own pace and convenience.<br /> <br /> <strong>How Will I Benefit?</strong> <ul> <li>Boost your career in windows server and networking</li> <li>Deepen your knowledge and skills in your chosen field just in hours not years!</li> <li>Study a course that has been designed by industry professionals.</li> <li>Save money and time by studying your convenient time</li> <li>Have access to a tutor whenever you are in need</li> </ul> So, what are you thinking about! Start getting the benefits by enrolling today!<br /> <br /> <strong>Why Choose Lead Academy:</strong> <ul> <li>Lifetime Access</li> <li>High-quality e-learning study materials </li> <li>The UK and globally recognized qualification</li> <li>Self-paced, no fixed schedules</li> <li>24/7 customer support through email</li> <li>Available to students anywhere in the world</li> <li>No hidden fee</li> <li>Study in a user-friendly, advanced online learning platform</li> </ul> <strong>Who is this course for?</strong><br /> <br /> This comprehensive MCSA Windows Server ) course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of windows server and networking.<br /> <br /> <strong>Certification</strong><br /> <br /> On successful completion of the MCSA Windows Server ) course, you will be eligible to obtain a verifiable certificate as proof of your new qualification. This means that you/your employer can verify your qualification through our website. Certificate can be obtained in PDF version at a cost of £10, and there is an additional fee to obtain a printed copy certificate which is £29.<br /> <br /> <strong>Career path</strong><br /> <br /> This MCSA Windows Server ) course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV, enhance your career, and become more competitive in your chosen industry.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Internship Program in MCSA,Windows Engineer,Window Assembler', 'eligibility' => '<ul> <li>There are no academic entry requirements for this MCSA Windows Server ) course, and it is open to students of all academic ;</li> <li>As long as you are aged seventeen or over and have a basic grasp of English, numeracy, and ICT, you will be eligible to enroll.</li> </ul> ', 'school' => 'Lead Academy', 'keywords' => 'MCSA,Microsoft,MCSE,Sqlserver,SQL', 'location' => 'Online', 'duration' => 'Upto 6 Hours', 'timing' => 'Flexible', 'cost' => null, 'discount' => '97% off through Laimoon!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'en', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ), (int) 1 => array( 'Course' => array( 'id' => '98297', 'seeder_id' => '14', 'edited_seeder_id' => '14', 'edited_client_id' => '0', 'title' => 'Implementing an Advanced Server Infrastructure', 'external_link' => 'https://www.johnacademy.co.uk/course/70-414-implementing-an-advanced-server-infrastructure-mcse/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 14 Hours', 'base_duration' => '0', 'timing' => 'Flexible', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'John Academy', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '54', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '72', 'nondiscounted_base_price' => '1440', 'currency' => 'GBP', 'discount' => '95% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => 'The 70-414 – Implementing an Advanced Server Infrastructure (MCSE) course will prepare you for the Exam 70-414: Implementing an Advanced Server Infrastructure.<br /> The course covers the advanced topics that IT professionals encounter in the enterprise environment. For passing the exam, you should have a thorough understanding of a fundamental server infra¬structure including monitoring, virtualisation, and high availability.<br /> There are four main objective areas on the 70-414 Exam which are discussed in the course thoroughly:<br /> Manage and maintain a server infrastructure<br /> Plan and implement a highly available enterprise infrastructure<br /> Plan and implement a server virtualisation infrastructure<br /> Design and implement identity and access solutions<br /> In the course, you will learn how to create the virtual infrastructure, plan and deploy virtual machines and implement solutions for the virtual administration. You will also learn about monitoring, high availability, updates, PKI, BCP and IDA. In short, the course will prepare you for the exam.<br /> <br /> <strong>COURSE CURRICULUM</strong><br /> <br /> <strong>Creating the Virtualization Infrastructure</strong> <ul> <li>Introducing Microsoft System Center 2012 Components</li> <li>Using System Center for Virtualization</li> <li>Using the VMM Management Console</li> <li>Planning a VMM Deployment</li> <li>Creating the Virtualization Host</li> <li>Configuring Host Groups</li> <li>Working with Libraries</li> <li>Storage Infrastructure</li> <li>Configuring a Storage Infrastructure for Virtualization</li> <li>Confituring Storage in VMM</li> <li>Network Infrastructure for Virtualization</li> <li>Configuring Virtual Networking</li> <li>Configuring Virtual Networks in VMM</li> </ul> <strong>Planning and Deploying Virtual Machines</strong> <ul> <li>Considerations for Virtual Machine Setup</li> <li>Planning Virtual Machine Deployment with VMM</li> <li>How to Deploy a Virtual Machine</li> </ul> <strong>Monitoring</strong> <ul> <li>Monitoring in Windows Server 2012</li> <li>Enabling and Viewing Resource Metering Data C3TAD1</li> <li>Introduction to Operations Manager</li> <li>Management Packs</li> <li>Notifications and Reporting</li> <li>Integration with VMM</li> </ul> <strong>Solution for the Virtualization Administration</strong> <ul> <li>System Center 2012 Administration</li> <li>Delegated Administration</li> <li>Automation with System Center 2012</li> <li>VMM Private Clouds</li> </ul> <strong>High Availability</strong> <ul> <li>Storage Spaces</li> <li>RAID</li> <li>NLB</li> <li>The Infrastructure for Failover Clustering</li> <li>Defining Failover Clustering</li> <li>Integrating Failover Clustering with Server Virtualization</li> <li>Multisite Planning a Multisite Failover Cluster</li> </ul> <strong>PKI</strong> <ul> <li>The Certificate Authority</li> <li>Certificate Templates</li> <li>Overview of Certificate Services</li> <li>CRL</li> <li>Key Archival</li> </ul> <strong>Updates</strong> <ul> <li>WSUS Deployment</li> <li>WSUS</li> <li>Using Configuration Manager 2012</li> <li>Updating Virtualization</li> </ul> <strong>BCP</strong> <ul> <li>BCP</li> <li>Backups</li> <li>Windows Backup Utility</li> <li>Recovery</li> <li>Backup and Recovery of VMs</li> </ul> <strong>IDA</strong> <ul> <li>Planning and Implementing an AD FS Server Infrastructure</li> <li>Planning and Implementing AD FS Claims Providers and Relying Parties</li> <li>Planning and Implementing AD FS Claims and Claim Rules</li> <li>Planning and Implementing an AD RMS Cluster</li> <li>Installing an AD RMS Cluster</li> <li>Planning and Implementing AD RMS Templates and Policies</li> <li>Planning and Implementing External Access to AD RMS Services</li> <li>Planning and Implementing AD RMS Integration with DAC</li> </ul> ', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Our 70-414 – Implementing an Advanced Server Infrastructure (MCSE) is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.', 'about_school' => '', 'keywords' => 'Sqlserver,SQL,Microsoft', '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' => '8150', 'trainer_ids' => null, 'created' => '2018-06-05 12:23:33', 'updated' => '2018-06-11 13:20:54', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@johnacademy.co.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider_verified', 'slug' => 'upto-fourteen-hours-part-time-implementing-an-advanced-server-infrastructure-john-academy', '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' => 'CiQ,CPD Qualification Standards', 'invoice_type' => 'Free', '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' => 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' => 'Server Consultant,Manager IT Infrastructure,IT infrastructure engineer', '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,"124983_en_c":350000000,"47622_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' => null, 'bundle_id' => null, 'randomizer' => '99682204', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '8150', 'name' => 'John Academy', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'john-academy', 'location' => null, 'customer_name' => 'Alex Gary', 'seeder_id' => '43', 'phone_number' => '020 3744 3990', 'pri_line_number' => '', 'address_street' => 'Whitechapel Road, E1 1EW', 'address_building' => '15', 'address_city' => 'London', 'address_country' => 'United Kingdom', 'addresss' => 'Whitechapel Road, E1 1EW, 15, London, United Kingdom', 'invoice_email' => 'info@johnacademy.co.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_1541078019-John Academy.png', 'logo_size' => '{"width":350,"height":200}', 'description' => '<strong>About us</strong><br /> <br /> John Academy is best known for offering awarding body accredited online courses that are available for anyone who wishes to acquire a certification and take their professional life to the next level. As an online course provider, we are aware of the fact that there are a lot of people out there who consider themselves to be very curious learners but the courses that they are interested in are not available at their convenient time and place. So, we have decided to give them a unique opportunity for them to learn and obtain necessary skills in a very convenient way at any time from anywhere.<br /> <br /> <strong>Who We Are</strong><br /> We are an online course provider who wants to make sure that the students would be able to learn everything there is a need for them to learn regarding the course that they have enrolled in on our site. So, we see to it that they would be provided with the highest possible standard of online learning. That way, students would be able to use it in the real world – the employment world and at their desired field of interests.', 'website' => 'http://www.johnacademy.co.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528976955-8-06-14 at 3.48.48 PM.png', 'video_embed_code' => '<iframe width="854" height="480" src="https://www.youtube.com/embed/O4dQ5-AK0z8" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@johnacademy.co.uk', 'contact_phone_number' => '+44 020 3744 3990', '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' => null, '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' => '2018-03-27 13:11:25', 'modified' => '2023-07-11 17:56:49', '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' => 'Converted', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2023-07-11 17:56:49', 'profile_completed_time' => '2018-03-27 13:51:32', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => '267018794', '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' => '1', 'topup_auto_renew' => '1', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '0', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1628705955_john-certi.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":352799,"r_84":502,"r_940":502,"r_615":502,"r_174":502,"r_690":502,"r_715":502,"r_82":502,"r_142":502,"r_400":502,"r_688":502,"r_80":502,"r_114":502,"r_609":502,"r_86":502,"r_193":502,"r_403":502,"r_404":502,"r_655":502,"r_85":502,"r_798":502,"r_805":502,"r_388":502,"r_83":502,"r_169":502,"r_401":502,"r_111":502,"r_17":502,"r_357":502,"r_79":502,"r_374":502,"r_682":502,"r_511":502,"r_531":502,"r_794":502,"r_730":502,"r_10":502,"r_441":502,"r_315":502,"r_848":502,"r_725":502,"r_930":502,"r_81":502,"r_126":502,"r_20":502,"r_164":502,"r_527":502,"r_332":502,"r_703":502,"r_9":502,"r_608":502,"r_673":502,"r_526":502,"r_167":502,"r_94":502,"r_181":502,"r_512":502,"r_786":502,"r_112":502,"r_122":502,"r_124":502,"r_785":502,"r_419":502,"r_589":502,"r_847":502,"r_180":502,"r_177":502,"r_21":502,"r_41":502,"r_15":502,"r_207":502,"r_206":502,"r_743":502,"r_344":502,"r_347":502,"r_143":502,"r_12":502,"r_231":502,"r_918":502,"r_362":502,"r_364":502,"r_524":502,"r_66":502,"r_541":502,"r_88":502,"r_215":502,"r_113":502,"r_254":502,"r_387":502,"r_345":502,"r_383":502,"r_666":502,"r_789":502,"r_432":502,"r_370":502,"r_146":502,"r_236":502,"r_382":502,"r_592":502,"r_253":502,"r_523":502,"r_759":502,"r_226":502,"r_125":502,"r_784":502,"r_818":502,"r_385":502,"r_811":502,"r_183":502,"r_91":502,"r_734":502,"r_819":502,"r_115":502,"r_597":502,"r_95":502,"r_809":502,"r_89":502,"r_229":502,"r_588":502,"r_726":502,"r_380":502,"r_328":502,"r_128":502,"r_243":502,"r_927":502,"r_929":502,"r_610":502,"r_596":502,"r_777":502,"r_350":502,"r_412":502,"r_204":502,"r_227":502,"r_384":502,"r_757":502,"r_439":502,"r_533":502,"r_707":502,"r_807":502,"r_394":502,"r_842":502,"r_195":502,"r_223":502,"r_932":502,"r_949":502,"r_694":502,"r_312":502,"r_656":502,"r_255":502,"r_606":502,"r_797":502,"r_820":502,"r_97":502,"r_788":502,"r_87":502,"r_198":502,"r_762":502,"r_709":502,"r_614":502,"r_221":502,"r_795":502,"r_636":502,"r_738":502,"r_351":502,"r_145":502,"r_704":502,"r_599":502,"r_740":502,"r_696":502,"r_745":502,"r_225":502,"r_658":502,"r_281":502,"r_365":502,"r_69":502,"r_499":502,"r_581":502,"r_216":502,"r_188":502,"r_361":502,"r_408":502,"r_799":502,"r_348":502,"r_389":502,"r_618":502,"r_593":502,"r_230":502,"r_395":502,"r_141":502,"r_149":502,"r_720":502,"r_391":502,"r_398":502,"r_873":502,"r_872":502,"r_393":502,"r_718":502,"r_717":502,"r_352":502,"r_60":502,"r_888":502,"r_583":502,"r_52":502,"r_335":502,"r_330":502,"r_790":502,"r_840":502,"r_27":502,"r_881":502,"r_120":502,"r_194":502,"r_731":502,"r_443":502,"r_321":502,"r_268":502,"r_272":502,"r_515":502,"r_519":502,"r_530":502,"r_222":502,"r_224":502,"r_313":502,"r_148":502,"r_652":502,"r_954":502,"r_90":502,"r_251":502,"r_411":502,"r_960":502,"r_343":502,"r_346":502,"r_528":502,"r_672":502,"r_161":502,"r_162":502,"r_318":502,"r_440":502,"r_697":502,"r_201":502,"r_14":502,"r_952":502,"r_436":502,"r_317":502,"r_668":502,"r_791":502,"r_626":502,"r_203":502,"r_955":502,"r_806":502,"r_587":502,"r_270":502,"r_665":502,"r_868":502,"r_320":502,"r_660":502,"r_375":502,"r_662":502,"r_219":502,"r_911":502,"r_516":502,"r_755":502,"r_780":502,"r_267":502,"r_776":502,"r_901":502,"r_26":502,"r_494":502,"r_611":502,"r_763":502,"r_852":502,"r_127":502,"r_620":502,"r_761":502,"r_760":502,"r_305":502,"r_607":502,"r_258":502,"r_259":502,"r_316":502,"r_950":502,"r_271":502,"r_931":502,"r_926":502,"r_232":502,"r_956":502,"r_629":502,"r_850":502,"r_823":502,"r_98":502,"r_373":502,"r_517":502,"r_601":502,"r_787":502,"r_257":502,"r_816":502,"r_256":502,"r_147":502,"r_187":502,"r_657":502,"r_214":502,"r_163":502,"r_123":502,"r_845":502,"r_199":502,"r_793":502,"r_269":502,"r_830":502,"r_234":502,"r_190":502,"r_600":502,"r_514":502,"r_724":502,"r_616":502,"r_959":502,"r_810":502,"r_197":502,"r_934":502,"r_168":502,"r_900":502,"r_851":502,"r_329":502,"r_838":502,"r_166":502,"r_638":502,"r_808":502,"r_919":502,"r_915":502,"r_196":502,"r_118":502,"r_812":502,"r_917":502,"r_671":502,"r_804":502,"r_498":502,"r_513":502,"r_792":502,"r_172":502,"r_173":502,"r_781":502,"r_242":502,"r_191":502,"r_779":502,"r_941":502,"r_944":502,"r_700":502,"r_220":502,"r_737":502,"r_319":502,"r_706":502,"r_765":502,"r_425":502,"r_705":502,"r_933":502,"r_308":502,"r_386":502,"r_912":502,"r_415":502,"r_299":502,"r_963":502,"r_844":502,"r_101":502,"r_170":502,"r_882":502,"r_96":502,"r_409":502,"r_630":502,"r_151":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '127182', 'course_id' => '98297', 'title' => 'Implementing an Advanced Server Infrastructure', 'slug' => 'upto-fourteen-hours-part-time-implementing-an-advanced-server-infrastructure-john-academy', 'external_link' => 'https://www.johnacademy.co.uk/course/70-414-implementing-an-advanced-server-infrastructure-mcse/', 'summary' => 'The 70-414 – Implementing an Advanced Server Infrastructure (MCSE) course will prepare you for the Exam 70-414: Implementing an Advanced Server Infrastructure.<br /> The course covers the advanced topics that IT professionals encounter in the enterprise environment. For passing the exam, you should have a thorough understanding of a fundamental server infra¬structure including monitoring, virtualisation, and high availability.<br /> There are four main objective areas on the 70-414 Exam which are discussed in the course thoroughly:<br /> Manage and maintain a server infrastructure<br /> Plan and implement a highly available enterprise infrastructure<br /> Plan and implement a server virtualisation infrastructure<br /> Design and implement identity and access solutions<br /> In the course, you will learn how to create the virtual infrastructure, plan and deploy virtual machines and implement solutions for the virtual administration. You will also learn about monitoring, high availability, updates, PKI, BCP and IDA. In short, the course will prepare you for the exam.<br /> <br /> <strong>COURSE CURRICULUM</strong><br /> <br /> <strong>Creating the Virtualization Infrastructure</strong> <ul> <li>Introducing Microsoft System Center 2012 Components</li> <li>Using System Center for Virtualization</li> <li>Using the VMM Management Console</li> <li>Planning a VMM Deployment</li> <li>Creating the Virtualization Host</li> <li>Configuring Host Groups</li> <li>Working with Libraries</li> <li>Storage Infrastructure</li> <li>Configuring a Storage Infrastructure for Virtualization</li> <li>Confituring Storage in VMM</li> <li>Network Infrastructure for Virtualization</li> <li>Configuring Virtual Networking</li> <li>Configuring Virtual Networks in VMM</li> </ul> <strong>Planning and Deploying Virtual Machines</strong> <ul> <li>Considerations for Virtual Machine Setup</li> <li>Planning Virtual Machine Deployment with VMM</li> <li>How to Deploy a Virtual Machine</li> </ul> <strong>Monitoring</strong> <ul> <li>Monitoring in Windows Server 2012</li> <li>Enabling and Viewing Resource Metering Data C3TAD1</li> <li>Introduction to Operations Manager</li> <li>Management Packs</li> <li>Notifications and Reporting</li> <li>Integration with VMM</li> </ul> <strong>Solution for the Virtualization Administration</strong> <ul> <li>System Center 2012 Administration</li> <li>Delegated Administration</li> <li>Automation with System Center 2012</li> <li>VMM Private Clouds</li> </ul> <strong>High Availability</strong> <ul> <li>Storage Spaces</li> <li>RAID</li> <li>NLB</li> <li>The Infrastructure for Failover Clustering</li> <li>Defining Failover Clustering</li> <li>Integrating Failover Clustering with Server Virtualization</li> <li>Multisite Planning a Multisite Failover Cluster</li> </ul> <strong>PKI</strong> <ul> <li>The Certificate Authority</li> <li>Certificate Templates</li> <li>Overview of Certificate Services</li> <li>CRL</li> <li>Key Archival</li> </ul> <strong>Updates</strong> <ul> <li>WSUS Deployment</li> <li>WSUS</li> <li>Using Configuration Manager 2012</li> <li>Updating Virtualization</li> </ul> <strong>BCP</strong> <ul> <li>BCP</li> <li>Backups</li> <li>Windows Backup Utility</li> <li>Recovery</li> <li>Backup and Recovery of VMs</li> </ul> <strong>IDA</strong> <ul> <li>Planning and Implementing an AD FS Server Infrastructure</li> <li>Planning and Implementing AD FS Claims Providers and Relying Parties</li> <li>Planning and Implementing AD FS Claims and Claim Rules</li> <li>Planning and Implementing an AD RMS Cluster</li> <li>Installing an AD RMS Cluster</li> <li>Planning and Implementing AD RMS Templates and Policies</li> <li>Planning and Implementing External Access to AD RMS Services</li> <li>Planning and Implementing AD RMS Integration with DAC</li> </ul> ', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Server Consultant,Manager IT Infrastructure,IT infrastructure engineer', 'eligibility' => 'Our 70-414 – Implementing an Advanced Server Infrastructure (MCSE) is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.', 'school' => 'John Academy', 'keywords' => 'Sqlserver,SQL,Microsoft', 'location' => 'Online', 'duration' => 'Upto 14 Hours', 'timing' => 'Flexible', 'cost' => null, 'discount' => '95% off through Laimoon!', 'eligibility_criteria' => null, 'job_matching_keywords' => null, 'boosted' => '0', 'lang_code' => 'en', 'status' => 'active', 'auto_translated' => '0', 'objectives' => null, 'photo' => null, 'photo_cta' => null, 'video' => null ), 'Profile' => array() ) ) $job = array( 'Job' => array( 'id' => '43108239', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'SQL Developer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<h2> Job Description </h2><p> As a SQL Developer, you will play a vital role in developing, implementing, and maintaining database solutions. You will be responsible for writing efficient SQL queries, designing and optimizing database structures, and collaborating with cross-functional teams to ensure seamless data integration and availability. This role requires a strong understanding of relational databases, excellent SQL programming skills, and the ability to work with large datasets.Key Responsibilities:Develop and optimize SQL queries to extract, manipulate, and analyze data from relational databases.Design, implement, and maintain database structures, tables, and relationships to ensure efficient data storage and retrieval.Collaborate with software developers, data analysts, and business stakeholders to understand data requirements and translate them into effective database solutions.Perform data validation, cleansing, and transformation to ensure data integrity and accuracy.Identify and resolve performance issues in SQL queries and database operations to optimize query execution time and overall database performance.Create and maintain database documentation, including data dictionaries, schema diagrams, and query optimization strategies.Collaborate with the IT team to ensure proper backup, recovery, and security measures are in place for databases.Stay up-to-date with emerging trends and advancements in SQL development and database technologies.Participate in code reviews and provide constructive feedback to improve code quality and maintainability.Troubleshoot and resolve database-related issues, including data corruption, connectivity problems, and performance bottlenecks.Qualifications and Skills:Bachelor's degree in Computer Science, Information Technology, or a related field.Minimum of 5 years of professional experience as a SQL Developer or similar role.Outstanding English communication, both verbal and non-verbal.Proven experience as a SQL Developer or similar role, working with relational databases.Strong proficiency in SQL programming, including complex queries, stored procedures, and query optimization techniques.Solid understanding of database concepts, data modeling, and normalization principles.Experience with database management systems such as Microsoft SQL Server, Oracle, or MySQL.Familiarity with ETL (Extract, Transform, Load) processes and tools.Knowledge of database performance tuning and optimization techniques.Strong problem-solving skills and attention to detail.Excellent communication and collaboration abilities to work effectively within a team environment.Familiarity with data visualization and reporting tools (e.g., Tableau, Power BI) is a plus. </p>', 'course_qualifications' => null, 'global_location_id' => '64', 'gender' => '0', 'baseSalary' => null, 'salary_duration' => 'Monthly', 'job_type' => 'Full time', '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' => '52091', 'company_name' => 'Capgemini', 'external_apply_url' => 'https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=3281ee33432858cc0e6a191118534a7a', 'external_short_url' => '8076885717139120247', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-04-20 03:28:20', 'published' => '2024-04-20 03:28:20', 'closed_time' => null, 'updated' => '2024-04-20 03:28:20', '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' => '113', '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' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ), 'Company' => array( 'id' => '52091', 'name' => 'Capgemini', 'website' => 'https://www.capgemini.com/in-en/', 'verified' => '0', 'photo' => 'Capgemini_e08058a0-f1f5-11e9-bbf3-15f76e7ed41e.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ) $jobsList = array() $courses = array() $promotedCourses = array() $referer = '/' $urlKeyword = 'SQL ' $profile = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '12299', 'contributedJobCount' => '24', 'courseCount' => null ) $askLogin = true $jobLinkTitle = 'SQL ' $renderSchema = 'yes' $title_for_layout = 'SQL Developer jobs in Capgemini in Egypt.' $page_description = 'Apply to SQL Developer jobs in Capgemini in Egypt.Find similar vacancies, jobs and salary information in Egypt.' $locationForTitle = 'Egypt' $currentJobCity = array( 'id' => '64', 'display_name' => 'Egypt', 'name_ar' => 'مصر', 'country_id' => '61', 'Country' => array( 'name' => 'Egypt', 'id' => '61', 'slug' => 'egypt', 'code' => 'EG' ) ) $jobCompanyPage = array( 'CompanyPage' => array( 'id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '28520', 'company_page_id' => '28538', 'title' => 'Capgemini', 'slug' => 'capgemini', 'summary' => null, 'description' => 'A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize', 'meta_title' => 'Jobs from Capgemini', 'meta_description' => 'Jobs from Capgemini', 'meta_keywords' => 'Jobs from Capgemini', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ) $location = 'Egypt' $breadCrumbs = array( 'Job Details' => '' ) $relCourseBanner = array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management/sql-server', 'title' => 'SQL Server', 'course_category_id' => (int) 395, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management/sql-server' ) $published = '2024-04-20 03:28:20' $daysleft = (float) 16 $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/egypt/SQL ' $csaKeywords = array( (int) 0 => 'SQL Developer' ) $allowLoginClass = 'notlogin' $jobLocSlug = 'egypt' $jobLocName = 'Egypt' $pfBackgrounds = '' $jobLink = 'https://jobs.laimoon.com/jobs/externalview/43108239' $companyName = ' at Capgemini' $twitterText = 'Hiring now! SQL Developer at Capgemini. Please apply or share https://jobs.laimoon.com/jobs/externalview/43108239' $emailText = 'Hiring now! SQL Developer at Capgemini. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/43108239' $sCompanyName = false $csaSearchKey = 'SQL Developer' $jobDetails = 'job details' $btn_text = 'Apply on company website' $confidentialExists = false $showCompany = (int) 1 $mainCheck = (int) 1 $confidentialThumbClass = '' $cdnImageThumbPath = 'https://cdn.laimoon.com/profileimages/thumbnail/' $companyPageTitle = 'Capgemini'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
Hiring company
Capgemini
Improve your chance to get this job.
Do an online course on SQL Server starting now.
-
MCSA Windows Server 2016 (70-740) Lead AcademyAED 92
AED 1,432Duration: Upto 6 Hours -
Implementing an Advanced Server Infrastructure John AcademyAED 249
AED 5,289Duration: Upto 14 Hours
X
Why are you reporting this job?
Job has expired Cannot view this pageAlternatively, you may click on the link below or copy/paste it into your browser.
https://eg.jooble.org/external/8076885717139120247?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_eg&extra_ars_request_id=3281ee33432858cc0e6a191118534a7a