Overview
On Site
Full Time
Skills
Database Design
Data Flow
Object-Oriented Programming
Database Administration
Distribution
Acceptance Testing
IOC
Information Technology
Evaluation
Optimization
Ad Hoc Reporting
Macros
Storage
SAP Sybase ASE
Migration
Amazon S3
Scalability
Database
High Availability
Collaboration
Stored Procedures
Bash
Python
Database Architecture
Performance Tuning
Query Optimization
Linux
Unix
Command-line Interface
PSQL
Replication
Backup
Grafana
Scripting
Docker
Kubernetes
Amazon Web Services
Remote Desktop Services
Amazon RDS
Google Cloud Platform
Google Cloud
Cloud Computing
SQL
SQL Azure
PostgreSQL
Continuous Integration
Continuous Delivery
Terraform
Ansible
RDBMS
Oracle
MySQL
NoSQL
Job Details
Job Description
Base-2 Solutions is seeking a Database Engineer 2 who provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The DBE works primarily at the front end of the lifecycle- requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project's inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies. Must also have experience with Sybase ASE and PostgreSQL, with specific experience with database migrations. Demonstrated experience with developing migration strategies, migration tool selection and use, schema conversion, code refactor, performance optimization, test, and validation. Experience with Amazon Web Services (Relational Database Services, Simple Storage Service) also required.
Required Education
Key Responsibilities
Required Qualifications
Preferred Qualifications
Base-2 Solutions is seeking a Database Engineer 2 who provides technical expertise for database design, development, implementation, information storage and retrieval, data flow and analysis. Develops relational and/or Object-Oriented databases, database parser software, and database loading software. Projects long-range requirements for database administration and design. Responsible for developing a database structure that fits into the overall architecture of the system under development and has to make trades among data volumes, number of users, logical and physical distribution, response times, retention rules, security and domain controls. The DBE works primarily at the front end of the lifecycle- requirements through system acceptance testing and Initial Operational Capability (IOC). Develops requirements from a project's inception to its conclusion for a particular business and Information Technology (IT) subject matter area (i.e., simple to complex systems). Assist with recommendations for, and analysis and evaluation of systems improvements, optimization, development, and/or maintenance efforts. Translates a set of requirements and data into a usable document by creating or recreating ad hoc queries, scripts, and macros; updates existing queries, creates new ones to manipulate data into a master file; and builds complex systems using queries, tables, Open Database Connectivity and database storage and retrieval using Cloud methodologies. Must also have experience with Sybase ASE and PostgreSQL, with specific experience with database migrations. Demonstrated experience with developing migration strategies, migration tool selection and use, schema conversion, code refactor, performance optimization, test, and validation. Experience with Amazon Web Services (Relational Database Services, Simple Storage Service) also required.
Required Education
- Five (5) years experience as a DBE in programs and contracts of similar scope, type, and complexity is required.
- Bachelor's degree in a technical discipline from an accredited college or university is required.
- Five (5) years of DBE experience may be substituted for a bachelor's degree.
Key Responsibilities
- Design and optimize PostgreSQL database schemas, indexes, and queries for performance and scalability.
- Monitor and tune database performance using native tools and custom scripts.
- Implement and maintain high availability (HA) and replication strategies.
- Collaborate with developers to refine complex queries and stored procedures.
- Automate routine tasks using scripting languages (e.g., Bash, Python).
- Document database architecture, processes, and best practices.
Required Qualifications
- Strong SQL skills and experience with performance tuning and query optimization.
- Proficiency in Linux/Unix environments and CLI tools like psql.
- Experience with logical and physical replication, partitioning, and backup strategies.
- Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana).
- Knowledge of scripting languages for automation and tooling.
- This position requires in-scope poly, within 7 years.
Preferred Qualifications
- Experience with containerized environments (Docker, Kubernetes).
- Familiarity with cloud platforms (AWS RDS, Google Cloud Platform Cloud SQL, or Azure Database for PostgreSQL).
- Understanding of CI/CD pipelines and infrastructure as code (Terraform, Ansible).
- Exposure to other RDBMS (e.g., Oracle, MySQL) or NoSQL systems is a plus.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.