What are the responsibilities and job description for the Database Engineer 2 position at Onyx Point, LLC.?
TO BE CONSIDERED FOR THIS POSITION YOU MUST HAVE AN ACTIVE TS/SCI WITH POLYGRAPH SECURITY CLEARANCE (U.S. CITIZENSHIP REQUIRED).
The candidate must have experience with PostgreSQL and PostGIS.
Key Responsibilities
This is an on site position located in Hanover, MD
Compensation
We are committed to providing fair and competitive compensation. The salary range for this position is $78,000 to $250,000 per year. This range reflects the compensation offered across the locations where we hire. The exact salary will be determined based on the candidate's work location, specific role, skill set, and level of expertise.
Benefits
We offer a comprehensive benefits package, including:
The candidate 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.
- 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.
- 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 is an on site position located in Hanover, MD
Compensation
We are committed to providing fair and competitive compensation. The salary range for this position is $78,000 to $250,000 per year. This range reflects the compensation offered across the locations where we hire. The exact salary will be determined based on the candidate's 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
Salary : $78,000 - $250,000
