Sysadmin Sr DBA - (#109)

Overview

SMS is seeking a Senior DBA to support the Air Force 26 NOS

As a dynamic systems integrator, SMS offers proven solutions in engineering, operations, cybersecurity, and digital transformation. With expertise in modernizing and optimizing legacy infrastructure and systems, ensuring operational efficiency, and designing, implementing, and managing secure environments, SMS supports business and mission goals with proficiency, quality, and integrity.

SMS has been serving the advanced information technology needs of the federal government since 1976, delivering talented teams and innovative, cost-effective solutions and services to support our customers' missions for more than 40 years. SMS is headquartered in McLean, Virginia, with offices and on-site operations at customer locations throughout the United States. For additional information on SMS, visit www.sms.com.

Submit your resume today!

Responsibilities

Duties & Responsibilities

• Work within data center operations supporting Windows servers, desktops, Linux systems and various application patching, software version updates, network and security configurations

• Administer SQL (Structured Query Language) database instances or PostgreSQL to manage and interact with hosted software applications such as SharePoint sites, NetQoS, Cacti, SolarWinds, etc.

• Provide database administration including design, install, configuration, upgrades, consolidation, monitoring, tuning, and maintenance; Manage database backup and recovery processes

• Strong skills designing, developing and maintaining stored procedures, views, tables, T-SQL scripts, creating associated documentation; Perform data conversion and server migrations

• Maintain detailed SQL server environment technical documentation and system security plans

• Interact with Microsoft SQL database stored procedures, and desktop applications

• Aide in effective provisioning, installation, configuration, operation, certificate management and maintenance of high availability production and disaster recovery (DR) sites

• Responsible for database implementation, security, privileges and regular maintenance tasks

• Build scripts automating daily, weekly, monthly, or quarterly operations of database management

• Detect, craft and sustain server Windows automation processes with PowerShell to improve or enhance day-to-day operations to create team efficiencies & reduce manual processes

• Provide a periodic report of system status to include uptime, incidents, problems or open issues

• Respond to system faults, analyzing and correcting applications or errors to reestablish service

• Aid to identify technical environment issues and recommend solutions to mitigate problems

• Perform analytical, technical and admin work using and installing new and existing physical or web-based database application systems in a smart card Public Key Infrastructure (PKI) environment

• Proactively monitor and evaluate performance issues and requests for local and remote data centers

• Mentor junior system administrators to impart knowledge, share methods and teach processes

• Preferred exposure to virtualized server offerings, especially those based on VMware or Nutanix

• Provide in depth systems analysis, system administration, security, compliance and maintenance

• Able to audit, remediate, and maintain DISA Security Technical Implementation Guide (STIG) checklist documentation on supported systems utilizing technical procedures, best practices, hardening guidance, vendor manuals, user guides and runbooks;

• Experience in evaluating audit scan report data from ACAS Tenable.SC or Tenable Nessus Scanners; participate in the review and response phases of the Vulnerability Management (VM) life cycle

• Aptitude to support provisional installation, configuration, operation and maintenance of server systems hardware (Dell PowerEdge, HPe ProLiant, etc.), and utilize related infrastructure devices such as KVMs, out-of-band management (OOBM) tools like integrated lights-out (ILO), iLO Amplifier, integrated Dell Remote Access Controller (iDRAC) or Open Managed Enterprise (OME) appliances

• Develop and/or implement technical solutions based on defined mission scope and using approved software tools such as PuTTY, SecureCRT, Remote Desktop Protocol (RDP), NotePad++, etc.

• Aptitude to test/interact with new software technologies in environment with 3rd party monitoring tools to track overall health and availability of apps: Splunk Enterprise, SolarWinds Orion platform, McAfee Endpoint Security Systems (ESS), Microsoft Endpoint Configuration Manager (MECM), WSUS, ForeScout, NAGIOS, Veritas NetBackup, etc.

• Ensures networks receive periodic updates from AFCYBER-released software, patches, firmware, and upgrades via Time Compliance Technical Orders (TCTO), Time Compliance Network Orders (TCNO), Maintenance Tasking Order (MTO) and Notices to Airman (NOTAMs)

• Assist AF Cyber personnel with Information Assurance Vulnerability Management (IAVM) programs, cybersecurity toolsets, and Operation Order (OPORD)/Fragmentary Order (FRAGO) support

• Candidate will report to the 26th NOS Systems Administration (SA) team leadership

Qualifications

Qualifications/Requirements:

• Experience within DoD environment or enterprise data center desired

• Experience with supporting database servers preferably VMware infrastructure, and/or backups

• Must have a minimum of 5+ years of experience with database technologies

• Prefer a minimum of 3+ years of experience with Windows server environment

• Knowledge of network protocols and technologies: DHCP, ICMP, LDAPS, NetFlow, Polling, SCP, SMTP, SNMP, Syslog, TCP/IP, VLANs, WMI

• Exposure to cluster management, high availability methodologies, load balancing traffic management technologies; virtualized environments such as VMware vSphere's vCenter Server Appliance (vCSA), ESXi hosts, virtual machines (VMs), VMTools, Horizon View, and/or VM/Host distributed resource schedules (DRS) groups/rules

• Support day-to-day technical communication systems, alerts and incident tickets queue in support of operations; Open/track change requests and interact with external customers or vendors

• Experience with networking, desktops / laptops, middleware, client/server software, Office products, server operating systems, virtualization, managing data, applications, websites, or database supporting a multi-site, multi-domain Windows forest

• Responsible for shared 24x7 coverage of the Windows physical and/or virtual support

Competencies:

• Interact well with all levels of management across multiple teams consisting of Government civilians, contractors, and military personnel

• Self-motivated self-starter, able to work autonomously and as part of a team, sharing knowledge to help others in a fast-paced cyber environment

• Possess refined critical thinking skills and thrive in fast-paced multi-task environment

• Good communication and interpersonal skills; Ability to follow policies and procedures

• Approach work tasks as diplomatic, adaptive to a dynamic environment, dependable and reliable

• Aptitude to address negative situations and resolve them in a positive manner

• Experience maintaining, overseeing and troubleshooting computers and related peripheral equipment performing preventative maintenance in accordance with department policies

• Proactively stay current with the latest server infrastructure and storage technologies releases

• Ability to lift, rack and provision government furnished equipment (GFE)

Education/Certification(s):

• Technical degree, Associates or, Bachelor's degree in Computer Science/Information Systems, Science/Engineering/Math or 2-4 years' relevant experience in Information Technology preferably within system administration is acceptable

• Required Certification: CompTIA Security+ ce (continuing education) or (ISC) CISSP

• Minimum one or more of the following technical certifications:

• Microsoft based certification (current): Microsoft 365 Certified: Fundamentals; Microsoft Certified: Security, Compliance, and Identity Fundamentals; Microsoft 365 Certified: Security Administrator Associate; Microsoft Certified: Azure Security Engineer Associate; Microsoft Certified: Identity and Access Administrator Associate

• Senior Level preferred: Microsoft 365 Certified: Enterprise Administrator Expert; Microsoft Certified: Windows Server Hybrid Administrator Associate

• Microsoft based certification (retired, will be considered): Microsoft Technology Associate (MTA) Database Fundamentals, Windows Operating System Fundamentals, Windows Server Administration Fundamentals, Security Fundamentals; or Microsoft Certified Solutions Associate (MCSA) SQL 2016 Database Administration, SQL Server 2012/2014; or Microsoft Certified Solutions Expert (MCSE) Data Management and Analytics, Server Infrastructure

• ITIL certification a plus

Clearance:

Active DoD Secret required or ability to complete investigation process for interim with potential to upgrade to Top Secret clearance preferred