Database Administrator

Company Overview

Details about the company, its industry, and culture are not provided.

Job Summary

The Database Administrator (DBA) is responsible for managing large database estates, ensuring high availability, performance, and security of databases across Unix and Windows platforms. This role plays a critical part in maintaining the integrity of data and providing support for production and non-production environments.

Responsibilities

• Handle large database estates and manage terabyte-sized databases.
• Install and administer multiple database versions on Unix and Windows servers.
• Design and implement high availability solutions such as Real Application Clusters (RAC), GoldenGate, and Data Guard.
• Plan and execute major migrations and upgrades of database systems.
• Define and configure disks and disk groups in Automatic Storage Management (ASM) and troubleshoot issues.
• Manage databases on Exadata machines, ensuring optimal performance and resource utilization.
• Plan and implement backup and recovery strategies based on organizational needs.
• Coordinate with database vendors to resolve major incidents and issues.
• Automate database refreshes, reorganizations, and backups using RMAN and third-party tools.
• Install and configure grid control database monitoring tools, while troubleshooting as needed.
• Conduct periodic database performance reviews and recommendations for tuning.
• Analyze database environments proactively and make suggestions to application teams regarding improvements.
• Develop and troubleshoot shell scripting, SQL, and PL/SQL scripts.
• Support production and non-production database environments with 24x7 on-call support.
• Maintain Standard Operating Procedures (SOPs) for all database activities.
• Identify and mitigate technology-related risks while tracking them effectively.
• Provide technical presentations on emerging technologies and suggest relevant training to the project manager.
• Offer guidance to L2 and L1 Database Administrators on technical and process-related matters.

Qualifications

• Proficiency in database administration, including installation, configuration, and maintenance.
• Experience with high availability solutions such as RAC, GoldenGate, and Data Guard.
• Strong skills in Automatic Storage Management (ASM) and Exadata environments.
• Familiarity with backup and recovery tools like RMAN.
• Knowledge of database performance tuning and troubleshooting techniques.
• Competence in shell scripting, SQL, and PL/SQL scripting languages.
• Strong analytical and problem-solving abilities.
• Effective communication skills for liaising with both technical teams and management.
• Experience in managing database security practices.

Preferred Skills

• Experience with cloud database solutions and migrations.
• Knowledge of database monitoring tools and practices.
• Familiarity with emerging database technologies.

Experience

A specific number of years of experience is not provided, but extensive experience in database management and administration is expected.

Environment

Details regarding the typical work setting, location, and environmental conditions are not provided.

Salary

Salary details are not specified.

Growth Opportunities

Opportunities for career advancement within the company are not specified.

Benefits

Details about offered benefits are not provided.