Oracle and PostgreSQL/Mysql - Cloud Database Engineer III - Night shift at Rackspace

We are redirecting you to the source. If you are not redirected in 3 seconds, please click here.

Oracle and PostgreSQL/Mysql - Cloud Database Engineer III - Night shift Rackspace. Job Profile Summary. The Database Administrator 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 (AWS/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 AWS DMS, SMS, App Migration Service, Migration Hub, Azure Migrate, Data Migration Service, SQL Server DMA, Azure ASR, AWS DRS. ·       Migration from SQL server to/from Other RDBMS platform for PaaS models like AWS Aurora, AWS RDS, Azure Database, Azure MI, GCP Cloud SQL.. ·       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..  . Knowledge List. ·       Proficient Skills from tech bucket (SQL Server or/and Oracle or/and PostgreSQL or/and MySQL) for 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.. ·       Cloud Enabled for Project based Migrations, Automation and Administration On-prem to cloud, Cloud to cloud. ·       Familiarity with industry best practices for (SQL Server or/and Oracle or/and PostgreSQL or/and MySQL) 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/AWS CLI/PowerShell/Shell/. ·       Ability to Deploy, Manage and Troubleshoot HADR config in one of the following tech buckets SQL Server (Always On, FCI, Loshipping, Replication) or Oracle(RAC, Data guard, Golden Gate)  , MySQL & PostgreSQL( Master slave replication, InnoDB cluster Set). ·       Knowledge of deploying and managing databases in cloud platforms such as Azure SQL Database or/and Amazon RDS or/and GCP Cloud SQL. ·       Homogeneous and Heterogeneous Migrations from/to between various Tech bucket (SQL Server or/and Oracle or/and PostgreSQL or/and MySQL). ·       Understanding of Monitoring tools such as Datadog or/and Azure monitor or/and AWS CloudWatch 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 AWS/Azure.. •            Cloud Associate/Professional Certification.