IZN1513 SQL Infrastructure DBA II

Twitter Facebook
Apply
Location
Burlington, VT
Job Type
Direct Hire
Date
Aug 11, 2017
Job ID
2502536
SQL Infrastructure DBA II
Location: 
Burlington, Vermont
Clearance: Clearable US Citizen 

Our great client is a leading provider of cloud managed services, agile software development, DevOps, systems engineering, and IT service management.  We work collaboratively with our customers to solve their biggest challenges through a commitment to delivering innovation, agility, and maximum value. Our employees are empowered to think outside of the box and provide innovative solutions to our customers and provide measurable cost savings.

Position Description: 
We are working to grow our team for an important mission with one of our federal government clients, when you join you will be part of an important and ex
citing mission that provides SQL Infrastructure DBA engineering information technology expertise, strategic vision and tactical implementations using frameworks that require cloud services that are virtualized, scalable, cost effective and that utilize DevOps practices.   The successful candidate is one who has had repeated success commanding respect as an articulate, creative problem solver comfortable acting as a trusted advisor and thought leader to senior Government customers, giving them expert advice on technical tradeoffs and risks, as well as designing technical solutions and commanding the respect of the highly technical engineers who will implement the solutions.
 
Responsibilities:
  • Deliver high quality IT service policies for SQL Database services within Private Cloud for applications
  • Define health check processes for production databases within Cloud and high availability clustering support such as "Failover", "AlwaysOn"
  • Deliver high availability IT services configurations
  • Ensure effective DR process in accordance with industry standards
  • Drive forward a proactive approach with "virtualization" based on HyperV and VMware in the team to support the business by offering critical support services
  • Working in a team environment with following components including Citrix VDI, Server, Storage, Network Management, Network Security, Automation / Service Center tools, Collaboration, and Service Operations
  • Experience with "AlwaysON" Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
  • Experience with in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using SQL Server monitoring utilities
  • Ability to detect/troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering
  • Provide data modeling expertise to the development staff
  • Provide level 4 support to technical operations regarding database systems
Qualifications:
  • 7+ years previous experience as a SQL Infrastructure DBA
  • Windows SQL Server 2012, 2014 and 2016 with HyperV and VMware
  • Experience of SQL clustering and Always-On
  • Experience of scripting languages including T-SQL, VB Script required and PowerShell
  • Experience with Data warehouse, SSIS, Cubes and Report server.
  • Proven experience with Backups, Restores and participated in Disaster Recovery Drills
  • Familiar with Trend and Capacity Planning tools and processes
  • Experience of High Availability technologies, Disaster recovery (Always on , Mirroring, Log Shipping, Database Partitioning, Replication, and Clustering
  • SQL Server certifications is a plus
Education: 
  • Minimum of a Bachelor’s Degree in Information Technology, Computer Science, Engineering or related technical degree