Pearson
Responsibilities
Summary
As the 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 a number of internal teams, and serve as the primary source for strategic database architecture, design, planning and implementation; regularly working with development to improve production systems and implement new database layouts and strategies.
As a top candidate you will possess a well-rounded and highly technical background with emphasis on design and performance.
PRIMARY RESPONSIBILITIES
SDLC and Production Database Maintenance
Software Development Life Cycle deployment, implementation and maintenance Database Security Database Change Management Transition changes between development, QC and Production Environments Create database and schedule backup, write TSQL, Capacity Planning and monitoring of the database and other activities as assigned Data modeling, logical and physical database design Database Tuning
Review data models to ensure optimal database performance Performance tuning Project Work as Needed
Work on various projects as directed as part of the development team Cloud Database Architecture and Security
Research and provide guidance on new database technologies implementation Mentoring
Work with development to communicate the best database practices Qualifications
Required Education and Experience:
Bachelor's degree in Computer Science, MIS, Math or technical field or equivalent combined work experience 2+ years working with relational database systems 2+ years Database Design experience Experience with Microsoft SQL Server 2016 and newer Azure SQL - Experience with SQL Managed Instance and Azure SQL Database, and SQL Server on Azure Virtual Machines Experience working in a high demand 24x7 web environment (rotation 1 week/month) Experience writing, optimizing, and supporting T-SQL Experience with T-SQL execution plans Experience identifying and proposing solutions to performance problems Experience with performance tuning tools Experience with Azure Automation Runbooks and PowerShell Experience with SQL Server Query Store Experience with SQL Server Extended Events Experience creating and enforcing data and database coding standards Experience with Database design/Data Modeling Desired Knowledge, Skills & Abilities:
MySQL experience a plus Experience working with data security preferred Data Warehousing experience - NICE TO HAVE Experience with Change Data Capture (CDC) is preferred Ability to create technical documentation Ability to see industry trends as they apply to databases Ability to work across functional groups, development, operations, configuration management, end users, and program managers Ability to work with cross-functional teams and with multiple projects
Compensation at Pearson is influenced by a wide array of factors including but not limited to skill set, level of experience, and specific location. As required by the California, Colorado, Hawaii, Illinois, Maryland, Minnesota, New Jersey, New York State, New York City, Vermont, Washington State, and Washington DC laws, the pay range for this position is as follows:
The minimum full-time salary range is between $95,000 - $105,000.
This position is eligible to participate in an annual incentive program, and information on benefits offered is here.
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 TalentExperienceGlobalTeam@grp.pearson.com.
Job:
Infrastructure and Cloud Operations
Job Family:
TECHNOLOGY
Organization:
Corporate Strategy & Technology
Schedule:
FULL_TIME
Workplace Type:
Remote
Req ID:
20650
Summary
As the 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 a number of internal teams, and serve as the primary source for strategic database architecture, design, planning and implementation; regularly working with development to improve production systems and implement new database layouts and strategies.
As a top candidate you will possess a well-rounded and highly technical background with emphasis on design and performance.
PRIMARY RESPONSIBILITIES
SDLC and Production Database Maintenance
Software Development Life Cycle deployment, implementation and maintenance Database Security Database Change Management Transition changes between development, QC and Production Environments Create database and schedule backup, write TSQL, Capacity Planning and monitoring of the database and other activities as assigned Data modeling, logical and physical database design Database Tuning
Review data models to ensure optimal database performance Performance tuning Project Work as Needed
Work on various projects as directed as part of the development team Cloud Database Architecture and Security
Research and provide guidance on new database technologies implementation Mentoring
Work with development to communicate the best database practices Qualifications
Required Education and Experience:
Bachelor's degree in Computer Science, MIS, Math or technical field or equivalent combined work experience 2+ years working with relational database systems 2+ years Database Design experience Experience with Microsoft SQL Server 2016 and newer Azure SQL - Experience with SQL Managed Instance and Azure SQL Database, and SQL Server on Azure Virtual Machines Experience working in a high demand 24x7 web environment (rotation 1 week/month) Experience writing, optimizing, and supporting T-SQL Experience with T-SQL execution plans Experience identifying and proposing solutions to performance problems Experience with performance tuning tools Experience with Azure Automation Runbooks and PowerShell Experience with SQL Server Query Store Experience with SQL Server Extended Events Experience creating and enforcing data and database coding standards Experience with Database design/Data Modeling Desired Knowledge, Skills & Abilities:
MySQL experience a plus Experience working with data security preferred Data Warehousing experience - NICE TO HAVE Experience with Change Data Capture (CDC) is preferred Ability to create technical documentation Ability to see industry trends as they apply to databases Ability to work across functional groups, development, operations, configuration management, end users, and program managers Ability to work with cross-functional teams and with multiple projects
Compensation at Pearson is influenced by a wide array of factors including but not limited to skill set, level of experience, and specific location. As required by the California, Colorado, Hawaii, Illinois, Maryland, Minnesota, New Jersey, New York State, New York City, Vermont, Washington State, and Washington DC laws, the pay range for this position is as follows:
The minimum full-time salary range is between $95,000 - $105,000.
This position is eligible to participate in an annual incentive program, and information on benefits offered is here.
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 TalentExperienceGlobalTeam@grp.pearson.com.
Job:
Infrastructure and Cloud Operations
Job Family:
TECHNOLOGY
Organization:
Corporate Strategy & Technology
Schedule:
FULL_TIME
Workplace Type:
Remote
Req ID:
20650