Database Specialist
Job Description:
Position: Database Specialist
Hiring: Contract based
Location: Hanoi, Vietnam
Working model: Remote - prefer base in Hanoi
JD & Deliverables: below
Man-day estimation: 20
Payment requirement: when all Deliverables are delivered and met expectations
Tentative start month: July 2024
Scope
Our client is seeking an experienced and highly skilled Database Administrator (DBA) with expertise in the banking domain to join our team. The ideal candidate will have a strong understanding of data migration processes and requirements, particularly in migrating data from on-premises environments to AWS using DMS, and RDS or EC2. Additionally, the candidate should be proficient in documenting and presenting technical information to customers. Experience with PostgreSQL and MariaDB is essential.
The following sections provide a detailed breakdown of the scope of work and additional tasks and considerations essential for the project's successful execution.
Key Responsibilities:
Lead, implement and responsible for Database Migration of on-premises workloads to AWS.
- On-Premises Assessment
- Conduct assessment phases to discover existing database sizing and schema compatibility using AWS tools.
- Document all aspects of database management, including design, configuration, maintenance, and troubleshooting.
- Strategy Development
- Work with other Delivery team members to provide Database input for Migration Strategy
- Collaborate with stakeholders to align migration strategy with business objectives and technical requirements.
- Ensure that Database designs adhere to AWS best practices and security standards.
- Migration
- Plan and execute data migration projects from on-premises to AWS within expected RPO, and RTO.
- Ensure database performance, availability, and security by industry best practices.
- Provide strategy documents including but not limited to migration, rollback, cutover, and validation process.
- Collaborate with cross-functional teams to migrate and verify the correctness of the database when migrate
- Testing and Quality Assurance
- Perform sample runs and test data ingestion, processing
- Create and execute test cases to validate data accuracy and performance
- Performance Optimization
- Monitor system performance and identify bottlenecks
- Optimize Database configurations for memory, timeout, connection pool, etc.
- Transition to Client
- Handover all necessary documentation and knowledge to the customer team
- Assist with the transition process and provide ongoing support if required
- Provide training and support to internal teams on Database migration & Administration best practices.
Required Skills and Qualifications:
- Technical Skills:
- Solutions Architect - Associate or Professional, AWS Database Speciality
- Minimum of 4+ years experience with DBA, familiar with MySQL, MariaDB, PostgreSQL, OracleDB, MongoDB, Redis etc. Skillful in database high-availability deployment
- Proven experience in migrating on-premises workloads to AWS.
- In-depth knowledge of AWS services and Database features.
- Proficiency in conducting Database assessments and implementing mitigation strategies.
- Experience in Linux and Windows Server
- Proficient in shell, bat, python or other scripting languages
- Soft Skills:
- Excellent problem-solving skills and the ability to work under pressure.
- Strong communication and interpersonal skills.
- Ability to work collaboratively in a team environment.
Project Deliverables
- Migration: Successfully migrates the on-premises database to AWS.
- Current State Assessment Report: A detailed report on the current state of on-premise applications, including architecture, infrastructure, and dependencies.
- Migration Strategy Document: A strategic roadmap for migrating on-premise applications to AWS Cloud, including timelines, resource requirements, and cost estimates.
- Migration Plan: Detailed migration plans for each application, including AWS service selection, architecture design, and implementation steps.
- Risk Assessment and Mitigation Plan: Identification of potential challenges and risks, along with mitigation strategies.
- Migration Runbooks: Comprehensive runbooks for migration processes, including
- Inventory list
- Data mapping and transformation: Definition of data schema, transformations, and data mapping from on-premises to AWS.
- pre-migration, migration, and post-migration steps.
- Environment setup: Creation and configuration of the AWS environment, including database cluster, backup solution
- Training and Knowledge Transfer Materials: Documentation to support training and knowledge transfer to internal teams and client personnel.