SQL DBA/Programmer- SECRET CLEARANCE REQUIRED- Silver Spring, MD

Zachary Piper Solutions is seeking a highly skilled SQL DBA/ Programmer to support operations at the Walter Reed Army Institute of Research in Silver Spring, MD. The SQL DBA/ Programmer will be responsible for managing, designing, and maintaining database systems, ensuring data integrity, security, and efficient database performance in a Department of Defense (DoD) environment.

Responsibilities:

• Manage, design, and evaluate various database management systems, including Microsoft SQL Server and Microsoft Access.
• Administer database servers and middleware tools supporting web-based database systems and frameworks.
• Establish and enforce database administration standards, policies, and user procedures.
• Conduct audits, modifications, and amendments to databases using SQL commands and bulk data imports.
• Lead database projects, overseeing backups, replication, and data synchronization between multiple servers.
• Collaborate with software engineers to develop web-based interfaces and assist system analysts in writing SQL queries for data mining.
• Develop high-level reports using Crystal Reports, SSRS, Tableau, Power BI, and similar tools.
• Ensure compliance with IT regulations and policies, including federal and DoD standards.
• Create documentation, develop SOPs, and handle technical issue resolutions.
• Perform technical tasks related to database-driven web services and program support.

Qualifications:

• M.S. in Computer Science, Information Technology, or equivalent experience.
• Active Secret clearance is mandatory, Top Secret is preferred.
• Security+ certification and Microsoft SQL Server certification is required.

Preferred Skills and Experience:

• 8+ years of experience designing and administering SQL Server databases within a DoD environment.
• Experience with MS SSRS systems and report deployment within the last 5 years.
• 2+ years of experience managing databases larger than 500 GB.
• Proficiency in MS SQL Server 2008 R2 and experience with reporting tools such as Tableau, Power BI, and Crystal Reports.
• Experience with database replication and synchronization.
• MS SQL database-related industry certification.
• Familiarity with SharePoint and bioinformatics is a plus.
• Experience working with MS SQL Server 2016.

Compensation:

Location: Silver Spring, MD (Walter Reed Army Institute of Research) - Onsite, 5 days a week

Customer: Walter Reed Army Institute of Research

Compensation: $130,000–$145,000/ year

Keywords: Database Programmer, database Administrator, SQL DBA, SQL database admin, onsite, Silver Spring, MD, Walter Reed, Cherokee Nation Technology Solutions, Walter Reed Army Institute of Research, research, researched, researcher, Researches, Admin, Administer, Administers, Administered, Administration, Administers, manage, manages. Managing, management, manages, design, designed, designing, designs, documented, documenting, documentation, documents, evaluate, evaluated, evaluating, evaluates, evaluation, database management systems, Microsoft SQL Server, SQL server, Microsoft Access, Database Management Systems, DBMS, maintain, maintained, maintaining, Maintains, administers, database server, middleware tools, developed, developing, develop, Web database systems, web database framework, Development, enforce, enforced, enforcing, enforces, database administration, user standards and procedures, database server integrity and security, audited, auditing, auditor, Audits, modify, modifies, modified, modifying, modification, amended, amend, amending, amends, amendment, SQL commands, hand-editing, bulk import, Oversees, oversee, oversaw, overseeing, overseen, scheduling, schedule, schedules, scheduled, database projects, database and transaction log backups, notifications, database replication, multiple SQL Servers and remote sites, assume, assumed, assuming, Assumes, technical lead, SQL Server, online database projects, lead, led, leads, leading, leader, Assists, assist, assisted, assisting, assistance, development of web-based interfaces to database systems, development of SQL queries, data mining, review, reviewed, reviewer, Reviews, reviewing, technical designs, reports, documentation, create, Creates, created, creating, creation, high-level reporting systems, Crystal Reports, SSRS, SQL Server Report Builder, Tableau, Power BI, implemented, implement, implementing, implementer, implements, new database and online technology, Ensures, ensure, ensured, ensuring, IT programs and databases comply, complied, complies, regulations and policies, Federal, DA MEDCOM, communicate, communicating, communication, communicator, Communicates, project status, issues, resolutions, application documentation, perform, performed, performing, Performs, evaluation, database driven Web sites, office operations support, problem resolution, Web server, middleware tools, Standard Operating Procedures, SOP's, templates and forms, database backup, log monitoring, management plans, M.S. Computer Science, Information Technology/Systems, active Top Secret Clearance, security Plus certification, design, designs, designed, designing, install, installs, installation, installed, installing, implementing, administering, SQL Server databases, servers in the DoD environment, MS SSRS systems, developing and deploying reports, administering relational databases of 500+ GB in size, MS SQL Server 2008 R2, commercial reporting and analytic tools, Tableau, Power BI, Crystal reports, web application development, MS SQL database certification, Replication and synchronization of multiple databases, SharePoint, reporting, bioinformatics, MS SQL Server 2016