JobCubby JobCubby
Sign up
Memphis Shelby County Schools

Database Engineer

Memphis Shelby County Schools Memphis, Tennessee, United States · $73K–$106K/yr

Education Administration Programs · 10,001+ employees

20 h ago
dba Senior (5-10 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

The Database Engineer will develop, maintain, and monitor the data warehouse and analytics architecture to support reporting needs. They will collaborate with cross-functional teams to transform raw data into accessible data stores while ensuring system performance and security.

What they look for

Microsoft SQL Server Data Warehousing PowerBI Cloud Environment Management Performance Tuning Optimization Stored Procedures Data Security Data Privacy Data Integrity Database Administration SQL Azure iPaaS Analytics Architecture

Requirements

Candidates must possess a bachelor's degree in a relevant field and at least 5 years of related experience. Proficiency in Microsoft SQL Server database administration and experience with cloud environments are highly preferred.

Full description

Purpose and Scope

The Database Engineer for the Decision Analytics & Information Management department will be responsible for developing, maintaining, monitoring and extending the data warehouse and analytics architecture to meet the analysis and reporting needs of Memphis Shelby County Schools. The position will work closely with the decision analytics consultants and our integration management managed service provider integration platform-as-a-service (iPaaS) to transform disparate raw data from multiple platforms into an easily accessible data store through the application of a defined data standard. The position requires flexibility, an eagerness to take on new challenges and collaboration with cross-functional teams to advance the decision analytic capabilities of Shelby County Schools.

Essential Job Functions

  • Works closely with decision analytics team to build/maintain table structure that aligns with date standard, delivers intuitive Microsoft PowerBI visualizations and empowers as hoc querying and analysis of the data by business analysts.
  • Responsible for managing permissions, data transfers, overall health and performance of the integration management solution and MS SQL warehouse in a cloud environment.
  • Works closely with vendor managed services team to maintain structured, high performing cloud environment.
  • Identifies and execute database improvement opportunities to provide a superior experience for end users performing ad hoc analysis.
  • Develops, promotes, and deploys stored procedures that improve data accessibility and optimize new reporting requirements.
  • Determines, enforces and documents database policies, procedures and standards.
  • Completes tests and evaluations regularly to ensure data security, privacy and integrity.
  • Performs all other related duties as assigned or directed.

Minimum Qualifications

Bachelor's degree in Computer Science, Computer Information Services, Computer Queering, Management Information Systems or similar field plus 5 years related experience, for a total education/experience of 9 years.

5+ years of Microsoft SQL Server database administration experience preferred

Experience managing a SaaS environment with a managed services vendor partnership a plus.

Experience with Performance Tuning and Optimization using native monitoring and troubleshooting tools. 1 year of SQL Azure experience would be preferred

Degree Equivalency Formula:

Bachelor’s Degree= 4 years plus required years of experience.

Master’s Degree= 2 years plus required years of experience. Where Master’s degrees are required, years for Bachelor’s Degrees must be included.

Similar roles