Job Description

Zachary Piper Solutions is seeking a SQL Database Administrator to support a DoD/DHA program fully onsite in Silver Spring, MD

Must have Secret clearance

Responsibilities:

• Researches, Administers, manages, designs, documents, and evaluates a variety of database management systems including Microsoft SQL Server, Microsoft Access, and other Database Management Systems (DBMS).
• Maintains and administers database server and middleware tools used to develop Web database systems and framework.
• Develops and enforces database administration and user standards and procedures.
• Evaluates database server integrity and security.
• Audits, modifies, and amends data in systems using SQL commands, hand-editing, and bulk import.
• Oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites.
• Assumes the technical lead for SQL Server and online database projects.
• Assists software engineers in the development of web-based interfaces to database systems.
• Assists information system analysts in the development of SQL queries, including for data mining.
• Reviews technical designs, reports, documentation, and other materials produced by staff.
• Creates and maintains high-level reporting systems using products such as Crystal Reports, SSRS, SQL Server Report Builder, Tableau, and Power BI.
• Ensures that IT programs and databases comply with all applicable regulations and policies, including Federal, DA and MEDCOM.
• Develops database and related application documentation as required.
• Performs complex technical, analytical and professional services involving program/member services, evaluation, database driven Web sites, office operations support, and problem resolution.
• Maintains and administers Web server and middleware tools used to develop Web database systems and framework.
• Develops Standard Operating Procedures (SOP's), templates and forms, (including, but not limited to, database backup; and log monitoring and management plans)

Qualifications:

• Bachelors/ Masters in related field
• Must have an active Secret Clearance.
• Must possess a Security Plus certification.

Desired Skills:

• Experience designing, installing, implementing and administering SQL Server databases and servers in the DoD environment within the last 8 years.
• Experience implementing MS SSRS systems and developing and deploying reports within the last 5 years.
• Minimum of 2 years of experience administering relational databases of 500+ GB in size
• Experience with MS SQL Server 2008 R2; experience with other commercial reporting and analytic tools like Tableau, Power BI, Crystal reports, etc.; web application development experience.
• Possess current/active MS SQL database related industry certification.
• Experience with Replication and synchronization of multiple databases
• Experience with SharePoint, reporting, and bioinformatics preferred
• Previous experience with MS SQL Server 2016

Compensation:

120,000-130,000– depending on years of experience and degree

Keywords: SQL DBA, SQL, SQL database, MS SQL Server, MS SQL, Microsoft SQL, Tableau, Power BI, Crystal, Crystal Reports, SQL Server Report Builder, MS SSRS, SSRS, Database administrator, SQL, DBA, Windows, ACAS, STIG’s, STIGS, HBSS, server, server maintenance, Sec+, Security+, IAT, CompTIA, certification, Active Directory, Powershell, scri[ting, windows deployment server, WDS, AD, PKI, Smart Card Login, Windows 2016, Windows 2010, desktop, DevOps, dev ops, fsp, fullscope, full-scope, polygraph, poly, databricks, AWS, YAML, python, java, EC2, S3, cloud formation, Nifi, Pentaho, Apache airflow, UI/UX, Lifecycle, Jenkins, Git, Puppet, DOD, Secret, Top Secret, SAS, R Studio, SPSS, Python, Power BI, Secret Cleared, Top Secret Cleared, TS/SCI Cleared, Laboratory, Data, Data gathering science, DHA, public health, health science, DoD, Department of Defense, Life Cycle Sustainment Plan, Acquisition Strategy, Simplified Acquisition Management Plan, Level of Repair Analysis, Source of Repair Analysis, Logistics Demonstration Planning and Execution, Product Support Package, Technical Manual Development and Finalization, Equipment Standardization, Memorandum of Agreements/Understanding, CDRL Reviews, Property Accountability of all GFE, APSR System updates, IUID Plan, biometrics, life cycle sustainment, life cycle, DoD, CPI, secret clearance, secret, SF, military, accounting, audit readiness, Finance, fund receipt, audit, auditor, financial, financial analyst, Disbursement, Military Pay, Civilian Pay, Travel Pay, Reimbursement Budget Authority and Execution, Contract Pay, Vendor Pay, Data Analysis, Machine Learning Engineer, Data Architect, Military Health, Data Operations Engineer, epidemiologist, disease control, COVID-19, Data Mining, Data Warehousing, Data Modeling, Data Visualization, DoD, CISA, security controls assessor, security control, security, CISSP, CISM, MCSE, CAP,

FISMA regulation, FIPS standards, NIST 800 series, NIST Special Publications, Risk Management Framework, IT security, infrastructure, vulnerability assessment, reporting, firewalls, VPN, Data Loss Prevention, IDS/IPS, Web-Proxy, security audits, .Net, .net, SQL, server, framework, Kendo UI, query, data, integration, deduplication, interface, SAFe, agile, reconciliation, jira, confluence, COTS, OS patching, VersionOne, NetApp, Linux, linux, windows, Windows, Cloud, Commvault, active directory, Ansible, Jenkins, AccuRev, Gitlab Teradici, PCoIP, scripting, remote display protocols, sharepoint, SharePoint, Sharepoint, .NET, C#, developer, virtual machines, VMware VCenter hypervisor, Citrix XenDesktop, XenApp, Desktop Director, systems engineer, engineer, system, systems, systems engineering, citrix, Citrix, secret, system admin, administator, systems administrator, contracts, contract, contracts specialist, contract specialist, procurement, PD2, procurement desktop, technical writing, technical editor, editor, cybersecurity, cyber security, secret, TS, Top Secret, top secret, sci, clearance, governemtn, DARPA, TS/SCI, DHS, federal, technical writer, business analyst, CONOPS, SOPs, standard operating procedures, sec+, security+, ITIL, ITILV4, adobe, Microsoft office, MS, .NET Framework, C#, AngularJS, Hyper Text Markup Language' OR 'HTML' OR 'AJAX' OR 'ASP.NET' OR 'XML' OR 'JavaScript' OR 'Jquery' OR 'CSS' OR 'Microsoft SharePoint Designer' OR 'SharePoint Workflows' OR 'Web Services' OR 'REST' OR 'Keyword Query Language' OR 'KQL' OR 'SharePoint Server' OR 'Internet Information Server' OR 'IISsuite, SCI, sensitive compartmented information, operation procedures, mission notes, editing, 508 compliance, documentation, cyber, APT, advanced persistent threat, incident management, incident response, concept of operations mitigation plan, incident response, PTO, Arlington, Virginia, on-site, onsite, on site, benefits, 401k, medical, homeland security, DOD, ci polygraph, counterintelligence, cyber intelligence, cyber investigation, cybersecurity investigation, PTO, technical writing, technical writer, business analyst, technical analyst, technology write, air force, digital forensics, project management, jira, army, military, Patrick space force base, Patrick SFB, SFB, Lompoc, California, CA, cocoa beach, satellite beach, space, research, technology research, technical investigations, secret clearance, ts/sci, top secret, ts, secret clearance, dod, clearance, clearance, cloud project, aws, azure,veterans, retired veterans