Database Engineer

Company: Covenant Living
Location: Skokie
Posted on: June 25, 2022

Job Description:

We Are Inspired to Serve. Join us!The Data Engineer role is responsible for the performance, integrity and security of the database(s). This includes being involved in the planning and development of the database, as well as troubleshooting any issues on behalf of the users. This position also performs a key function in the business with developing, maintaining and enhancing our Business Intelligence Dashboards and reporting.

Responsibilities include:

• Install, configure and monitor SQL enterprise servers
• Work with Business stakeholders to generate insights and present these findings in visually rich dashboards
• Translate business requests and KPIs into relevant data sources to be able to adequately build and design reports.
• Maintain regular touchpoints with business stakeholders to ensure existing reports and dashboards are functioning and meeting the business needs
• Manage database clusters and failover scenarios
• SQL server performance analysis and tuning using diagnostic tools
• SQL server job automation using SQL agents
• Backup and recovery of large databases
• Disaster recovery and business continuity planning
• Database administration in virtual environments like VMWare
• SQL Data warehouse performance tuning
• SQL index design and tuning
• PowerShell scripting experience
• Maintain and customize dashboards in Power BI
• Review and implement application API integrations to add additional sources to the datasetRequired Skills:
  • Expertise in Microsoft SQL Server.
  • Excellent communication skills ability to understand the requirements and implement or present the story in a meaningful way
  • Good program management and change management skills ability to work in very agile environment with quick turnaround
  • Experience with scripting in Python is a plus
  • Experience with Varigance BimlFlex data vaulting is a plus
  • Experience with data visualization in excel and PowerPivot a plusFor full time employees, we offer a generous benefits package that includes:
    • Medical, dental and vision insurance
    • Employer paid group term life and disability
    • Paid Time Off (PTO) & six paid holidays
    • 403(b) with a 3% employer match
    • Fitness center use at most facilities.
    • Various voluntary benefits:
      • Life, AD&D
      • Tuition assistance and scholarships
      • Employee assistance program
      • Legal services, home/auto insurance, discount purchasing program
      • Pet InsuranceFor more information about Covenant Living and CovenantCare at Home, please visit www.covliving.org or www.covenantcareathome.org.
        
        Covenant Living and CovenantCare at Homeare equal opportunity employers. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin or ancestry, age, disability, marital status, pregnancy, protected veteran status, protected genetic information, or any other characteristics protected by local laws, regulations, or ordinances.
        
        Required qualifications:
        • 18 years or older
        • At least high school diploma or equivalent or higher
        • Able to comfortably lift 40 lbs
        • Able to stand for duration of shift
        • Legally authorized to work in the United States
        • Reliable transportation to and from work
        • Background check

Keywords: Covenant Living, Skokie , Database Engineer, Other , Skokie, Illinois