Cloud Database Consultant - Oracle & MS SQL

Ironbook AI

India

On-site

INR 1,200,000 - 1,800,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading tech consulting firm in India is looking for a Database Consultant to design and implement MS SQL and Oracle database solutions on AWS. The role involves client engagement, architectural design, and handling complex database migrations. Candidates should have strong experience with AWS RDS and the ability to optimize database performance. Preferred certifications include AWS and Oracle qualifications. This is a full-time position offering mid-senior level opportunities.

Qualifications

Strong hands-on knowledge of AWS RDS and cloud-native database services.
Proven experience in database migration projects.
Expertise in database performance tuning and optimization.
Strong consulting, leadership, and stakeholder management skills.

Responsibilities

Engage with clients to design scalable database solutions.
Lead workshops to define and design database architectures.
Deliver consulting services across migrations, upgrades, and performance tuning.
Plan and implement backup and recovery strategies.

Skills

Database performance analysis

Database migration expertise

AWS RDS knowledge

Cross-platform migration

Scripting for automation

Stakeholder management

Database security best practices

Education

AWS Solutions Architect Certification

Oracle Certified Professional

Tools

AWS EC2

Docker

JDBC

Job description

Role Overview – Database Consultant (MS SQL & Oracle on Cloud)

The Database Consultant will engage with customers to design, architect, and deliver end-to-end MS SQL and Oracle database solutions on the cloud. This role involves leading client workshops, coordinating with multiple stakeholders, and delivering consulting services across architecture design, migrations, upgrades, performance tuning, and disaster recovery implementations, primarily on AWS.

Key Responsibilities

Client Engagement & Consulting

Engage with clients to understand business and technical requirements and translate them into scalable database solutions.
Lead customer workshops to gather requirements, define solutions, and design database architectures for MS SQL and Oracle on cloud.
Coordinate with multiple stakeholders across client hierarchies, including DBAs, developers, architects, and infrastructure teams.
Deliver consulting services through workshops, solution design, architecture reviews, migrations, upgrades, performance tuning, and DR engagements.
Enforce contractual SLAs through effective database design, administration, and optimization.
Design holistic MS SQL and Oracle database solutions on one or more public cloud platforms, primarily AWS.
Plan, design, implement, and maintain database environments on AWS services such as EC2, RDS, and S3.
Define and implement High Availability (HA), Disaster Recovery (DR), replication, failover, and monitoring strategies.
Develop secure, scalable, and high-performance database architectures aligned with best practices.

Database Administration & Operations

Installation and configuration
Schema management
User and security management
Backup and restore operations
Creating and managing MS SQL and Oracle databases
Perform architect-level server security configuration and monitoring
Plan and implement backup and recovery strategies using scripting and automation
Monitor and tune database performance; analyze and resolve complex performance issues
Develop and optimize database structures to ensure data integrity, security, and performance

Performance, Security & Integration

Expert in database performance analysis, tuning, and optimization
Strong knowledge of database security best practices and compliance
Experience integrating databases with third‑party monitoring tools
Experience with JDBC connection pools and database integrations
Knowledge of Linux and Windows system administration (preferred)
Familiarity with virtualization and container technologies such as AWS EC2 and Docker (plus)

Core Requirements & Migration Expertise (Must-Have)

Strong hands‑on knowledge of AWS RDS and cloud‑native database services
Proven experience in database migration projects, including assessment, planning, execution, and cutover
Demonstrated ability to migrate database workloads across engines such as Oracle, MS SQL Server, MySQL, and PostgreSQL
Hands‑on experience migrating databases to AWS RDS
Deep understanding of High Availability (HA) and Replication architectures, including engine‑specific HA and replication mechanisms, and supported/unsupported HA/replication features across different database engines on AWS
Strong expertise as a Multi‑Database Migration Specialist, capable of handling complex cross‑platform migrations
Deep experience in database migrations across MS SQL Server, MySQL, PostgreSQL, and Oracle
Skilled in planning and design, cutover and post‑migration validation, cross‑platform migrations and cloud database transitions, including AWS RDS
Strong scripting capabilities for migration, automation, and validation
Expertise in data validation, reconciliation, and post‑migration performance tuning
Work effectively within cohesive, cross‑functional teams
Demonstrate strong consulting, leadership, and stakeholder management skills
Communicate clearly with both technical and non‑technical audiences at various organizational levels
Apply consultative techniques and structured problem‑solving approaches in service delivery
Exhibit strong skills in decision‑making, planning, organization, and documentation