DBA

Role: DBA

Experience: 6+yrs

Location: Chennai

Notice period: Only Immediate

Package: 8LPA max

Database Administration:

Install, build, and configure Oracle server software and related products.

Maintenance, Patching and Upgrade of oracle databases.

Ensure high availability and disaster recovery solutions, such as RAC, Data Guard, ACFS.

Configure and manage backups for database using RMAN and Cohesity

Perform RMAN and logical(datapump) backup and restore

Provision, configure and manage database clones for in Cohesity

Interact with Oracle Corporation for technical support when necessary

Setup and maintain documentation and standards i.e. SOP's

2. Performance Tuning and Optimization:

Monitor database performance and identify bottlenecks.

Optimize queries, indexes, and database configurations.

Analyze and improve database storage and I/O performance.

3. Backup and Recovery:

Implement and manage database backup and recovery strategies using RMAN, datapump and Cohesity

Conduct regular backups and test restore processes to ensure data integrity.

4. Security and Compliance:

Manage user access, roles and permissions.

Ensure databases comply with security standards and regulations (e.g., GDPR, HIPAA).

Perform audit duties like Unified auditing and apply security patches.

5. Monitoring and Troubleshooting:

Use monitoring tools to track database health, performance, and capacity.

Diagnose and resolve database errors and performance issues.

Maintain and manage DPA and dashboards like OEM, SolarWinds, New Relic.

6. Collaboration and Support:

Work closely with application developers to support database requirements.

Provide technical support for oracle databases.

Provide in 24/7 and on-call rotations for after-hours support.

7.AWS cloud support:

Install, build, and configure Oracle server software and related products in EC2 instance using terraform

Have extensive knowledge on RDS and EC2 instances.

Have extensive knowledge on terraform.

Perform migration of database from on-premises to AWS cloud.

8. Documentation and Reporting:

Maintain accurate documentation for database configurations, procedures, and changes.

Generate reports on database performance, capacity, and usage.

9. Delphix

Installation, configuration, and upgrade of Delphix engine

Creating and managing dSource; Creating and managing VDBs

Configuring and maintaining Delphix Environments

Performing VDB refresh upon requests and configuring daily/weekly refresh

Monitoring and fixing alerts in the delphix

Delphix engine Space management

User and data management in VDBs using pre/post refresh scripts

Engage with Delphix corporation for technical support when necessary