Job Description :
Position: Senior SQL Server DBA and Developer
Location: Falls Church, VA
Clearance/Citizenship: SSBI (Secret clearance is highly preferred) / U.S Citizenship

Position Description: This position is for a SQL Server DBA and SQL Developer to work on a the Defense Health Agency project. Responsible for the MS SQL DBA and SQL Developer functions of various SQL Server-based systems. This “hands-on” position requires solid technical and analytical skills, as well as excellent interpersonal and communication skills. The ideal candidate will be able to contribute to a wide variety of data-centric requirements. Must be a self-starter who enjoys problem-solving researching techniques and methodologies to produce effective, complete and reliable solutions. Ability to collaborate and work with teams and can be counted on to complete assignments in a timely manner with minimal oversight. This role will also utilize experience in system analysis and troubleshooting to support maintenance, design, performance and/or troubleshooting.

Primary Job Duties:

Develop and maintain ETL processes to support: data warehouse, business intelligence, internal and external data integration needs.
Development of SQL procedures, triggers, views, functions and reports to support enhancement to critical SQL based business systems.
Create adhoc reports using SQL and other scripting languages per customer requirements from the database.
Analyze troubleshoot and remediate data integrity issues.
Monitor systems; proactively manage and maintain configurations to insure performance and availability.
Perform database and related asset backups and recovery.
SQL query optimization; index management.
System performance and optimization tuning.
Perform STIGing and fix the findings on the DB servers.
Support production systems for database problem resolution, recovery and Emergency off-hour support.
Provides analytical and troubleshooting abilities to address multiple technical areas of systems.
Recognizes and acts on inconsistencies in data or results and escalates unusual problems.
Defines configuration requirements in the context of functional requirements.
Works independently on assignments where considerable judgment and initiative are required in resolving problems and making choices, recommendation or decisions
Works as an integrated member of the project team.
Provides analytical and troubleshooting abilities to address multiple technical areas of systems.
Works various tasks as assigned by the project manager.
Required Education & Work Experience:

Bachelor’s Degree in Computer Science, Engineering, Business, or related field of studies and/or greater than four (4) years equivalent experience above the experience requirement identified below.
7 + years working knowledge of Microsoft SQL Server 2008R2, 2012, or newer versions
At least seven (7) years of experience with delivering information technology system analysis to support maintenance, design, and/or performance. Also, providing operations and maintenance to enterprise SQL Server Database Servers for DoD.
Required Qualifications & Certifications:

Experience implementing maintaining and automating backup and recovery plans.
Experience in database design, development, implementation and methodologies for Data warehouses and OLTP business systems.
Comprehensive knowledge of Transact SQL, Stored procedures, Views, Triggers, Functions.
Experience automating data Import/Extraction using SQL Server tools such as SSIS, BCP, bulk insert.
Ability to examine and optimize query execution plans and index/data usage.
Experience analyzing hardware, software, network ecosystems to optimize database server performance.
Experience resolving locking, dead lock issues.
Developed SQL databases.
Performed development tasks of designing tables, storing procedures, views and functions.
Experience with SQL Replication and Service Broker.
Experience with Microsoft Reporting and Analysis Services.
Ability to work with internal customers, including the ability to read and interpret what the internal customer is saying to proactively identify potential issues and problems and advise the internal customer on best practices and/or be able to suggest and deliver product enhancements
Familiarity with various programming and/or scripting languages such as: C#, VB/VBA, PowerShell, batch/cmd files, XML, BIML, JSON.
Expertise with creating maintaining data sources
Worked with a multiple discipline team in an Agile development environment
Excellent writing communication skills to assist in the creation of project-related documentation such as DB Design Document, COOP,
Ability to multi-task and manage several tasks simultaneously while working both independently and in group environments
Possession of excellent oral and written communication skills, including working with senior military leadership
Excellent MS Office experience: Word, Excel, PowerPoint and Visio
Preferred Qualifications & Certifications:

Experience with SOA solutions for large, complex automated information systems projects
Assisting with the DoD certification and accreditation information assurance following the DIACAP and Risk Management Framework (RMF) processes
DOD or other Federal Government exposure
Knowledge of how the military health system deploys and maintains IM or IT to their MTFs and their military health IT systems
Familiarity with: Data Integration with external sources using Web Services/SFTP, Managing Virtual Server Environments with SAN’s (VMWare, XENServer), direct Extensible Markup Language (XML) data transfer, DMIS ID, CPT, LOINC, SNOMED
Experience in MHS systems such as AHLTA, CHCS, HAIMS, or Essentris
Experience developing and maintaining system documentation including requirements and design documents.
Support creating and updating other project documentation such as Requirement Traceability Matrix, Agile Management Plan, Configuration Management (CM) Compliance Plan, Software Implementation Plan, Development Integration Test (DIT) Environment Plan, Solutions Design Documents (SDDs), Contingency Operations Plan, and other project documents
Security +, Industry Related certification (e.g. .NET, SQL Server)


Client : VA

             

Similar Jobs you may be interested in ..