Link Solutions, Inc Washington , DC 20319
Sr. SQL DBA
Education Bachelor's Degree or equivalent experience
Experience 7+ years
Citizenship Requirement US Citizen
Clearance Required Top Secret
Location Washington, D.C.
Provides O&M system/user support to include regular data updates/loads, requirements gathering, software development, system testing, and release validation
Provide as needed back-end software development support for other HR applications
Setup and manage server infrastructure of TDE enabled SQL Server 2014/2016 R2 databases and SSRS in various production and non-production environments.
Manage operations for SQL Server instances, databases and Web servers.
Responsible for creating multiple SQL Server environments (such as Training, Demo, CPY, UAT etc.)
Migrate numerous SQL 2008/2012 databases to SQL 2014/2016.
Demonstrate strong technical troubleshooting skills in Microsoft Windows server operating system.
Patch all SQL servers with latest patches, hot-fixes, service packs etc. during regularly scheduled software release and infrastructure release nights and ensure SQL servers are compliant with Agency security configurations standards.
Monitor all SQL Servers with the following system monitoring tools - NetIQ and Spotlight.
Provide database support to application developers during application installations and upgrades in addition to general troubleshooting.
Develop and manage backup strategies in all environments.
Understand and execute all phases of the standard Software Development Life Cycle including technical requirements analysis, design, development, testing, implementation, training and system support.
Assist other technical teams to recognize, diagnose, and resolve complex problems or potential conflicts between technologies and platforms within the HR IT environment
Systems design, performance tuning, administration, maintenance, and support of SQL and BizTalk physical and virtual servers located locally and remote in a 24/7 enterprise production environment
Assist application developers on applications that use the databases to ingest and retrieve data
Must be able to work the early and late shifts (7AM 3:30PM & 9:30AM 6PM). Must be available to work one Friday evening a month and one Sat. every 2 months to support production issues, maintenance, migrations, backups, etc.
Strong SQL administration experience required. Extensive SQL Server 2014/2016 exp. in a large scale production environment.
Experience with BizTalk server administration, IIS 7.5/8.x
Strong technical troubleshooting skills in Microsoft Windows server operating system 2012/2016 R2
Experience with system monitoring tools (NetIQ & Spotlight)
Experience with Linux and/or similar Unix-based servers
7+ years Microsoft Windows administration, server maintenance and system integration
4+ years' experience administering and troubleshooting Microsoft IIS web server
Experience with NetIQ monitoring tool in a large scale production environment
Familiarity with Oracle administration tasks including installation, configuration, and backups
SQL Server Certification a plus