We are seeking a Senior DBA to support the Air Force 26 NOS.
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/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 24×7 coverage of the Windows physical and/or virtual support
Qualifications/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, S.T.E.M. or 2-4 years’ relevant experience in Information Technology preferably within system administration is acceptable
- Required IA Certification: CompTIA Security+ CE or higher
- Minimum one or more of the following technical CE/OS certifications:
- Microsoft based certification (current):
Microsoft Certified: Azure* Data Fundamentals* (Database/DBA Role); | 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 Certified: Azure Database Administrator Associate -or- Administering Microsoft Azure SQL Solutions -or- Oracle Database SQL Certified Associate (Database/DBA Role); | 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