Cognizant - Oracle Database Administration Expert

<p><p><b>Primary mandate skills :</b></p><p><br/>- Oracle DBA, MySQL DBA<br/><br/><b>Secondary mandate skill :</b></p><p><br/>- Shell scripting, AWS RDS, Postgres<br/><br/>Flexible to hire in any location If not, please mention job location : Bangalore<br/><br/><b>Shift timing :</b></p><p><br/>12 :30 to 10 :30 BST with on-call<br/><br/><b>Notice period :</b></p><p><br/>Less than 30<br/><br/><b>Detailed Job Description :</b><br/><br/><b>Database Administration :</b></p><p><br/>- Manage Oracle databases in production environments, including installation, configuration, and maintenance of Oracle standalone and RAC databases.<br/><br/><b>AWS RDS Management :</b></p><p><br/>- Handle AWS RDS instances, including instance migration, upgrades, snapshots, cloning, and restoration.<br/><br/><b>Performance Tuning :</b></p><p><br/>- Utilize tools like OEM, AWR, ADDM, ASH, SQL tuning advisor, SQL access advisor, SQL profile, SQL baseline, and resource management for performance optimization.<br/><br/><b>Backup and Recovery :</b></p><p><br/>- Implement backup and recovery strategies using Data Pump, RMAN, and Transportable Tablespaces.<br/><br/><b>Security :</b></p><p><br/>- Ensure database security, manage user access, and maintain compliance with security policies.<br/><br/><b>Disaster Recovery :</b></p><p><br/>- Design and implement disaster recovery solutions.<br/><br/><b>Automation :</b></p><p><br/>- Automate routine tasks using Shell scripts, Jenkins, Python, etc.<br/><br/><b>Monitoring :</b></p><p><br/>- Monitor database performance and health, and respond to alerts and issues promptly.<br/><br/><b>Secondary Skills :</b><br/><br/><b>PostgreSQL and MySQL :</b></p><p><br/>- Experience in managing PostgreSQL and MySQL databases.<br/><br/><b>AWS Services :</b></p><p><br/>- Knowledge of AWS S3, EC2, and DMS.<br/><br/><b>Operating Systems :</b></p><p><br/>- Proficiency in Linux and Windows operating systems.<br/><br/><b>Schema and Tablespace Management :</b></p><p><br/>- Manage database schemas and tablespaces.</p><br/></p> (ref:hirist.tech)