Sysadmin Sr DBA - (#109)

SMS Montgomery , AL 36101

Posted 2 months ago

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

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Solarwinds Engineer 24

SMS

Posted 6 days ago

VIEW JOBS 6/24/2022 12:00:00 AM 2022-09-22T00:00 Overview Team SMS is looking for an Enterprise Network Tools Administrator to support our Air Force Intranet Control (AFINC) team at Maxwell Gunter AFB in Montgomery, AL. The AFINC Enterprise Network Analysis Team supports the 26 NOS, who requires services and solutions that accomplish and provide enabling capabilities to operate the DoDIN. These capabilities include, but are not limited to, Distributed Network Connectivity, Continuity of Operations, Information Management and Exchange, Standardization, Risk Management, DoD Enterprise Service Management Framework (DESMF), System Administration, Database Management, Account Management, Asset Management and Network Address Management. 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 and Responsibilities: * Serve as SolarWinds engineer, senior leader and/or subject matter expert (SME) responsible for SolarWinds Orion product suite across multiple enterprise networks cluster implementations * Strong expertise in SolarWinds, enterprise network monitoring tools and/or NetFlow analysis for either commercial and DoD (preferred) environments. * Skilled in SQL queries as well as SQL server and Window Operating System (OS) server management * Candidate oversees web (IIS, Apache), application or SQL planning, researching, deploying, patching, monitoring, upgrading, and troubleshooting components spanning a large and complex environment * Ability to maintain valid system certificates, application certificates, F5 load balancing local traffic management (LTM) and two-factor authentication (2FA) within a PKI smart card environment * Monitor, troubleshoot, and analyze overall health and effectiveness of four separate SolarWinds instances while utilizing SQL, SWQL, SNMP, WMI and SSH to manage the USAF global WAN * Oversee Orion Platform Suite for Federal Government; Server & Application Monitor (SAM); Virtualization Manager (VMAN); IP Address Manager (IPAM); Network Configuration Manager (NCM); Network Performance Monitor (NPM); VoIP & Network Quality Manager (VNQM) * Assesses current SolarWinds implementations for each network and recommend changes to distributed deployments to include SQL databases, web pollers, data sources, users, custom apps/dashboards/views * Perform root cause analysis, recommend, and implement tactical and strategic solutions to problems * Support internal and external websites, fault isolation, performance, quality controls, AF Enterprise Secure Sockets Layer (SSL)/Transport Layer Security (TLS) inspection and analysis * Develop, update and document SolarWinds architecture, operational processes, and training materials * Manage the addition, deletion, and editing of all 26th Network Operation Squadron's devices and views * Monitor all servers running ENAT applications by utilizing MIBS and performance counters * Patch and manage the efficiency and performance of these servers with regards to hardware and OS * Assist the USAF Program Management Office (PMO) as the 26 NOS SME/Engineer\ with architecture requirements, deployment plans, patch, upgrades and schedules of new SolarWinds environment * Potentially assist with PMO lab testing, verification, or deployment SolarWinds related projects and recommended configurations or revisions for better practices, efficiency and/or performance * Create PowerShell scripts that run queries on the SolarWinds database providing efficient performance and network checks for multiple 26 NOS teams * Provide technical web & database administrator expertise, guide technical support, create, maintain, secure, and monitor all applicable instances; design, deploy, and optimize SQL databases & web sites * Document steps required to design/engineer SolarWinds systems for each network to include virtual/real IP address, Fully Qualified Domain Name (FQDN), DNS entries, Role Based Access Controls (RBAC), TCP/IP, service accounts, web certificates, licenses and physical/virtual location of each component * Ability to gather bootstrap ideas, data and diagrams to polished, efficient dashboards, views and recommend baseline monitoring thresholds * Sr Systems Engineer/SME provides tech support in system architecture, system design, system integration & technical management; keep up to date with new features and versions of products * Oversee the baseline configuration, ensure operational data integrity, and use vendor best practices for Web application systems and secure management across multiple unclassified and classified network locations supporting the interaction with Tenable products within Assured Compliance Assessment Solution (ACAS) including .SC (SecurityCenter™) and Nessus® Scanner™ * Ability or experience in evaluating scan report data from Tenable Nessus; participate in the review and response phases of the Vulnerability Management (VM) life cycle * Install and patch operating systems, applications, network security and document Department Information Systems Agency (DISA) Security Technical Implementation Guidelines (STIGs) checklists applicable to each Non-classified or Secret Internet Protocol (IP) Router Network (NIPRNet, SIPRNet) network environment systems for all SolarWinds, NetQoS, database or web application implementations * Manage or assist the processes related to onboarding users/projects, configuration audits, building data models, summary data reports, or advanced search analytics * Ability to create network designs diagrams with Microsoft Visio (include specialty requirements) * Implement/create report dashboard designs, automated custom email report notifications, report data repositories for each environment that are specific to the following audiences: Leadership & Executives; Cybersecurity Staff; and System Administrators * Ensures networks receive periodic updates from AFCYBER-released software patches, updates, 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 the DISA Information Assurance Vulnerability Management (IAVM) programs, cybersecurity toolsets, and Operation Order (OPORD)/Fragmentary Order (FRAGO) support * Communicate, manage expectations, eliminate gaps and successfully interact with multiple external and internal 26th NOS team leads, admins, analysts, users, customers, system owners and management * Guide customers in the use of strategic products through education and guidance, first-use and tuning assistance problem solving and critical situation resolution * Candidate will be part of the 26th NOS Enterprise Networking Application Tools (ENAT) team which will be small but highly visible so experience in at least one other monitoring platforms or enterprise tools is helpful if not critical (SolarWinds; CA's NetQoS NetFlow Analysis; Cacti, F5 Big-IP, Splunk) * Ensure optimal server performance for daily operations and generation of network analysis data from CA NetQoS for customers within and outside of the 26 NOS organization. * Candidate will report to the 26th NOS Systems Administration (SA) team leadership Qualifications Qualifications/Requirements: * SrSA/Engineer/SME candidate must have a minimum of 6+ years of SolarWinds Orion products experience and/or other enterprise monitoring tools experience interacting with 3rd party systems preferably in role(s) such as a system administrator, engineer, developer or SME capacity * Enterprise monitoring and/or NetFlow analysis end-user experience or preferably administration in a large-scale environment ideally interacting daily, weekly, monthly functions and/or troubleshooting * Candidate should have 4+ years of years of hands-on experience in: * System Integrator and/or administrator for SolarWinds nodes, users, , systems, custom views reports, dashboards, Network Atlas maps, simple/complex alerts and 3rd party onboarding * Windows OS systems support, patch/update management, best practices, advanced commands and admin skills with experience in mid-to-large data center environments * Demonstrated advanced diagnostics, analytical, troubleshooting skills * Add additional servers to cluster; Install/upgrade/patch new software to servers * Preferred system hardening experience; Preferred Splunk experience * Identify, analyze, define, & coordinate user, client, and stakeholder needs and translate them into technical requirements; Coordinate service outages or fail over * Support day-to-day technical communication systems and incident tickets in support of operations * Help the support team solving support tickets (BMC Remedy) on an adhoc basis * Perform systems analysis, design review, integration of complex system applications * Experience with disaster recovery (DR) - expertise in risk reduction, hot/warm site DR architecture * Experience with physical servers and within virtualized environments such as VMware vSphere's vCenter Server Appliance, ESXi hosts, virtual machines (VMs), SAN datastores, host bus adapters (HBA) fiber connectivity, and/or VM/Host distributed resource schedules (DRS) groups/rules * Good knowledge related to Infrastructure monitoring, networking management, system operations, application tools implementation and integration with 3rd party systems * Scripting/programming experience in HTML, Perl, PowerShell, Python or similar * Knowledge of data communications, local-area networking (LAN), wide-area networking (WAN), servers, appliances, routers, switches, and firewalls * Network (Layer 2, 3) LAN/WAN knowledge * Thorough understanding of Internet Protocol (IP) routing, switching, and OSI model Competencies: * Possess refined critical thinking skills, should be a motivated self-starter, and multi-task capable * Excellent organizational and time management skills * Ability to plan, organize and prioritize own workload * Ability to follow policies and procedures * Approach work tasks as diplomatic, adaptive to a dynamic environment, dependable and reliable * Calm, organized and able to work well within a team * Ability to deal with conflicts with your peers and users * Good communication and interpersonal skills; Strong written and oral communication skills * Ability to communicate in a clear speaking voice as well as the ability to respond clearly to questions * Aptitude to address negative situations and resolve them in a positive manner * Assist and mentor other engineers or administrators with various Splunk related activities * Jump right in and start building * Ability to lift, rack and provision government furnished equipment (GFE) servers Education: * Associate, Bachelor's or Master's degree in Computer Science or related technical discipline, or MIS related field is preferred but not mandatory. Relevant professional experience is acceptable. * SolarWinds courses desired Required Certification: (All) * CompTIA Security+ ce (continuing education) or (ISC)² CISSP * Minimum one Operating System Certification: CompTIA Linux+; a current Microsoft technical certification: Microsoft Technology Associate (MTA), Microsoft Certified Solutions Associate (MCSA), Microsoft Certified Solutions Developer, Expert (MCSD, MCSE), Microsoft 365 Certified: Security Administrator Associate, Microsoft Certified: Windows Server Hybrid Administrator Associate or Microsoft Certified: Identity and Access Administrator Associate * Minimum one Application Certification: SolarWinds Certified Professional: Server & Application Monitor (SAM), Network Configuration Manager (NCM) or Network Performance Monitor (NPM); Security Event Manager (SEM); NetFlow Traffic Analyzer (NTA); Database Performance Analyzer (DPA); Orion Architecture and Design (OAD) | Splunk Core Certified User; Splunk Core Certified Power User; Splunk Core Certified Advanced Power User; Desired Certification(s): * SolarWinds Sr/Engineer/SME Positions: * SolarWinds Certified Professional: SAM or NCM or NPM or SEM or NTA or DPA or OAD * Optional: Splunk Core Certified User, Splunk Core Certified Power User or Splunk Core Certified Advanced Power User; Splunk Enterprise Certified Admin or Splunk Enterprise Security Certified Admin; Clearance: Active DoD Secret required or ability to complete investigation process for interim with potential to upgrade to Top Secret clearance preferred SMS is an Equal Opportunity Employer. SMS Montgomery AL

Sysadmin Sr DBA - (#109)

SMS