Database Administrator

Summary

Join T-Rex Solutions as an AWS Database Engineer to support the US Department of the Treasury's TCloud enterprise cloud development. This role focuses on managing and optimizing relational and open-source databases, leveraging AWS managed databases like RDS, Aurora, and Redshift. You will design scalable and secure database solutions, lead database migrations, and ensure high availability and performance. The position requires expertise in database failover, recovery, and automation using tools like Terraform and Ansible. This is a fully remote opportunity.

Requirements

• Bachelor's Degree and at least 4 years of experience
• 8 Years of Experience in Lieu of a degree
• Must be U.S Citizen
• Must be able to obtain a Public Trust clearance to start
• Database Expertise: Proven experience as a DBA with expertise in Oracle and Postgres databases
• AWS Managed Databases: Extensive experience with AWS database services, including Aurora, RDS, and Redshift
• Cloud Infrastructure: Familiarity with AWS infrastructure and services like EC2, VPC, S3, IAM, and Lambda
• Automation and Scripting: Experience with automation tools and scripting languages such as Python, Shell, or AWS Lambda to automate database tasks
• Monitoring and Logging: Experience with AWS CloudWatch, CloudTrail, and other monitoring tools to ensure high availability and performance
• Failover and Recovery: Solid experience in database failover, recovery procedures, and disaster recovery planning
• Comprehensive understanding of modern database design, database management, and best practices
• Strong understanding of the software development and release management processes
• Strong verbal, written, interpersonal, troubleshooting, and analytical skills
• Migration Experience: Demonstrated experience with migrating on-premises databases to AWS
• Proficient in SQL, database design, and data modeling
• Familiarity with AWS CLI, SDKs, and CloudWatch

Responsibilities

• Design scalable, secure, and highly available database solutions AWS, OCI and GCP
• Architect scalable, secure, and highly available database solutions using AWS services like RDS, Aurora, DynamoDB, and Redshift
• Translate business requirements into optimized cloud-native database architectures
• Administer and tune databases like Oracle Autonomous DB, MySQL HeatWave, Cloud SQL, BigQuery, and Cloud Spanner
• Lead migrations from on-prem or other clouds using AWS DMS, Snowball, or custom ETL pipelines
• Use Terraform, Ansible, or Deployment Manager for infrastructure as code
• Build, maintain, and manage multiple SQL and NoSQL databases, ensuring data integrity and security as the team works through a broad modernization and database migration effort like SQL Server, PostgreSQL, MySQL (Aurora), DynamoDB, MongoDB
• Optimize queries, distribution styles, sort keys, and vacuum schedules on Redshift
• Provide strong analytical and diagnostic capabilities to support identifying opportunities for building better system and data boundaries and managing data integrity across a distributed systems architecture
• Manage user accounts, permissions, cron jobs, and system updates using linux
• Have proficiency in Linux system administration and skilled in automation using Python, PowerShell, Bash, T-SQL, and AWS Lambda to streamline infrastructure, optimize database performance, and enforce security compliance
• Implement IAM roles, CMKs, encryption at rest/in transit, and audit logging
• Play a critical role in all aspects of the development and deployment process and help the team scale by improving processes and mentoring new developers
• Develop, modify, and design new or existing software systems to meet client needs
• Provide technical support, including the analysis, design, development and implementation of new systems, system enhancements and bug fixes
• Responsible for the creation, modification, and execution of test plans and scripts

Preferred Qualifications

• AWS or relevant database certifications (e.g., Oracle Certified Professional, PostgreSQL Professional)
• Scripting Skills: Experience with scripting languages (e.g., Python, Bash) for automation of database tasks
• Data Warehousing: Experience with data warehouse design, implementation, and optimization, for example, AWS Redshift
• Agile, Scrum, JIRA, Service now
• Experience utilizing version control systems like Git and SVN

Benefits

• PTO available to use immediately upon joining (prorated based on start date)
• Paid parental leave
• Individual and family health, vision, and dental benefits
• Annual budget for training, professional development and tuition reimbursement
• A 401(k) plan with company match fully vested after 60 days of employment
• Competitive salaries
• Performance bonuses
• Training and educational reimbursement
• Transamerica 401(k) and Cigna healthcare benefits