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.