Sr. Oracle Database Administrator [CRP283]

Sr. Oracle Database Administrator [CRP283]

**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 the

production 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 ASM

Tipo de puesto: Tiempo completo

Salario: $35,000.00 - $50,000.00 al mes

Horario:

- Turno de 8 horas

El anuncio original lo puedes encontrar en Kit Empleo:
https://www.kitempleo.com.mx/empleo/138691194/oracle-database-administrator-crp283-xico/?utm_source=html