04 feb
XpertGo Talent Solutions
Xico
**Job Overview**Senior Oracle Database Administrator will be responsible for the management of production and non- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; Setup and manage data replication; Support release/code deployment activities; perform query tuning and optimization**Essential Functions**Conduct the following for Oracle on Solaris and Linux and other related products as applicable and necessary- Install/Configure/Setup/Administer and Maintain production and non-production environments- Setup High-Availability and Disaster Recovery- Plan,
configure, maintain and test high availability and disaster recovery- Configure and maintain DB replicas for either oracle (data guard, golden gate)- Identify and get necessary alerts setup to monitor database events/situations/activities- Create Users and assign/manage permissions based on the level of access the user would need; Ensure robust and full proof security of assets- Resolve database integrity, performance, blocking, connectivity, and replication issues.- Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.- Perform and manage Database backup/recovery/restore and capacity monitoring- Refresh and cloning of production databases into test environments- Maintain databases - Statistics, Indexes, fragmentation- Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries,database etc.)
using Oracle Enterprise Manager Advanced, AWR,
DMVs- Implement operational automation using scripts.- Coordinate removal and/or archiving of data that is no longer required to be available in theproduction databases.- Design and create databases to support development initiatives- Support release/code deployment activities- Develop and maintain SunOS/Solaris/Linux Shell Scripts- Develop and maintain and packages, materialized views- Provide 24x7 support as necessary- Mentor junior/new DBA team members- Manage a team of DBAs if necessary**Qualifications**- Bachelor's Degree- Expertise with Oracle version 10.X to latest, Oracle Enterprise Manager Advanced- Expertise in SunOS/Solaris/Linux RedHat- Advanced PL/SQL Programming and troubleshooting skills- Advanced Expertise in RMAN and ASMTipo de puesto: Tiempo completoSalario: $35,000.00 - $50,000.00 al mesHorario:- Turno de 8 horas
Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.