Database Specialist

Dikshatek; United States; Remote; USD 92,000 - 166,000; Part time

Job summary

Dikshatek seeks a Database Specialist for contract-based work focused on migrating on-prem databases to AWS. The role emphasizes AWS DMS, RDS/EC2, and PostgreSQL/MariaDB proficiency, with documentation and customer-facing delivery responsibilities.

The candidate will collaborate with the delivery team to ensure secure, scalable, and well-documented migrations, including testing, validation, and knowledge transfer to client personnel.

Qualifications

• 4+ years of DBA experience, especially in migrations to cloud
• Experience migrating on-prem databases to AWS using DMS/RDS/EC2
• Strong knowledge of PostgreSQL and MariaDB in production
• Ability to document and present technical information to customers

Responsibilities

• Lead migration of on-premises databases to AWS
• Assess sizing and schema compatibility using AWS tools
• Document database management, design, configuration, maintenance, and troubleshooting
• Develop migration strategy, rollback, cutover and validation processes
• Collaborate with delivery teams to align migration with business objectives
• Ensure AWS best practices, security, performance and high availability
• Prepare runbooks, training materials and knowledge transfer for client teams

Skills

Problem-solving

Communication

Teamwork

Education

AWS Certifications: Solutions Architect Associate/Professional; AWS Database Specialty

Tools

MySQL

MariaDB

PostgreSQL

OracleDB

MongoDB

Redis

Linux

Windows Server

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.

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.