Job details
Allgemeine Angaben
Bewerbungsfrist21-Apr-2024
Standort
Ortigas Center
Land
Philippinen
Job Kategorien
Support Positions
Work Style
Hybrid
Jobbeschreibung
Position Summary The Database Administration Engineer is responsible for installation, maintenance and support of miscellaneous database platforms to ensure the operation of global systems in order to provide performance and availability for its users, such as staff, customers and suppliers. Including teams within Information Technology, Information Systems, and others. Functional Responsibilities ● Responsible for providing, planning, conducting and directing the analysis of complex business initiatives that require a Database to be actioned upon. ● Provide technical support and resolve requests around the Database Admin technology verticals. ● Work hand in hand with other technology teams to provide solutions to end user needs. ● Documentation and Implementation of Standard and Normal Changes, as well as support on Emergency Changes. ● Work along other teams to plan and deploy patches and or upgrades to the Database Management Systems environments. ● Perform peer reviews for Method of Procedure and enforce Policies and standardization. ● Perform TELUS International Database Assessments that include but are not limited to: Administration, deployment, configuration and recovery of DBMS. ● Perform Database Inventorying and documentation. ● Implement and enforce Database Best practices, least privileged access models, Backup and Recovery practices. ● Database Monitoring and tune up: sessions, locks, peaks, io, waits, etc. ● HADR failover and management for different DBMS. ● Provides Support to Global Security Audits acting as POC from IT Database Administration Team within the Auditor Interviews and evidence asks. ● Collaborate with Engineering New Client Launches and/or new technology projects, enabling new business and features. ● Become the link and facilitator of implementations and deployment of applications related to several different teams including Artificial Intelligence, DataWareHouse, Business Intelligence, Machine Learning, Information System Developments, etc. ● Perform other project related duties as requested by management. Zusätzliche StellenbeschreibungRequired Experience, Education, Skills & Competencies: Specific Qualifications: ○ Miscellaneous Operating system knowledge and practice background within Databases scope. ○ Strong skills in Miscellaneous DBMS and SQL Language ■ MSSQL 2005 - 2019 | MySQL 5.0 - 8 | PostgreSQL ■ Cloud Technologies (GCP | AWS | Azure)■ DevOps Knowhow (Kubernetes | Docker | etc)■ NoSQL (Riak/Redis/MongoDB)■ SQL Development ○ Common troubleshooting knowledge and debugging for multi-tiered architecture. ○ Powershell Scripting, Bash Shell Scripting, Python Scripting. ○ General Knowledge of Programming Language and their interaction with DBs. Skills ○ Teamwork and Remote Work skills. ○ Ability to respond to External & Internal requests ○ Fast adaptation to technology changes ○ Schedule Flexibility (including On Call Shift Rotation) Education/Experience and Knowledge ○ MCSA SQL - Microsoft Certified Solutions Associate (desirable)○ Experience handling multi tiered Database Solutions ○ Experience in Microsoft Windows and Linux. ○ Knowledge in Cloud interaction in any of these technologies: GCP, Azure, AWS. ○ Minimum of 1 year experience in a DBA/DevOps development role. ○ Amenable to work at TELUS Ortigas. EEO Statement
At TELUS International, we enable customer experience innovation through spirited teamwork, agile thinking, and a caring culture that puts customers first. TELUS International is the global arm of TELUS Corporation, one of the largest telecommunications service providers in Canada. We deliver contact center and business process outsourcing (BPO) solutions to some of the world's largest corporations in the consumer electronics, finance, telecommunications and utilities sectors. With global call center delivery capabilities, our multi-shore, multi-language programs offer safe, secure infrastructure, value-based pricing, skills-based resources and exceptional customer service - all backed by TELUS, our multi-billion dollar telecommunications parent. Equal Opportunity Employer At TELUS International, we are proud to be an equal opportunity employer and are committed to creating a diverse and inclusive workplace. All aspects of employment, including the decision to hire and promote, are based on applicants’ qualifications, merits, competence and performance without regard to any characteristic related to diversity. Ref Number
Req_00127315
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' => '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' ), 'cityLists' => array( (int) 0 => array( 'name' => 'Dubai', 'slug' => 'dubai' ), (int) 1 => array( 'name' => 'Abu Dhabi', 'slug' => 'abu-dhabi' ), (int) 2 => array( 'name' => 'Ras al Khaimah', 'slug' => 'ras-al-khaimah' ), (int) 3 => array( 'name' => 'Al Ain', 'slug' => 'al-ain' ), (int) 4 => array( 'name' => 'Sharjah', 'slug' => 'sharjah' ), (int) 5 => array( 'name' => 'Fujairah', 'slug' => 'fujairah' ), (int) 6 => array( 'name' => 'Ajman', 'slug' => 'ajman' ), (int) 7 => array( 'name' => 'Umm Al Quwain', 'slug' => 'umm-al-quwain' ) ), 'menuState' => 'loggedoutmenu', 'showCVReviewLink' => true, 'profileInfo' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '11156', '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' => '43517323', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'Database Engineer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<p><p><h3>Allgemeine Angaben </h3><p><p>Bewerbungsfrist </p><p>21-Apr-2024 </p><p><p>Standort </p><p>Ortigas Center </p><p><p>Land </p><p>Philippinen </p><p><p>Job Kategorien </p><p>Support Positions </p><p><p>Work Style </p><p>Hybrid </p><p><h3>Jobbeschreibung </h3><p><p><b> Position Summary </b></p><p></p><p> The Database Administration Engineer is responsible for installation, maintenance and support of miscellaneous database platforms to ensure the operation of global systems in order to provide performance and availability for its users, such as staff, customers and suppliers. Including teams within Information Technology, Information Systems, and others. </p><p></p><p></p><p><b> Functional Responsibilities </b></p><p></p><p>● Responsible for providing, planning, conducting and directing the analysis of complex business </p><p> initiatives that require a Database to be actioned upon. </p><p>● Provide technical support and resolve requests around the Database Admin technology </p><p> verticals. </p><p>● Work hand in hand with other technology teams to provide solutions to end user needs. </p><p>● Documentation and Implementation of Standard and Normal Changes, as well as support on </p><p> Emergency Changes. </p><p>● Work along other teams to plan and deploy patches and or upgrades to the Database </p><p> Management Systems environments. </p><p>● Perform peer reviews for Method of Procedure and enforce Policies and standardization. </p><p>● Perform TELUS International Database Assessments that include but are not limited to: </p><p> Administration, deployment, configuration and recovery of DBMS. </p><p>● Perform Database Inventorying and documentation. </p><p>● Implement and enforce Database Best practices, least privileged access models, Backup and </p><p> Recovery practices. </p><p>● Database Monitoring and tune up: sessions, locks, peaks, io, waits, etc. </p><p>● HADR failover and management for different DBMS. </p><p>● Provides Support to Global Security Audits acting as POC from IT Database Administration </p><p> Team within the Auditor Interviews and evidence asks. </p><p>● Collaborate with Engineering New Client Launches and/or new technology projects, enabling </p><p> new business and features. </p><p>● Become the link and facilitator of implementations and deployment of applications related to </p><p> several different teams including Artificial Intelligence, DataWareHouse, Business Intelligence, </p><p> Machine Learning, Information System Developments, etc. </p><p>● Perform other project related duties as requested by management. </p><p><p><p>Zusätzliche Stellenbeschreibung </p><p><p><b> Required Experience, Education, Skills & Competencies: </b></p><p></p><p><b> Specific Qualifications: </b></p><p></p><p>○ Miscellaneous Operating system knowledge and practice background within Databases </p><p> scope. </p><p>○ Strong skills in Miscellaneous DBMS and SQL Language </p><p>■ MSSQL 2005 - 2019 | MySQL 5.0 - 8 | PostgreSQL </p><p>■ Cloud Technologies (GCP | AWS | Azure)</p><p>■ DevOps Knowhow (Kubernetes | Docker | etc)</p><p>■ NoSQL (Riak/Redis/MongoDB)</p><p>■ SQL Development </p><p>○ Common troubleshooting knowledge and debugging for multi-tiered architecture. </p><p>○ Powershell Scripting, Bash Shell Scripting, Python Scripting. </p><p>○ General Knowledge of Programming Language and their interaction with DBs. </p><p></p><p><b> Skills </b></p><p></p><p>○ Teamwork and Remote Work skills. </p><p>○ Ability to respond to External & Internal requests </p><p>○ Fast adaptation to technology changes </p><p>○ Schedule Flexibility (including On Call Shift Rotation)</p><p></p><p><b> Education/Experience and Knowledge </b></p><p></p><p>○ MCSA SQL - Microsoft Certified Solutions Associate (desirable)</p><p>○ Experience handling multi tiered Database Solutions </p><p>○ Experience in Microsoft Windows and Linux. </p><p>○ Knowledge in Cloud interaction in any of these technologies: GCP, Azure, AWS. </p><p>○ Minimum of 1 year experience in a DBA/DevOps development role. </p><p>○ Amenable to work at TELUS Ortigas. </p><p><p>EEO Statement </p><p><p> At TELUS International, we enable customer experience innovation through spirited teamwork, agile thinking, and a caring culture that puts customers first. TELUS International is the global arm of TELUS Corporation, one of the largest telecommunications service providers in Canada. We deliver contact center and business process outsourcing (BPO) solutions to some of the world's largest corporations in the consumer electronics, finance, telecommunications and utilities sectors. With global call center delivery capabilities, our multi-shore, multi-language programs offer safe, secure infrastructure, value-based pricing, skills-based resources and exceptional customer service - all backed by TELUS, our multi-billion dollar telecommunications parent. </p><p> Equal Opportunity Employer </p><p> At TELUS International, we are proud to be an equal opportunity employer and are committed to creating a diverse and inclusive workplace. All aspects of employment, including the decision to hire and promote, are based on applicants’ qualifications, merits, competence and performance without regard to any characteristic related to diversity. </p><p><p>Ref Number </p><p>Req_00127315 </p>', 'course_qualifications' => null, 'global_location_id' => '275', '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' => '89202', 'company_name' => 'TELUS International', 'external_apply_url' => 'https://ph.jooble.org/external/-7394677023437785072?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_ph&extra_ars_request_id=0efe1adafdb02519276988de17d55ba1', 'external_short_url' => '7394677023437785072', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-05-08 03:41:58', 'published' => '2024-05-08 03:41:58', 'closed_time' => null, 'updated' => '2024-05-08 03:41:58', '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' => '275', 'display_name' => 'Online', 'name_ar' => null, 'country_id' => '250', 'Country' => array( [maximum depth reached] ) ), 'Company' => array( 'id' => '89202', 'name' => 'telus international', 'website' => 'https://www.telusinternational.com/', 'verified' => '0', 'photo' => 'TELUS_International_cea0e7d0-edd5-11ea-a204-752b08f7e4cd.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ), 'jobsList' => array(), 'courses' => array(), 'promotedCourses' => array(), 'referer' => '/', 'urlKeyword' => 'Database ', 'profile' => array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '11156', 'contributedJobCount' => '24', 'courseCount' => null ), 'askLogin' => true, 'jobLinkTitle' => 'Database ', 'renderSchema' => 'yes', 'title_for_layout' => 'Database Engineer jobs in telus international in Online.', 'page_description' => 'Apply to Database Engineer jobs in telus international in Online.Find similar vacancies, jobs and salary information in Online.', 'locationForTitle' => 'Online', 'currentJobCity' => array( 'id' => '275', 'display_name' => 'Online', 'name_ar' => null, 'country_id' => '250', 'Country' => array( 'name' => 'Online', 'id' => '250', 'slug' => 'online', 'code' => 'ON' ) ), 'jobCompanyPage' => array( 'CompanyPage' => array( 'id' => '71220', 'title' => 'telus international', 'slug' => 'telus-international', 'description' => 'At TELUS International, we focus on the human connection to deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. <br><br>TELUS International focuses on the value of human connection to design, build and deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. With over 50,000 team members', 'meta_title' => 'Jobs from telus international', 'meta_description' => 'Jobs from telus international', 'meta_keywords' => 'Jobs from telus international', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '71202', 'company_page_id' => '71220', 'title' => 'telus international', 'slug' => 'telus-international', 'summary' => null, 'description' => 'At TELUS International, we focus on the human connection to deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. <br><br>TELUS International focuses on the value of human connection to design, build and deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. With over 50,000 team members', 'meta_title' => 'Jobs from telus international', 'meta_description' => 'Jobs from telus international', 'meta_keywords' => 'Jobs from telus international', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ), 'location' => 'Online', 'breadCrumbs' => array( 'Job Details' => '' ), 'relCourseBanner' => array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management', 'title' => 'Database Management', 'course_category_id' => (int) 394, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management' ), 'published' => '2024-05-08 03:41:58', 'daysleft' => (float) 15, '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' => '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' ) $cityLists = array( (int) 0 => array( 'name' => 'Dubai', 'slug' => 'dubai' ), (int) 1 => array( 'name' => 'Abu Dhabi', 'slug' => 'abu-dhabi' ), (int) 2 => array( 'name' => 'Ras al Khaimah', 'slug' => 'ras-al-khaimah' ), (int) 3 => array( 'name' => 'Al Ain', 'slug' => 'al-ain' ), (int) 4 => array( 'name' => 'Sharjah', 'slug' => 'sharjah' ), (int) 5 => array( 'name' => 'Fujairah', 'slug' => 'fujairah' ), (int) 6 => array( 'name' => 'Ajman', 'slug' => 'ajman' ), (int) 7 => array( 'name' => 'Umm Al Quwain', 'slug' => 'umm-al-quwain' ) ) $menuState = 'loggedoutmenu' $showCVReviewLink = true $profileInfo = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '11156', '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' => '144961', 'seeder_id' => '43', 'edited_seeder_id' => '43', 'edited_client_id' => null, 'title' => 'Certificate in Database Management Systems (DBMS)', 'external_link' => 'https://www.vskills.in/certification/dbms-database-management-systems-certificate', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => null, 'next_session' => null, 'schedules' => null, 'duration' => '1 To 2 Months', 'base_duration' => '0', 'timing' => 'Flexible', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Vskills', 'logo' => null, 'certificate_diploma' => 'yes', 'image' => null, 'brochure_url' => null, 'video' => null, 'cost' => null, 'price' => '3499', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '42', 'nondiscounted_base_price' => null, 'currency' => 'INR', 'discount' => '50% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<br /> DBMS or Database Management Systems is an appliocation software for management of data as per its representational model. Due to immense growth in data there is an continous and increasing need for DBMS professionals to manage data.<br /> <br /> <strong>Why should one take this certification?</strong><br /> DBMS or Database Management Systems have become an integral part of IT systems and companies rely on DBMS for their operational and strategic needs. The Certificate in Database Management Systems (DBMS) is suitable for professionals and graduates wh want to stand out amongst their peers in skills and knowledge on DBMS.<br /> <br /> The certification covers <ul> <li>DBMS Basics</li> <li>Data Modeling</li> <li>Relational Data Model</li> <li>Data Storage and DBMS File Structure</li> <li>Transaction And Concurrency</li> <li>Backup and Recovery</li> <li>Various DBMS (open source, commercial, cloud-based and No SQL)</li> </ul> <strong>Who will benefit from taking this certification?</strong><br /> The certification is suitable for administrators, system admins, IT admins and professionals engaged in database support. The certification is of immense benefit to professionals in IT management or administration department especially senior executives and managerial cadre candidates, to increase and demonstrate their skills in Database Management Systems (DBMS).<br /> <br /> <strong>Benefits of Certification</strong> <ul> <li><strong>Government certification</strong></li> <li>Certification valid for life</li> <li>Lifelong e-learning access</li> <li>Learning Hours: 12+ hrs</li> </ul> <br /> <strong>How It Works</strong> <ol> <li>Select Certification & Register</li> <li>Receive Online e-Learning Access (LMS)</li> <li>Take exam online anywhere, anytime</li> <li>Get certified & Increase Employability</li> </ol> <strong>Test Details</strong> <ul> <li>Duration: 60 minutes</li> <li>No. of questions: 50</li> <li>Maximum marks: 50, Passing marks: 25 (50%).</li> <li>There is NO negative marking in this module.</li> <li>Online exam.</li> </ul> <br /> <strong>TABLE OF CONTENT</strong><br /> <br /> <strong>DBMS Basics</strong> <ul> <li>What is a Data?</li> <li>What is a Database?</li> <li>What is DBMS or Database Management System?</li> <li>DBMS vs RDBMS vs File System</li> <li>Client/Server Basics</li> <li>DBMS Architecture</li> <li>Data Models</li> <li>Data Schemas</li> <li>Data Independence</li> <li>ACID Property</li> </ul> <strong>Data Modeling</strong> <ul> <li>Entity Relationship (E-R) Model</li> <li>DBMS Keys</li> <li>Mapping Constraints</li> <li>DBMS Generalization</li> <li>DBMS Aggregation</li> <li>ER Diagram Representation</li> </ul> <strong>Relational Data Model</strong> <ul> <li>Relational Data Model</li> <li>Codd's Rules for RDBMS</li> <li>Relational Algebra</li> <li>Relational Calculus</li> <li>Integrity Constraints</li> <li>ER to Relational Model</li> </ul> <strong>Relational Database Design</strong> <ul> <li>Dependency (Functional and Multivalued)</li> <li>DBMS Normalization</li> <li>DBMS Normal Forms (1NF to 5NF)</li> <li>Database Joins</li> </ul> <strong>Data Storage and DBMS File Structure</strong> <ul> <li>File Organization (Sequential, Heap, Hash and B+)</li> <li>DBMS ISAM</li> </ul> <strong>Indexing and Hashing</strong> <ul> <li>DBMS Indexing</li> <li>Static and Dynamic Hashing</li> </ul> <strong>Transaction Processing</strong> <ul> <li>Transaction Processing</li> <li>Serializability</li> <li>Recoverability</li> <li>Log-Based Recovery</li> <li>DBMS Checkpoint</li> <li>Deadlock in DBMS</li> </ul> <strong>Concurrency Control</strong> <ul> <li>Concurrency Control Protocols</li> <li>Multiple Granularity</li> </ul> <strong>Backup and Recovery</strong> <ul> <li>Data Backup</li> <li>Data Recovery</li> <li>RAID</li> </ul> <strong>SQL</strong> <ul> <li>SQL Datatype</li> <li>SQL Commands, Operators and Statements</li> <li>SQL Clauses</li> <li>SQL Aggregate Function</li> <li>SQL JOIN</li> <li>SQL Set Operation</li> <li>SQL Query Processing</li> </ul> <strong>Open Source DBMS</strong> <ul> <li>MySQL</li> <li>PostgreSQL</li> </ul> <strong>Commercial DBMS</strong> <ul> <li>Microsoft Access</li> <li>Microsoft SQL Server</li> <li>Oracle</li> </ul> <strong>NoSQL or Big Data DBMS</strong> <ul> <li>Cassandra</li> <li>HBase</li> <li>MongoDB</li> <li>CouchDB</li> </ul> <strong>Cloud DBMS</strong> <ul> <li>AWS</li> <li>GCP</li> <li>Micrososft Azure</li> </ul> ', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Anyone can apply for the online certification', 'about_school' => null, 'keywords' => 'Database,Data Science,Database Management Systems,DBMS,Big data', 'job_matching_keywords' => null, 'instructor_bio' => null, 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '954,597,394', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '5788', 'trainer_ids' => null, 'created' => '2023-12-27 12:11:19', 'updated' => '2023-12-27 13:19:03', 'sort_order' => null, 'page' => 'JobListing', 'to_emails' => 'info@vskills.in', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '0', 'status' => 'active', 'collect_mode' => 'provider_verified', 'slug' => 'part-time-certificate-in-database-management-systems-dbms-vskills', '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' => null, 'accreditation_logos' => null, 'invoice_type' => 'CPC', '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' => null, 'delivery_languages' => 'en', 'career_path' => 'DATABASE ADMINISTRATOR,Data Analyst,Project Manager', 'rank' => null, 'resized' => '0', 'ctr' => '100.000', 'laimoon_rank' => '{"default":3500,"65240_en_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => null, 'cpa_recommended' => null, 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99984828', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '5788', 'name' => 'Vskills', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => null, 'location' => null, 'customer_name' => 'Rajat Kakkar', 'seeder_id' => '43', 'phone_number' => '47344723', 'pri_line_number' => '', 'address_street' => '711, Tower-2, ', 'address_building' => 'Pearls Omaxe, Netaji Subhash Place,', 'address_city' => 'Delhi', 'address_country' => 'India', 'addresss' => '711, Tower-2, , Pearls Omaxe, Netaji Subhash Place,, Delhi, India', 'invoice_email' => 'info@vskills.in', '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' => null, 'intl_leads_enabled' => '0', 'invoice_notification' => '1', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1469622248-vskills-logo.jpg', 'logo_size' => '{"width":118,"height":82}', 'description' => null, 'website' => 'http://www.vskills.in/certification/', 'no_of_courses' => null, 'course_types' => 'Online/Distance education,Professional qualifications,Professional short courses,Corporate training', 'spotlight' => null, 'video_thumb' => null, 'video_embed_code' => '', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@vskills.in', 'contact_phone_number' => '+971 47344723', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:3;s:12:"total_points";i:3;s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => 'Yes', 'instant_callback_disabled' => '0', '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' => '2016-07-22 09:38:49', 'modified' => '2023-12-14 14:30:13', 'pageview_enabled' => '1', 'timezone' => 'Asia/Kolkata', 'provider_status' => 'performance', 'cpc_direct_linking' => 'no', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => '{"ProfileCompleted":1,"B&WCourses":"254"}', 'verified_time' => '2023-10-26 16:45:07', 'profile_completed_time' => null, 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => null, 'course_type_ids' => '2', 'trusted' => '1', 'legacy' => '0', 'moderation_status' => 'trusted', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '0', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1560255278_vskills-ce.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":625221,"r_82":502,"r_145":502,"r_737":502,"r_894":502,"r_79":502,"r_375":502,"r_662":502,"r_97":502,"r_95":502,"r_98":502,"r_14":502,"r_952":502,"r_142":502,"r_143":502,"r_400":502,"r_369":502,"r_383":502,"r_666":502,"r_86":502,"r_197":502,"r_20":502,"r_388":502,"r_87":502,"r_203":502,"r_80":502,"r_119":502,"r_15":502,"r_365":502,"r_361":502,"r_21":502,"r_115":502,"r_111":502,"r_17":502,"r_281":502,"r_12":502,"r_237":502,"r_399":502,"r_350":502,"r_398":502,"r_873":502,"r_653":502,"r_394":502,"r_9":502,"r_101":502,"r_323":502,"r_10":502,"r_607":502,"r_81":502,"r_123":502,"r_690":502,"r_146":502,"r_148":502,"r_381":502,"r_539":502,"r_364":502,"r_799":502,"r_206":502,"r_42":502,"r_114":502,"r_596":502,"r_536":502,"r_199":502,"r_422":502,"r_808":502,"r_112":502,"r_613":502,"r_84":502,"r_174":502,"r_401":502,"r_85":502,"r_177":502,"r_231":502,"r_187":502,"r_180":502,"r_918":502,"r_538":502,"r_738":502,"r_694":502,"r_597":502,"r_695":502,"r_963":502,"r_196":502,"r_194":502,"r_193":502,"r_652":502,"r_954":502,"r_599":502,"r_348":502,"r_752":502,"r_236":502,"r_188":502,"r_202":502,"r_88":502,"r_221":502,"r_219":502,"r_127":502,"r_124":502,"r_785":502,"r_955":502,"r_216":502,"r_215":502,"r_373":502,"r_370":502,"r_603":502,"r_351":502,"r_609":502,"r_610":502,"r_195":502,"r_192":502,"r_691":502,"r_890":502,"r_234":502,"r_267":502,"r_387":502,"r_173":502,"r_433":502,"r_113":502,"r_779":502,"r_689":502,"r_897":502,"r_214":502,"r_205":502,"r_681":502,"r_118":502,"r_66":502,"r_254":502,"r_253":502,"r_641":502,"r_403":502,"r_204":502,"r_207":502,"r_807":502,"r_898":502,"r_83":502,"r_758":502,"r_899":502,"r_149":502,"r_688":502,"r_809":502,"r_380":502,"r_730":502,"r_395":502,"r_726":502,"r_871":502,"r_887":502,"r_126":502,"r_891":502,"r_344":502,"r_911":502,"r_164":502,"r_498":502,"r_513":502,"r_161":502,"r_43":502,"r_210":502,"r_266":502,"r_810":502,"r_191":502,"r_646":502,"r_668":502,"r_151":502,"r_443":502,"r_432":502,"r_926":502,"r_419":502,"r_589":502,"r_847":502,"r_541":502,"r_705":502,"r_255":502,"r_697":502,"r_678":502,"r_436":502,"r_198":502,"r_362":502,"r_211":502,"r_345":502,"r_686":502,"r_346":502,"r_956":502,"r_347":502,"r_201":502,"r_420":502,"r_200":502,"r_826":502,"r_232":502,"r_700":502,"r_147":502,"r_406":502,"r_693":502,"r_888":502,"r_585":502,"r_382":502,"r_592":502,"r_128":502,"r_396":502,"r_860":502,"r_857":502,"r_424":502,"r_384":502,"r_89":502,"r_638":502,"r_514":502,"r_949":502,"r_916":502,"r_99":502,"r_178":502,"r_608":502,"r_439":502,"r_217":502,"r_960":502,"r_91":502,"r_261":502,"r_259":502,"r_734":502,"r_225":502,"r_696":502,"r_229":502,"r_731":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '222453', 'course_id' => '144961', 'title' => 'Certificate in Database Management Systems (DBMS)', 'slug' => 'part-time-certificate-in-database-management-systems-dbms-vskills', 'external_link' => 'https://www.vskills.in/certification/dbms-database-management-systems-certificate', 'summary' => '<br /> DBMS or Database Management Systems is an appliocation software for management of data as per its representational model. Due to immense growth in data there is an continous and increasing need for DBMS professionals to manage data.<br /> <br /> <strong>Why should one take this certification?</strong><br /> DBMS or Database Management Systems have become an integral part of IT systems and companies rely on DBMS for their operational and strategic needs. The Certificate in Database Management Systems (DBMS) is suitable for professionals and graduates wh want to stand out amongst their peers in skills and knowledge on DBMS.<br /> <br /> The certification covers <ul> <li>DBMS Basics</li> <li>Data Modeling</li> <li>Relational Data Model</li> <li>Data Storage and DBMS File Structure</li> <li>Transaction And Concurrency</li> <li>Backup and Recovery</li> <li>Various DBMS (open source, commercial, cloud-based and No SQL)</li> </ul> <strong>Who will benefit from taking this certification?</strong><br /> The certification is suitable for administrators, system admins, IT admins and professionals engaged in database support. The certification is of immense benefit to professionals in IT management or administration department especially senior executives and managerial cadre candidates, to increase and demonstrate their skills in Database Management Systems (DBMS).<br /> <br /> <strong>Benefits of Certification</strong> <ul> <li><strong>Government certification</strong></li> <li>Certification valid for life</li> <li>Lifelong e-learning access</li> <li>Learning Hours: 12+ hrs</li> </ul> <br /> <strong>How It Works</strong> <ol> <li>Select Certification & Register</li> <li>Receive Online e-Learning Access (LMS)</li> <li>Take exam online anywhere, anytime</li> <li>Get certified & Increase Employability</li> </ol> <strong>Test Details</strong> <ul> <li>Duration: 60 minutes</li> <li>No. of questions: 50</li> <li>Maximum marks: 50, Passing marks: 25 (50%).</li> <li>There is NO negative marking in this module.</li> <li>Online exam.</li> </ul> <br /> <strong>TABLE OF CONTENT</strong><br /> <br /> <strong>DBMS Basics</strong> <ul> <li>What is a Data?</li> <li>What is a Database?</li> <li>What is DBMS or Database Management System?</li> <li>DBMS vs RDBMS vs File System</li> <li>Client/Server Basics</li> <li>DBMS Architecture</li> <li>Data Models</li> <li>Data Schemas</li> <li>Data Independence</li> <li>ACID Property</li> </ul> <strong>Data Modeling</strong> <ul> <li>Entity Relationship (E-R) Model</li> <li>DBMS Keys</li> <li>Mapping Constraints</li> <li>DBMS Generalization</li> <li>DBMS Aggregation</li> <li>ER Diagram Representation</li> </ul> <strong>Relational Data Model</strong> <ul> <li>Relational Data Model</li> <li>Codd's Rules for RDBMS</li> <li>Relational Algebra</li> <li>Relational Calculus</li> <li>Integrity Constraints</li> <li>ER to Relational Model</li> </ul> <strong>Relational Database Design</strong> <ul> <li>Dependency (Functional and Multivalued)</li> <li>DBMS Normalization</li> <li>DBMS Normal Forms (1NF to 5NF)</li> <li>Database Joins</li> </ul> <strong>Data Storage and DBMS File Structure</strong> <ul> <li>File Organization (Sequential, Heap, Hash and B+)</li> <li>DBMS ISAM</li> </ul> <strong>Indexing and Hashing</strong> <ul> <li>DBMS Indexing</li> <li>Static and Dynamic Hashing</li> </ul> <strong>Transaction Processing</strong> <ul> <li>Transaction Processing</li> <li>Serializability</li> <li>Recoverability</li> <li>Log-Based Recovery</li> <li>DBMS Checkpoint</li> <li>Deadlock in DBMS</li> </ul> <strong>Concurrency Control</strong> <ul> <li>Concurrency Control Protocols</li> <li>Multiple Granularity</li> </ul> <strong>Backup and Recovery</strong> <ul> <li>Data Backup</li> <li>Data Recovery</li> <li>RAID</li> </ul> <strong>SQL</strong> <ul> <li>SQL Datatype</li> <li>SQL Commands, Operators and Statements</li> <li>SQL Clauses</li> <li>SQL Aggregate Function</li> <li>SQL JOIN</li> <li>SQL Set Operation</li> <li>SQL Query Processing</li> </ul> <strong>Open Source DBMS</strong> <ul> <li>MySQL</li> <li>PostgreSQL</li> </ul> <strong>Commercial DBMS</strong> <ul> <li>Microsoft Access</li> <li>Microsoft SQL Server</li> <li>Oracle</li> </ul> <strong>NoSQL or Big Data DBMS</strong> <ul> <li>Cassandra</li> <li>HBase</li> <li>MongoDB</li> <li>CouchDB</li> </ul> <strong>Cloud DBMS</strong> <ul> <li>AWS</li> <li>GCP</li> <li>Micrososft Azure</li> </ul> ', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'DATABASE ADMINISTRATOR,Data Analyst,Project Manager', 'eligibility' => 'Anyone can apply for the online certification', 'school' => 'Vskills', 'keywords' => 'Database,Data Science,Database Management Systems,DBMS,Big data', 'location' => 'Online', 'duration' => '1 To 2 Months', 'timing' => 'Flexible', 'cost' => null, 'discount' => null, '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' => '97528', 'seeder_id' => '0', 'edited_seeder_id' => '94', 'edited_client_id' => '0', 'title' => 'Microsoft 70-762 - Developing SQL Databases', 'external_link' => 'https://www.globaledulink.co.uk/course/microsoft-70-762-developing-sql-databases-live-practice-lab/', 'objectives' => null, 'photo_cta' => null, 'photo' => null, 'length' => '', 'next_session' => '', 'schedules' => null, 'duration' => 'Upto 29 Hours', 'base_duration' => '0', 'timing' => '', 'location' => 'Online', 'global_location_id' => '275', 'school' => 'Global Edulink', 'logo' => '', 'certificate_diploma' => 'yes', 'image' => '', 'brochure_url' => null, 'video' => '', 'cost' => '', 'price' => '79', 'price_enquiry' => '0', 'course_status' => 'Paid', 'base_price' => '106', 'nondiscounted_base_price' => '706.666666667', 'currency' => 'GBP', 'discount' => '85% off through Laimoon!', 'free_trial_text' => null, 'laimoon_offer' => '1', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-762 Developing SQL Databases Practice Lab course.<br /> <br /> Microsoft Practice Lab courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. To gain a Microsoft certification, you’ll need to take a theory course, and a Practice Lab course. This Global Edulink 70-762 Practice Lab will provide excellent training which will guarantee your success in your chosen exam. For those hoping to take the 70-762 exam, this Practice Lab is a must.<br /> <br /> The 70-762 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the Practice Lab tasks, you will improve your practical skills in designing and implementing database objects, implementing programmability objects, managing database concurrency and optimizing database objects and SQL infrastructure. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-762 Developing SQL Databases exam.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Design and implement database objects (25–30%)</li> <li>Implement programmability objects (20–25%)</li> <li>Manage database concurrency (25–30%)</li> <li>Optimize database objects and SQL infrastructure (20–25%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>Course Units:</strong><br /> <br /> <strong>Module 01:</strong> Designing a Relational Database Schema<br /> <strong>Module 02:</strong> Creating Indexes<br /> <strong>Module 03:</strong> Best Practices in Index Creation<br /> <strong>Module 04:</strong> Creating and Implementing Views<br /> <strong>Module 05:</strong> Creating Columnstore Indexes<br /> <strong>Module 06:</strong> Maintaining Columnstore Indexes<br /> <strong>Module 07:</strong> Creating Constraints<br /> <strong>Module 08:</strong> Effects of Contraints on DML Statements<br /> <strong>Module 09:</strong> Creating Stored Procedures with Parameters<br /> <strong>Module 10:</strong> Error Handling and Streamlining Stored Procedures<br /> <strong>Module 11:</strong> Creating Triggers<br /> <strong>Module 12:</strong> Creating User-Defined Functions<br /> <strong>Module 13:</strong> Impact of Transactions on DML Statements<br /> <strong>Module 14:</strong> Implicit and Explicit Transactions – Creating Savepoints<br /> <strong>Module 15:</strong> Manage Isolation Levels<br /> <strong>Module 16:</strong> Serializable and Snapshot<br /> <strong>Module 17:</strong> Identifying and Analyzing Locking Issues<br /> <strong>Module 18:</strong> Implementing Memory-Optimized Tables and Native Stored Procedures<br /> <strong>Module 19:</strong> Optimizing Statistics<br /> <strong>Module 20:</strong> Optimizing Indexes<br /> <strong>Module 21:</strong> Optimizing Query Plans Part 1<br /> <strong>Module 22:</strong> Optimizing Query Plans Part 2<br /> <strong>Module 23:</strong> Monitoring Performance using SQL Trace and Extended Events<br /> <strong>Module 24:</strong> Optimizing Performance for Database Instances Part 1<br /> <strong>Module 25:</strong> Optimizing Performance for Database Instances Part 2<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-762 Developing SQL Databases certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and skills.', 'outline' => null, 'who_should_take_this_course' => '', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'about_school' => '', 'keywords' => 'Microsoft,MCSE,MCSA,Sqlserver,SQL', 'job_matching_keywords' => null, 'instructor_bio' => '', 'external_course_info' => null, 'eligibility_criteria' => null, 'career_opportunity' => null, 'targetted_roles' => null, 'targetted_industries' => null, 'targetted_locations' => null, 'gender' => '0', 'targetted_course_categories' => '395,393', 'suggested_course_categories' => '', 'course_type_id' => '2', 'course_provider_id' => '7646', 'trainer_ids' => null, 'created' => '2018-05-09 14:18:49', 'updated' => '2024-05-13 18:39:41', 'sort_order' => '0', 'page' => 'JobListing', 'to_emails' => 'info@globaledulink.co.uk', 'cc_emails' => null, 'phone_number' => null, 'pri_line_number' => null, 'instant_calls' => '1', 'status' => 'active', 'collect_mode' => 'provider', 'slug' => 'upto-twenty-nine-hours-microsoft-70-762-developing-sql-databases-global-edulink', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"1";s:7:"dec_avg";d:1;s:9:"whole_avg";d:1;}}', 'agg_ratings' => null, 'prospects' => '1', 'end_date' => null, 'featured' => '0', 'impressions' => '0', 'contract_type' => 'CPC', 'deleted' => '0', 'delete_request' => '1', 'accreditation' => '0', 'accreditation_logos' => 'CPD,iAP', 'invoice_type' => 'Free', 'payment_mode' => 'free', 'invoice_value' => '5', 'invoice_click_value' => '0.12', 'next_session_date' => null, 'brochure_cost' => '3', 'call_cost' => '0', 'boosted' => '0', 'featured_text' => null, 'fresh' => '0', 'connections' => '502', 'show_map' => '0', 'course_feed_id' => '0', 'visa_required' => '0', 'ladies_only' => '0', 'gents_only' => '0', 'method' => 'Full Time', 'study_timings' => '1', 'language_program_covers' => null, 'language_program_level' => null, 'language_program_type' => null, 'language_study_mode' => null, 'badge_url' => null, 'last_revision_status' => 'None', 'online_method' => '', 'delivery_languages' => 'en', 'career_path' => 'Systems Engineer,Customer Support Engineer,Network Engineer,Windows Server Administrator', '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,"5153_en_c":350000000,"65222_ar_c":350000000}', 'lead_count' => '0', 'enrol_option' => '1', 'enrol_free' => '0', 'import_course_code' => '', 'cpa_recommended' => '0', 'study_format' => 'Video', 'pdf_certificate' => '1', 'course_certificate' => null, 'bundle_id' => null, 'randomizer' => '99252346', 'virtual_classroom' => '0', 'on_credit' => '0', 'laimoon_organized' => '0' ), 'CourseProvider' => array( 'id' => '7646', 'name' => 'Global Edulink', 'account_name' => '', 'trainer_type' => 'institute', 'slug' => 'global-edulink', 'location' => null, 'customer_name' => 'Rushan Arachchige', 'seeder_id' => '43', 'phone_number' => '2034097966', 'pri_line_number' => '', 'address_street' => ' CityPoint, 1 Ropemaker Street,', 'address_building' => '', 'address_city' => 'London, EC2Y 9HU.', 'address_country' => 'United Kingdom', 'addresss' => ' CityPoint, 1 Ropemaker Street,, London, EC2Y 9HU., United Kingdom', 'invoice_email' => 'info@globaledulink.co.uk', 'student_enrolment' => '1', 'masked_emails' => '1', 'moneyback' => '1', 'student_enrolment_processing_percentage' => '50', 'invoice_missed_calls' => '0', 'budget_alerts' => '0', 'budget_amount' => '0', 'budget_start_date' => null, 'provider_code' => '', 'payment_type' => 'CPC', 'intl_leads_enabled' => '0', 'invoice_notification' => '0', 'enable_intro_offer' => '1', 'lead_notification' => '1', 'weekly_digest' => '1', 'logo' => 'content_1578472083-go (White Background).jpg', 'logo_size' => '{"width":3461,"height":1200}', 'description' => 'Global Edulink is a leading online learning and training provider. We believe that everyone should have the opportunity to learn, no matter what their situation, which is why we strive to keep our resources cutting edge and easy-to-understand.<br /> <br /> Education is just one aspect of life that can shape who you are and who you want to be as an employee. In a time-poor world, sometimes you need a flexible approach to help you achieve your goals. Online learning with Global Edulink offers just that – professional and vocational training to fit in with your life.<br /> <br /> Global Edulink is well-established in the UK, but reaches out to learners all over the world. The company aims to bridge the gaps in a three step process of training, skills, and jobs, where you can learn at your own pace using interactive teaching techniques.<br /> ', 'website' => 'http://www.globaledulink.co.uk', 'no_of_courses' => null, 'course_types' => '', 'spotlight' => null, 'video_thumb' => 'opt_content_1528980709-8-06-14 at 4.52.50 PM.png', 'video_embed_code' => '<iframe width="854" height="480" src="https://www.youtube.com/embed/bn_ZJ_0B2jM" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>', 'meta_title' => null, 'meta_description' => null, 'meta_keywords' => null, 'email' => 'info@globaledulink.co.uk', 'contact_phone_number' => '+44 2034097966', 'contact_person_position' => null, 'global_location_ids' => '275', 'head_office_gloc_id' => '275', 'vat_enabled' => '0', 'draft' => '0', 'auto_account_suspension' => '0', 'ratings' => 'a:1:{s:2:"r1";a:4:{s:12:"number_votes";i:1;s:12:"total_points";s:1:"3";s:7:"dec_avg";d:3;s:9:"whole_avg";d:3;}}', 'call' => '0', 'auto_call_paid' => '0', 'instant_callback_number' => '', 'instant_callback_status' => null, 'instant_callback_disabled' => '1', 'show_map' => '1', 'same_place' => '0', 'tier' => 'tier2', 'featured_advertiser' => '0', 'institution_type' => 'Training Institute', 'certificate' => null, 'hyperlocal_leads' => '0', 'training_mode' => 'Online', 'establish' => null, 'verify_code' => '', 'verify_status' => '1', 'course_csa_keywords' => null, 'untrusted' => '0', 'mobile_cpc_disabled' => '0', 'deleted' => '0', 'created' => '2017-11-24 20:50:10', 'modified' => '2022-09-05 13:45:10', 'pageview_enabled' => '1', 'timezone' => 'Europe/London', 'provider_status' => 'performance', 'cpc_direct_linking' => 'no', 'phone_calls_timing' => '', 'phone_calls_exclude_days' => '', 'signup' => '1', 'completeness' => '1', 'signup_status' => 'Received', 'engagement_ranking' => 'normal', 'exclusive_leads' => '0', 'progress' => null, 'verified_time' => '2018-08-17 18:12:33', 'profile_completed_time' => '2017-11-24 20:57:46', 'payment_overdue' => '0', 'bad_debtor' => '0', 'tax_regn_number' => null, 'tax_emirate' => null, 'traffic_referral' => '/', 'course_type_ids' => '2', 'trusted' => '0', 'legacy' => '0', 'moderation_status' => 'verified', 'rfp_email_alerts' => '0', 'rfp_unsubscribed' => '0', 'offer_start_date' => '0000-00-00', 'offer_end_date' => '0000-00-00', 'offer_price' => '0', 'discount_percentage' => '0', 'offer_published' => '0', 'offer_text' => '', 'resized' => '1', 'is_corporate' => '0', 'topup_auto_renew' => '0', 'disabled_topup' => '0', 'topup_credit_enabled' => '0', 'enable_hyperlocation_leads' => '0', 'import_course_enable' => '1', 'sample_certificate' => 'https://cdn.laimoon.com/cityimages/marketing/1662371099_Sample_Cer.jpg', 'lead_filters' => null, 'repeat_email_lead_alerts' => '1', 'load_blncr_weight' => '1', 'remote_option' => null, 'classroom_status' => 'pending', 'topup_info' => null, 'provider_rank' => '{"default":502,"rndm":931454,"r_84":502,"r_174":502,"r_777":502,"r_82":502,"r_401":502,"r_89":502,"r_229":502,"r_80":502,"r_114":502,"r_610":502,"r_615":502,"r_609":502,"r_66":502,"r_614":502,"r_805":502,"r_79":502,"r_374":502,"r_682":502,"r_636":502,"r_88":502,"r_215":502,"r_17":502,"r_357":502,"r_86":502,"r_388":502,"r_221":502,"r_81":502,"r_382":502,"r_592":502,"r_541":502,"r_193":502,"r_95":502,"r_762":502,"r_656":502,"r_85":502,"r_180":502,"r_113":502,"r_809":502,"r_255":502,"r_808":502,"r_253":502,"r_254":502,"r_389":502,"r_618":502,"r_593":502,"r_599":502,"r_738":502,"r_743":502,"r_387":502,"r_12":502,"r_231":502,"r_97":502,"r_10":502,"r_528":502,"r_931":502,"r_527":502,"r_843":502,"r_111":502,"r_112":502,"r_596":502,"r_122":502,"r_823":502,"r_912":502,"r_149":502,"r_83":502,"r_167":502,"r_657":502,"r_237":502,"r_236":502,"r_168":502,"r_256":502,"r_739":502,"r_312":502,"r_511":502,"r_588":502,"r_332":502,"r_313":502,"r_439":502,"r_385":502,"r_811":502,"r_183":502,"r_227":502,"r_329":502,"r_225":502,"r_944":502,"r_223":502,"r_169":502,"r_597":502,"r_526":502,"r_818":502,"r_884":502,"r_268":502,"r_269":502,"r_27":502,"r_830":502,"r_531":502,"r_794":502,"r_347":502,"r_755":502,"r_780":502,"r_779":502,"r_524":502,"r_148":502,"r_94":502,"r_419":502,"r_589":502,"r_847":502,"r_725":502,"r_840":502,"r_125":502,"r_226":502,"r_391":502,"r_15":502,"r_207":502,"r_652":502,"r_694":502,"r_270":502,"r_760":502,"r_507":502,"r_508":502,"r_403":502,"r_204":502,"r_272":502,"r_515":502,"r_519":502,"r_918":502,"r_195":502,"r_432":502,"r_142":502,"r_691":502,"r_393":502,"r_722":502,"r_398":502,"r_872":502,"r_394":502,"r_395":502,"r_400":502,"r_887":502,"r_196":502,"r_194":502,"r_345":502}', 'preferences' => '{"laimoon_fallback_number":"0"}' ), 'CourseTranslation' => array( 'id' => '126390', 'course_id' => '97528', 'title' => 'Microsoft 70-762 - Developing SQL Databases', 'slug' => 'upto-twenty-nine-hours-microsoft-70-762-developing-sql-databases-global-edulink', 'external_link' => 'https://www.globaledulink.co.uk/course/microsoft-70-762-developing-sql-databases-live-practice-lab/', 'summary' => '<strong>Overview</strong><br /> <br /> Would you like to achieve an excellent online accredited Microsoft qualification, which will demonstrate a high level of skill and knowledge? Look no further than this fantastic 70-762 Developing SQL Databases Practice Lab course.<br /> <br /> Microsoft Practice Lab courses demonstrate a high level of skill, and have been expertly created for IT professionals who hope to become certified. To gain a Microsoft certification, you’ll need to take a theory course, and a Practice Lab course. This Global Edulink 70-762 Practice Lab will provide excellent training which will guarantee your success in your chosen exam. For those hoping to take the 70-762 exam, this Practice Lab is a must.<br /> <br /> The 70-762 Practice Lab will provide you with the necessary platform to gain hands on skills Microsoft SQL Server 2016. By completing the Practice Lab tasks, you will improve your practical skills in designing and implementing database objects, implementing programmability objects, managing database concurrency and optimizing database objects and SQL infrastructure. These same tasks will help you understand the objectives and competencies required by the Microsoft 70-762 Developing SQL Databases exam.<br /> <br /> <strong>Description</strong><br /> <br /> <strong>Course Objectives:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Design and implement database objects (25–30%)</li> <li>Implement programmability objects (20–25%)</li> <li>Manage database concurrency (25–30%)</li> <li>Optimize database objects and SQL infrastructure (20–25%)</li> </ul> <strong>Course Benefits:</strong> <ul> <li>Gain an accredited Microsoft qualification</li> <li>Access to excellent quality video tutorials</li> <li>Learners will be eligible for an NUS Discount Card</li> <li>One year’s access to the course</li> <li>Support by phone, live chat, and email</li> <li>Join a friendly online learning platform</li> </ul> <strong>Course Units:</strong><br /> <br /> <strong>Module 01:</strong> Designing a Relational Database Schema<br /> <strong>Module 02:</strong> Creating Indexes<br /> <strong>Module 03:</strong> Best Practices in Index Creation<br /> <strong>Module 04:</strong> Creating and Implementing Views<br /> <strong>Module 05:</strong> Creating Columnstore Indexes<br /> <strong>Module 06:</strong> Maintaining Columnstore Indexes<br /> <strong>Module 07:</strong> Creating Constraints<br /> <strong>Module 08:</strong> Effects of Contraints on DML Statements<br /> <strong>Module 09:</strong> Creating Stored Procedures with Parameters<br /> <strong>Module 10:</strong> Error Handling and Streamlining Stored Procedures<br /> <strong>Module 11:</strong> Creating Triggers<br /> <strong>Module 12:</strong> Creating User-Defined Functions<br /> <strong>Module 13:</strong> Impact of Transactions on DML Statements<br /> <strong>Module 14:</strong> Implicit and Explicit Transactions – Creating Savepoints<br /> <strong>Module 15:</strong> Manage Isolation Levels<br /> <strong>Module 16:</strong> Serializable and Snapshot<br /> <strong>Module 17:</strong> Identifying and Analyzing Locking Issues<br /> <strong>Module 18:</strong> Implementing Memory-Optimized Tables and Native Stored Procedures<br /> <strong>Module 19:</strong> Optimizing Statistics<br /> <strong>Module 20:</strong> Optimizing Indexes<br /> <strong>Module 21:</strong> Optimizing Query Plans Part 1<br /> <strong>Module 22:</strong> Optimizing Query Plans Part 2<br /> <strong>Module 23:</strong> Monitoring Performance using SQL Trace and Extended Events<br /> <strong>Module 24:</strong> Optimizing Performance for Database Instances Part 1<br /> <strong>Module 25:</strong> Optimizing Performance for Database Instances Part 2<br /> <br /> <strong>Method of Assessment:</strong><br /> <br /> At the end of the course learners will be assessed by an official exam. Please note that we do not provide the official exam, which you will need to purchase separately.<br /> <br /> <strong>Recommended Experience:</strong><br /> <br /> This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.<br /> <br /> <strong>Certification:</strong><br /> <br /> Successful learners will be awarded a 70-762 Developing SQL Databases certificate.<br /> <br /> <strong>Awarding Body:</strong><br /> <br /> Whether you’re an established IT professional or are new to the field, Microsoft online IT training from Global Edulink will give you the expertise you need in a specific product or technology. When you learn from Global Edulink Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete and up to date. Microsoft Certifications supplied by Global Edulink will take you from the start of your career to its pinnacle. These certifications will increase your visibility, differentiate you from your peers, and validate your knowledge and skills.', 'outline' => null, 'who_should_take_this_course' => null, 'career_path' => 'Systems Engineer,Customer Support Engineer,Network Engineer,Windows Server Administrator', 'eligibility' => 'Learners should be age 16 or over, and must have a basic understanding of Maths, English, and ICT.', 'school' => 'Global Edulink', 'keywords' => 'Microsoft,MCSE,MCSA,Sqlserver,SQL', 'location' => 'Online', 'duration' => 'Upto 29 Hours', 'timing' => null, 'cost' => null, 'discount' => '85% 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' => '43517323', 'contact_id' => '3773199', 'recruiter_id' => '74726', 'job_function_id' => null, 'title' => 'Database Engineer', 'vacancies' => null, 'job_type_id' => null, 'description' => null, 'pay_status' => 'Free', 'external_job_description' => '<p><p><h3>Allgemeine Angaben </h3><p><p>Bewerbungsfrist </p><p>21-Apr-2024 </p><p><p>Standort </p><p>Ortigas Center </p><p><p>Land </p><p>Philippinen </p><p><p>Job Kategorien </p><p>Support Positions </p><p><p>Work Style </p><p>Hybrid </p><p><h3>Jobbeschreibung </h3><p><p><b> Position Summary </b></p><p></p><p> The Database Administration Engineer is responsible for installation, maintenance and support of miscellaneous database platforms to ensure the operation of global systems in order to provide performance and availability for its users, such as staff, customers and suppliers. Including teams within Information Technology, Information Systems, and others. </p><p></p><p></p><p><b> Functional Responsibilities </b></p><p></p><p>● Responsible for providing, planning, conducting and directing the analysis of complex business </p><p> initiatives that require a Database to be actioned upon. </p><p>● Provide technical support and resolve requests around the Database Admin technology </p><p> verticals. </p><p>● Work hand in hand with other technology teams to provide solutions to end user needs. </p><p>● Documentation and Implementation of Standard and Normal Changes, as well as support on </p><p> Emergency Changes. </p><p>● Work along other teams to plan and deploy patches and or upgrades to the Database </p><p> Management Systems environments. </p><p>● Perform peer reviews for Method of Procedure and enforce Policies and standardization. </p><p>● Perform TELUS International Database Assessments that include but are not limited to: </p><p> Administration, deployment, configuration and recovery of DBMS. </p><p>● Perform Database Inventorying and documentation. </p><p>● Implement and enforce Database Best practices, least privileged access models, Backup and </p><p> Recovery practices. </p><p>● Database Monitoring and tune up: sessions, locks, peaks, io, waits, etc. </p><p>● HADR failover and management for different DBMS. </p><p>● Provides Support to Global Security Audits acting as POC from IT Database Administration </p><p> Team within the Auditor Interviews and evidence asks. </p><p>● Collaborate with Engineering New Client Launches and/or new technology projects, enabling </p><p> new business and features. </p><p>● Become the link and facilitator of implementations and deployment of applications related to </p><p> several different teams including Artificial Intelligence, DataWareHouse, Business Intelligence, </p><p> Machine Learning, Information System Developments, etc. </p><p>● Perform other project related duties as requested by management. </p><p><p><p>Zusätzliche Stellenbeschreibung </p><p><p><b> Required Experience, Education, Skills & Competencies: </b></p><p></p><p><b> Specific Qualifications: </b></p><p></p><p>○ Miscellaneous Operating system knowledge and practice background within Databases </p><p> scope. </p><p>○ Strong skills in Miscellaneous DBMS and SQL Language </p><p>■ MSSQL 2005 - 2019 | MySQL 5.0 - 8 | PostgreSQL </p><p>■ Cloud Technologies (GCP | AWS | Azure)</p><p>■ DevOps Knowhow (Kubernetes | Docker | etc)</p><p>■ NoSQL (Riak/Redis/MongoDB)</p><p>■ SQL Development </p><p>○ Common troubleshooting knowledge and debugging for multi-tiered architecture. </p><p>○ Powershell Scripting, Bash Shell Scripting, Python Scripting. </p><p>○ General Knowledge of Programming Language and their interaction with DBs. </p><p></p><p><b> Skills </b></p><p></p><p>○ Teamwork and Remote Work skills. </p><p>○ Ability to respond to External & Internal requests </p><p>○ Fast adaptation to technology changes </p><p>○ Schedule Flexibility (including On Call Shift Rotation)</p><p></p><p><b> Education/Experience and Knowledge </b></p><p></p><p>○ MCSA SQL - Microsoft Certified Solutions Associate (desirable)</p><p>○ Experience handling multi tiered Database Solutions </p><p>○ Experience in Microsoft Windows and Linux. </p><p>○ Knowledge in Cloud interaction in any of these technologies: GCP, Azure, AWS. </p><p>○ Minimum of 1 year experience in a DBA/DevOps development role. </p><p>○ Amenable to work at TELUS Ortigas. </p><p><p>EEO Statement </p><p><p> At TELUS International, we enable customer experience innovation through spirited teamwork, agile thinking, and a caring culture that puts customers first. TELUS International is the global arm of TELUS Corporation, one of the largest telecommunications service providers in Canada. We deliver contact center and business process outsourcing (BPO) solutions to some of the world's largest corporations in the consumer electronics, finance, telecommunications and utilities sectors. With global call center delivery capabilities, our multi-shore, multi-language programs offer safe, secure infrastructure, value-based pricing, skills-based resources and exceptional customer service - all backed by TELUS, our multi-billion dollar telecommunications parent. </p><p> Equal Opportunity Employer </p><p> At TELUS International, we are proud to be an equal opportunity employer and are committed to creating a diverse and inclusive workplace. All aspects of employment, including the decision to hire and promote, are based on applicants’ qualifications, merits, competence and performance without regard to any characteristic related to diversity. </p><p><p>Ref Number </p><p>Req_00127315 </p>', 'course_qualifications' => null, 'global_location_id' => '275', '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' => '89202', 'company_name' => 'TELUS International', 'external_apply_url' => 'https://ph.jooble.org/external/-7394677023437785072?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_ph&extra_ars_request_id=0efe1adafdb02519276988de17d55ba1', 'external_short_url' => '7394677023437785072', 'apply_url' => null, 'contributed' => '0', 'created' => '2024-05-08 03:41:58', 'published' => '2024-05-08 03:41:58', 'closed_time' => null, 'updated' => '2024-05-08 03:41:58', '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' => '275', 'display_name' => 'Online', 'name_ar' => null, 'country_id' => '250', 'Country' => array( 'name' => 'Online', 'id' => '250', 'slug' => 'online', 'code' => 'ON' ) ), 'Company' => array( 'id' => '89202', 'name' => 'telus international', 'website' => 'https://www.telusinternational.com/', 'verified' => '0', 'photo' => 'TELUS_International_cea0e7d0-edd5-11ea-a204-752b08f7e4cd.jpeg', 'details' => null, 'display_details' => '' ), 'Industry' => array(), 'Tag' => array() ) $jobsList = array() $courses = array() $promotedCourses = array() $referer = '/' $urlKeyword = 'Database ' $profile = array( 'locations' => array( (int) 2 => 'UAE' ), 'searchKey' => '', 'guest' => (int) 1, 'jobCount' => '11156', 'contributedJobCount' => '24', 'courseCount' => null ) $askLogin = true $jobLinkTitle = 'Database ' $renderSchema = 'yes' $title_for_layout = 'Database Engineer jobs in telus international in Online.' $page_description = 'Apply to Database Engineer jobs in telus international in Online.Find similar vacancies, jobs and salary information in Online.' $locationForTitle = 'Online' $currentJobCity = array( 'id' => '275', 'display_name' => 'Online', 'name_ar' => null, 'country_id' => '250', 'Country' => array( 'name' => 'Online', 'id' => '250', 'slug' => 'online', 'code' => 'ON' ) ) $jobCompanyPage = array( 'CompanyPage' => array( 'id' => '71220', 'title' => 'telus international', 'slug' => 'telus-international', 'description' => 'At TELUS International, we focus on the human connection to deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. <br><br>TELUS International focuses on the value of human connection to design, build and deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. With over 50,000 team members', 'meta_title' => 'Jobs from telus international', 'meta_description' => 'Jobs from telus international', 'meta_keywords' => 'Jobs from telus international', 'draft' => '0' ), 'CompanyPageTranslation' => array( 'id' => '71202', 'company_page_id' => '71220', 'title' => 'telus international', 'slug' => 'telus-international', 'summary' => null, 'description' => 'At TELUS International, we focus on the human connection to deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. <br><br>TELUS International focuses on the value of human connection to design, build and deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. With over 50,000 team members', 'meta_title' => 'Jobs from telus international', 'meta_description' => 'Jobs from telus international', 'meta_keywords' => 'Jobs from telus international', 'company_matching_keywords' => null, 'draft' => '0', 'lang_code' => 'en' ) ) $location = 'Online' $breadCrumbs = array( 'Job Details' => '' ) $relCourseBanner = array( 'relatedUrl' => 'https://courses.laimoon.com/uae/it-computing-and-technology/database-management', 'title' => 'Database Management', 'course_category_id' => (int) 394, 'relatedOnlineUrl' => 'https://courses.laimoon.com/online/it-computing-and-technology/database-management' ) $published = '2024-05-08 03:41:58' $daysleft = (float) 15 $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/uae/Database ' $csaKeywords = array( (int) 0 => 'Database Engineer' ) $allowLoginClass = 'notlogin' $jobLocSlug = 'online' $jobLocName = 'Online' $pfBackgrounds = '' $jobLink = 'https://jobs.laimoon.com/jobs/externalview/43517323' $companyName = ' at telus international' $twitterText = 'Hiring now! Database Engineer at telus international. Please apply or share https://jobs.laimoon.com/jobs/externalview/43517323' $emailText = 'Hiring now! Database Engineer at telus international. Please apply or share by clicking here https://jobs.laimoon.com/jobs/externalview/43517323' $sCompanyName = false $csaSearchKey = 'Database Engineer' $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 = 'telus international'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
Telus international
Improve your chance to get this job.
Do an online course on Database Management starting now.
-
AED 154Duration: 1 To 2 Months
-
Microsoft 70-762 - Developing SQL Databases Global EdulinkAED 369
AED 2,596Duration: Upto 29 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://ph.jooble.org/external/-7394677023437785072?cpc=d0FU&utm_source=affiliate&utm_medium=laimoon_organic_ph&extra_ars_request_id=0efe1adafdb02519276988de17d55ba1