Job description

Sr. Database Administrator

Aspira | IT Technology Operations

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.

The Ideal Candidate

Aspira’s Senior Database Administrator is a resource that manages, maintains, and secures data in one or more data systems that enable users and applications to perform critical business operations.

Responsible for owning the data storage, compute infrastructure, organization, presentation, utilization, and security for each of the database systems for the company, which span development through to production environments, and from internal only through to customer facing environments.

Playing a critical role in ensuring the backbone to countless systems remains functional and available, and enabling Aspira’s systems and users to perform their given roles, incumbent spearheads position to achieve annual department goals and key performance indicators (KPIs).

Key Responsibilities

Maintenance and Support

·          Design, develop, and maintain Oracle, Microsoft SQLServer, and PostgreSQL databases and associated systems to meet business requirements

·          Perform database tuning and optimization to ensure high performance and availability

·          Implement and manage database security measures to protect sensitive data

·          Monitor and troubleshoot database issues, ensuring timely resolution

·          Collaborate with software developers, system administrators, and other stakeholders to support database-related projects

·          Develop and maintain documentation for database design, implementation, and maintenance procedures

·          Conduct regular database backups and recovery operations

·          Maintain complex data replication environments for High Availability, redundancy, analytics pipelines, and customer facing reporting and data delivery systems

·          Stay up-to-date with the latest database technologies, trends, and best practices

Cloud-Based Solutions on AWS

·          Architect and deploy scalable, cloud-based database solutions leveraging AWS services such as EC2, RDS, and purpose driven AWS managed database services

·          Utilize AWS CloudFormation for automating infrastructure provisioning and management.

·          Use AWS Database Migration Service (DMS) for seamless data migration across different database platforms

·          Leverage AWS CloudWatch to provide system health tracking and problem diagnosis

Qualifications

·          Good people skills with a natural ability to work with and support colleagues, and an ability to adapt to and work effectively with clients and co-workers with different styles and levels of technical knowledge.

·          Ability to work proficiently in a fast-paced environment while adapting to changing deadlines and priorities.

·          Composes effective and appropriate written and verbal communication for all organizational levels.

·          Detail-oriented, displaying an ability to manage multiple assignments simultaneously with strong organizational skills and effectiveness under pressure with tight timeframes.

·          Possesses a natural sense of urgency in achieving business goals and uses those skills to motivate others and create positive momentum.

·          Initiative-taking, responsive, results-oriented, and resourceful; possessing the highest level of integrity and motivation.

·          Leads by example; inspiring and demonstrating Aspira’s core values and dedication to the Company’s missions.

·          Ability to work independently while being accountable to a team and actively contributes innovative ideas, methods, or initiatives to improve Aspira’s database performance, objectives, results, and commitment.

·          Willing to take on work you’re unfamiliar with an eagerness to learn

·          Possess a strong sense of ownership for tasks, seeing them through to completion

Desired Education and Experience

·          Bachelor’s degree in Information Technology or other related discipline.

A combination of related experienced and education will be considered

·          8+ years of experience with relational databases (Oracle, SQL Server, PostgreSQL)

·          3+ years of hands-on experience with AWS RDS for Oracle, AWS EC2

·          Proven experience with Microsoft Always On Availability Groups and Transactional Replication technologies

·          Experience with database security and data protection measures

·          Proficiency in SQL, PL/SQL, and Python for database management and analytics.

·          Advanced knowledge of database security, performance tuning, and optimization.

·          Hands-on experience with AWS services like EC2, RDS, CloudWatch, CloudFormation, and DMS.

Required Skill Profession

Computer Occupations