Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the Kansas City, St. Louis, Denver, and Dallas Areas.
We are currently looking for an IT Analyst to join our team.
Perform assigned SQL reports design, engineering and development efforts required to deliver required or requested reports on time and with highest quality.
Provide SQL diagnostics and troubleshooting including advanced data mining assistance for internal and client related requests or issues.
Review and translation of SQL database information, internal application error logs, IIS and OS logs, and Windows Event Viewer logs.
Provide installation, maintenance, and support of web-based software programs for multiple software product lines.
Perform advanced troubleshooting and resolution for client troubles escalated from Client Services
Complete file transfers, database backups, database restoration and validation.
Perform upgrades, software conversions, server updates and package installations including implementation and interface assistance.
Complete operational performance monitoring and maintenance for all product and service related platforms.
Availability via cell phone when not working in the office in an on-call capacity.
A BS/BA or equivalent experience in Computer Science, IS/IT or equivalent experience is required for this position.
Minimum of 5 years of third level technical support experience dealing with and resolving complex database issues through queries, assessing and modifying stored procedures, database troubleshooting procedures and database performance maintenance.
Extensive knowledge of SQL 2008 R2 and SQL Server Integration Services (SSIS) is required.
Technical understanding of SSRS report server configuration is also required
At least 5 years professional experience with direct client contact
Minimum of 5 years professional experience in a Systems Administration, DBA or application level Technical Support position
At least 5 years of web-based applications and services with technical support experience, primarily in understanding IIS configuration and troubleshooting
Minimum of 5 years of networking experience, primarily in understanding how to troubleshoot and resolve network connectivity and performance issue preferred
Understanding of TCP/IP protocols, SMTP, DNS, HTTP, etc.
Understanding of WAN, LAN, networking, switch environments, DHCP, NAT, and firewall applications
Strong server, database, networking and desktop computer skills including working knowledge of Windows server and desktop operating systems, network, computer hardware, applications, web-based software programs, and peripherals
Experience in MS Office and a general use of CRM program software
Knowledge of Remote Desktop, DameWare, pcAnywhere, and/or other remote connectivity software
Ability to work as an unbiased, collaborative team member in an ever changing environment
Extremely strong diagnostic and discovery skills
Understanding of Visual Basic (VB) terminology
Possesses motivation, a sense of urgency, and is results oriented to meet commitments
Technical Project Manager and Business Analyst skills
Excellent written and verbal communication skills
Excellent interpersonal skills
Critical Thinking and Problem Resolution — Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems
Judgment and Decision Making — Considering the relative costs and benefits of potential actions to choose the most appropriate alternative
Obtaining Information — Observing, receiving, and otherwise finding information from all relevant sources
Dependability — Reliable, responsible, and dependable at fulfilling obligations
Attention to Detail — Careful about detail and thorough in completing work tasks
Cooperation — Pleasant with others and displaying a good-natured, cooperative attitude
Initiative — Willingness to actively take on responsibilities and challenges
Leadership — Desire to lead, take charge, and offer opinions and direction
Analytical Thinking — Analyzing information and using logic to address issues and problems
SQL 2008 R2, SQL 2012 R2, SQL 2014 R2 and SQL Server Reporting (SSRS) certifications are preferred
Network administration certification a plus
A+ technical certification or equivalent is preferred
Knowledge in SQL 2012 and/or SQL 2014 is a plus.
Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.
Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.