Description
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 reexamining 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.
Pearson’s Online & Blended Learning K-12 group provides high-quality, highly accountable online education solutions to schools, school districts and students in grades K-12. It serves families and schools with a variety of digital learning and online school solutions including Connections Academy, International Connections Academy, and Pearson Connexus. In 2017, it will deliver online learning to over 400,000 students in the U.S. and 48 countries. The group, formerly known as Connections Education, is based in Columbia, Maryland and has been named a “Top Workplace” by the Baltimore Sun for three consecutive years and a “Best Place to Work” by Baltimore magazine. Recognized for its outstanding curriculum, high-quality teachers and leadership, Pearson Online & Blended Learning is committed to expanding quality education through technology, and helping students achieve both academic and personal success.
Position Summary :
Working remotely and/or from our Columbia, MD or Durham, NC office, the Senior Database Engineer is part of a team responsible for the development of robust, scalable database structures and queries, and the management of data size and archiving.
Responsibilities:
Assists software engineers with the creation and maintenance of robust, scalable database code, and evaluates new and existing code for performance and scalability
Creates and implements data archiving strategies and tools
Mentors software engineers in writing better database code
Works on a self-managed Agile team to build and maintain our web-based Education Management System
Maintains database performance by developing tuning methodologies and monitoring performance
Manages and tunes the logical and physical database design
Enforces SQL standards and guidelines, and answers technical and procedural questions from team members
Develops requirements for, and implements database projects
Maintains technical knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations
Accomplishes department and organization mission by completing related tasks as needed
Other duties as assigned
Qualifications
Requirements:
The individual in this position will be working with a team of developers, DBAs, designers, and testers. Due to the nature of this position, the applicant will need the ability to work from home or during off-hours as necessary.
Candidates must have:
A comprehensive understanding of database structures, database administration, and query optimization
At least 7 years' experience developing with SQL Server 2014 and including 2017 and Azure SQL Database
Excellent SQL skills, with the ability to generate complex SQL queries from an entity-relationship diagram
Excellent query tuning skills
Experience designing schemas for OLTP databases
Understanding of and experience with data archival strategies
Ability to reverse-engineer processes through close examination of existing database procedures and code
Experience with rollback processes
Experience with automated or unit testing of database code
An extremely detail-oriented work ethic
Excellent communication skills with the ability to understand user requests and translate them into technical requirements
High-speed Internet access at home and a personal computer
In addition, the ideal candidate will have:
Experience developing for SQL Server Reporting Services and SQL Server Integration Services
Experience with automated or unit testing of database code
Familiarity with legislation like GDPR and CCPA as pertaining to data privacy and security
Recently worked on databases with hundreds of tables, thousands of transactions per second, and/or thousands of simultaneous users (via application or Web pooled connections)
Familiarity with C# and web application architecture
#LI-POST
Pearson is an Equal Opportunity and Affirmative Action Employer and a member of E-Verify. All qualified applicants, including minorities, women, protected veterans, and individuals with disabilities are encouraged to apply.
Primary Location: US-RE-Remote
Other Locations US-MD-Columbia, US-NC-Durham
Work Locations: US-Remote Remote
Job: Technology
Organization: North America Connections
Employee Status: Regular Employee
Job Type: Standard
Shift: Day Job
Job Posting: Nov 13, 2020
Job Unposting: Ongoing
Schedule: Full-time Regular
Req ID: 2009518
Pearson is an Equal Opportunity and Affirmative Action Employer and a member of E-Verify. All qualified applicants, including minorities, women, protected veterans, and individuals with disabilities are encouraged to apply.