About the role

Senior Database Engineer handling application databases for Aspira, a market leader in outdoor resource management. Collaborating with teams to ensure streamlined data handling and optimization.

Responsibilities

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.
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.

8-10 years of professional experience as a Database Engineer, Database Administrator, or similar role in a software or application development environment.
7+ years of hands-on experience with Oracle Database, including administration, development, performance tuning, and troubleshooting in production systems.
4+ years of extensive experience with data evaluation, import and migration for clients and internal use cases.
Strong expertise in database management and optimization, including schema design, indexing strategies, query optimization, and capacity planning.
Advanced proficiency in SQL and PL/SQL, with a proven track record of building highly efficient, reliable database code.
Extensive experience with database performance monitoring and tuning tools and techniques.
Solid understanding of database security, data integrity, backup, recovery, and disaster recovery strategies.
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.