Tria Federal Logo

Tria Federal

Application Database Administrator (Mid-Level/Senior)

Posted One Month Ago
Remote
Hiring Remotely in United States
Senior level
Remote
Hiring Remotely in United States
Senior level
Provide mid/senior-level application DBA support for MySQL and PostgreSQL: participate in Agile teams, design data models, maintain DB environments, implement HA/DR and replication, optimize performance, lead production incident response, manage backups/patching/changes, and mentor junior DBAs.
The summary above was generated by AI

 Who we are:

Tria Federal delivers digital services and technology solutions that support the health and safety of veterans, service members and civilians. For two decades, federal agencies have relied on Tria companies to advance their critical missions and modernize their systems, so that they can uphold their commitment to the American people. Today, we are pushing the boundaries of possibility through partnerships and investments in artificial intelligence and emerging technologies, developing solutions for the biggest challenges that government will face tomorrow.

We are proud to employ and support military veterans who bring mission-first mindset, technical expertise, and leadership qualities that strengthen our work. Veterans, transitioning service members, and military spouses are strongly encouraged to apply.



We are seeking a mid/senior- level Application Database Administrator to support our Agile sprint teams and manage production database environments. The ideal candidate brings solid, hands-on expertise with MySQL and PostgreSQL, strong data modeling capabilities, and a demonstrated track record in performance tuning and production support. This role works closely with development teams throughout the sprint lifecycle and is expected to operate with a good degree of independence, mentor junior team members, and contribute to database architecture decisions.

Key Responsibilities

Sprint Team Support

  • Actively participate in Agile/Scrum ceremonies (sprint planning, standups, retrospectives, backlog grooming) as the database subject matter expert
  • Review user stories and technical requirements, providing database design input and effort estimates
  • Partner with developers to translate application requirements into efficient, scalable database structures
  • Provide timely turnaround on database changes to keep sprint deliverables on track
  • Guide and review the work of junior DBAs or developers on database-related tasks

Data Modeling

  • Independently design and maintain logical and physical data models using tools such as Erwin
  • Develop conceptual data models aligned with business and application requirements
  • Ensure models support normalization standards, referential integrity, and long-term scalability
  • Own data dictionaries, schemas, and entity relationship diagrams (ERDs)
  • Lead data model reviews with development, architecture, and business stakeholders
  • Identify and resolve data model conflicts across multiple applications/systems

Database Administration (MySQL & PostgreSQL)

  • Install, configure, and maintain MySQL and PostgreSQL instances across dev, test, staging, and production
  • Manage database schemas, users, roles, and security/access controls
  • Own backup, restore, patching, and upgrade strategy and execution
  • Design, implement, and maintain replication, high availability, and disaster recovery solutions
  • Evaluate and recommend improvements to database architecture and standards

Performance Tuning

  • Proactively monitor database performance metrics and identify bottlenecks before they impact users
  • Analyze and optimize complex, slow-running queries, indexes, and execution plans
  • Tune database configuration parameters for optimal throughput and resource utilization
  • Lead capacity planning and scalability assessments for growing application workloads
  • Establish performance benchmarks and monitoring best practices

Production Support

  • Serve as senior/primary DBA support for production systems, including on-call rotation
  • Lead troubleshooting and resolution of complex database incidents, outages, and performance degradation
  • Drive root cause analysis on production issues and implement preventive/long-term fixes
  • Own database change management for deployments and releases, minimizing risk and downtime
  • Develop and maintain runbooks, SOPs, and incident documentation
  • Serve as an escalation point for critical/high-severity database issues
Required Qualifications
  • Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience)
  • 5+ years of hands-on experience as a Database Administrator supporting MySQL and PostgreSQL in production environments
  • Demonstrated proficiency with data modeling tools (Erwin or similar, e.g., ER/Studio, dbt, Lucidchart)
  • Strong, advanced SQL skills with proven experience in query optimization and performance tuning
  • Experience supporting Agile/Scrum development teams as an embedded DBA
  • Deep understanding of backup/recovery, security, replication, and high-availability architecture
  • Proven experience providing production support and resolving critical incidents under pressure
  • Experience with database change management and release processes
  • Ability to work independently, prioritize competing demands, and communicate effectively with both technical and business stakeholders
