IT Systems Administrator/SQL Database Administrator

IT Systems Administrator / SQL Database Administrator (Office Position)

CLI Services

Position Summary:

Multifaceted role that encompasses all aspects of the management of technology including:

Hardware equipment maintenance, troubleshooting, upgrades, user interface, and modernization

Software database maintenance including SQL uploads, software program integrations, report writing, and software upgrades.

Expertise working with and configuring LANs, WANs, VPNs, intranet, communication and telecommunication systems, and peripheral hardware and software.

Specific duties:

Ability to operate under minimal supervision.

Working technical competency in the following supported platforms: Microsoft SQL Server 2019 Programmer/Administrator, IIS, Windows Server 2019, Windows 10 /11, Microsoft Office 365 and Exchange online, including, Networking/firewalls/vulnerability assessment.

Troubleshoots, repairs, maintains, installs, and performs testing activities on various computer equipment, peripherals, data communication and computer network systems.

Responsible for installation of new computer equipment including routine installation or modification projects with software and hardware integration.

Assist with creating user interfaces, custom reporting, testing and training.

Devise ways to add new functionality to existing computer systems and processes.

Research emerging technologies for possible integration to improve effectiveness and efficiency.

Explore integration with customer requirements on portals and data transfers.

Develop templates for pricing and warranty billings, by customer driven contracts.

Create reporting that will measure profitability by line of business, customer base, and overall productivity.

Work with other departments to evaluate costing and implementation of new potential product and business lines.

Document system reports and processes and incorporate documentation into training guides for departmental and functional use.

Monitor database integrity to ensure security, backups, upgrades, and data consistency are maintained.

Responsible for the importing and exporting of data functions to ensure seamless integration of data and to meet specialized reporting needs.

Responsible for the ongoing infrastructure and provides management with recommendations within the budgetary guidelines provided.

Providing technical support in an end user support role.

Special projects as assigned; this will make up approximately 35% of the job duties.

Requirements:

This is a position that will need excellent communication skills as well as proficiency in excel, access, and experience with extracting data from numerous databases.

Must be able to work independently as well as on a team and produce results within agreed upon timelines. This position will require work outside of normal business hours to support users across a multistate region and not impact business operations.

Bachelor’s degree in business or computer science, with three to five years experience in system integration, network administration, and database administration.

Experience with SQL and Access preferred.

Experience in a construction/distribution environment helpful.

CLI provides outstanding benefits: including full medical, dental, and life insurance. PTO and paid holidays. Come join our winning team!

We maintain a drug-free workplace and perform pre-employment substance abuse and background testing.

Colorado Lighting offers an extensive benefits package. Please visit www.coloradolighting.com for more details.

COLORADO LIGHTING, INC. provides sustainable energy-efficient solutions from consultation through installation and recycling. We enhance the efficiency of lighting and electrical systems for our customers through expert assistance in (1) specifying which products will produce the greatest energy and maintenance savings while providing the best solution to meet customer goals, (2) supplying and installing the new lighting and electrical products and (3) maintaining the lighting and electrical system. Customer service is our number one focus. We provide full-service solutions to our customers; the key element being the long-term relationship we build and maintain. In addition, when we recommend a product or system, we stand behind that product and its performance.

COLORADO LIGHTING, INC. was founded in 1977 and has steadily grown over the past 45 years. We have, on staff, certified lighting consultants, journeyman electricians, master electricians, and certified lighting technicians. Our employees drive fully-stocked service vehicles. In addition to our service vehicles, we have fully stocked bucket trucks with the capability of reaching up to 100 ft. working height. We also have 24-hour on-call service as well as GPS locating capabilities and Nextel 3-way radio communications.