Sr SQL Engineer
Falls Church, VA
This is a great opportunity to affect change by being an integral part of a team of Network, System, Process, and Cyber Admins and Engineers. This team is responsible for re-architecting and constructing the operational environment undergirding the current and future IT platform of one of the most significant defense office buildings in the world. You will be providing front seat support with direct impact on the safety and protection of tens of thousands of military, government and civilian personnel.
Principal Systems Engineer with application and Microsoft SQL Server expertise.
Designs and defines system architecture for new or existing computer systems. The candidate will apply proven communication, analytical, and problem-solving skills to help identify, communicate, and resolve issues in order to maximize the benefit of IT systems investments.
Communicate effectively with customers and fellow employees
Conduct project-based work to design, document and implement infrastructure solutions to solve business problems
Defines, creates, and maintains database metrics and documentation for database configuration and support
Conduct database systems and applications requirements analysis, design, development, implementation and support
Perform and manage and implement IT projects from initiation through closeout
Complete technical documentation to design, test, implement, train, and transition solutions to operational support
Manage project implementation from the development of assessments, preparation of project charters, conducting briefing sessions with client management.
Assist, and publish technical standards including white papers
Use Hands-on experience supporting desktop, laptop hardware and network equipment
Microsoft SQL 2008, 2012, or 2016. Run advanced database commands and scripts
Standardizes and migrates data to facilitate testing by utilizing database and third-party tools and custom scripts
Designs, implements and automates security for databases
Diagnoses and resolves highly complex database problems
Researches new database technologies to evaluate, install and upgrade database software products
Bachelor’ s Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education, technical training, or work/military experience.
Must meet DoD 8570 IAT II compliance including Security Plus with CE enrolled certification plus computing environment certification and hold an active secret clearance.
Strong written and oral communication skills.
Microsoft SQL 2008, 2012, 2014, and 2016.
SQL Clustering, always-on availability group.
Minimum of 3years’ experience as a developer building and supporting business intelligence / data warehousing reporting solutions using Microsoft SQL, SSIS, SSRS, SSAS.
Experience building/optimizing cubes with SQL queries, and experience with Analysis Services (SSAS) and Reporting Services (SSRS) including database development, deployment, configuration, security and troubleshooting.
Strong proficiency with core Microsoft Office Tools (Outlook, Power Point, Excel, and Word).
Experience with the full Software Development Life Cycle (SDLC).
Experience working in a high availability environment.
Excellent logical and problem-solving abilities.
8-10 years of related Microsoft SQL, and other application and database related experience.
Nice to have:
Knowledge of SQL Server 2016 would be an advantage.
Knowledge of Microsoft Azure would be an advantage.
Excellent English communication skills – both verbal and written.
Self-motivated and self-directed.
Very high attention to detail
Intermediate VMware experience. VCP 5 or higher certification a plus.
Foundational knowledge around Linux systems preferably with Redhat
Hands on experience with Storage Area Network (SAN) technologies is a plus
Working knowledge of networking protocols and components including TCP/IP, DNS, DHCP, IP Networking VPN’ s, switching, and routing
Proactive thinker and self-starter, must be able to innovate and think out of the box
Intermediate experience designing, implementing and managing enterprise solutions using Microsoft, HP and VMWare 5.x and 6.x technologies.
HP blade hardware and virtual platform, Windows Server and SQL Server experience preferred.
Backup and disaster recovery experience preferred.