SQL Database Administrator - Need Locals
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