Hi Partner
We are looking for a SQL Server Production Support Consultant for one of my
Clients.
*Title*: SQL Server Prodution Support Consultant
*Location*: Chicago, IL [Local / Nearby] F-F Must
*Experience*: 8+ years
*Rate*: $ 40 / hr on C-C [All Inclusive]
*Duration*: 12 Months +
*Start Date*: Immediate
*Job Description:*
**
Responsible for the design, development, coding, testing, debugging and
documentation of applications to satisfy the requirements of one or more
user areas. May include hands-on new development as well as support,
maintenance or enhancement of existing applications. Works closely with
client management to identify and specify complex business requirements and
processes. Researches and evaluates alternative solutions and makes
recommendations.
*Duties:*
This person will triage Production Incidents and resolve to defects or
create scripts to run against SQL DB to fix data.
You will be required to provide day to day production support of the
in-house applications from a MS SQL perspective.
This demands intense troubleshooting/problem-solving skills in a dynamic
environment.
SQL script writing will be required to mitigate issues resulting from data
conditions and analysis of issue due to defects in stored procedures, views
and functions.
You will be part of the oncall rotation with limited shift and weekend work
and will be expected to handle a variety of support including application
and file transfers while on call.
Troubleshooting production incidents, incident management, SQL authoring
*Production Support -
*
*A*bility to code/provide support in ANSI SQL i.e. raw SQL....not in
conjunction with the tools and plugins that help with SQL ability to
write/troubleshoot a basic select statement (to select data from a database)
in SQL ability to write/troubleshoot indexing (indexing refers to how the
data is organized in the database; much like an index in a library works)
troubleshooting indexes help in the performance and tuning of the database.
Based on this information, we should be more database/support centered than
application
They need to understand Troubleshooting and also understand a Windows
environment. He can take someone who is an expert in one area and train
them in the other, but can't train them in both. Manager feels that
"programmers" do not think on their own and he needs someone who can write
simple code and understand how to triage production indecents.
*Windows Infrastructure* - (used to find and view productions issues; they
do not use an incident tree to locate where incidents originate so the
following basic windows troubleshooting skills are needed to locate the
source of hte issue before resolution, triage even begins).
1. Terminal Services
2. Browsing from Desktop to Desktop on a Network, not just Map shore.
3. Event Viewer, advanced understanding.
1. -go to logs
2. - log views
- the three types of log views, why / how they are different
*Skills: MS-SQL, Scripting, SQL*
Thanks & Regards
Subash
|SageIT Inc |Direct:972-996-0650 Ext: 323
2801 Network Blvd, Suite 507,
Frisco, TX 75034
*[email protected] * | [email protected]
IM : subash.sageit
GTalk : subash.sageit
FAX: 214-619-2033
