AWS Database Administrator

T-Rex Solutions is looking to select an AWS Database Engineer to support the US Department of the Treasury TCloud enterprise cloud development effort. This effort aims to facilitate holistic multi-cloud solutions (AWS, Azure, OCI and GCP) to meet the Department of Treasury’s enterprise-wide infrastructure needs. The ideal candidate will have a strong background in managing and optimizing Relational and open source databases such as SQL Server, PostgreSQL, MySQL and Oracle databases, as well as extensive experience with AWS managed databases including RDS, Aurora and Redshift. This role requires a deep understanding of database failover and recovery, backups, migration of on-premises databases to AWS, and proficiency with AWS CloudWatch. The successful candidate will be passionate about ensuring database performance, availability, and security, and experienced in handling data warehouses. This opportunity will be fully remote. 

Responsibilities:

• Database Management: Administer, maintain, and implement policies and procedures for ensuring the security and integrity of databases.
• Database Design and Architecture: Collaborate with the team to design highly available, scalable, and secure database architectures.
• Performance Tuning: Monitor database performance, implement changes and apply new patches and versions when required to ensure optimal performance.
• Failover and Recovery: Design and execute database backup and recovery strategies, including failover planning and testing.
• Migration and Upgrade: Lead migration projects from on-premises databases to AWS, including planning, execution, and validation of database migrations and upgrades.
• Security and Compliance: Ensure database security measures are in place, including access controls and audit logging. Comply with all applicable data privacy laws and regulations.
• Data Warehousing: Manage and optimize AWS Redshift instances and other data warehousing solutions for scalable and efficient data storage and analysis.
• Monitoring: Utilize AWS CloudWatch and other monitoring tools to ensure database health, performance, and to automate scaling and notifications.
• Troubleshooting and Support: 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.
• Automated Monitoring: Set up and configure automated monitoring and alerting for database health, performance, and uptime using AWS CloudWatch, AWS CloudTrail, and other tools.

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.

Desired:

• 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.

T-Rex Overview

Established in 1999, T-Rex Solutions, LLC is a proven mid-tier business providing data-centric mission services to the Federal government as it increasingly tries to secure and leverage the power of data. We design, integrate, secure, and deploy advanced technical solutions for our customers so they can efficiently fulfill their critical objectives. T-Rex offers both IT and professional services to numerous Federal agencies and is a leader in providing high quality and innovative solutions in the areas of Cloud and Infrastructure Services, Cyber Security, and Big Data Engineering.

T-Rex is constantly seeking qualified people to join our growing team. We have built a broad client base through our devotion to delivering quality products and customer service, and to do that we need quality individuals. But more than that, we at T-Rex are committed to creating a culture that supports the development of every employee's personal and professional lives. T-Rex has made a commitment to maintain the status of an industry leader in compensation packages and benefits which includes competitive salaries, performance bonuses, training and educational reimbursement, Transamerica 401(k) and Cigna healthcare benefits.

T-Rex is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex (including pregnancy and sexual orientation), parental status, national origin, age, disability, family medical history or genetic information, political affiliation, military service, or other non-merit based factors.

In compliance with pay transparency guidelines, the annual base salary range for this position is $100,000 - $130,000. Please note that the salary information is a general guideline only. T-Rex considers factors such as (but not limited to) scope and responsibilities of the position, candidate’s work experience, education/training, key skills, internal peer equity, as well as market and business considerations when extending an offer.

T-Rex offers a diverse and collaborative work environment, exciting opportunities for professional growth, and generous benefits, including: 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, and a 401(k) plan with company match fully vested after 60 days of employment among other benefits.