Junior Database Administrator Job at Jobright.ai, Bloomington, MN

bm1jaEVjQ3FqRmxXZyswWHNKdWUvU3dvblE9PQ==
  • Jobright.ai
  • Bloomington, MN

Job Description

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.

Job Summary:

Pearson is a leading education company, and they are seeking a Database Administrator to manage their database systems. In this role, you will be responsible for the architecture, planning, implementation, and maintenance of database systems, with a focus on Azure technologies and performance tuning.

Responsibilities:

• 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

• Review data models to ensure optimal database performance

• Performance tuning

• Work on various projects as directed as part of the development team

• Research and provide guidance on new database technologies implementation

• Work with development to communicate the best database practices

Qualifications:

Required:

• 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

Preferred:

• 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

Company:

Pearson operates as a media and education company that offers a wide range of services to its customers. Founded in 1998, the company is headquartered in London, England, GBR, with a team of 5001-10000 employees. The company is currently Public Company. Pearson has a track record of offering H1B sponsorships.

Job Tags

Work experience placement, H1b,

Similar Jobs

Chick-fil-A Cottonwood FSR

Trabajo en un restaurante de Chick-fil-A Job at Chick-fil-A Cottonwood FSR

 ...manera y puedas transmitir lo mismo por cada uno de los clientes. Descansamos los domingos, ofrecemos comida gratis durante el turno de trabajo, horarios de trabajo son muy flexibles, ofrecemos pago competitivo, beneficios, y tambin donamos $25,000 en becas escolares... 

The Cove

Room Attendant - Puesto De Limpieza Job at The Cove

 ...exceptional guest experience.Responsibilities: Responsabilidades del Trabajo: Cumplir con las solicitudes de los huspedes puntualmente....  ...trabajar en The Beverly Hotel en Beverly, MA 2-3 Dias por semana. Estamos comprometidos a contratar una fuerza laboral diversa... 

Get It - Marketing

Senior Ecommerce Manager, Amazon - Remote | WFH Job at Get It - Marketing

Senior Ecommerce Manager, Amazon Location: Hybrid - Remote & Greater Los Angeles Area Salary: $100,000 - $130,000 About the Role We're looking for a Senior Ecommerce Manager, Amazon to drive growth and optimize performance across our Amazon portfolio. Reporting... 

USA DeBusk, LLC

Industrial, Oil & Gas Chemical Cleaning Operator Job at USA DeBusk, LLC

 ...Industrial, Oil & Gas Chemical Cleaning Operator - Experienced Classification: Non-Exempt Department: UDCC Reports to: Supervisor / Project Manager / Operations Manager Company Profile: USA DeBusk is a best-in-class mechanical and industrial cleaning... 

Parks Lincoln of Tampa

Body Shop Repair Technician Job at Parks Lincoln of Tampa

 ...our vehicles are Ford/Lincoln, Toyota, and Honda less than 5 years old. Call and ask for Ron - (***) ***-**** On the Spot Interviews, and FAST Hiring process! Be part of one of the BEST dealerships in Tampa Bay! Benefits Competitive compensation plan* 401(k) retirement...