Job Title: Database Architect and Migration Expert

Experience Level: 9-15 Yrs.

Skillsets: Database Architect, PostgreSQL, MSSQL,

MySQ Database Migration, Heterogenous database Migrations

AWS Databases, Aurora, RDS , EC2 database


Introduction:

Seeking a highly skilled AWS Database Architect and Migration Expert to join our team. The ideal candidate will possess deep expertise in designing, deploying, and managing AWS database solutions, with a strong focus on database migration strategies and execution. This role requires a blend of technical acumen, project management skills, and the ability to work collaboratively with various stakeholders to achieve seamless data transitions and optimally architected databases.

Key Responsibilities:

  • Database Architecture Design:
  • Design and implement scalable, high-performance database architectures using AWS services viz., Amazon RDS, Amazon Aurora, Amazon DynamoDB, Amazon Redshift).
  • Develop and document database Migration and Modernization strategies and best practices inclined to Business Outcomes
  • Develop database Migration and Modernization use case strategies and build use case solutions
  • Ability to build a database Practice and create best practices across database technologies on Migrations and Modernizations
  • Migration Planning and Execution:
  • Lead and manage the end-to-end migration of databases from on-premises environments or other cloud providers to AWS.
  • Perform assessments and create detailed migration plans, including data transfer methods, downtime minimization strategies, and testing procedures.
  • Utilize AWS Database Migration Service (DMS), AWS SCT and other tools for data migration, transformation, and integration.
  • Performance Tuning and Optimization:
  • Monitor and optimize database performance, ensuring high availability, reliability, and scalability.
  • Implement and manage database backups, recovery, and disaster recovery solutions.
  • Collaboration and Communication:
  • Work closely with development, operations, and data teams to understand their requirements and deliver effective database solutions.
  • Provide technical guidance and support to team members and stakeholders during database migrations and architectural changes.
  • Security and Compliance:
  • Implement and enforce database security policies, including encryption, access control, and compliance with industry regulations (e.g., GDPR, HIPAA).
  • Regularly review and update security measures to protect sensitive data.
  • Documentation and Reporting:
  • Create and maintain comprehensive documentation related to database architectures, migration processes, and configurations.
  • Prepare and present reports on database performance, migration status, and improvement recommendations.


Required Skills and Qualifications:

  • Technical Expertise:
  • Extensive experience with AWS database services (Databases on EC2,Amazon RDS, Aurora, DynamoDB, Redshift).
  • Expertise and Proficiency in SQL and database management systems (MSSQL PostgreSQL, MySQL).
  • Strong understanding of database migration tools and techniques, particularly AWS DMS, SCT Babel fish and other custom migration tools.
  • Strong understanding and design experience of Database Migration methodology, Data Modelling, defining migration strategies and plans
  • Strong understanding and working with Linux, Windows Operating systems
  • Developing Stored procedures, Functions & Routines at Database level is Plus
  • Experience:
  • Proven experience in designing and implementing database architectures on AWS.
  • Demonstrated success in managing and executing complex database migration projects.
  • Certifications:
  • AWS Certified Solutions Architect – Professional or similar AWS certifications.
  • AWS Certified Database – Specialty is a plus.
  • Soft Skills:
  • Excellent problem-solving skills and the ability to troubleshoot complex database issues.
  • Strong communication and interpersonal skills, with the ability to convey technical concepts to non-technical stakeholders.
  • Ability to work independently and manage multiple projects simultaneously.
  • Strong Customer Communication skills Desirable with ability to explain the Technical Solutions inclined to Business Outcomes and Database Migration Strategy

Preferred Qualifications:

  • Experience with additional cloud platforms (e.g., Azure, Google Cloud) is a plus.

Education:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field. Advanced degrees or relevant certifications are a plus.