Database Administrator - Oracle

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 - Oracle

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

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

Depth knowledge in Oracle 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

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