Job Description

Company DescriptionFounded in 2018 in Bangalore, the center of India's high-tech industry area, Attain has grown to serve a global client base of startups, early stage companies, and SMEs.Attain is US based software company TANGO's India partner. TANGO's software solution helps customers find, build and manage retail and office locations in a single suite/ software platform. Attain supports Tango with services in the areas of development, implementation, QA, and client support.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: Bachelorxe2x80x99s 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.
• Work from home.

Attain