Cloud Database Engineer III (Oracle + PostgreSQL) - Night Shift
Job Summary
Job Description
This role involves database engineering and administration tasks, including design, planning, configuration, monitoring, automation, and space management for Oracle and PostgreSQL databases. The engineer will be responsible for database backup and recovery, capacity planning, high availability and disaster recovery strategies, patch management, troubleshooting, and performance analysis. Significant experience with cloud platforms (Azure/GCP) is required, including migrations, automation, and administration (using tools like Azure Migrate, Data Migration Service, Azure ASR, GCP DMS, GCP Backup and Disaster Recovery Service). The role demands proficiency in database migrations and upgrades, understanding of cloud basics (security, storage, cost optimization), and experience with monitoring tools (Datadog, Azure Monitor, OEM, GCP Monitoring). The position requires 24x7 production support and working knowledge of ITIL ticketing systems. The ideal candidate will have experience with automation (Python/Shell), HADR configurations (Oracle RAC, Data Guard, RMAN, Data Pump, ASM, Golden Gate; PostgreSQL Master-Slave replication, InnoDB cluster), and troubleshooting performance issues.
Must have:
- Oracle/PostgreSQL expertise
- Cloud platform experience (Azure/GCP)
- Database migration experience
- Automation skills (Python/Shell)
- Troubleshooting & performance analysis
- High Availability & Disaster Recovery
- Backup and recovery procedures
- Monitoring and alerting setup
Good to have:
- Database certifications
- Cloud certifications
- Experience with Datadog or similar tools
- ITIL experience
- Experience with Golden Gate or similar tools
9 skills required
Job Details
Job Profile Summary
The Cloud Database Engineer Perform database engineering and administration activities including design, planning, configuration, monitoring, automation, self- serviceability, alerting, and space management, database backup and recovery. Plan computerized databases, including base definition, structure, documentation, long- range requirements, operational guidelines, and protection with a capacity to lead and advise on migration and modernization, discover, and execute workload migrations to Cloud (Azure/GCP).
Key Responsibilities
§ List 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.
§ Vendor and Third-Party Tool Management: Evaluate and manage third-party tools and solutions that assist in database management, monitoring, and performance tuning.
§ Participate in 24X7 production support for Database Operations.
§ Hand’s on with using cloud tech tools such as Azure Migrate, Data Migration Service, Azure ASR, GCP DMS, GCP Backup and Disaster Recovery Service Migration from Oracle or/and Postgres to/from Other RDBMS platform for PaaS models like Azure Database, GCP Cloud SQL, Oracle@GCP.
§ 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.
§ Proficient Skills from tech bucket (Oracle or/and PostgreSQL) for Architecture, Installation and Configuration, Performance Tuning, High Availability and Disaster Recovery, Monitoring and Troubleshooting Knowledge List Database Migrations and Upgrades: Experience in planning and executing database migrations and upgrades, including version compatibility, testing, and minimizing downtime.
§ Cloud Enabled for Project based Migrations, Automation and Administration On-prem to cloud, Cloud to cloud Familiarity with industry best practices for (Oracle or/and PostgreSQL) administration, including configuration settings, maintenance tasks, and disaster recovery strategies.
§ Ability to communicate technical info and ideas so others will understand.
§ Ability to apply varying leadership skills and traits that create solutions and results to unexpected situations.
Skills List
§ Experience working in Automation with Python/Shell/Scalability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets Oracle (RAC, Data guard, RMAN, Data pump, ASM, Golden Gate) , PostgreSQL (Master slave replication, InnoDB cluster Set) 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 Dataguard and configuring DG broker
§ Good experience of patching, cloning, security, backup and recovery procedures, node addition, deletion, replication setup and DR-Drill activities
§ Knowledge of deploying and managing databases in cloud platforms such as Azure Database or/and GCP Cloud SQL Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (Oracle or/and PostgreSQL) Understanding of Monitoring tools such as Datadog or/and Azure monitor or/and OEM or/and GCP Monitoring Tool alerting and performance analyzation.
§ Understanding and usage of ITIL based tickets tools like Service Now
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 Azure/GCP.
§ Cloud Associate/Professional Certification
Similar Jobs
CloudLinux
(Remote)
• 3 Months ago
ByteDance
San Jose, California, United States (On-Site)
• 1 Week ago
CloudLinux
(Remote)
• 1 Month ago
CloudHire
Jersey City, New Jersey, United States (Hybrid)
• 3 Months ago
Get notifed when new similar jobs are uploaded
Similar Skill Jobs
Warner Bros Discovery
Mexico City, Mexico City, Mexico (On-Site)
• 2 Months ago
Nielsen Holdings
Bengaluru, Karnataka, India (Hybrid)
• 3 Months ago
PwC
Bengaluru, Karnataka, India (On-Site)
• 4 Months ago
Get notifed when new similar jobs are uploaded
Jobs in Gurugram, Haryana, India
Get notifed when new similar jobs are uploaded
Administrative Jobs
NetEase Games
Toronto, Ontario, Canada (On-Site)
• 3 Months ago
PlayStation Global
Aliso Viejo, California, United States (On-Site)
• 3 Months ago
Extreme Network
Chennai, Tamil Nadu, India (Hybrid)
• 3 Months ago
Get notifed when new similar jobs are uploaded
