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 districts 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
Bachelors or Masters 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 (401kwith 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 ITis 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.
Required Skills:
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. Responsibilities may include but are not limited to: 2 years demonstrating professional desktop support history with a variety of platforms / systems / applications and tools to include Operating system expertise - Windows Unix/Linux Apple Network protocol and Image loading protocol 2 years LAN/NETWORK connectivity and basic network connectivity assessment for troubleshooting or setups 2 years of experience in connectivity and telecommunications/networking Evaluates and tests software programs to verify functionality according to specifications and standards Demonstrates excellent Customer Service Install and configure network devices (i.e. network printers scanners plotters PCs etc.). Troubleshoot problems with network printing and scanning devices. Perform data termination/ activation in telecommunication closets aka network connect (activation of data drops). Repair and replace data connectors on network cables and data drops. Assist in the relocation of customer employees on the facility (move PCs and activate data drops in new location).Troubleshoot network issues with PCs and LAN (duplex mismatches duplicate IPs corrupt firewall software proxy configuration issues etc.) Assist with imaging of laptops and PCs for deployment.
Required Education:
Bachelors or Masters Degree from an accredited university or its foreign equivalent in Computer Science or Information Systems/Technology.
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 districts Student System Power School Data Warehouse Laserfiche document management and ot...
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 districts 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
Bachelors or Masters 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 (401kwith 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 ITis 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.
Required Skills:
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. Responsibilities may include but are not limited to: 2 years demonstrating professional desktop support history with a variety of platforms / systems / applications and tools to include Operating system expertise - Windows Unix/Linux Apple Network protocol and Image loading protocol 2 years LAN/NETWORK connectivity and basic network connectivity assessment for troubleshooting or setups 2 years of experience in connectivity and telecommunications/networking Evaluates and tests software programs to verify functionality according to specifications and standards Demonstrates excellent Customer Service Install and configure network devices (i.e. network printers scanners plotters PCs etc.). Troubleshoot problems with network printing and scanning devices. Perform data termination/ activation in telecommunication closets aka network connect (activation of data drops). Repair and replace data connectors on network cables and data drops. Assist in the relocation of customer employees on the facility (move PCs and activate data drops in new location).Troubleshoot network issues with PCs and LAN (duplex mismatches duplicate IPs corrupt firewall software proxy configuration issues etc.) Assist with imaging of laptops and PCs for deployment.
Required Education:
Bachelors or Masters Degree from an accredited university or its foreign equivalent in Computer Science or Information Systems/Technology.
Your browser does not support HTML5 video. We make the impossible, possible! Expand our presence by providing elite services as a skillful partner to change the user’s perception of the IT Industry while fostering an enjoyab
... View more
Job Location:
Monthly Salary:
Experience Required:
Posted on:
Vacancies:
