Cloud Database Migration Engineer III
Job Summary
Job Description
The Cloud Database Migration Engineer III is responsible for creating and maintaining Standard Operating Procedures for migration execution and ensuring the long-term technical viability of production deployments. The role involves engaging with customers to streamline project deliverables, forecasting future database growth for capacity planning, and planning High Availability and Disaster Recovery strategies. Key responsibilities include managing patch updates and upgrades, troubleshooting complex database issues, and contributing to automation scripts for efficiency. The engineer will also set up monitoring and alerting systems, generate performance reports, maintain documentation, and handle incident, change, and service requests within agreed SLAs. Problem management, including RCA reports, is also a core duty. The role requires understanding cloud basics for security, storage, backup vaults, key vaults, and server/database monitoring, as well as cost optimization through workload analysis and license enhancements.
Must have:
- 7+ years of relevant experience
- Experience with Oracle (RAC, Data guard, RMAN, Data pump, ASM, Golden Gate)
- Experience with SQL Server Architecture, Installation, Configuration, Performance Tuning, HADR
- Experience in planning and executing database migrations and upgrades
- Experience with automation using Python/Shell/PLSQL
- Ability to deploy, manage, and troubleshoot HADR configs in Oracle or SQL Server
- High school diploma or equivalent
Good to have:
- Experience with MySQL or PostgreSQL (Master slave replication, InnoDB cluster Set)
- Database Specialty Certifications in AWS/Azure
- Cloud Associate/Professional Certification
- Bachelor's degree in Computer Science or related field
10 skills required
Job Details
Job Description
Atleast 7 yrs of relevant exp.
Job Profile Summary
•Create, maintain, and use Standard Operating Procedures (SOP’s) for migration execution and ensure long term technical viability and optimization of production deployments and administration.
•Engage, Consult and Deliver based on interactive customer communications in streamlining project deliverables and scope of work.
•Capacity Planning: Forecast future database growth based on usage trends and plan for hardware and storage requirements accordingly to ensure scalability and optimal performance.
•Plan, Create, Manage and Deploy Effective High Availability and Disaster Recovery strategy/Runbooks.
•Patch Management and Upgrades: Plan and execute Database software upgrades, patches, and service packs.
•Troubleshooting and Issue Resolution: Investigate and resolve complex database-related issues, including data corruption, performance problems, and connectivity challenges.
•Automation and Scripting: Contribute to automation scripts and tools to streamline repetitive tasks, improve efficiency, and reduce the risk of human errors.
•Monitoring and Alerting: Set up monitoring and alerting systems to proactively identify and address potential database issues before they become critical.
•Performance Analysis and Reporting: Generate performance reports and analysis for stakeholders and management to provide insights into the database environment's health and performance.
•Documentation: Maintain up-to-date documentation of database configurations, procedures, and troubleshooting steps
•Ticket Handling: Work to resolve Incident, Changes and Service request under the agreed client SLA.
•Problem Management: Responsible in resolving problem tickets by creating detailed RCA reports.
•Understanding Cloud basics and perform duties like security management, storage management, Backup Vaults, Key vaults, Server/DB Monitoring
•Cost Optimization: Compute and workload analysis, License enhancements and features.
Skills List
•Experience working in Automation with Python/Shell/PLSQL
•Ability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets Oracle (RAC, Data guard, RMAN, Data pump, ASM, Golden Gate) .
•Experience in troubleshooting performance issues and able to suggest development team with complete analysis
•Hands on working experience in setting up standby in using Oracle Data guard and configuring DG broker
•Proficient Skills in SQL Server Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery (HADR), Monitoring and Troubleshooting
•Database Migrations and Upgrades: Experience in planning and executing database migrations and upgrades, including version compatibility, testing, and minimizing downtime.
•Ability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets SQL Server (Always On, FCI, Loshipping, Replication) MySQL or PostgreSQL (Master slave replication, InnoDB cluster Set)
Education
• High school diploma or equivalent required.
• Bachelor’s degree in computer science, Computer Information Systems, Management Information Systems, or a directly related field
Certifications List
•Database Specialty Certifications in AWS/Azure.
•Cloud Associate/Professional Certification
Similar Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Similar Skill Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Jobs in Gurugram, Haryana, India
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Devops Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
