IT

Related Categories

IT
Title SQL Server DBA/Developer
Categories IT
Location Mission, KS
Job Information

Summary

Support data processing products and services across. This role will share responsibility for maintaining and supporting all Production/QA/development database servers along with database development to support the business. The Database team provides support for departmental reporting, development team and data warehouse initiatives. This role will participate in on-call and off hour deployment rotation.

 

Essential Duties and Responsibilities include the following.

  • Install, Configuring, Patching and Upgrading SQL Server Database Servers
  • Performance Tuning and Query Optimization using native SQL Server tools
  • Monitor and support High Availability Database server including Availability Groups and Replication.
  • Ability to troubleshoot performance issues impacting production databases.
  • Work as part of a project team to coordinate database development and determine project scope and limitations
  • Create functions and stored procedures to provide custom functionality as per the requirements.
  • Ad-hoc query generation using T-SQL
  • Develop reports using SQL Server Reporting Services.
  • Participate in development and creation of Data warehouses.
  • Participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.
  • Other duties may be assigned

Education and/or Experience

Bachelor’s degree from a four-year college or university; or four to five years related experience and/or training; or equivalent combination of education and experience.  Must be able to work under minimal supervision, maintain confidentiality of information, and communicate and work effectively throughout all levels of the organization.  Proficiency with SQL Server and T-SQL is required.

 

Other Skills and Abilities

  • Experience in Database Administration in SQL Server (2008/2012)
  • Strong SQL coding skills (SQL Server/T-SQL), including stored procedures.
  • Experience with data modeling including normalization, logical and physical designs.
  • Performance Tuning, Query Optimization, Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Strong knowledge of backups, restores, recovery models, DBCC commands, Database mirroring, Replication.
  • Knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
  • Knowledge of SQL Server tools (Profiler, SSMS, DMVs, and system stored procedures
  • Database Security
  • Technical documentation skills

 

Apply Now


Title Help Desk Technician
Categories IT
Location Las Vegas, NV
Job Information

 

Summary The Help Desk Technician is responsible for providing first level technical assistance to computer users. The Helpdesk Technician responds to telephone calls, electronic mail, and other inquiries from computer users regarding hardware, software, networking or other IT-related problems or needs; logs, tracks, escalates, and resolves work orders; or refers the issue to specialized IT staff.

Essential Duties and Responsibilities include the following:

Review and sort Helpdesk tickets as they come in and assign to the correct technician.

Address assigned Help Desk tickets and resolve in a timely, appropriate manner.

Build and configure new desktop or laptop systems, and install needed software per user profile.

Install and configure new thin client workstations including monitor.

Install new phones and configure on the I3 phone system.

Create new user accounts in Active Directory and add to proper workgroups; grant needed permissions.

Create new user accounts in Microsoft Exchange and configure mailbox.

Create new user accounts in Interaction Admin. and configure phone profile.

Troubleshoot issues with technology equipment.

Install new software on user systems as needed.

Contact vendors and order new computer systems, and new hardware, as needed.

Maintain IT equipment located in conference rooms and training areas, and assist as needed.

Assist users with printing, scanning and copying equipment.

Troubleshoot system access problems.

Maintain inventory of equipment and parts; document IT vendor activities.

Perform other assignments as required.

Education and/or Experience

Minimum one year certification from college or technical school; or two to three years related experience and/or training; or equivalent combination of education and experience.

Certificates, Licenses, Registrations

A+ Certification and Active Directory knowledge required; Network + certification desired.

Apply Now