Pearson Senior Database Design/Analysis/Administration Engineer in Colombo, Sri Lanka

Senior Database Design/Analysis/Administration Engineer


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

Database Administrator – Oracle / MySQL

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 Oracle / MySQL Database server.

Monitor the Jobs and Alerts and carry out corrective tasks as required.

Perform backups and restores.

Configure and Monitor the Replications and corrective actions as required

Configure RAC , monitor and corrective actions as required

Applies updates and upgrades to production database / staging 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

Implement and Maintain the industry best practices

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.



Bachelor’s degree in Computer Science / IT

3 to 5 Years’ experience in Development / Database administration


Key Technical Competencies

Depth knowledge in Oracle / MySQL DBA administration activities.

Proficient in OOP concepts

Proficient in SQL

Good Knowledge in writing Stored Procedures

Good Knowledge in relational database design

Proficient in Linux and shell scripting’s

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 (OCP) Oracle certified professionals

RAC Expert (OCE) Oracle certified expert is added advantage

Primary Location: LK-1-Colombo

Job: Technology

Organization: Technology & Operations

Employee Status: Regular Employee

Job Type: Standard

Shift: Day Job

Job Posting: Feb 13, 2018

Job Unposting: Ongoing

Schedule: Full-time Temporary

Req ID: 1802479