Apply on Employer Site

Aspira · 1 week ago

Senior Database Administrator, Oracle

Dallas, TX

Full-time

Onsite

Senior Level, Lead/Staff

8+ years exp

Aspira is a market-leading provider of software and services that help public agencies protect natural and cultural resources. The Senior Database Administrator is responsible for managing, maintaining, and securing data in various database systems, ensuring high performance and availability while collaborating with stakeholders on database-related projects.

CommunitiesGovernmentHospitalityInformation TechnologyInternetInternet of ThingsLeisureTourismTravel

No H1B

Responsibilities

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

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

Qualification

OracleAWS RDSSQL ServerPostgreSQLDatabase securityPerformance tuningSQLPL/SQLPythonCloudFormationCloudWatchDMSMicrosoft Always OnTransactional Replication

Required

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

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