What are the responsibilities and job description for the Sr. Database Adminastrator position at SES?
Job Details
Location : Denver, CO
We are seeking a skilled and experienced Database Administrator to work on data migration project. The successful candidate will have a strong background in database administration, particularly with MySQL ad Redshift databases, and extensive experience with data migration, consolidation, and optimization processes. This role requires a meticulous attention to detail, strong problem-solving skills, and the ability to collaborate effectively with cross-functional teams.
Candidate Requirements:
- Hands-on experience with AWS MySQL Aurora 5.7 or above, including 24x7 production support and on-call troubleshooting.
- Experience with database migrations, and agile development methodology.
- Self-motivated, able to work independently, and collaborate effectively with developers during software deployments and data migrations.
- Excellent written and verbal communication skills for a collaborative, cross-functional environment.
Minimum Skills and Experience:
- Bachelor of Science degree in Computer Science or equivalent.
- 8 years as a MySQL, Redshift DBA, with expertise in design, implementation, backup, recovery, monitoring, and performance tuning.
- Strong understanding of database consolidation techniques and best practices.
- Experience with data migration tools and techniques, such as AWS Database Migration Service (DMS) or similar.
- Proficiency in SQL and database performance tuning.
- Develop a comprehensive strategy for merging the two databases into a single Aurora MySQL database while minimizing downtime and ensuring data integrity.
- Experience with 24x7 support, troubleshooting, and managing databases in cloud environments (AWS).
- Experience with cloud-based services (AWS Cloudwatch, DataDog, Percona Monitoring Management PMM).
- Expertise in high-availability database features, replication, disaster recovery, and live production schema changes.
- Proficiency with cloud-specific technologies (S3, Route 53, CloudFormation), version control tools (GitHub), and database life-cycle management.
- Knowledge of database security, backup retention policies, and scaling databases.
- Experience with managing the full life cycle of database schema design and implementation, which includes script management from development through production releases.
- Experience implementing database schema changes in a live production environment requiring minimal downtime and zero performance impact.
Benefits:
SES hires W2 benefitted and non-benefitted consultants. Our contract employee benefits include group medical dental vision life LT and ST disability insurance, 21 days of accrued paid time off, 401k, tuition reimbursement, performance bonuses, paid overtime, and more.
Jake Lutman
Technical Recruiter
Systems Engineering Services
