Be on Alert – Fraudulent Employment Offers. Learn More

A statement on social injustice. Click to read more.
Suitland, Maryland, United States of America
JOB #R2003247

Tech Lead, SQL DBA

ICF’s IT Modernization division is a rapidly growing, entrepreneurial, technology driven department, seeking a motivated Tech Lead, SQL DBA to support current & upcoming needs.

The Team

The Database Support Branch (DSB) operates as a Database Center of Excellence (DCoE) and provides enterprise database administration support for multiple Census organizations. The DSB functions as a service-provider offering Database as a Service (DaaS) functionality. In order to provide DaaS, the DCoE maintains two primary platform types: Oracle and SQL Server. Each platform type is backed by a team of Data Base Administrators (DBAs) who are available in 3-tiers of support levels.

The Work

Total customer satisfaction is a primary goal of the DCoE and multiple automated monitoring tools are used to ensure maximum database performance and availability in all environments. As a member of this team, you will provide customer support, including technical assistance for Project O&M, builds and deployments. Other services include upgrades, patching, migration, installation, configuration, proactive monitoring, security, tuning, backup, recovery and troubleshooting.

Responsibilities Include:

  • Work with clients, peers and management in a highly visible, mission critical environment

  • End-to-end knowledge of MS SQL server database technologies including MS SQL Clusters and AlwaysOn Failover Cluster Instances (FCI)

  • Experience with deploying and maintaining Enterprise Level SQL Server Farms and AlwaysOn Failover Cluster Instances (FCI)

  • Evaluate, implement and maintain Microsoft technology, security updates, hot fixes, upgrades and version releases to ensure architecture stability

  • Configure and manage Microsoft's Windows Server 2008/2012, Windows Clustering on a spanned VLAN, and SQL Server 2008/2012/2014/2016, demonstrating how these technologies may be leveraged to impact the architecture's overall design, security, availability and stability

  • Solution development and integration of value-add applications to meet new requirements.

  • Provide troubleshooting of database instances and OS level support in a consolidated SQL Server environment leveraging a wide-array of configurations, including local and multi-site failover clustering

  • Demonstrate ability to analyze resource bottlenecks and provide suggestions to team, management, and internal customers on how to alleviate pressure and plan for capacity

  • Provide recommendations and strategies to application owners on how to improve performance and scalability of their database components

  • Install, upgrade and administer SQL Server database engine, Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)

  • Provide architectural guidance on strategies to improve operations and monitoring of current and future implementations.

  • Prepare technical documentation

Required Skills:

  • 10 years of experience (with a graduate/postgraduate degree) in the field of information     technology and business process management. Experience as an SME, or other high-level strategic planning position, within multiple markets, is required for all levels of education.

  • 10 years’ experience is required, with not less than 8 years of actual SQL Server DBA experience

  • Hands on experience specifically with Microsoft SQL Server and variants

  • Candidate must have experience supporting an environment with 50 to 100+ combination of virtual and physical SQL servers.

  • Extensive experience in Windows Server 2008/2012

  • Extensive administrative experience in SQL Server 2008 R2/2012/2014/2016

  • Experience implementing and managing Windows clustering and AlwaysOn Failover Cluster Instances (FCI)

  • Experience implementing and managing SQL Server high-availability technologies (replication, mirroring, failover clusters, etc.)

  • SQL Server Integration Services package development (SSIS)

  • SQL Server Reporting Services report development (SSRS)

  • Experience working with IBM and Cisco hardware

  • Ability to implement physical designs from logical designs

  • Strong verbal and written communication skills as responsibilities include direct client interfacing, acting as a technical focal/SME for escalations, and the development of documentation

  • US Citizenship required (required by federal government for this position).

  • Must be able to obtain Public Trust clearance.

Preferred Skills:

  • Virtualization (VMWare, preferred)

  • Windows and power shell scripting skills (preferred)

  • MSCE/A or other relevant (e.g. MCP) professional certification a big plus

Working at ICF

Working at ICF means applying a passion for meaningful work with intellectual rigor to help solve the leading issues of our day. Smart, compassionate, innovative, committed, ICF employees tackle unprecedented challenges to benefit people, businesses, and governments around the globe. We believe in collaboration, mutual respect, open communication, and opportunity for growth. If you’re seeking to make a difference in the world, visit www.icf.com/careers to find your next career. ICF—together for tomorrow.

ICF is an equal opportunity employer that values diversity at all levels. (EOE – Minorities/Females/ Protected Veterans Status/Disability Status/Sexual Orientation/Gender Identity). For more information, please read our EEO & AA policy.

Reasonable Accommodations are available for disabled veterans and applicants with disabilities in all phases of the application and employment process. To request an accommodation please email icfcareercenter@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more about non-discrimination:  EEO is the law and  Pay Transparency Statement.

Maryland Client Office (MD88)

Who is ICF?

A global consulting services company with +7,000 people across +70 countries, but we are not your typical consultants.
LEARN MORE ABOUT ICF

More jobs you might like

Nov 18, 2020
Suitland, Maryland, United States of America
Oct 5, 2020
Washington, District of Columbia, United States of America
See All Jobs

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.

Join our talent network

ICF is growing, and we add new open roles to our site regularly. If you're waiting for that perfect opportunity at ICF or want an inside look at what it's like to do world-changing work, join our talent network to stay updated.