What are the responsibilities and job description for the SQL Server-Database Administrator with Schoold District epxerience (Preferred Dallas TX) position at TexcelVision Inc.?
Job Description
Job Title: Database Administrator
Client seeks skilled S L - Database Administrator, for S L Server Applications (Microsoft Business Intelligence Stack (SSIS/SSRS/SSAS)) database administrators for managing administrative operations of school district's Student System Power School, Data Warehouse, Laserfiche document management and other S L Server based database and applications and to perform following duties
- Assist in Installing, configuring, maintaining C supporting Microsoft Business Intelligence (MSBI) applications C S L server databases (Latest versions) in production, development, UAT and test environments.
- Assists in the development of high quality efficient ETL applications leveraging Transact- S L stored procedures and other ETL environments.
- Monitor the S L 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-S L for various business applications.
- Developing and implementing database security policies.
- Create and maintain reports involving a variety of features using SSRS, lik-view and Power BI.
- Error handling and debugging coding issues and troubleshoot production problems.
- Works with the team to create and maintain best-practice standards and procedural 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 S L Server Applications (MSBI, S L) Database Administration on Windows platforms.
- Basic experience in ETL design and development experience working with S L stored procedures and/or ETL tools such as Microsoft SSIS.
- Must be willing to work in an on-call production support model