Job Description :
Position: .Net SQL L3/L4 Support
Job location: Alpharetta, GA
Type: Full time & permanent
Job Description::
Windows 2003 / 2008 R2 / 2012 Server
IIS 6.0 / 7.0
SQL 2000 / 2005 / 2008 / 2012
.NET Framework 3.5 / 4.x
JavaScript
XML
Demonstrable knowledge of C#, VB.Net
SharePoint 2010 / 2013
Control-M
Skills:
Read and Modify XML based config files
Experience with Web Services
Read and Modify JavaScript based custom components
Read, Modify and Execute SQL scripts
Verify user and group rights to server machines, folders and files
Verify IIS application permissions and configurations, platform and tasks (security, application pooling, SSL certificates, etc
Demonstrable Intermediate to Advanced knowledge of web platforms such as IIS
Intermediate to senior level .NET programming and/or scripting experience. (C#, Shell Scripting, HTML 5, HTML)
Verify configuration of Windows services
Execute application install packages
Query SQL tables and views to identify data related issues
Analyze XML data feed files to identify data related issues
Analyze SQL execution plans to identify performance bottlenecks
Analyze Windows performance statistics to identify resource bottlenecks
Analyze logs from IIS, Windows events, and SQL to identify errors
Ability to read and understand code (Code-competency) for diagnosis, escalation to tier 4 teams
Knowledge of troubleshooting tools and techniques related to networks and systems i.e. remote access tools, Windows Support tools, connectivity tests, etc.
General understanding of various IT security concepts as they relate to production environments.
Demonstrable knowledge of Stored Procedures, SSIS and Data Transformation Services, Tables, Foreign Keys, Indexes
Familiarity with SQL DBMS interface and integrated tools
Creation of simple queries, running pre-defined scripts, configuration, security, and interpreting logs and traces.
Understanding of n-Tier application architecture concepts.
General knowledge of SQL and In-depth knowledge of MS SQL Server 2008/2012/2014 .
Experience of Active Directory/LDAP
Experience supporting multi-tier environment
Lovekesh Kushwah
Ph Ext: 2196