Job description

Junior Database Administrator job at Jobright.ai. Bloomington, MN. 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.

Requirements