We are seeking skilled SQL - Database Administrator, for SQL 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 SQL Server based database and applications and to perform following duties:
• 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 Transact-SQL 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, Qlik-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.
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 experience 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
Benefits
Benefits
- Health Care Plan (Medical, Dental & Vision)
- Retirement Plan (401k,with matching)
- Life Insurance Plan
- PTO
- Short Term & Long-Term Disability
- Internet & Phone Allowance (for applicable roles)
- Wellness Resources (EAP)
- Pet Insurance
- Work-Life balance
- Flexible Hours
- Full-Time Permanent Positions
JW Affinity IT is a full-service IT solutions provider supporting schools and private organizations with strategic, innovative technology projects. We take the time to understand our clients’ needs to successfully develop, implement, and manage each initiative. JW is a certified small, woman- and minority-owned business through the National Minority Supplier Development Council.
We are committed to fostering a diverse, inclusive, and innovative workplace where different perspectives lead to better IT solutions. As an Equal Opportunity Employer, we welcome applicants from all backgrounds and are dedicated to creating an inclusive environment.