Job Brief:
Employment Type: Contract Based
Location: Remote, Full Time
Time Zone: CET (04 Hours Overlap)
Project Duration: 6 months with the possibility of extension
Responsibilities:
Provide support for all Database Hosting SDAs
Design, install, configure and support database infrastructure
Administer and support database systems including storage provisioning, VM provisioning, patching and upgrading Implement backups, standby databases and monitoring
Assist in the design, development, implementation and maintenance of database automation tasks using Ansible or any other automation tool
Perform database clones using backups/snapshot/clone/replication technology
Provide support for setup/architecture including setup of monitoring, alerting and
scripts/interfaces to Help Desk systems
Manage NAS/LUNs for use with relational databases and related systems
Co-ordinate with Vendor Database Support for resolution of problems and incidents related to databases
Perform troubleshooting and performance tuning activities as required
Apply database patches, updates and perform upgrades
Assist in the planning and running of disaster recovery tests
Perform capacity management and reporting as required
Produce documentation as required
Perform support activities during planned maintenance windows outside of normal working hours
Requirements:
Extensive Database administration experience, including upgrades and patching
Good understanding of one or more cloud services - Oracle (OCI), Amazon (AWS), Microsoft (Azure), Google (GCP), etc.
Familiar with Cloud products such as Oracle Database Cloud, Oracle Exadata Cloud, Oracle
Integration Cloud, Azure SQL database, Azure SQL Managed Instance and AWS RDS, etc.
Extensive knowledge and support experience in three or more of the following products:
o Oracle Exadata
o Oracle Real Application Clusters (RAC)
o Oracle DataGuard
o Oracle RMAN
o High availability solutions including SQL Server Always On technology
o Failover Clustering (FCI), and Availability Groups (AG).
o Disaster recovery technologies including database mirroring and transaction log shipping.
o SQL Server Reporting Services (SSRS), Analysis Services (SSAS), Integration Services (SSIS), and Master Data Services.
o Latest version of Oracle Enterprise Manager including installation, configuration, patching and upgrading
o SQL Server Replication technology including snapshot, merge and transactional
replications.
o Database recovery procedures including the ability to recover user and system databases from failed processes and engine crashes.
Experience in automating database administration activities
Good scripting skills using Linux shell, PowerShell, Oracle, Transact-SQL and/or other automation tools