Job Description for the Database Engineer position. Review job description, requirements, and qualifications. Apply or register interest for the position.

Title: Database Engineer

Position Type: Staff Full-Time

Days Per Week: Monday;#Tuesday;#Wednesday;#Thursday;#Friday

Hours Per Week: 40

VP Area: Finance and Administration

Department: Information Technology

Position Summary

The Database Engineer is responsible for various data functions of Enterprise Solutions and the University’s databases. Their duties include installation, monitoring, performance, security audits, and account management. The Database Engineer will automate data movement between applications and vendors to support the University’s goals. Communication and attention to detail will be essential skills to help solve complex business needs and implement data projects across the campus. Ongoing maintenance of a database requires being on call. This person will learn the business needs for interacting with the various software solutions and data and attend classes and conferences as necessary to keep skills sharp.

Benefits of Working at Elon

Benefits of Working at Elon University 

As an Elon University employee, you’ll join an internationally acclaimed university with a commitment to fostering a thriving community. Ranked among the most innovative, creative and best-run universities in the nation, Elon’s personal approach to education extends to employees, whose growth, professional development and success is a hallmark of our training and advancement opportunities.

Elon University’s home is the charming town of Elon, North Carolina, a small, friendly community located a short distance from the beach and the mountains, and among the vibrant cities of Greensboro, Raleigh and Durham. In addition to the beautiful canopy of historic oak trees iconic to our campus, you’ll find boundless opportunities for family-friendly recreation, cultural events and outdoor activities. Hiking, water sports, fine dining and entertainment are just a few of the many happenings in the Elon area, making the region one of the nation’s premier travel destinations.

Employees at Elon enjoy a generous and comprehensive benefits package that includes:

28 annual days off, including holidays and vacation.

Immediate tuition remission for undergraduate courses

Tuition remission for approved graduate-level courses after 12 months of employment.

Retirement plan with an 8 percent contribution from the university.

Immediate eligibility for health, dental and vision insurance, along with free acute care and lab services at our onsite Health & Wellness Clinic.

Free use of campus fitness facilities.

Free admission to musical and theater performances, guest speakers, religious and ethnic observances, recitals, art exhibitions, entertainment and our Division I Phoenix athletics.

Eligibility for tuition remission at Elon for spouses, qualifying domestic partners and dependents begins at two years of service. After two years of employment, eligibility begins for participation in the Tuition Exchange, a national scholarship exchange program that enables dependents to enroll in nationally recognized partner colleges and universities.

Elon values and celebrates the diverse backgrounds, cultures, experiences and perspectives of our community members. As an equal opportunity employer, Elon’s principles of diversity extend to race and gender identity, age, disability status, veteran status, sexual orientation, religion, and other aspects of one’s identity. At Elon, our employees respect human differences, passion for lifelong learning, emphasis on personal integrity and an ethic of service.

Minimum Required Education and Experience

Bachelor's degree in STEM with minimum 3 years of experience with the following relevant work experience:
• Strong experience building and improving performance of t-sql queries, views and stored procedures.
• Strong experience gathering requirements and designing and building solutions to meet those requirements.
• Strong experience sourcing and integrating data from disparate data sources (Cloud and on-premise relational databases, APIs, files of varying formats (json, xml, csv and Excel files))
• Strong experience modeling data for both transactional and reporting systems.
• Experience with software development best practices such as agile methodologies, source code control, prototyping, and testing.
• Experience with creating and administering SSRS.
• Experience working in a team-oriented, collaborative environment
• Years of experience as a DBA could replace STEM field of study

Preferred Education and Experience

Master's degree in STEM

Required Other Training, Certifications, or Licensing

Job Duties

• Operational Management: - Installation of new instances of SQL Server, Integration Services, and Reporting Services. - Secure data access to approved users and applications. - Protect databases with regular backups and restores. - Verify successful backups via restore testing. - Monitor database platform performance to maximize resources and licenses. - Perform regular security audits to verify data access and ensure best practices are maintained. - Work with developers with database schema, script creation, and deployment. - Support ongoing maintenance of university databases, including monthly weekend maintenance and monitoring systems after hours and providing on call support as warranted. - Enable data encryption as needed based on personally identifiable information (PII) - Manage service requests through our ticketing systems (Team Dynamics)
• Data Movement: - Create extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) to move data between applications and vendors. - Create PowerShell scripts to automate data movement and operational management tasks. 
• Strategy & Planning: - Create standard documents for SQL Server development and SSIS design. - Research database technology and how that can enable more efficient access/movement of data. - Consult with system analysts and application programmers on program design and access methods.