Summary
Join T-Rex Solutions as a Senior AWS Database Engineer to contribute to 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 (RDS, Aurora, Redshift), and ensuring database performance, availability, and security. You will be responsible for database design, migration to AWS, failover and recovery strategies, and data warehousing solutions. The ideal candidate possesses extensive experience in database administration, AWS services, and automation tools. A strong understanding of database security and compliance is crucial. This position offers a competitive salary and comprehensive benefits package.
Requirements
- Be a US Citizen with the ability to obtain a Public Trust clearance
- Have a Bachelorβs degree in Computer Science, Information Technology, or related field and at least 7 years' experience
- Have proven experience as a DBA with expertise in Oracle and Postgres databases
- Have extensive experience with AWS database services, including Aurora, RDS, and Redshift
- Have familiarity with AWS infrastructure and services like EC2, VPC, S3, IAM, and Lambda
- Have experience with automation tools and scripting languages such as Python, Shell, or AWS Lambda to automate database tasks
- Have experience with AWS CloudWatch, CloudTrail, and other monitoring tools to ensure high availability and performance
- Have a solid experience in database failover, recovery procedures, and disaster recovery planning
- Have a comprehensive understanding of modern database design, database management, and best practices
- Have a strong understanding of the software development and release management processes
- Have strong verbal, written, interpersonal, troubleshooting, and analytical skills
- Have demonstrated experience with migrating on-premises databases to AWS
- Be proficient in SQL, database design, and data modeling. Have familiarity with AWS CLI, SDKs, and CloudWatch
Responsibilities
- Administer, maintain, and implement policies and procedures for ensuring the security and integrity of databases
- Collaborate with the team to design highly available, scalable, and secure database architectures
- Monitor database performance, implement changes and apply new patches and versions when required to ensure optimal performance
- Design and execute database backup and recovery strategies, including failover planning and testing
- Lead migration projects from on-premises databases to AWS, including planning, execution, and validation of database migrations and upgrades
- Ensure database security measures are in place, including access controls and audit logging. Comply with all applicable data privacy laws and regulations
- Manage and optimize AWS Redshift instances and other data warehousing solutions for scalable and efficient data storage and analysis
- Utilize AWS CloudWatch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications
- Provide high-level support for complex database issues, including troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, etc
- Set up and configure automated monitoring and alerting for database health, performance, and uptime using AWS CloudWatch, AWS CloudTrail, and other tools
- Maintain clear documentation for database configurations, processes, procedures, and troubleshooting guides
Preferred Qualifications
- Have AWS or relevant database certifications (e.g., Oracle Certified Professional, PostgreSQL Professional)
- Have experience with scripting languages (e.g., Python, Bash) for automation of database tasks
- Have deep familiarity with database monitoring tools, especially AWS CloudWatch, for performance monitoring and alerting
- Have an Active Treasury clearance
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
- Transamerica 401(k)
- Cigna healthcare benefits
Disclaimer: Please check that the job is real before you apply. Applying might take you to another website that we don't own. Please be aware that any actions taken during the application process are solely your responsibility, and we bear no responsibility for any outcomes.