[Hiring] Senior Cloud Services Engineer @Pearson

Role Description

As Senior Cloud Services Engineer, 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. You will work 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, applying 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.

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.

Qualifications

• Bachelor’s degree in computer science, MIS, Math or technical field or equivalent combined work experience
• 7+ years working with relational database systems
• 5+ years Database Design / Data Modeling
• 5+ years Microsoft SQL Server 2019 and newer
• 3+ years Azure SQL Managed Instance and Azure SQL Database
• 5+ years working in a high demand 24x7 web environment including participation in a production support on call rotation
• 5+ years writing, optimizing, and supporting T-SQL
• 5+ years’ experience with performance monitoring and tuning tools including SQL Server Query Store and Extended Events
• Deep understanding of T-SQL execution plans
• Proven success identifying and proposing solutions to performance problems
• Advanced experience managing database security using least-privilege methodology
• Advanced 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
• MySQL experience preferred
• Experience working with data security preferred
• Data Warehousing experience - NICE TO HAVE
• Experience with Change Data Capture (CDC) is preferred
• Experience with Change Tracking a plus
• Experience with GitHub a plus
• Ability to see industry trends as they apply to databases

Requirements

• 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 modelling, 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

Company Description