Oracle/SQL Database Technical Lead
Pay Rate Range: $39.28 - 40.44/hr.REQUIREMENT_ID-10672058Role Name - Oracle/SQL Database Technical LeadJob Description:Technical Skills 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 CohesityPerform RMAN and logical(data pump) backup and restoreProvision, configure and manage database clones for in CohesityInteract with Oracle Corporation for technical support when necessarySetup and maintain documentation and standards i.e. SOP'sPerformance Tuning and Optimization:Monitor database performance and identify bottlenecks.Optimize queries, indexes, and database configurations.Analyze and improve database storage and I/O performance.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.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.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.Collaboration and Support:Work closely with application developers to support database requirements.Provide technical support for oracle databases.Provide 24/7 and on-call rotations for after-hours support.AWS cloud support:Install, build, and configure Oracle server software and related products in EC2 instance using terraformPerform migration of database from on-premises to AWS cloud.Documentation and Reporting:Maintain accurate documentation for database configurations, procedures, and changes.Generate reports on database performance, capacity, and usage.DelphixInstallation, configuration, and upgrade of Delphix engineCreating and managing dSource; Creating and managing VDBsConfiguring and maintaining Delphix EnvironmentsPerforming VDB refresh upon requests and configuring daily/weekly refreshMonitoring and fixing alerts in the delphixDelphix engine Space managementUser and data management in VDBs using pre/post refresh scriptsEngage with Delphix corporation for technical support when necessaryEXPERIENCE_RANGE_IN_REQUIRED_SKILLS_ Core Database Administration; Backup, Recovery & High Availability & DR (RAC, Data guard, ACFS); Performance Tuning & Monitoring; Cloud & Modern Platforms; Cross-Functional & Application SupportSkills: IT IS_AMS_Oracle Database Administration~IT IS_AMS_Database_MS SQL ServerExperience Required: 8-10 yearsSkills: Category Name Required Importance Experience SkillCategoryTest1_MN IT IS_AMS_Oracle Database Administration Yes 1 7+ years