What are the responsibilities and job description for the Database Application Developer position at Emerald Resource Group?
Database Application Developer
Must be located in the Cleveland, Columbus, or Toledo area
On-Call: Light rotation, approximately 1 weekend per quarter (around 8 hours total)
Compensation: ~$150,000 annually, commensurate with experience
About the Company
We are a large, established organization operating at a significant scale, with complex, mission-critical systems supporting high-volume transactional operations across the country. Our technology team is collaborative and cross-functional, built around practical expertise, continuous improvement, and a strong sense of ownership. We have made a substantial investment in Oracle Cloud Infrastructure (OCI) over the past several years and are committed to leveraging modern cloud capabilities to drive operational excellence.
Role Overview
We are seeking a Senior Database Engineer to join our growing data and engineering organization. This is not a traditional DBA role. It is a hybrid position that blends production database administration, development support, and database engineering. You will work closely with software development teams, operations, and our data warehouse function to support the full lifecycle of our database environment.
Required Qualifications
- 5 years of experience as a Database Administrator, Database Engineer, or similar role
- Deep hands-on expertise with Oracle databases in a production environment
- Strong proficiency in PostgreSQL / Postgres
- Experience with Oracle Cloud Infrastructure (OCI) or comparable cloud database platforms
- Proven ability to support both production operations and active software development teams
- Experience building and maintaining data retention, purge, and archiving processes at scale
- Strong SQL skills, including complex query writing, performance tuning, and schema design
- Scripting proficiency in Shell (Bash) and/or Perl
- Solid understanding of how data flows through enterprise applications and business processes
- Excellent communication and collaboration skills, with the ability to work effectively across development, operations, and data teams
Key Responsibilities
Production Database Support
- Manage and support production Oracle and PostgreSQL databases, ensuring stability, performance, and availability
- Handle production tickets, execute database changes, and participate in change management processes
- Monitor database health and proactively address issues before they impact operations
- Participate in a light on-call rotation (approximately one weekend per quarter, ~8 hours)
Data Engineering & Process Automation
- Build and manage data retention policies and purge processes across databases containing billions of records
- Develop utility scripts and process tools to move, transform, and communicate data across systems
- Process result files and report data back into operational and order management systems
- Understand how data flows through the business and contribute to improving those flows
Audit Trail & Data Governance
- Lead and support the re-implementation of audit trail tracking across production databases
- Design solutions to capture old and new values across configuration and transaction tables
- Ensure data is maintained within proper retention standards and regulatory controls
- Collaborate on data governance initiatives, including potential use of AI tooling in the audit trail environment
Technologies & Tools
Core Databases
• Oracle (primary)
• PostgreSQL / Postgres
Cloud Infrastructure
• Oracle Cloud Infrastructure (OCI), approx. 85% of the environment
SQL & GUI Tools
• SQL Developer
• DBeaver
• JetBrains IDEs
Scripting
• Shell scripting (Bash)
• Perl scripting
• Advanced SQL
Salary : $150,000