Job
Description
Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex Oracle databases from version (11g,12c,19c and 21c (CDB/PDB and Standalone) on (Linux/AIX) Operating System. Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance; Makes use of advanced database features such as partitioning, advanced compression, multitenant architecture, etc. Design, implement and maintain automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform. Develop and manage of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic.Provides technical advice and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance. Troubleshoot and resolve, in conjunction with Operational/Customer DBAs, database application issues across production, test and development environments Customer-facing position and may require interaction with senior customer leadership on matters concerning design, engineering, or functional areas Identifies and resolves problem utilizing structured tools and techniques. Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards. Participates in a 24X7 pager rotation, providing Subject Matter Expert support to the on-call DBA as needed Identify, participate and resolve complex Root Cause Analysis (RCA) Maintains, and administers data infrastructure security policies safeguarding information, evaluating existing data infrastructure security procedures and identifying new areas of risk. Extensive knowledge of ServiceNow ticketing system. KB article creation and maintenance, and CMDB maintenance 7+ years of experience with Performance Tuning, physical database design, database programming skills, and shell scripting Working experience with Cloud infrastructure, Elastic, Ansible, data replication and project management Working knowledge of other database technology such as UDB, Informix, PostgreSQL or MSSQL preferred 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. Experience (In Years) 10+ Years Total IT experience & 7+ Years relevant experience in Oracle database Technical Skills 7+ years of related work experience on Oracle 11g,12c, Oracle 19c 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 3 year s 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. Should have 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) (Active 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 well 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 Should have 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 OCP 12c/19c, Azure and OCI cloud certification preferable. Should have Project management experience for creating and delivering Business solutions. Demonstrate ability to work independently and in a team environment
