Add office photos
All Filters
9 Attain Jobs
Oracle Database Administrator (DBA)
Attain
posted 1mon ago
Job Role Insights
Key skills for the job
Job Description
Job Description
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.
Qualifications
- 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.
Additional Information
- Need for immediate joining.
Employment Type: Full Time, Permanent
Read full job descriptionCompare Attain with
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Capgemini
Compare
HDFC Bank
Compare
ICICI Bank
Compare
Infosys
Compare
HCLTech
Compare
Tech Mahindra
Compare
Genpact
Compare
Teleperformance
Compare
Concentrix Corporation
Compare
Axis Bank
Compare
Amazon
Compare
Jio
Compare
Reliance Retail
Compare
IBM
Compare
iEnergizer
Compare
LTIMindtree
Compare
Attain ESG Compliance and Reporting Specialist
5-10 Yrs
Bangalore / Bengaluru
Share an Interview