This job listing has expired and may no longer be relevant!
22 Dec 2014

Full-Time Looking for Database Administrator -MSSQL

Pearson Lanka (Pvt) Ltd – Posted by Anushka - Advertising manager Anywhere

Job Description

About PEARSON

Pearson is the world’s leading learning company, with 40,000 employees in more than 80 countries working to help people of all ages to make measurable progress in their lives through learning. With revenues over €5.2 billion in 2013 we provide learning materials, technologies, assessments and services to teachers and students in order to help people everywhere aim higher and fulfill their true potential. We put the learner at the center of everything we do.

We at Pearson Lanka, a core part of Pearson’s global Learning Technologies team. We build and manage some of the industry leading cloud based learning platforms that serve millions of students across the world. Over the years, we have built a strong Agile Development team, and we are now looking to expand aggressively over the next 12 months.  The industry leading cloud-based technology platforms of Pearson help educate more than 30 million students across the globe.

The 360+ strong engineering team based out of the Colombo office works dedicatedly to service Pearson technology companies located in North America, Europe and Australia.

At Pearson, we aim to be the best company to work for in the world. It is part of our philosophy to provide benefits, profit share plans, development opportunities and a culture that beats anywhere else. If you are ‘always learning’, and have a passion for technology and creativity, send in your resume and join our exciting engineering culture.

Database Administrator -MSSQL

The 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 responsibilities

Database 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.

EDUCATION and/or EXPERIENCE                                                                                                                                                                                       

  • Bachelor’s degree in Computer Science / IT
  • 3 Years’ experience in Development  / Database administration

KNOWLEDGE, SKILLS AND ABILITIES

Key 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 Competencies

  • Ability to be flexible and adapt to any given situation
  • Ability to perform multiple tasks concurrently in a high stressed environment
  • Excellent customer service attitude, communication skills (written and verbal), and interpersonal skills
  • Excellent organizational and time management skills
  • Excellent analytical and problem-solving skills
  • Ability to work independently and in a team based environment

License/certifications required

  • Preference given to MCITP – DBA certified professionals

How to Apply

Please submit your CV using the following link http://pearsonlankavacancies.peopleshr.com/

Job Categories: IT-Software/DB/QA/Web/Graphics/GIS. Job Types: Full-Time.

838 total views, 1 today

Apply for this Job