Senior Database Administrator
28 days ago
Dallas
Job Description Sr. Database AdministratorAspira | IT Technology OperationsAbout 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, MS SQLServer and PostgreSQL databases 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, • Stay up-to-date with the latest database technologies, trends, and best practices, • Tune performance using tools like SQL Server DMVs, Oracle AWR/ASH, and PostgreSQL EXPLAIN/pg_stat, • Troubleshoot database outages, blocking, deadlocks, database hangs, & long-running transactions. Cloud-Based Solutions on AWS • Architect and deploy scalable, cloud-based database solutions leveraging AWS services such as RDS, Redshift, and S3., • Utilize AWS CloudFormation or Terraform for automating infrastructure provisioning and management., • Use AWS Database Migration Service (DMS) for seamless data migration across different database platforms. AI and Advanced Analytics • Build, deploy, and integrate machine learning and deep learning models for structured and unstructured data analysis using frameworks., • Leverage AI tools like AWS SageMaker, Comprehend, and etc for advanced analytics and insights., • Develop structured data analysis models to drive decision-making, customer engagement, and operational efficiency. Data Engineering and Development • Develop and maintain optimized database queries and workflows using SQL, PL/SQL, and Python., • Design and deploy APIs using GraphQL for efficient database querying and integration., • Maintain comprehensive documentation of database designs, implementations, and maintenance procedures., • Design, test, and manage disaster recovery plans for multi-platform database environments., • Expertise in designing dimensional and normalized data models optimized for Snowflake’s architecture., • Knowledge of query optimization, clustering, micro-partitioning, and managing virtual warehouses to optimize cost and performance. · 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. Desired Education and Experience · Bachelor’s degree in Information Technology or other related discipline. · 8+ years of experience with relational databases (Oracle, SQL Server) and modern NoSQL solutions (DynamoDB, Redshift). · 3+ years of hands-on experience with AWS RDS for Oracle, DynamoDB, and Redshift. · 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 Lambda, SageMaker, Glue, CloudFormation, and DMS. · Expertise in designing and deploying machine learning models for structured data analysis. · Strong familiarity with GraphQL for API development will be plus. · Knowledge of ETL tools, data warehousing, and Big Data technologies. · Proficiency in scripting (Shell, Python, or PowerShell) for automation · Certifications in Oracle, SQL Server, PostgreSQL, or AWS are a plus