Description

You will design, deliver, and optimize enterprise database solutions, focusing on migration from Oracle to PostgreSQL and backend integration.

This role is on-site.

Responsibilities

• Design and develop backend procedures, functions, and application integrations.
• Write, optimize, and tune SQL queries for maximum performance efficiency.
• Manage database migrations, specifically transforming Oracle SQL scripts and data to PostgreSQL.
• Perform moderate DBA tasks and assess SQL security for potential risks.
• Support quality assurance teams through disciplined development and testing processes.

Required Skills

• 5+ years of experience in database design and development for enterprise-scale databases.
• Proficiency with RDBMS including PostgreSQL, Oracle, and MySQL.
• Experience with NoSQL databases.
• Hands-on experience with AWS services including RDS, DynamoDB, EC2, IAM, and S3.
• Expertise in ETL processes involving high volumes of complex data structures.
• Practical experience with AWS DMS and SCT tools for data migration.
• Proficiency with Git and Continuous Integration infrastructure.
• Knowledge of Enterprise Integration Patterns, EAI, SOA, and EDA architectures.

Preferred Skills

• Bachelor's degree in Computer Science or related field.

Key Skills

Education

Bachelor's degree