Database Engineer 2
Database Engineer 2
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Description:
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 projects 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.
Five (5) years experience as a DBE in programs and contracts of similar scope type and complexity is required. Bachelors degree in a technical discipline from an accredited college or university is required. Five (5) years of DBE experience may be substituted for a bachelors degree.
Support the database design development implementation information storage and retrieval data flow and analysis activities.
Support the development of long and short-term requirements for database administration and design.
Support the analysis and evaluation of system improvements optimization development and/or maintenance efforts.
Translate a set of requirements and data into a usable database schema by creating or recreating ad hoc queries scripts and macros updates existing queries creates new ones to manipulate data into a master file.
Assist in developing databases database parser software and database loading software.
Assist in developing database structures that fit into the overall architecture of the system under development.
Lead development of databases database parser software and database loading software.
Lead development of database structures that fit into the overall architecture of the system under development.
Develop requirement recommendations from a projects inception to its conclusion for a particular Business and IT subject matter area (i.e. simple to complex systems).
Develop 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 candidate shall must have experience with PostgreSQL and PostGIS.
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. pgstatstatements Prometheus Grafana).
Knowledge of scripting languages for automation and tooling.
Preferred Qualifications:
Experience with containerized environments (Docker Kubernetes).
Familiarity with cloud platforms (AWS RDS GCP 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.
This position requires in-scope poly within 7 years.
Compensation:
We are committed to providing fair and competitive compensation. The salary range for this position is $78000 to $250000 per year. This range reflects the compensation offered across the locations where we hire. The exact salary will be determined based on the candidates work location specific role skill set and level of expertise.
Benefits:
We offer a comprehensive benefits package including:
- Health Coverage: Medical dental and vision insurance
- Additional Insurance: Basic Life/AD&D Voluntary Life/AD&D Short and Long-Term Disability Accident Critical Illness Hospitalization Indemnity and Pet Insurance
- Retirement Plan: 401(k) plan with company match
- Paid Time Off: Generous PTO paid holidays parental leave and more
- Wellness: Access to wellness programs and mental health support
- Professional Development: Opportunities for growth including tuition reimbursement
- Flexible work arrangements including remote work options
- Flexible Spending Accounts (FSAs)
- Employee referral programs
- Bonus opportunities
- Technology allowance
- A diverse inclusive and supportive workplace culture
Employment Type
Full-Time
