Shelby County Schools

  • Database Engineer

    Posted Date 1 week ago(5/17/2018 5:12 PM)
    Location Name
    Central Office
    Salary Min
    USD $72,235.00/Yr.
    Salary Max
    USD $94,989.00/Yr.
    Category
    Central Office
    # of Openings
    1
    Close Date
    5/31/2018
  • 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 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

    1. 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.
    2. Responsible for managing permissions, data transfers, overall health and performance of the integration management solution and MS SQL warehouse in a cloud environment.
    3. Works closely with vendor managed services team to maintain structured, high performing cloud environment.
    4. Identifies and execute database improvement opportunities to provide a superior experience for end users performing ad hoc analysis.
    5. Develops, promotes, and deploys stored procedures that improve data accessibility and optimize new reporting requirements.
    6. Determines, enforces and documents database policies, procedures and standards.
    7. Completes tests and evaluations regularly to ensure data security, privacy and integrity.
    8. 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. 

    Knowledge, Skills, and Abilities

    • Demonstrated skills for Web Services environments, languages and formats including RESTful, APIs, HTML, Javascript, XML, SOAP, JSON
    • Expertise with SQL (Microsoft, Oracle, PostgreSQL, MySQL, etc.), including the creation of complex views, stored procedures, and/or packages
    • Knowledge of Ed-Fi or other educational data standard including the supporting definitions and structures
    • Must have a strong understanding of database schema object management, data modeling and architecture.
    • Strong background in implementing complex database stored procedures, functions, and trigger in PL/SQL, T-SQL or similar language
    • Experience with some of the modern relational databases
    • Skilled at optimizing large complicated SQL statements
    • Knowledge of best practices when dealing with relational databases
    • Ability to document and diagram technical systems and architectures.
    • Ability to analyze complex data structures with minimal direction
    • Understanding of iPaaS models and data warehouse theory
    • Ability to monitor and maintain data quality and standards
    • Strong team player with willingness to collaborate
    • High comfort level working on multiple simultaneous assignments and dealing with assignment prioritization changes
    • Excellent organizational, time management, written and verbal communication skills
    • History of working cooperatively within a team environment and communicating with a wide range of people with varying levels of responsibility
    • Demonstrated ability to work independently at times with minimal supervision and assistance.

    Physical Requirements and Working Environment

    Physical Demands: Requires sedentary work involving standing or walking for brief periods, exerting up to 10 pounds of force on a regular basis; and some dexterity in operating office equipment; must be able to use hands and fingers for sign language.

     

    Unavoidable Hazards:  The position is exposed to no unusual environmental hazards.

    Sensory (ADA) Requirements: The position requires normal visual acuity and field of vision, hearing and speaking abilities.

     

    AMERICANS WITH DISABILITIES ACT COMPLIANCE

    Shelby County Schools is an Equal Opportunity Employer.  ADA requires the district to provide adequate accommodations to qualified persons with disabilities. Prospective and current employees are encouraged to discuss ADA accommodations with management.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed