Database Administrator

Gigalabs (Pvt) Ltd.; Lahore; Remote; PKR 17,001,000 - 25,503,000; Full time

Job summary

A leading tech company is looking for an experienced Database Administrator to manage and support database infrastructure with extensive cloud services knowledge. You will design, install, and configure systems while performing upgrades and automating administration tasks. Ideal candidates must have a strong background in Oracle and SQL Server technologies and be skilled in scripting and cloud integration. Remote opportunities are available, with a contract period of six months.

Qualifications

• Extensive database administration experience, including upgrades and patching.
• Good understanding of one or more cloud services (Oracle, AWS, Azure).
• Experience in automating database administration activities.

Responsibilities

• Provide support for all Database Hosting SDAs.
• Design, install, configure and support database infrastructure.
• Administer and support database systems including storage provisioning.
• Implement backups, standby databases and monitoring.
• Perform troubleshooting and performance tuning activities as required.

Skills

Database administration

Cloud services (Oracle, AWS, Azure)

Automation tools (Ansible)

Scripting (Linux shell, PowerShell)

Service management systems

Networking configuration on Exadata

Tools

Oracle Database

SQL Server

Oracle Enterprise Manager

NetApp NAS

ServiceNow

Job description

Overview

Employment Type: Contract Based
Location: Remote, Full Time
Time Zone: 12PM-9PM(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
• The resource SHOULD have the following skills and experience:
• Experience with service management systems (ServiceNow or similar) and collaboration tools
• Experience in integrating with Oracle Cloud products such as Oracle Integration Cloud, etc.
• Oracle OVM administration and support on Exadata
• Networking configuration on Exadata
• Oracle Enterprise Linux or RedHat Linux administration and support
• Oracle Direct-NFS experience
• Experience with Ansible or other automation technologies
• Experience with NetApp NAS (or similar) hosting Oracle databases
• Experience data storage virtualization technologies.
• Experience with Windows failover clusters.
• Experience with MySQL replication.
• Experience with Ansible or other automation technologies.