The Role
Administers and supports SAP ASE and PostgreSQL databases in AWS, including configuration, performance tuning, monitoring, troubleshooting, backups, replication, upgrades, patching, authentication, and disaster recovery. Supports migration from SAP ASE to Amazon RDS PostgreSQL, resolves production issues, develops database architecture and schemas, and collaborates with engineering and IT teams on cloud, hybrid-environment, and database improvement initiatives.
Summary Generated by Built In
BayNova is seeking an experienced and highly motivated Senior ASE Database Administrator to join our team in support of a mission-critical federal government client in a remote / work from home role.Job Responsibilities:
Requirements:
Preferred:
- 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
Requirements:
- 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.
- BS CS / EE / CE or related degree or professional experience working in PostgreSQL.
- 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.
- 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.
- Must be a US Citizen
Preferred:
- 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.
Skills Required
- 5+ years of experience with Sybase RDBMS technologies, including ASE and Replication Server
- Experience with performance tuning, database and replication server upgrades, EBF/SR patching, disaster recovery planning, and testing
- 3+ years of general database administration experience with PostgreSQL
- Experience developing PostgreSQL database objects, implementing database servers, designing database architecture and schemas, deploying code, managing backups, creating authentication principals, and tuning system and query performance
- Bachelor's degree in Computer Science, Electrical Engineering, Computer Engineering, or a related field, or professional PostgreSQL experience
- Working knowledge of AWS cloud services and infrastructure, including database workload administration
- Experience with Infrastructure as Code concepts and Terraform
- Python, T-SQL, or other scripting experience
- Excellent written and verbal communication skills
- Ability to communicate effectively with professionals at all levels
- Extensive troubleshooting knowledge using system, event, cluster, and enhanced subsystem logs, plus system metadata catalogs
- Knowledge of virtualization and virtualized database environments
- Must be a US Citizen
- 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
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
BayNova is a results-oriented consulting and technology services firm dedicated to serving the U.S. federal government and commercial enterprises.
