IT Database Administrator - Alajuela, Costa Rica - Teradyne
Encontrado en: Talent CR S2 - hace 2 semanas
Descripción
Role Description
· This role will be responsible for the installation, configuration upgrading, administration, monitoring, maintenance, and security of databases.
· This role will be responsible to apply the security patches for Oracle and MS-SQL Databases
· This role will be responsible to work closely with business aligned teams to perform day-to-day database operational tasks including managing incidents, plan and execute changes, manage user requests.
· This role will be responsible to identify automation opportunities and take ownership to drive the automation solutions.
· This role will work closely with user community and work towards adoption of cloud-based technologies.
Job Responsibilities
· Ensure the security, integrity, and performance of Production, Non-Prod, & DR (standby) Oracle databases
· Design, implement, and maintain database systems to meet business requirements
· Manage database back up, restore, recovery, update statistics, database maintenance plan
· Query optimization and performance tuning
· Respond and troubleshoot database related problems reported by customers
· Automate the routine tasks
·Database software installation, database server builds, applying patches, upgrading, configuring, troubleshooting
· Unix scripting
· Provide Rotational On-Call support
· Preparing knowledge articles and sharing with the team
· Strong communication and management skills and expertise in Onsite/Offshore team coordination
Job Qualification
· 4 years' experience administering Oracle database versions 12c, 18c, & 19c on Solaris and Linux systems.
· Routine Administrative Activities: Database statistics and tuning monitoring, monitor and report alert events, database installation and configuration, patching·
· Experience with performance tuning, capacity planning, and optimization of database environments
· Must have basic experience writing and optimizing SQL and PL/SQL
· Must have basic experience writing Linux shell scripts for maintenance and automation purposes
· Experience in database backup solutions (Oracle RMAN and Data Pump)
· Experience in database security patches
· Familiar with Oracle high availability solutions (RAC, Data Guard, MAA)
· Familiarity with cloud-based database solutions (e.g. OCI, Azure Database)
· Oracle OCP or OCM certification(s) is a plus
· Availability for on-call rotation.
· Strong organizational skills with attention to detail and the ability to manage multiple and concurrent tasks.
· Excellent communication and documentation skills