SHR Consulting Group

Database Administrator

• Operate and maintain Platform Services Microsoft SQL Server High Availability (HA) Cluster Environments and database servers/instances in NIPR, SIPR, TIPR, and JWICS at primary and alternate site locations
• Provide full database administration O&M for SQL Server enterprise application databases (CORE, Domain Services, DMZ, SharePoint, VMware Infrastructure, SCCM, SCOM, Skype) and Mission Application databases listed in the JSP Environmental Document
• Provide basic database administration for customer-managed databases hosted on JSP enterprise SQL Server HA Cluster Environments, including attaching/detaching of databases and coordination with database owners
• Install, configure, and maintain SQL Server services and software, including upgrades, patches, third-party tools, and dependencies (clients, drivers, providers)
• Allocate and manage database storage; perform database, instance, and cluster configuration tuning and modifications
• Create and manage database environment accounts, profiles, and permissions in accordance with cybersecurity requirements; manage application accounts for customer application administrators with direct DB access
• Configure, schedule, monitor, and restore database, instance, server, and cluster backups; test and validate backup procedures at least annually
• Configure, manage, and monitor database replication, synchronization, and failover for HA Cluster Environments and Mission Essential Systems (MES)
• Provide T-SQL development, debugging, and performance tuning; produce entity-relationship and data flow diagrams and database architecture diagrams as needed
• Operate and maintain databases in accordance with DISA STIGs/SRGs; patch and remediate IAVA findings; validate and document cybersecurity compliance for application RMF accreditation at least annually; manage assigned cybersecurity POA&Ms
• Provide after-hours support for scheduled Authorized Service Interruptions (ASIs), break/fix incidents, and incidents impacting Enterprise and MES Mission Application databases
• Manage assigned incidents and service requests with detailed status/tasks/actions in the JSP ITSM tool

SQL Server Database Administrator, DBA

System Administrator

• Operate, update, and maintain the JSP Citrix capabilities, including Citrix images and the network appliances supporting Citrix (load balancers, NetScalers )
• Configure, maintain, and sustain JSP and JPH VDI/DaaS desktop services; provide O&M, administration, desktop hosting, virtual machine, storage, directory, desktop connection, virtual management, and database services in coordination with other operational entities
• Maintain desktop image repositories and perform recomposes; develop and sustain virtualization of applications using Microsoft App-V, ThinApp , or SCCM/MECM, including creating, updating, and testing application packages and user profiles
• Perform management and maintenance of VMware software (vCenter, View, Horizon) and supporting hyper-converged infrastructure (Nutanix, Dell, HP)
• Maintain VDI/Citrix servers, including patching, monitoring, and STIG compliance; ensure all system applications remain operationally compliant with DoD and STIG standards and IAVA requirements
• Create and maintain VDI pools for user communities; develop and maintain SOPs for the VDI environment
• Use the JSP VDI monitoring tools to monitor session health and performance; identify, analyze, and resolve issues across configured systems, sub-components, application services, message flows, and communications ports
• Provide endpoint VDI client configuration support, baseline image, and patch level maintenance, and recompose activities aligned with the published VDI Image Test and Deployment Schedule
• Coordinate with JSP/JPH branches for network connectivity, CSR space, physical/network security, DNS, and backup and restoral services for the virtual desktop solution
• Follow JSP Enterprise configuration management processes for all modifications and meet Group 1 restoral times (CCIR Priority 1 – 2 hours; Priority 2 – 4 hours; Priority 3 – 6 hours) more than 90% of the time.

Systems Administrator – Virtualization, VDI, Citrix

Project Manager

• Prepare Sponsor Forms outlining initiative scope and objectives for Government approval; do not proceed without Government concurrence.
• Within 30 calendar days of initiative approval, identify the team lead, resources required, and deliver a project schedule to complete the initiative.
• Provide weekly status updates on all initiatives and maintain accurate status on a SharePoint site and within the enterprise project management system (PROMIS or equivalent).
• Track initiative tasks and subtasks in the enterprise ITSM ticket system (Remedy/Helix), and document level of effort, time, and resources involved.
• Create or update documentation required to support each initiative, including future O&M plans and supporting RMF artifacts.
• Lead transition of approximately 15–20 projects per year from the JSP Engineering team to Platform Services Operational teams, including participating in design phases, coordinating internal acceptance, and identifying transition risks.
• Coordinate Platform Service project tasks for early lifecycle backups, monitoring, and patching; provide design and transition feedback to the JSP Transition team within 5 business days.
• Within 15 calendar days of a project transition, update internal SOPs, Work Instructions, and CMDB records to reflect the transitioned project.
• Maintain situational awareness of project lifecycles and provide Platform Services feedback on project scope changes in weekly status updates.
• Develop and present project briefs to JPH/JSP Leadership and provide PROMIS inputs within 48 hours of meetings with Division leadership.
• Apply industry-standard project management practices in accordance with PMI / PMBOK and ITIL service transition principles.

