Senior Capacity Planning Database Administrator

COMMAND CYBER SOLUTIONS, LLC

HILL AFB, UT

JOB DETAILS
SKILLS
Amazon Relational Database Service (RDS), Analysis Skills, Ansible, Atlassian JIRA, Automation, Best Practices, CPU (Central Processing Unit), Capacity Analysis, Capacity Management, Capacity and Performance Management, Cloud Computing, Communication Skills, CompTIA Security+, Computer Science, Customer Support/Service, Data Recovery, Database Administration, Database Backup, Database Design, Database Optimization, Database Programming, Database Technology, Docker, Documentation, Ecosystems, Forecasting, High Availability, Identify Issues, Information Technology & Information Systems, Input/Output, Leadership, Memory Hardware, Mentoring, Microsoft Access Database, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, Migration Strategy, Oracle, Oracle Database, Pattern Analysis, Performance Analysis, Performance Management, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Secret Clearance, Software Administration, Software Patches, Systems Administration/Management, U.S. National Institute of Standards and Technology (NIST), United States Department of Defense (DoD), Utilization Management, Windows PowerShell
LOCATION
HILL AFB, UT
POSTED
2 days ago
Essential Duties & Responsibilities - Administer Oracle, SQL Server, and PostgreSQL databases on-premises, ensuring availability, security, and scalability. - Support customer applications by optimizing database performance and access. - Monitor database health, utilization, and growth trends using SolarWinds, SQL Developer, and Jira. - Develop and maintain database capacity baselines and capacity planning reports to forecast CPU, memory, storage, and I/O requirements. - Perform capacity assessments to identify resource constraints, performance bottlenecks, and future infrastructure needs. - Provide Tier 2-3 support for database issues, using SQL Developer and SolarWinds for diagnostics. - Automate tasks such as backups, patching, and reporting with Ansible and SQL scripts, ensuring STIG compliance. - Apply patches, upgrades, and validate NIST/STIG requirements. - Manage database schemas in containerized environments where applicable. - Collaborate with developers and security teams to optimize queries, resolve incidents, and support future growth planning. - Maintain documentation, including continuity plans, troubleshooting guides, and capacity planning studies. - Mentor junior staff on database administration, automation, and capacity monitoring practices.   Education, Certification & Experience Requirements Education: - Bachelor's degree in computer science, Information Systems, or related field or equivalent experience (Required)   Certifications: - CompTIA Security+ (Required) - Active Secret clearance. (Required) - Oracle Certified Associate (Preferred)   Required Experience: - 3-5 years in database administration, with expertise in Oracle, SQL Server, or PostgreSQL. - Experience supporting enterprise databases in secure on-premises environments. - Proficiency in SQL Developer, Ansible, Terraform, and SolarWinds. - Familiarity with NIST/DoD compliance frameworks.   Preferred Experience: - Experience in database capacity planning, performance monitoring, and resource forecasting. - Familiarity with tracking database CPU, memory, storage, and I/O utilization trends. - Experience analyzing growth patterns and infrastructure constraints to support future demand. - Knowledge of database tuning, backup/recovery, high availability, and automation tools. - Experience working in secure enterprise environments with strong documentation and compliance practices.     Knowledge, Skills & Abilities Knowledge: - Enterprise database platforms: Deep expertise in Oracle, SQL Server, and PostgreSQL administration across on-premises and cloud (OCI, AWS RDS, Azure DB/SQL). - Cloud and container ecosystems: Strong knowledge of cloud migration strategies, Infrastructure-as-Code (Terraform, Ansible), and containerized environments (Docker, Kubernetes).   Skills: - Database optimization and tuning skills: Proficient in query optimization, schema design, and access management to maximize performance and scalability. - Automation and scripting skills: Skilled in SQL scripting, PowerShell, Ansible, Terraform, and Python for deployments, backups, and patching.   Abilities: - Problem-solving and analytical ability: Exceptional capacity to evaluate database challenges, identify root causes, and implement effective solutions. - Leadership and mentoring ability: Proven ability to guide junior DBAs, foster professional growth, and promote best practices in database administration and capacity planning/management. - Communication ability: Skilled at explaining complex database concepts to diverse audiences, including technical teams and leadership. - Command Cyber Solutions, LLC is an equal opportunity employer. Command Cyber solutions, LLC does not discriminate in employment opportunities or practices on the basis of race, color, religion, sex, national orig n, age, disability, marital status or any other characteristic protected by law. -

About the Company

C

COMMAND CYBER SOLUTIONS, LLC