Database Administrator - MSSQL

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 fulﬁll 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

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