Job Title

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 ResponsibilitiesClient Engagement & ConsultingEngage 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.Database Architecture & Cloud ImplementationDesign 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 & OperationsHands-on expertise in:Installation and configurationSchema managementUser and security managementBackup and restore operationsCreating and managing MS SQL and Oracle databasesPerform 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 & IntegrationExpert 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 RDSNative EC2-based database deploymentsDeep understanding of High Availability (HA) and Replication architectures, including:Engine-specific HA and replication mechanismsSupported and unsupported HA/replication features across different database engines on AWSStrong expertise as a Multi-Database Migration Specialist, capable of handling complex cross-platform migrations.Expertise RequiredDeep experience in database migrations across MS SQL Server, MySQL, PostgreSQL, and Oracle.Skilled in:Migration assessmentsPlanning and designCustomer workshopsCutover and post-migration validationProven track record in cross-platform migrations and cloud database transitions, including:AWS RDSAzure SQLGoogle Cloud SQLStrong scripting capabilities for migration, automation, and validation.Expertise in data validation, reconciliation, and post-migration performance tuning.Collaboration & LeadershipWork 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.Preferred CertificationsAWS Solutions Architect – Associate or ProfessionalAWS Database Specialty (now aligned under AWS Data Engineer Specialty)Oracle Database Administration Certified ProfessionalOracle Database SQL Certified AssociateOracle Certified Professional (OCP)Oracle Certified Professional – Database Security ExpertMicrosoft Certified: Azure Database Administrator Associate