Senior Database Engineer

Aspira Association, Inc.
Dallas, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Dallas, United States of America

Tech stack

Java
Amazon Web Services (AWS)
Application Configuration Access Protocols
Backup Devices
CentOS
Databases
Computer Engineering
Data Integrity
Database Schema
Database Security
Linux
Disaster Recovery
Amazon DynamoDB
PostgreSQL
Liquibase
NoSQL
Oracle
Performance Tuning
Query Optimization
Software Engineering
SQL Stored Procedures
PL-SQL
SQL Databases
Data Import/Export
Database Performance
Indexer
Information Technology
Redgate

Job description

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

Requirements

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

Desired Hardware and Software Competencies

  • Experience with additional relational and NoSQL databases such as PostgreSQL or DynamoDB.
  • Hands-on experience with AWS, including services that interact with databases.
  • 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.

About the company

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.

Apply for this position