Key Responsibilities:
Database Administration:
Install, configure, and maintain Oracle databases (versions 12c, 18c, 19c, etc.).
Perform database backups and disaster recovery planning, ensuring business continuity.
Implement and manage high availability solutions like Oracle Data Guard, RAC (Real Application Clusters), and Oracle GoldenGate.
Monitor and manage the health of Oracle databases to ensure high availability, efficiency, and reliability.
Performance Tuning:
Analyze and optimize database performance, including query tuning, index optimization, and system resource management.
Identify and resolve performance bottlenecks and implement scalability solutions.
Work with developers to review and improve SQL queries, PL/SQL scripts, and overall database design.
Monitor database logs and proactively resolve issues related to database efficiency and performance.
Backup and Recovery:
Develop and implement backup strategies using Oracle RMAN (Recovery Manager) and ensure regular testing of recovery plans.
Manage and maintain Oracle Flashback, Data Guard, and standby databases for high availability and disaster recovery.
Ensure the integrity of the database backup processes and manage the archival and restoration of critical data.
Security and Compliance:
Implement security best practices to ensure the protection of database data, including user access control, encryption, and audit logging.
Maintain and review Oracle database security policies, ensuring compliance with organizational security standards.
Perform regular vulnerability assessments and patch management for Oracle databases to ensure that security patches are applied in a timely manner.
Database Monitoring and Maintenance:
Utilize Oracle Enterprise Manager (OEM) and other monitoring tools to keep track of database performance, health, and security.
Perform routine maintenance tasks like database upgrades, patch management, and capacity planning.
Manage storage allocations, tablespaces, and other database resources efficiently.
Troubleshooting and Issue Resolution:
Diagnose and resolve complex database issues, including performance degradation, database corruption, and failed queries.
Provide on-call support for production database environments to resolve issues in real time.
Troubleshoot database connectivity and data access issues, including resolving issues with networking, load balancing, and high availability configurations.
Database Integration:
Work with developers and application teams to ensure that databases are integrated seamlessly into enterprise applications.
Optimize data migration processes and integrate data between Oracle databases and other systems (e.g., ETL processes, third-party tools).
Provide support for data replication, data warehousing, and analytics platforms.
Automation and Scripting:
Write and maintain shell scripts, SQL scripts, and PL/SQL scripts to automate repetitive database administration tasks such as backups, reporting, and monitoring.
Utilize scripting to implement database automation solutions for proactive maintenance, patching, and system monitoring.
Documentation and Reporting:
Maintain detailed and up-to-date documentation on database configurations, patching procedures, security protocols, and disaster recovery plans.
Generate regular reports on database health, performance metrics, and security status for management and stakeholders.
Create and maintain user guides and technical documentation for the development and support teams.
Collaboration and Knowledge Sharing:
Collaborate with development teams to ensure that database design aligns with application requirements and best practices.
Mentor junior DBA staff and assist them in problem-solving and troubleshooting complex database issues.
Stay current with emerging Oracle technologies and best practices in database administration and management.
Required Qualifications:
Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
3-5 years of experience working as an Oracle Database Administrator.
Extensive experience in Oracle database administration (versions 12c, 18c, 19c).
Hands-on experience with Oracle RMAN, Data Guard, RAC, and GoldenGate.
Strong knowledge of PL/SQL, SQL performance tuning, and Oracle database architecture.
Experience with Oracle Enterprise Manager (OEM) or other monitoring tools.
Proficiency in shell scripting, Python, or PowerShell for task automation.
Experience in data migration, replication, and ETL processes.
Knowledge of Oracle security, including user management, data encryption, and auditing.
Familiarity with cloud-based Oracle databases (e.g., Oracle Cloud).

Oracle DBA

Job Description

Required Skills