Note: The job is a remote job and is open to candidates in USA. BayNova is seeking an experienced Database Administrator to support a mission-critical federal government client in a remote, customer-facing role. The position serves as a technical lead for daily database operations and maintenance, including the migration from SAP ASE to PostgreSQL, database performance, replication, backup and recovery, security, and team oversight.
Responsibilities
- Provide technical expertise in administering and maintaining production and non‑production PostgreSQL environments running on Linux
- Lead efforts in database physical design, query optimization, indexing strategies, performance tuning, and troubleshooting
- Implement PostgreSQL replication, backup and recovery strategies, monitoring, and disaster‑recovery capabilities
- Support schema conversions, data migrations, performance validation, and cutover activities as part of the ASE‑to‑Postgres migration
- Evaluate PostgreSQL configuration parameters; recommend improvements and best practices for stability and performance
- Maintain capacity planning, security controls, patching/upgrade strategy, and proactive database health assessments
- Provide working expertise for the existing ASE environment during the migration lifecycle
- Troubleshoot ASE performance issues, analyze error logs, validate configuration parameters, support replication server processes, and assist with patching/upgrade activities as needed
- Document ASE environment characteristics to support migration planning and knowledge transfer
- Participate in decommissioning and transitioning ASE instances following successful migration milestones
- Oversee daily ticket queue triage and assign work to other DBAs, providing mentorship and technical leadership to a small team
- Coordinate activities with customer project management and contract project managers
- Participate in complex customer/project meetings, needs assessments, technical design reviews, and solution feasibility discussions
- Provide database architectural guidance and evangelize modern concepts and best practices across the team
Skills
- Expertise in core database architecture: objects, file structures, tables, views, procedures, functions, triggers, sequences, indexes, constraints
- Strong hands‑on experience with PostgreSQL administration, including installation, configuration, performance tuning, backup/recovery, replication, security, and monitoring
- Demonstrated experience with the SAP ASE technology stack (ASE, Replication Server, etc.), including performance tuning, patching, replication, and upgrade planning
- Experience with database architecture design concepts and the ability to clearly communicate these concepts to the team
- Experience leading or managing a small DBA team
- Strong SQL skills (SQL, PL/pgSQL, T‑SQL) and proficiency with one or more shell scripting languages (Bash, Korn, etc.)
- Ability to install and perform application/database upgrades
- Ability to analyze and interpret database performance data, both PostgreSQL and ASE
- Strong working knowledge of programming tools and data migration techniques used in schema conversion and ETL workflows
- Ability to work independently, manage your own schedule, and handle multiple priorities across multiple projects
- Strong organizational and time‑management skills
- Excellent performance tuning capabilities across queries, memory, process scheduling, I/O, and system resource utilization
- Understanding of database design and modeling concepts for varying workload types
- Experience working with vendors for troubleshooting, escalations, licensing, and procurement
- Strong understanding of Linux OS features and how they affect both PostgreSQL and ASE
- 10+ years of database administration experience, including ASE and PostgreSQL
- 4‑year degree in an IT‑related field or equivalent professional experience
- Experience with PostgreSQL in enterprise environments (preferred)
- 10+ years of scripting experience (preferred)
Benefits
- Remote / work from home role
Company Overview