Database Administrator
Long-term contract; Possibility of contract to hire
100% remote, but must live in DFW
This is starting as a long-term contract and could convert to full-time later down the road.
Hours: M-F Daytime Hours
Job Description:
SQL Database Administrators for SQL Server Applications (Microsoft Business Intelligence Stack (SSIS/SSRS/SSAS)) to manage administrative operations of the school district’s Student System PowerSchool, Data Warehouse, Laserfiche document management, and other SQL Server-based databases and applications, and to perform the following duties.
Responsibilities:
• Assist in installing, configuring, maintaining, & supporting Microsoft Business Intelligence
• (MSBI) applications & SQL Server databases (Latest versions) in production, development, UAT and test environments.
• Assists in the development of high-quality, efficient ETL applications leveraging TransactSQL stored procedures and other ETL environments.
• Monitor the SQL Server database/Business Intelligence environment, including ETL Jobs, Database Refreshes and Maintenance jobs.
• Perform backup and restore all databases.
• Assist in deploying database scripts requested by the Application Development Team.
• Managing database schemas, objects, Tables, Views, Functions, stored procedures, triggers, and Cursors using Transact-SQL for various business applications.
• Developing and implementing database security policies.
• Create and maintain reports involving a variety of features using SSRS, QlikView, and Power BI.
• Error handling and debugging coding issues and troubleshooting production problems.
• Works with the team to create and maintain best-practice standards and procedures guidelines.
Job Requirements:
• Bachelor’s or Master’s Degree from an accredited university, or its foreign equivalent, in Computer Science or Information Systems/Technology.
• 8 years of experience performing SQL Server Applications (MSBI, SQL) Database Administration on Windows platforms.
• Basic experience in ETL design and development, working with SQL stored procedures and/or ETL tools such as Microsoft SSIS.
• Must be willing to work in an on-call production support model