Job
Description
Provides technical leadership to design, distribution, performance, replication, security, availability, and access requirements for large and complex Oracle databases version (11g,12CDB/PDB,19c CDB/PDB and above) on (Linux Unix) operating system on on-premises, cloud-based). Works in Agile model with the understanding of Agile concepts. . Ensures database availability, scalability, observability, recoverability and resilience through backup, recovery, monitoring, optimization, etc Leads the design, implementation and maintenance of automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform. Leads the development and management of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic. Complex Root Cause Analysis (RCA) Ensures the security of the database infrastructure, including encryption, access controls and compliance with industry standards and regulations. Stays current with emerging technologies and industry trends related to database management and Architecture Subject matter expert in Database programming skills for designing and coding, optimizing and tuning the SQL and PL/SQL queries. Subject matter expert in certifying new DB versions and patches within the company s integrated Infrastructure. Subject matter expert in analyzing ServiceNow ticketing system to produce various type of reports Strong knowledge in debug the code and provide appropriate solution to developers and application team. Works closely with cross-functional teams, including developers, system administrators, network engineers, and security specialists. Education, Technical Skills Other Critical Requirement Education Bachelor s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience. Oracle Certified DBA and Cloud certification (Azure,AWS or OCI) is preferrable Experience (In Years) 14+ Years Total IT experience 10+ Years relevant experience in Oracle database Technical Skills 10+ years of related work experience on Oracle 11g,12c , Oracle 18c/19c and 21c database administrator with specific knowledge on ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security ,Active Data Guard and data pump 6 years Unix, Linux and Windows operating systems and shell scripting. Strong database analytical skills to improve application performance. Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and integrity constraints Engineering and support experience with PeopleSoft financials application databases and Goldengate replications. Strong knowledge in configuration and implementation Backup and recovery strategy as per Industry best practice using backup tools (RMAN, Data Pump, BCV and Rubrik) Expertise in database performance tuning with hands on experience on AWR, ADDM, SQLTRPT skill. Experience in Data guard configuration (DR) Must have extensive experience in Database switchover and failover. Strong Experience in Cloud computing (Azure, OCI) Data security by managing roles and privileges to User and groups. Strong knowledge in configuring and implementing data replication between complex databases using Goldengate. 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 organize tasks for self and others, prioritize and balance tasks, and lead complex projects Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders. Strong Automation skills and programming such as Python and Ansible Good experience in Database monitoring installation, configuration and monitoring using OEM and Elastic. Ability to work 24*7 rotational shift to support for production, development, and test databases Other Critical Requirements Good experience working on Cloud platforms (Azure and Cosmos DB) Strong leadership skills with the ability to manage, mentor, and inspire a team of DBAs and technical staff. Excellent communication and problem-solving skills Hands on experience in managing monitoring with Observability tools (Elastic). SME in Ticketing tools (ServiceNow and Splunk)
