2 FTE openings: 1 Mid-Level and 1 Sr Level Database Administrator/DBA
Locations: Westminster, CO or Longmont, CO. Hybrid role – 3 days onsite. 2 remote days.
Our Client is a provider of secure, precise, geospatial intelligence. We deliver disruptive value to government and commercial customers to help them monitor, understand, and navigate our changing planet. Our unique approach combines decades of deep mission understanding and a proven commercial and defense foundation to deploy solutions and deliver insights with unrivaled speed, scale, and cost effectiveness.
The Database Services team is focused on providing highly integrated and value-added consulting services. In partnership with our internal platform groups around data design, database administration and management, we operate a highly sophisticated commercial earth-imaging satellite constellation enabling us to amass the largest database of high-resolution imagery in the world. Our systems manage massive scale storage and processing of this data to provide imagery solutions. In this role you will support commercial, GovCloud and secure environments in multiple clouds and on-perm.
Core databases including: Oracle, Postgres, SQL Server, and MySQL.
As a Mid Level or Sr. DBA, you will architect, design, develop and maintain Database-as-a-Service (DBaaS) platforms for our ground systems platform/application teams (a highly automated process). You will also be responsible for patching, upgrading database servers, internal and external compliance, as well as security and license audits for database software. This role is a 7x24 shop and will be part of an on-call rotation.
What You’ll Be Doing:
- Work with multiple versions of Oracle, PostgesSQL, SQL Server and MySQL in support of our business units. Mostly focused on database administration and management but also help with design and implementations
- Plan, coordinate and administer matters related to PostgreSQL, SQL Server, Oracle, and SQL Server databases including definition, structure, documentation, upgrades, long-range requirements, operational guidelines and protection
- Demonstrate your experience working with Data Center migration to multiple cloud provide
- Establish and maintain security integrity controls
- Translate logical to physical design, develop comprehensive DB architectures, implementation and upgrade plans and assist in definition of database standards, policies, and procedures.
- Create and manage large scale, highly available production database environments
- Data loading, security, capacity planning and backup and recovery
- Support production databases in a high quality and dynamic environment
- Responsible for solving SQL performance related issues and optimizing poorly performing queries and stored procedures
- Strong Scripting- Shell, Ruby, Perl, Bash, Puppet, Salt, Python
- Responsible for 24x7 production operations (incident break/fix, change, service requests, management) and On-Call pager rotation
Minimum Requirements:
- Must be a US Citizen with an active secret level security clearance or able to obtain within expected timeframes
- Bachelor’s degree in CS or relevant field or 4 years of relevant experience
- 8+ years of experience with database administration in a production environment
- 3+ years of development experience with data management systems
- 2+ years of experience with AWS, Azure, Google, or relevant cloud provide. This can include public or private clouds
- Experience working in a DevOps model with agile project management experience
Preferred Requirements:
- Migration of large databases from one platform to another
- GIS spatial models experience from a DB perceptive
- CI/CD pipeline in Jenkins, and pipeline controls
- Terraform and SCIaC
- Docker/Helm/Kubernetes/Rancher
- Vault
- Artifactory
- Gihub/Gitlab
- Python/SQLAlchemy/Flask
- SNS/SQS/Lambda/EC2/CloudWatch/DynamoDB/IAM/S3
- Elasticsearch/Beats/Elastic Agent/Fleet/Kibana/Grafana
- PgAdmin4
- JSON, YAML, TOML, DM, and HTML
Salary for Mid-Level Role Mid Point of Range is: $140-$155K Base salary + 10% Bonus
Salary for Sr Level Role Mid Point of Range is: $150-$165K Base salary + 10% Bonus
Other: Great benefits plan included, with unlimited PTO, Pet Insurance, 401K, and more.