Job
Description
Provides technical support and resolves database-related issues for Oracle databases from version 11g to 19c (CDB/PDB and Standalone) on (Linux/AIX) Operating System. Handles daily database operations, maintenance, and troubleshooting such as DB back-up, recovery, archiving and basic performance tuning; Manages job scheduling, application release, database change and compliance. Maintains, and administers data infrastructure security policies safeguarding information, evaluating existing data infrastructure security procedures and identifying new areas of risk. Identifies and resolves problem utilizing structured tools and techniques. Working knowledge of ServiceNow ticketing system, KB articles and CMDB maintenance Working experience with Performance Tuning, physical database design, database programming, and shell scripting Limited experience with Cloud infrastructure, Elastic, Ansible, data replication and project management Education, Technical Skills & Other Critical Requirement Education bachelors degree in computer science, Information Systems, or another related field with 3+ years of IT and Infrastructure engineering work experience. Experience 3+ Years Total IT experience & 2+ Years relevant experience in Oracle database Technical Skills 2+ years of related work experience with application database implementation; knowledge of all key Oracle utilities such as SQLPLUS, RMAN, OEM, Data Pump At least 2 years of experience to work in Unix and Linux operating systems. Basic database analytical skills to improve application performance by tuning database configuration. Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and integrity constraints. Experience in data replication using Goldengate is preferred. Knowledge in Backup and recovery (Data pump, RMAN, Rubrik). Have experience performance tuning with hands on experience on AWR, ADDM, SQLTRPT skill. Experience in Data guard configuration (DR). Experience in Database switchover and failover using traditional or Flashback method. Good to have experience in Cloud computing (Azure, OCI). Data security by managing roles and privileges to User and groups. Experience in installation and configuration of OEM Agent and monitoring. Experience in working Ticketing tools (ServiceNow) Understanding of modern IT infrastructure such as Cloud Architecture as we'll as Agile DevOps Framework. Ability to work 24*7 rotational shift to support for production, development, and test databases Other Critical Requirements Basic experience in Automation tools and programming such as Shell, Python and Ansible. Monitoring the database using Elastic and Oracle Enterprise monitoring (OEM) Experience managing geographically distributed and culturally diverse workgroups with strong team management, leadership and coaching skills Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders.
