Oracle and PostgreSQL/MySQL Cloud Database Engineer III - Night shift

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