Preferred Qualifications
  • Experience with cloud database platforms (AWS RDS/Aurora, Azure Database, GCP Cloud SQL)
  • Scripting/automation experience (Python, Bash, PowerShell) for routine DBA tasks
  • Experience with monitoring tools (Percona Monitoring and Management, pgAdmin, Datadog, New Relic)
  • Prior experience mentoring junior DBAs or leading small technical initiatives
  • Knowledge of ETL processes and data integration pipelines
  • Experience with additional RDBMS platforms (Oracle, SQL Server) a plus
  • Experience contributing to database architecture standards or governance
Key Skills
  • MySQL & PostgreSQL Administration (Advanced)
  • Data Modeling (Erwin)
  • Performance Tuning & Query Optimization
  • Production Incident Support & RCA
  • Agile/Scrum Collaboration
  • Backup, Recovery & High Availability
  • Mentorship & Cross-Team Communication

Why Tria?
What defines the Tria brand is more than just our dedication to excellence in our craft; it’s our incredible team of dedicated, talented, and passionate people that make Tria so exceptional. As people powering possible, we are all partners in our team’s shared success.

As a company that cares about people, we seek to cultivate a culture in which all can thrive personally and professionally. We offer a top-tier benefits package to invest in your physical, mental, and financial health and wellness so that you can be your best self - at work and in life. At Tria, we are growth-minded, entrepreneurial in spirit, and committed to fostering a culture of inclusion and opportunity for all. Whatever your background, your role, your department, or stage in your professional journey, here you will have opportunities to learn new skills, seize new challenges, and advance your career as we grow. 


California Consumer Privacy Act (CCPA)

We are committed to protecting your privacy. As part of our compliance with the California Consumer Privacy Act (CCPA), we want to inform you about how we collect, use, and protect your personal information during the job application process. For more details, please review https://www.oag.ca.gov/privacy/ccpa.

Similar Jobs

14 Minutes Ago
Easy Apply
Remote or Hybrid
Easy Apply
158K-225K Annually
Senior level
158K-225K Annually
Senior level
Cloud • Information Technology • Security • Software • Cybersecurity
Build and operate production LLM-powered agents and machine learning systems for customer risk identification and threat detection. Translate security heuristics into agent logic, collaborate with threat researchers, develop data requirements and pipelines, evaluate precision and recall, and deploy solutions through CI/CD. The role also requires production reliability ownership, observability, incident debugging, cloud infrastructure expertise, and senior staff-level technical leadership.
Top Skills: AthenaAWSCi/CdDockerElasticsearchLangchainLanggraphLlm AgentsNumpyOpensearchPandasPolarsPrestoPythonSQL
14 Minutes Ago
Easy Apply
Remote or Hybrid
Easy Apply
116K-165K Annually
Senior level
116K-165K Annually
Senior level
Cloud • Information Technology • Security • Software • Cybersecurity
Develop production LLM-powered agents and machine learning solutions for customer risk identification and threat detection. Translate threat-research methods into agent logic, build data requirements and pipelines, evaluate precision and recall, backtest and tune models, and deploy and monitor reliable solutions using CI/CD. Collaborate with threat researchers and data engineers while addressing production reliability, observability, data quality, cost, latency, and accuracy.
Top Skills: AthenaAWSCi/CdContainerizationElasticsearchInfrastructure As CodeLangchainLanggraphLlmsMachine LearningNumpyOpensearchPandasPolarsPrestoPythonSQL
22 Minutes Ago
Remote or Hybrid
105K-173K Annually
Senior level
105K-173K Annually
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Owns and operates a scaled digital customer success program for mid-market SaaS customers from onboarding through renewal. Designs lifecycle campaigns, adoption plays, automated risk interventions, segmentation, health scores, and customer journeys. Partners with CSMs, Product, Marketing, and CS Operations to improve adoption, retention, customer health, and revenue outcomes. Builds dashboards, analyzes customer behavior, leverages AI and automation, and translates insights into scalable customer engagement actions.
Top Skills: AIAutomationCrm SystemsCustomer Success PlatformsMarketing Automation ToolsSaaS

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account