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 -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 to 5 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
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
Preference given to MCITP – DBA, MCSA,MCTS certified professionals
Primary Location: LK-1-Colombo
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: 1802485