Project Manager – Initiatives, Sys Transition

• Provide 24x7x365 health monitoring of Platform Services, infrastructure, and applications using JSP Enterprise System Management tools including SCOM, Stratosphere, Aternity, Atrium, Splunk, vRealize Operations (VRops), and Prism
• Open Break/Fix tickets, engage Platform Services teams and external agencies when system issues are observed, and respond to alerts within two (2) hours to prevent service failures when warnings of impending failures are observed
• Monitor and participate (when task is related to the Platform Services team) in JSP Network Operations Security Center (JNOSC) dial-in conference bridges and JSP Chat Rooms supporting JNOSC-led troubleshooting efforts during critical incident resolution (historically 3–5 troubleshooting bridges per month)
• Act as the incident coordinator for activities between Platform Services teams supporting compute, applications, and infrastructure; provide status to bridge participants and JNOSC on all Priority 1 incidents affecting the Platform Services IT environments
• Notify JNOSC and Platform Services Leadership within thirty (30) minutes of any system or service degradation and provide updates every four (4) hours until issue resolution
• Maintain central customer lists, problem and solution knowledge bases, work instructions, employee lists, recall lists, and incident management escalation procedures on JSP Portals; report changes to JNOSC
• Perform first-tier triage on Windows Server, Red Hat Linux, virtualization, and core service alerts and escalate to SME-level support when needed
• Document outages, restoration times, problem resolutions, and customer impact data in the JSP Enterprise ITSM system (currently Remedy)
• Support COOP and contingency operations from primary or alternate continuity facilities as needed during exercises or real-world events.

Systems Administrator – Monitoring

• Operate and maintain Active Directory, DNS, DHCP, and Distributed File System (DFS) infrastructure across approximately 21 AD domains; manage Active Directory Security Groups, Group Managed Service Accounts ( gMSA ), Organizational Units, and Group Policy Objects in accordance with Microsoft Security Administrative Environment guidance.
• Administer the JSP Microsoft Exchange Server environment supporting approximately 5,000 mailboxes on JWICS, including monitoring, mailbox provisioning, system upgrades, backup/restore, and patching.
• Operate and maintain enterprise SMTP gateways (currently Symantec Messaging Gateways) on NIPR and SIPR networks; maintain SMTP routing tables, MX/SPF/DKIM records, and the SMTP Outbound Client list in compliance with security policy.
• Operate and maintain the JSP enterprise Print Services environment: manage print servers, print drivers, print queues, and scaling for customer demand; coordinate with JP5/JP7 during major upgrades and lifecycle refresh.
• Operate and maintain the System Center Operations Manager (SCOM) deployment on NIPR, SIPR, and JWICS, including management servers, gateway servers, and Linux SSH/SSL monitoring; ensure systems are maintained with the latest Management Packs and that alerts function correctly.
• Identify, analyze, and resolve problems affecting system operations across all assigned core services; meet Group 1 restoral AQLs (CCIR Priority 1 – 2 hours; Priority 2 – 4 hours; Priority 3 – 6 hours) more than 90% of the time.
• Schedule and perform routine backups; test and validate backup procedures at least annually; store backups away from the proximity of the physical system.
• Apply security patches, GPO changes, and configuration updates to maintain compliance with DoD STIGs, IAVM notices, and other cyber tasking; collaborate with cyber teams on compliance scanning and endpoint analysis.
• Maintain DoD/NSS PKI server certificates and ensure they are issued/renewed within 30–15 days before expiration; maintain a tracker of expiration dates.
• Coordinate with the JSP Transport, Networks, and JP5/JP7 teams during major system upgrades, firewall changes, and hardware lifecycle refresh activities.

Systems Administrator – Core Services, Microsoft

Operations

• Lead day-to-day operations of enterprise server environments (virtual and physical)
• Deliver and support Platform as a Service (PaaS) across distributed systems
• Ensure high availability, performance, and security of infrastructure services
• Oversee Active Directory, including group policy, permissions, and issue resolution
• Manage core services such as DNS, DHCP, and WINS within the enterprise environment
• Support identity and access management, including PKI integration
• Maintain and optimize scalable, load-balanced, and clustered architectures

SQL Server Database Administrator, DBA

Systems Administrator – Virtualization, VDI, Citrix

Project Manager – Initiatives, Sys Transition

Systems Administrator – Monitoring

Systems Administrator – Core Services, Microsoft

Enterprise Operations Lead