Administer and support ASE and PostgreSQL databases across on-premises and AWS environments. Responsibilities include configuration, performance tuning, monitoring, troubleshooting, backups, disaster recovery, security, migrations from SAP ASE to Amazon RDS PostgreSQL, upgrades, and production support. The role also collaborates on database architecture, cloud migration, infrastructure improvements, and engineering best practices.
Company Overview
By Light Professional IT Services LLC readies warfighters and federal agencies with technology and systems engineered to connect, protect, and prepare individuals and teams for whatever comes next. Headquartered in McLean, VA, By Light supports defense, civilian, and commercial IT customers worldwide.
Position OverviewWe are seeking a highly motivated, results-oriented professional who is driven to succeed and brings a strong sense of urgency to their work. The ideal candidate is a self-starter and collaborative team player who takes initiative, demonstrates sound judgment, and continually looks for opportunities to improve processes, increase efficiency, and enhance customer service.
In this role, you will be responsible for supporting, maintaining, and administering ASE and PostgreSQL databases, ensuring their availability, performance, security, and reliability. The successful candidate will work effectively both independently and as part of a team while proactively identifying and addressing issues to support mission and business objectives.
Responsibilities- Supporting/administrating ASE and Postgres database platforms, including databases hosted and operated in AWS environments
- Setup, configuration, administration, tuning, monitoring, troubleshooting, data manipulation/backups of ASE and PostgreSQL database infrastructure
- Working with large amounts of data moving at rapid pace
- Working on PostgreSQL in our migration from SAP ASE to an Amazon RDS PostgreSQL environment
- Client support for test & production systems when needed
- Maintains database performance by resolving production and application development problems
- Works with all major database components of ASE and POSTGRESQL Servers and has strong knowledge of the various interrelationships between major system components including networking, storage, server, OS, authentication, application code, and disaster recovery technology
- Collaborates with fellow engineers and other IT teams to develop and execute both tactical and strategic architecture plans and implementations
- Identifies and provides recommendations to change and improve existing ASE/POSTGRESQL servers and database configurations
- BS CS / EE / CE or related degree or professional experience working in PostgreSQL.
- 5+ experience with Sybase RDBMS technology stack (ASE, REP, etc), systems management tools and implementing new features and functionality, performance tuning, planning, and executing database and replication server upgrades, applying EBF/SR patches, disaster recovery planning and testing.
- 3+ years of experience conducting general database administration tasks such as developing POSTGRESQL Server database objects, database server implementations, database architecture and schema design, code deployments, backups, and creation of DB authentication principals, system, and query performance tuning.
- Extensive knowledge of troubleshooting techniques using system logs, event logs, cluster logs, enhanced logging configurations for related subsystems, and system metadata catalogs.
- Knowledge of virtualization and experience with virtualized database environments.
- Working knowledge of AWS cloud platform services and infrastructure, including supporting and administering database workloads in AWS environments, as well as experience with Infrastructure as Code (IaC) concepts and Terraform.
- Python, T-SQL, or other scripting experience.
- Excellent written and verbal communication skills.
- Ability to work and communicate effectively with all levels of professionals.
- Experience supporting enterprise cloud migration initiatives and hybrid database environments.
- Experience establishing database governance, architecture standards, and engineering best practices.
- AWS, Oracle, Microsoft SQL Server, PostgreSQL, or other database-related professional certifications are desirable.
- Ability to obtain and maintain a Public Trust
Salary Minimum: $100,000
Salary Maximum: $150,000
The annual base salary provided is a guideline for this position and is not a guarantee of compensation or salary. When extending an offer, By Light also considers other variables such as (but not limited to) work experience, education, training, skill set, internal peer equity, clearance level, and market conditions. In addition, By Light provides an extensive selection of benefits and offerings to our employees.
Similar Jobs
Security • Cybersecurity
Lead hypothesis-driven threat hunts across industrial control system and operational technology networks. Investigate suspicious activity, escalate high-severity alerts, configure Dragos Platform hunt profiles, develop hunting content, analyze network telemetry, and improve detection capabilities. Advise customers during critical security events, produce technical reports, create repeatable tooling, and mentor junior team members on OT protocols, adversary tactics, and threat intelligence.
Top Skills:
DnsDragos PlatformFirewallsIcs/OtIds/IpsMitre Att&Ck For IcsPcapSIEMTcp/Ip
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Own the roadmap and end-to-end seller experience for quoting, approvals, and opportunity workflows across Salesforce and CPQ. Discover high-impact problems with Sales, Deal Desk, Finance, and Engineering; build prototypes, dashboards, internal tools, and AI-assisted workflows; measure adoption and business impact; and iterate solutions for scale. The role requires hands-on product development, strong stakeholder management, and expertise in go-to-market systems.
Top Skills:
Ai ToolsCpqSalesforceSQLWorkato
Software • Defense
The Procurement Specialist manages corporate indirect procurement operations, including vendor contract cleanup, record maintenance, renewals, onboarding, purchase requests, approvals, purchase orders, and vendor documentation. They operate Zip, maintain data flows with NetSuite, track compliance and renewals, support negotiations, train stakeholders on procurement policies, and optimize workflows. The role also supports spend tracking, budgeting, forecasting, and cross-functional coordination with Finance, IT, GRC, Legal, and business units.
Top Skills:
AirbaseCoupaNetSuiteProcurifyZip
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
