Senior Database Engineer

• Critical role in the planning, designing, developing, and managing of application databases in multiple environments ranging from R&D to production.

• Will work both independently and collaboratively in a team to support the software engineering, Technical Account Management, and Client Implementation teams with database-related activities ranging from database update scripts for application configuration to test environment database preparation to client data import and migration.

Key Responsibilities

• Design, develop, test, and maintain high-quality database objects (queries, stored procedures, functions, and schemas) supporting company-developed applications.

• Plan and execute database updates, migrations, and configuration changes across development, test, and production environments.

• Lead data evaluation, transformation, import, and migration efforts for client and internal use cases.

• Monitors database performance and identifies opportunities for optimizations.

• Provides guidance to software engineers on best practices for database schema and script design.

• Reviews and approves application-related database updates.

• 7-9 years of professional experience as a Database Engineer or similar role in a software or application development environment.

• Oracle is the chosen enterprise database. 6+ years of hands-on experience with Oracle Database is required, including data modeling, scripting, performance tuning and troubleshooting in non-production and production systems.

• 5+ years of extensive experience with data evaluation, import and migration for clients and internal use cases.

• AWS experience is a must, including experience with services that interact with databases.

• Creates, develops, modifies, and maintains data pipelines for internal and external facing data applications as part of an Agile/SCRUM engineering team.

• Collaborate with software engineering teams to determine data modeling requirements and ensure delivery aligns with business objectives and goals.

• Advanced proficiency in SQL and PL/SQL, with a proven track record of building highly efficient, reliable database code.

• Experience with identifying and resolving performance bottlenecks at query/schema level.

• Solid understanding of database security and data integrity.

• Strong troubleshooting, analytical, and problem-solving skills with the ability to work independently.

• Excellent communication skills, including the ability to document designs and explain technical concepts to non-database specialists.

• Proactive, detail-oriented, and able to thrive in a fast-paced, collaborative environment.

Desired Hardware and Software Competencies

• Experience with additional relational and NoSQL databases such as PostgreSQL or DynamoDB.

• Practical knowledge of Linux environments (Amazon Linux, CentOS, or similar).

• 2+ years of experience with Java programming languages for tooling and automation.

• 2+ years of experience with database change and release tools such as Liquibase, Redgate or other similar tools.

Desired Education and Experience

• Bachelor's degree in Computer Science, Computer Engineering, Information Technology, or a related technical field (or equivalent practical experience).

• Prior experience supporting customer-facing or data-intensive enterprise systems.

• Knowledge of the Outdoor Recreation domain is a plus.

***Please Note: Applicants must be legally authorized to currently work in the United States. Aspira is unable to sponsor or take over sponsorship of employment visas (H1B, TN, J1, OPT, etc...), now or in the future.*** About Aspira For more than 40 years, Aspira has been the market-leading provider of software and services that help public agencies protect natural and cultural resources while making them accessible for all. Our platform supports everything from campground reservations to hunting licenses, helping millions of people discover, enjoy, and care for the outdoors. We share our client partners' mission: to steward resources for future generations, create opportunities for genuine enjoyment of the outdoors today, and expand access so more people can experience its benefits. Aspira is transforming its technology and service model to give agencies more capacity and insight-streamlined tools, smarter automation, and better connections with their communities. Our goal is simple: make it easier for our clients to conserve what matters most and for their customers to enjoy it to the fullest.