Complete Description:
*local candidates strongly preferred
*ONLY in-person interviews will be conducted, NO Skype, NO exceptions
Seeking a highly skilled, technologically diverse, senior-level SQL Server Engineer with experience working in multi-tiered server environments. This position will provide technical guidance and support in the areas of server and applications architecture, systems design and integration, specialized code deployments, and Internet/Intranet deployment. Position will be involved in many aspects of Engineering & Technology section in VDOT’s IT Division in supporting a sundry of agency applications. Demonstrated ability to work independently and complete assigned project responsibilities under limited supervision. Daily tasks include but not limited to, technical solution design and delivery, application deployments, application operations and troubleshooting issues. Extensive systems administration experience on the Windows Server platform, including the following technologies: SQL Server Administration, SQL Clustering, SQL DB Encryption and recovery, SQL DB tuning, Application High-Availability, Visual Studio experience, web infrastructure and operations including IP, HTTP, HTTPS, FTP. Candidate should be knowledgeable of load balancing principles, firewall rules, failover, as well as experience in monitoring, diagnostics, etc. Experience in architecting Microsoft Internet/Intranet solutions, SQL migrations, query writing, ability to understand and perform limited custom coding for different solutions. Possess high aptitude for problem-solving and trouble-shooting. Knowledge of requirements and tools for application, database and server security and mitigate risks for audit points. Prepares detailed system deployment documentation and operations manuals. Installs and configures application software for various project teams meeting project deadlines. Ability to asses needs, make recommendations and perform installs/upgrades of application software as required. Experience and skills in prevailing industry architecture and engineering methodologies such as ITIL. Works closely with client/application architects, senior managers, system engineering peers and project managers to design and assist with the implementation of the solutions infrastructure related components. Ability to work under pressure while meeting project deadlines. Relies on years of experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, while a wide degree of creativity and latitude is expected. College Degree in Computer Science, Information Systems, or equivalent work experience in applications and server architecture desired. Backup and restore databases between multiple environments and locations
Skills:
Skill
Required / Desired
Amount
of Experience
SQL Server 2005, 2008, 2012, SQL Server Reporting Services, SQL Cluster Configs and implementation
Required
8
Years
.NETFramework 2.0 - 4.5, IIS, MTS, COM, DCOM, Microsoft DTS and SSIS packages
Required
8
Years
Server administration of Microsoft Server OS 2003, 2008, 2012
Required
8
Years
Application and infrastructure architecture design experience and knowledge of firewall security
Required
8
Years
Visual Interdev 6.0, ASP, XML coding
Required
5
Years
BizTalk 2010, Administration and experience creating custom adapters
Nice to have
1
Years
JavaScript, Apache TomCat
Required
3
Years
Unix/Linux OS System Admin
Nice to have
1
Years
IBM WebSphere DataStage and QualityStage 8.1 running on AIX UNIX
Nice to have
1
Years
K2 Blackpearl
Nice to have
6
Months