What are the responsibilities and job description for the Database Administrator 2 position at Trilogy Innovations?
Secret Level Security Clearance Required
About Trilogy Innovations
At Trilogy Innovations, we are committed to driving meaningful change for our customers and communities through smart, innovative technology that solves real problems. As a growing systems and software engineering company, we partner across public and private sectors to modernize enterprise systems, strengthen security, and deliver high value solutions. We are scaling with purpose, investing in our people, processes, and platforms as we expand. We work hard, think creatively, and value every perspective as we push boundaries and build systems that matter.
Who You Are
You are the kind of Database Administrator who enjoys digging into problems and making systems run faster, cleaner, and smarter. You know your way around Oracle and PostgreSQL, and you are just as comfortable in a Linux environment as you are navigating cloud platforms like AWS.
You have a solid handle on the fundamentals, backups, performance tuning, and database optimization are not new concepts to you. You have likely written your fair share of SQL and scripts, and you take pride in making things more efficient than you found them.
You are naturally curious. When something breaks, you want to understand why, not just fix it and move on. When something works, you look for ways to make it even better. You are proactive, detail-oriented, and not afraid to take ownership.
You work well with others, explain technical concepts without making it complicated, and keep a cool head when things get busy. Most importantly, you care about the impact of your work, because behind every database is a mission that depends on it running right.
This position will require being on call once every 2 months.
What You Will Do
Database DBA / ETL
Compensation And Benefits
At Trilogy Innovations, we believe strong teams build meaningful solutions. We deliver high quality systems and software engineering services across public and private sectors, supporting complex and mission critical environments with integrity, collaboration, and care.
Since 2010, our talented team has partnered with organizations such as the FBI, U.S. Air Force, NASA, Department of Education, Department of Energy, DHS, SOCOM, and leading private sector clients. We are known for combining technical excellence with a thoughtful, people first approach.
At Trilogy, you will work alongside smart, committed professionals in a supportive, learning oriented environment. We value innovation, accountability, and continuous growth, and we encourage our people to bring both expertise and humanity to the work they do.
If you are looking to contribute to impactful work while growing your skills in a collaborative and forward-thinking organization, Trilogy Innovations is a place where you can do just that.
Equal Opportunity Employer
Trilogy Innovations, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Applicant Privacy Notice
Trilogy Innovations, Inc. collects and processes personal information you provide when applying for a position through our careers site, which is powered by JazzHR. This may include your contact details, resume, work history, qualifications, and information obtained through interviews, references, and background checks, where permitted by law.
We use this information to evaluate your application, communicate with you, verify your qualifications, and support our recruiting and hiring processes. If you are selected for a role, your information may be used for onboarding and employment purposes. Your information may be shared with authorized Trilogy personnel and trusted service providers, including our applicant tracking system, JazzHR. We may also disclose information where required by law or to protect our business and operations.
We retain applicant information for as long as necessary to support recruiting activities and comply with legal requirements, typically up to two years after your application is no longer active. You may have the right to access, correct, or request deletion of your personal information, subject to applicable law. You may also update your information through your candidate profile.
Powered by JazzHR
About Trilogy Innovations
At Trilogy Innovations, we are committed to driving meaningful change for our customers and communities through smart, innovative technology that solves real problems. As a growing systems and software engineering company, we partner across public and private sectors to modernize enterprise systems, strengthen security, and deliver high value solutions. We are scaling with purpose, investing in our people, processes, and platforms as we expand. We work hard, think creatively, and value every perspective as we push boundaries and build systems that matter.
Who You Are
You are the kind of Database Administrator who enjoys digging into problems and making systems run faster, cleaner, and smarter. You know your way around Oracle and PostgreSQL, and you are just as comfortable in a Linux environment as you are navigating cloud platforms like AWS.
You have a solid handle on the fundamentals, backups, performance tuning, and database optimization are not new concepts to you. You have likely written your fair share of SQL and scripts, and you take pride in making things more efficient than you found them.
You are naturally curious. When something breaks, you want to understand why, not just fix it and move on. When something works, you look for ways to make it even better. You are proactive, detail-oriented, and not afraid to take ownership.
You work well with others, explain technical concepts without making it complicated, and keep a cool head when things get busy. Most importantly, you care about the impact of your work, because behind every database is a mission that depends on it running right.
This position will require being on call once every 2 months.
What You Will Do
Database DBA / ETL
- Administer, support, configure, upgrade, and maintain Oracle (19c/21c) and PostgreSQL databases across Linux, RHEL, and Windows environments.
- Manage database high availability and recovery solutions, including Oracle Data Guard, RMAN, and PostgreSQL backup and recovery methods such as pg_dump, pg_basebackup, and point-in-time recovery (PITR).
- Perform database performance tuning and troubleshooting using tools such as AWR, ASH, ADDM, and PostgreSQL explain plans and monitoring utilities.
- Execute database patching, upgrades, and maintenance across all COTS database platforms.
- Develop and maintain database scripts using PL/SQL and PL/pgSQL, including loops, conditions, and variables.
- Design and manage database storage, schemas, user roles, access controls, and security models.
- Support database interfaces, integrations with external applications, and cross-system data interactions.
- Utilize AWS cloud services, including CloudWatch, CloudTrail, EC2, and RDS (Oracle, PostgreSQL, Aurora).
- Perform system-level performance tuning, hardware replacements, firmware upgrades, and patching across operating systems and COTS software.
- Develop and maintain shell scripts to automate monitoring, maintenance, and operational tasks.
- Apply strong SQL expertise, including query writing, optimization, indexing, and normalization.
- Bachelor's Degree required or related field or equivalent experience
- 3 years' experience in Database Administration
- Secret Level Security Clearance
- Hands-on experience administering Oracle (19c/21c) and PostgreSQL databases in production environments
- Strong understanding of database performance tuning, optimization, and troubleshooting
- Experience with backup and recovery strategies, including RMAN and PostgreSQL tools such as pg_dump and PITR
- Solid SQL skills, including writing, optimizing, and analyzing complex queries
- Experience working across Linux, RHEL, and Windows operating systems
- Familiarity with AWS services such as EC2, CloudWatch, CloudTrail, and RDS (Oracle, PostgreSQL, Aurora)
- Experience with database patching, upgrades, and overall system maintenance
- Scripting experience using shell, PL/SQL, or PL/pgSQL to automate tasks and improve efficiency
- Understanding of database security, user roles, access control, and data integrity best practices
- Ability to support database integrations and work across multiple systems and applications
- Strong problem-solving skills with a proactive, solution-oriented mindset
- Clear communication skills and the ability to work effectively with technical and cross-functional teams
Compensation And Benefits
- Competitive salary based on experience
- Performance bonus eligibility
- 401k with company match
- Medical, dental, and vision coverage
- Life and disability insurance
- Health Savings Account
- Professional development programs
- Employee referral bonus program
At Trilogy Innovations, we believe strong teams build meaningful solutions. We deliver high quality systems and software engineering services across public and private sectors, supporting complex and mission critical environments with integrity, collaboration, and care.
Since 2010, our talented team has partnered with organizations such as the FBI, U.S. Air Force, NASA, Department of Education, Department of Energy, DHS, SOCOM, and leading private sector clients. We are known for combining technical excellence with a thoughtful, people first approach.
At Trilogy, you will work alongside smart, committed professionals in a supportive, learning oriented environment. We value innovation, accountability, and continuous growth, and we encourage our people to bring both expertise and humanity to the work they do.
If you are looking to contribute to impactful work while growing your skills in a collaborative and forward-thinking organization, Trilogy Innovations is a place where you can do just that.
Equal Opportunity Employer
Trilogy Innovations, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Applicant Privacy Notice
Trilogy Innovations, Inc. collects and processes personal information you provide when applying for a position through our careers site, which is powered by JazzHR. This may include your contact details, resume, work history, qualifications, and information obtained through interviews, references, and background checks, where permitted by law.
We use this information to evaluate your application, communicate with you, verify your qualifications, and support our recruiting and hiring processes. If you are selected for a role, your information may be used for onboarding and employment purposes. Your information may be shared with authorized Trilogy personnel and trusted service providers, including our applicant tracking system, JazzHR. We may also disclose information where required by law or to protect our business and operations.
We retain applicant information for as long as necessary to support recruiting activities and comply with legal requirements, typically up to two years after your application is no longer active. You may have the right to access, correct, or request deletion of your personal information, subject to applicable law. You may also update your information through your candidate profile.
Powered by JazzHR