Senior Capacity Planning Database Administrator

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

• Bachelor's degree in computer science, Information Systems, or related field or equivalent experience (Required)
• 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

• 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).
• 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.
• 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.