Companies in this catalog do not charge applicants. Never send money to apply.
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.