CT Database Engineer
Summary
Senior database engineer serving as the relational database SME, designing, securing, tuning, and modernizing database platforms (SQL Server, Oracle, PostgreSQL, MySQL) across on-prem and AWS/Azure/GCP cloud environments. Requires an ACTIVE Top Secret/SCI clearance with polygraph; based in Tysons or Warrenton, VA.
- Bachelor’s Degree in Computer Science, IT, or a related technical discipline, or the equivalent combination of education, technical training, or work/military experience
- Minimum ten (10) years of related database technologies experience
- Relational Database Platforms
- Microsoft SQL Server
- Oracle Database
- PostgreSQL (on-prem and cloud variants)
- MySQL
- Amazon RDS / Azure SQL Database / Google Cloud SQL
- Cloud Platforms
- Amazon Web Services (AWS)
- Microsoft Azure
- Google Cloud Platform (GCP)
- Core Technical Competencies
- Database architecture and engineering design
- High Availability (HA) and Disaster Recovery (DR)
- Performance tuning and query optimization
- Backup and recovery strategies
- Database security, encryption, and compliance
- Migration from on-prem to cloud and hybrid environments
- Linux and Windows server environments
- Scripting and automation (PowerShell, Bash, Python)
- CI/CD integration for database deployments
- Database containerization (Docker, Kubernetes)
- Database monitoring tools (SolarWinds, Redgate, OEM, Cloud-native monitoring)
- Data replication and distributed systems
- Data warehouse platforms (Snowflake, Redshift, Azure Synapse)
- ETL frameworks and tools
- Infrastructure as Code (Terraform, ARM, CloudFormation)
- Massively Parallel Processing database administration experience (MPP DBA)
- Ansible (or similar IT automation tools like Puppet or Chef)
- Supporting federal government compliance frameworks
- Knowledge of Zero Trust architectures
- Supporting mission-critical or high-transaction environments
- Serve as the Subject Matter Expert (SME) for relational database technologies
- Document and analyze current-state (as-is) database environments while promptly coming up to speed
- Develop comprehensive engineering design documents for modernization, optimization, and transformation initiatives for the database to align with the organization technical vision
- Lead implementation of enhanced and future-state database architectures
- Design, deploy, configure, optimize, secure, and maintain database platforms across hybrid environments
- Collaborate closely with the department engineering teams, including Network, Storage, Windows and Linux Systems Operating, Cloud, Web Services, Software Development, Information Systems Security Officer (ISSO), and DevOps
- Partner with Software Engineers, Data Engineers (ETL), Data Modelers, Data Scientists, and Data Analysts
- Ensure high availability, performance tuning, security hardening, and compliance adherence
- Provide database governance, standards, and best practices across the enterprise
Skills
- Ansible
- Automation
- AWS
- Azure
- Azure Synapse
- Bash
- CI/CD
- Cloud
- Cloud Native
- CloudFormation
- Containerization
- Data Warehousing
- DevOps
- Distributed Systems
- Docker
- ETL
- GCP
- Infrastructure as Code
- Kubernetes
- Linux
- MySQL
- Oracle
- PostgreSQL
- PowerShell
- Puppet
- Python
- RDS
- Redshift
- Snowflake
- Solarwinds
- SQL
- SQL Server
- Terraform
- Windows Server
- Zero Trust