Sr DevOps DBA

$104,000 - $174,000/Yr

Maxar Technologies - Westminster, CO

posted 4 months ago

Full-time - Mid Level
Hybrid - Westminster, CO
Transportation Equipment Manufacturing

About the position

Maxar Intelligence is a leading provider of secure, precise geospatial intelligence, delivering disruptive value to both government and commercial customers. Our mission is to help clients monitor, understand, and navigate the complexities of our changing planet. The Database Services team at Maxar plays a crucial role in this mission by providing highly integrated and value-added consulting services. We collaborate closely with our internal platform groups on data design, database administration, and management, operating a sophisticated commercial earth-imaging satellite constellation. This enables us to maintain the largest database of high-resolution imagery in the world, managing massive scale storage and processing to provide effective imagery solutions. In the role of Sr. DevOps DBA, you will be responsible for architecting, designing, developing, and maintaining Database-as-a-Service (DBaaS) platforms for our ground systems platform/application teams. This position involves a high degree of automation and requires you to support commercial, GovCloud, and secure environments across multiple clouds and on-premises. You will work with core databases including Oracle, Postgres, SQL Server, and MySQL, ensuring their optimal performance and security. Your responsibilities will also include patching and upgrading database servers, ensuring compliance with internal and external standards, and conducting security and license audits for database software. As part of a 7x24 operational environment, you will participate in an on-call rotation to address any incidents that arise. Your work will involve planning, coordinating, and administering various database matters, including defining structures, documenting processes, and establishing operational guidelines. You will also be tasked with translating logical designs into physical implementations, developing comprehensive database architectures, and creating large-scale, highly available production database environments. Additionally, you will be responsible for data loading, security, capacity planning, and backup and recovery processes, all while supporting production databases in a dynamic environment. Your expertise will be crucial in solving SQL performance issues and optimizing queries and stored procedures, ensuring the highest quality of service in our production operations.

Responsibilities

  • Work with multiple versions of Oracle, PostgreSQL, SQL Server, and MySQL in support of business units, focusing on database administration and management.
  • Plan, coordinate, and administer matters related to PostgreSQL, SQL Server, Oracle, and SQL Server databases, including definition, structure, documentation, upgrades, and operational guidelines.
  • Demonstrate experience working with Data Center migration to multiple cloud providers.
  • Establish and maintain security integrity controls.
  • Translate logical to physical design, develop comprehensive DB architectures, implementation and upgrade plans, and assist in defining database standards, policies, and procedures.
  • Create and manage large scale, highly available production database environments.
  • Handle data loading, security, capacity planning, and backup and recovery processes.
  • Support production databases in a high-quality and dynamic environment.
  • Solve SQL performance-related issues and optimize poorly performing queries and stored procedures.
  • Manage 24x7 production operations, including incident break/fix, change, service requests, and on-call pager rotation.

Requirements

  • Bachelor's degree in computer science 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 providers, including public or private clouds.
  • Experience working in a DevOps model and agile project management.

Nice-to-haves

  • Work on-site at our Longmont or Westminster, CO office.
  • Experience with migration of large databases from one platform to another.
  • GIS spatial models experience from a database perspective.
  • Experience with CI/CD pipeline in Jenkins and pipeline controls.
  • Familiarity with Terraform and SCIaC.
  • Experience with Docker, Helm, Kubernetes, and Rancher.
  • Knowledge of Vault and Artifactory.
  • Experience with GitHub and GitLab.
  • Proficiency in Python, SQLAlchemy, and Flask.
  • Familiarity with AWS services like SNS, SQS, Lambda, EC2, CloudWatch, DynamoDB, IAM, and S3.
  • Experience with Elasticsearch, Beats, Elastic Agent, Fleet, Kibana, and Grafana.
  • Experience with PgAdmin4 and data formats like JSON, YAML, TOML, DM, and HTML.

Benefits

  • Health, Vision, Dental Insurance, and Employee Assistance Program
  • 401K with matching and immediate vesting
  • Health Savings Account (HSA)/Flexible Spending Accounts (FSA) Options
  • Flexible Time Off (FTO), 10 Holidays, and Sick Time
  • Maternity and Paternity Leave
  • Adoption Reimbursement
  • Flexible Hours, Hybrid work options
  • Tuition Reimbursement and Student Loan Repayment
  • Pet Insurance
  • And More!
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service