hireejobsgulf
Register for Job

Senior Database Design/Analysis/Administration Engineer

5.00 to 10.00 Years   Sri Lanka   22 Jul, 2019
Pearson
1 Jobs Openings
Job LocationSri Lanka
EducationNot Mentioned
SalaryNot Mentioned
IndustryEducation, Training, and Library
Functional AreaNot Mentioned

Job Description

Senior Database Design/Analysis/Administration EngineerDescriptionAt Pearson, we?re committed to a world that?s always learning and to our talented team who makes it all possible. From bringing lectures vividly to life to turning textbooks into laptop lessons, we are always re-examining the way people learn best, whether it?s one child in our own backyard or an education community across the globe. We are bold thinkers and standout innovators who motivate each other to explore new frontiers in an environment that supports and inspires us to always be better. By pushing the boundaries of technology ? and each other to surpass these boundaries ? we create seeds of learning that become the catalyst for the world?s innovations, personal and global, large and small.Senior Database Administrator -MSSQL / NoSQLThe Database Administrator ensures maintaining the databases in good working order and performing tasks necessary to ensure continued growth and stability of the database.Roles and responsibilitiesDatabase Administration tasks.

  • Install and configure SQL Server
  • Setup and maintain SQL Server account security.
  • Performs SQL backups and restores.
  • Setup, schedule, and troubleshoot SQL Server jobs.
  • Applies updates and upgrades to production database environments.
  • Monitoring existing installations and fine tuning for better performance
  • Closely work with the Development teams to play the role of trusted advisor on all Database related work.
  • Read requirement documents and Design Databases based on them and preparing ER diagrams
  • Writing Database code including stored procedures and triggers
  • Setup and run SQL Server Profiler traces.
  • Optimize SQL queries and suggest alternative methods to enhance the efficiency.
  • Identify potential performance / security vulnerabilities and bad coding patterns and propose / implement solution to overcome those.
QualificationsEDUCATION and/or EXPERIENCEBachelor?s degree in Computer Science / IT3 to 5 Years? experience in Development / Database administrationKNOWLEDGE, SKILLS AND ABILITIESKey Technical Competencies
  • Proficient in OOP concepts
  • Proficient in Microsoft SQL Server administration , preference on the latest Version
  • Proficient in Structured Query Language (SQL)
  • Knowledge in writing Stored Procedures
  • Knowledge in relational database design
  • Knowledge in SSIS
  • Knowledge in scripting languages
  • Knowledge of database driven Internet applications
  • Coding skills in multiple languages desired in at least one language is essential
Other CompetenciesAbility to be flexible and adapt to any given situationAbility to perform multiple tasks concurrently in a high stressed environmentExcellent customer service attitude, communication skills (written and verbal), and interpersonal skillsExcellent organizational and time management skillsExcellent analytical and problem-solving skillsAbility to work independently and in a team based environment
  • Exposure to NoSQL technologies such as MongoDB and/or Cassandra will be an added advantage
License/certifications required
  • Preference given to MCSA,MCTS certified professionals
Primary Location: LK-1-ColomboJob: TechnologyOrganization: Technology and OperationsEmployee Status: Regular EmployeeJob Type: StandardShift: Day JobJob Posting: Jul 11, 2019Job Unposting: Aug 25, 2019Schedule: Full-time RegularReq ID: 1908452Pearson is an Equal Opportunity and Affirmative Action Employer and a member of E-Verify. All qualified applicants, including minorities, women, protected veterans, and individuals with disabilities are encouraged to apply.

Keyskills :

APPLY NOW

Related Jobs

© 2023 HireeJobsGulf All Rights Reserved