Job ID: VA-635642 (97390908)
(Cancelled) Windows/SQL Server Admin with Azure, T-SQL, SSIS, IIS, AWS, WordPress, MySQL, .net, Tomcat, NGINX, Tableau, Quest Spotlight and ArcGIS experience
Location: 109 Governor Street, Richmond VA (VDH)
Duration: 6 months
*local candidates strongly preferred
*interviews to be conducted by Skype or Google Hangout
*some after-hours and weekend hours required based on workload
*candidates must participate in on-call rotation
*****candidate hired will work ONSITE 50% of the time NOW, NO exceptions, and work ONSITE 100% of the time after restrictions are lifted*****
Skill Required / Desired Amount of Experience Expertise Rating
Sql server administration starting from 2008/2012/2016 versions with Alway-On Required 10 Years
SQL Server in Azure, AZure SQL Required 5 Years
T-SQL, Stored Procedure, SSIS, SSRS Required 5 Years
IIS with Security experience Required 5 Years
Experience in AWS – EC2, IAM, S3 Required 3 Years
Experience in Azure – VM, App Service, Azure AD, Azure Storage Required 4 Years
Wordpress Administration Required 4 Years
MySQL and Amazon RDS for MySQL Required 4 Years
Windows Server 2008+/Linux Redhat v7+ Required 3 Years
.NET Development:ASP.NET, ASP.NET MVC, WPF, WCF Required 3 Years
Tomcat, NGINX Required 3 Years
Tableau administration Required 3 Years
Sql server backup/recovery/performance tuning Required 5 Years
Quest Spotlight for SQL Server Enterprise Required 5 Years
ArcGIS setup/administration Desired 3 Years
General Job Description:
The following are deemed the most important in order for the applicant to make an immediate contribution to our organization:
• Windows and Linux administration experience in server setups and configurations as fileservers and database servers (MySQL and SQL-Server).
Triage server issues and document root cause analysis.
IIS configuration including security modifications
Implementing CIS recommendations to NGINX, IIS, WordPress.
Resolving server security scan issues.
Server and database level performance monitoring and metrics.
Knowledge of firewalls and common port usage.
• Visible contextual experience in the above areas. *this is a key requirement. We want to see where/how they applied their knowledge and experience.
• There will be little to no hand-holding for the selected candidate so the resume needs to illustrate what they have accomplished.
ABOUT THE ROLE
This resource will work as part of the Virginia Department of Health, Office of Information Management (OIM-DBA) team. The team member will assist in maintenance and administration of SQL Server databases that support critical multi-tier applications implemented mostly in Windows environment using MS suite of tools. The resource will also support administration and maintenance of the agency website that uses WordPress/MySQL set-up. The OIM-DBA team is currently tasked with developing a migration plan to transition from traditional data center environment to the Cloud infrastructure (private/AWS/Azure); the resource will help in coordinating this effort, provide technical assistance in configuring the new set-up with emphasis on security, compile test plans, implement and adopt new features, set-up monitoring and automate processes; document time and effort. The contractor should be able to work and communicate with vendors if required and share timely updates with the team.
Sql server administration starting from 2008/2012/2016 versions with Alway-On
SQL Server in Azure, AZure SQL
T-SQL, Stored Procedure, SSIS, SSRS
IIS with Security experience s –
Experiences in Azure – VM, App Service
Experiences in Azure – VM, App Service, Azure AD, Azure Storage
MySQL and Amazon RDS for MySQL
Windows Server 2008+/Linux Redhat v7+
.NET Development:ASP.NET, ASP.NET MVC, WPF, WCF
Sql server backup/recovery/performance tuning
Quest Spotlight for SQL Server Enterprise