Cloud Services Engineer III

Summary

As Database Administrator, you will be responsible for the architecture, planning, implementation, and maintenance of database systems including strategic database design, planning, and execution, with emphasis on Azure technologies, working with development teams to design and implement complex database layouts and strategies. In this role you will also be responsible for performance monitoring and tuning. You will also be expected to apply new technologies and techniques to improve production systems, capacity planning, data integrity, backup and recovery solutions, and database security.

To be effective you will be expected to work closely with internal teams and serve as the primary source for strategic database architecture, design, planning and implementation; regularly working with development to improve production systems, tune workloads, and implement new database layouts and strategies.

As a top candidate you will possess a well-rounded and highly technical background with emphasis on scalable design and performance in the cloud and will be self-motivated and able to handle complex tasks independently.

Scheduled shift will cover US business hours for the foreseeable future. When assigned to the US shift, you will work remotely but this is subject to change to hybrid if shift needs change.

PRIMARY RESPONSIBILITIES

SDLC and Production Database Maintenance

• Software Development Life Cycle: implementation, deployment, and maintenance, including participation in monthly release rotation



• Database Security



• Database Change Management: Review scripts and perform deployments to Development, QC and Production Environments



• Create databases (with appropriate resources when applicable) and ensure proper backup retention



• Capacity Planning and monitoring



• Data modeling, logical and physical database design



• Alert Response: Determine root cause and resolution

Database Tuning

• Write performant T-SQL and tune existing T-SQL



• Review data models to ensure optimal database performance including appropriate indexing



• Database performance tuning for optimal resource usage



• Identify performance bottlenecks and recommend corrective action



• Assess real-time performance issues and determine root cause and resolution

Project Work as Needed

• Work on various projects as directed in partnership with the development and other teams

Cloud Database Architecture and Security

• Research and provide guidance on new database technologies implementation



• Follow organization security standards and procedures

Mentoring

• Work with development teams to communicate and encourage database and T-SQL best practices



• Provide guidance to development teams to ensure T-SQL code is scalable and performant

Qualifications

Required Education and Experience:

• Bachelor's degree in Computer Science, MIS, Math or technical field or equivalent combined work experience



• 4+ years working with relational database systems



• 3+ years Database Design / Data Modeling



• 3+ years Microsoft SQL Server 2019 and newer



• 2+ years Azure SQL Managed Instance and Azure SQL Database



• 2+ years working in a high demand 24x7 web environment including participation in a production support oncall rotation



• 3+ years writing, optimizing, and supporting T-SQL



• 2+ years experience with performance monitoring and tuning tools including SQL Server Query Store and Extended Events



• Understanding of T-SQL execution plans



• Proven success identifying and proposing solutions to performance problems



• Experience managing database security using least-privilege methodology



• Experience automating tasks with SQL Agent and Azure Automation PowerShell Runbooks



• Experience creating and enforcing data and database coding standards



• Experience creating technical documentation



• Ability to work across functional groups, development, operations, configuration management, end users, and program managers on multiple projects

Additional Desired Knowledge, Skills & Abilities:

• MySQL experience preferred



• Experience working with data security preferred



• Experience with Change Data Capture or Change Tracking a plus



• Experience with GitHub a plus

Who we are:

At Pearson, our purpose is simple: to help people realize the life they imagine through learning. We believe that every learning opportunity is a chance for a personal breakthrough. We are the world's lifelong learning company. For us, learning isn't just what we do. It's who we are. To learn more: We are Pearson.

Pearson is an Equal Opportunity Employer and a member of E-Verify. Employment decisions are based on qualifications, merit and business need. Qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, age, national origin, protected veteran status, disability status or any other group protected by law. We actively seek qualified candidates who are protected veterans and individuals with disabilities as defined under VEVRAA and Section 503 of the Rehabilitation Act.

If you are an individual with a disability and are unable or limited in your ability to use or access our career site as a result of your disability, you may request reasonable accommodations by emailing [Confidential Information].

Job: Engineering

Job Family: TECHNOLOGY

Organization: OCTO

Schedule: FULL_TIME

Workplace Type: Hybrid

Req ID: 24245