Cloud Database Administrator (DBA) - Oracle and MS SQL

Education and Work Experience Requirements:

This section is used to describe what knowledge, skills and abilities are required to perform the daily tasks.

Key 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):

· Oracle Database Administration Certified Professional.

· Oracle Certified Autonomous Database Specialist.

· MS SQL Database Administration Certified Professional.

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 & comments.

· Experience on driving migration project end to end on process and technical front.

· Excellent communication, interpersonal & presentation skills

· Reliability, Ability to work under pressure and ability to be precise in communication are must.