Full-Time Oracle Database Administrator (DBA)
Attain is hiring a remote Full-Time Oracle Database Administrator (DBA). The career level for this job opening is Manager and is accepting India based applicants remotely. Read complete job description before applying.
Attain
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
The Oracle DBA will be responsible for the design, implementation, maintenance, and performance tuning of Oracle databases. This role involves ensuring database reliability, security, and availability while supporting application teams with database solutions. The ideal candidate will have extensive experience with Oracle Database Administration, a deep understanding of database architecture, and strong problem-solving skills.
Key Responsibilities:
1. Database Management:
- Install, configure, and upgrade Oracle database servers and related software.
- Create and manage database structures, including tablespaces, schemas, and objects.
- Perform regular database maintenance tasks, including backups, restores, and data recovery operations.
2. Performance Tuning and Optimization:
- Monitor database performance and implement enhancements for optimal performance.
- Analyze and resolve performance bottlenecks using Oracle tools like AWR, ADDM, and SQL Tuning Advisor.
- Optimize SQL queries and PL/SQL scripts for efficiency.
3. Security and Compliance:
- Implement and maintain database security policies and procedures to protect sensitive data.
- Manage user access and roles, ensuring compliance with company security standards.
- Conduct regular audits and apply patches to maintain system security.
4. Backup and Recovery:
- Develop and implement backup strategies, including RMAN backup and recovery plans.
- Perform disaster recovery planning and testing to ensure data integrity and availability.
5. Support and Troubleshooting:
- Provide 24/7 support for database-related issues, ensuring minimal downtime.
- Troubleshoot and resolve database-related incidents and service requests.
- Collaborate with development and application teams to resolve database issues.
6. Documentation and Reporting:
- Maintain comprehensive documentation of database environments, configurations, and procedures.
- Prepare regular reports on database performance, incidents, and capacity planning.
- Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience: 5+ years of experience as an Oracle DBA.
- Technical Skills:
- Proficiency in Oracle Database versions 11g/12c/19c.
- Strong knowledge of Oracle RAC, ASM, Data Guard, and GoldenGate.
- Experience with Oracle Enterprise Manager (OEM).
- Proficiency in SQL, PL/SQL, and shell scripting.
- Familiarity with backup and recovery tools (RMAN).
- Understanding of database security and compliance standards.
- Soft Skills:
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Ability to work independently and as part of a team.
Preferred Qualifications:
- Oracle Certified Professional (OCP) or Oracle Certified Master (OCM).
- Experience with cloud platforms (e.g., Oracle Cloud, AWS, Azure).
- Knowledge of other databases (e.g., MySQL, SQL Server).
Personal Attributes:
- Detail-oriented with a commitment to accuracy and quality.
- Proactive approach to identifying and resolving issues.
- Strong organizational and time-management skills.
- Need for immediate joining.
- Work from home.