Cloud Database Administrator (DBA) - Oracle and MS SQL

PradeepIT Consulting Services Pvt Ltd; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A consulting services firm in Bengaluru is seeking a Cloud Database Administrator (DBA) with expertise in Oracle and MS SQL. Responsibilities include database maintenance, performance optimization, troubleshooting, and implementing security measures. Candidates should have proficiency in SQL and automation tools like PowerShell and Python. Experience with Azure SQL Database is a plus.

Qualifications

• Expertise in DB administration, especially in Oracle & MS SQL 2019.
• Experience with Oracle Database versions 19c and above.
• Strong understanding of Azure infrastructure components.

Responsibilities

• Perform regular maintenance tasks such as DB backups and ensure DB availability.
• Monitor user activities and resource utilization.
• Plan and execute database build & migration projects with minimal downtime.
• Monitor and optimize database performance, including query tuning.
• Diagnose and resolve database-related issues.
• Implement and maintain database security measures.
• Develop and maintain disaster recovery plans.

Skills

DB administration expertise

Proficiency in SQL

Proficiency in PL/SQL

Automation scripting

Tools

Oracle Database 19c

MS SQL

Azure SQL Database

PowerShell

Python

Bash

Linux systems

Windows systems

Job description

Cloud Database Administrator (DBA) - Oracle and MS SQL

Job Openings Cloud Database Administrator (DBA) - Oracle and MS SQL

Overview

Cloud Database Administrator (DBA) with Oracle and MS SQL experience.

Responsibilities

• Infrastructure Maintenance: Perform regular maintenance tasks such as DB backups, ensuring DB availability, patching, indexing, user management and performance tuning for Oracle and MS SQL databases.
• Monitoring: Manage space, monitor user activities, and resource utilization. Independently maintain and administer databases and create and publish database health check reports.
• Database Build & Migration: Plan and execute database build & migration projects, ensuring minimal downtime and data integrity.
• Performance Optimization: Monitor and optimize database performance, including query tuning and resource management.
• Troubleshooting: Diagnose and resolve database-related issues promptly.
• Security Management: Implement and maintain database security measures, including user access controls and encryption.
• Disaster Recovery: Develop, implement and maintain disaster recovery plans and procedures.

Mandatory Skills

• Expertise in DB administration, especially in Oracle & MS SQL 2019.
• Experience with Oracle Database versions 19c and above.
• Proficiency in SQL, PL/SQL, and scripting languages.

Mandatory certification (if Any)

Good to have skills

• Strong understanding of Azure infrastructure components (server, storage, network, database, and services) to deliver end to end Cloud Infrastructure engagements that includes assessment and design.
• Experience with cloud database services and platforms like Azure SQL Database.
• Strong knowledge of database migration tools and techniques.
• Proficiency in automation tools and scripting languages such as PowerShell, Python, or Bash to automate routine tasks and improve efficiency.
• Operating system: Expert knowledge in Windows and Linux system.
• Experience on driving migration project end to end on process and technical front.
• Reliability, ability to work under pressure and ability to be precise in communication are must.