Senior ASE Database Administrator

By Light Professional IT Services LLC; Alexandria (VA); On-site; USD 100,000 - 150,000; Full time

Job summary

By Light Professional IT Services LLC seeks a database administrator to support, maintain, and administer ASE and PostgreSQL databases across on-prem and AWS environments. The role emphasizes availability, security, and performance, with migration work from SAP ASE to Amazon RDS PostgreSQL and collaboration across teams.

The ideal candidate will have a strong background in database systems, virtualization, and IaC practices, plus excellent communication skills for cross‑functional support and

Qualifications

• BS CS / EE / CE or related degree or professional experience working in PostgreSQL.
• 5+ years of experience with Sybase ASE/REP and related systems, performance tuning, upgrades, patches, and disaster recovery planning/testing.
• 3+ years of general database administration tasks: PostgreSQL server objects, backups, schema design, deployments, and performance tuning.
• Extensive troubleshooting using logs, metadata catalogs, and monitoring tools; virtualization knowledge.
• Experience with AWS cloud platforms and IaC concepts including Terraform.

Responsibilities

• Support/administrate ASE and PostgreSQL databases, including AWS-hosted instances.
• Setup, configuration, administration, tuning, monitoring, and backups of ASE and PostgreSQL infrastructure.
• Work with large data volumes and migrations from SAP ASE to Amazon RDS PostgreSQL.
• Provide client support for test and production systems as needed.
• Maintain database performance and resolve production and application issues.
• Collaborate with engineers and IT teams on architecture plans and implementations.
• Recommend changes to improve ASE/PostgreSQL server configurations.

Skills

Communication skills

Scripting experience

Team collaboration

Problem solving

Analytical thinking

Education

BS CS / EE / CE or related degree

Tools

Terraform

AWS

PostgreSQL

Job description

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 Overview

We 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

Required Experience/Qualifications

• 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 recoveryplanningand 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.

Preferred Experience/Qualifications

• 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.

Special Requirements/Security Clearance

• Ability to obtain and maintain a Public Trust

Salary Range

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.