SQL Engineer




Ortman Consulting is looking for a SQL Engineer. The ideal candidate should have at least 3-5 years of experience with SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, and SQL Server 2008. This position is targeted for both dedicated support roles and short term reactive support and proactive engagements where overnight travel is required.

The selected candidate must be able to start within 30 days of offer acceptance.

Required Skills

  • Act as a resource for on-going SQL planning and deployment
  • Help with analysis of migration to new SQL environments
  • Identify compatibility issues on SQL Server 2014 & 2012 databases that would prevent upgrades
  • Fix or remediate source objects to make them compatible with SQL 2014
  • Produce a set of scripts designed to remediate production SQL 2014 databases
  • Provide assistance to administrators to resolve script deployment issues in production environment
  • Work with application owners to provide fixes for issues classified as simple remediation items
    • These contain no functional changes or expected fixes needed to existing defects
  • Design and adopt an application testing strategy to test the remediated applications
  • Provide guidance on the packaging of applications when changes are made
  • Perform unit testing for database and application changes as well as any required security testing
  • Security enhancements to the existing SQL code

Required Education:

BS in Computer Science or equivalent technical degree and 8+ years of experience in a similar role

Desired Skills:

Strong demonstrable development experience/expertise in one or more of the following technologies is desirable:

  • SQL Server 2012, and SQL Server 2008 R2
  • Exposure to and some knowledge about SQL Server 2014
  • Fair knowledge on Windows clustering – Windows 2008 R2, Windows 2012 and Windows 2012 R2
  • Install, tune and administer SQL 2014 Clusters including Always on Availability Groups
  • Author design documents, build procedure, test procedures
  • Strong familiarity running SQL Server products in a secure environment compliant w/DISA STIG
  • Familiarity with Hyper-v and System Center Virtual Machine manager is a plus
  • Solid understanding of Active Directory (AD) including:
    • Multi-Forest, Multi-domain, and Group Policy to include how SQL is impacted by AD elements
  • Familiarity with PowerShell is a required
  • Experience with Desired State Configuration is a plus
  • Familiarity with SSRS, SSAS, and System Center 2012 R2 product line is a plus
  • Deep technical knowledge/experience on SQL HA/DR solutions.
  • Experience w/SQL Integration, Reporting, and Analysis Services to support Business Intelligence
  • Practical experience troubleshooting performance problems, query tuning and optimization
  • Experience delivering and/or authoring technical training
  • Ability to work independently with minimal management supervision
  • Ability to manage challenging technical issues by:
    • Setting customer expectations
    • Devising and implementing action plans
    • Being available 24×7 and professionally communicating to all parties involved


  • SQL programming skills in one of the following: SQL, VB, VBA, C++, VJ++, VBS, Jscript, HTML/DHTML
  • Active Directory (architecture, design, disaster recovery and troubleshooting), IIS and ISA
  • Debugging skills in the Windows Platform
  • Up to date with Windows 7 and Windows 10 client
  • Experience with network captures and network troubleshooting
  • PowerShell V2 skills including scripting


ITIL V3 Foundations is desired

To apply for this job email your details to careers@ortmanconsulting.com