Oracle Database Administrator

Job Description

Position : Oracle Database Administrator (L2) Experience : 6 Plus year Location : Noida/Pune Work Mode : Hybrid Role Description : Oracle Database Administrators (Oracle DBAs) are responsible for developing, implementing, and maintaining the company’s Oracle databases. Oracle is a widely used database management system in enterprise IT, especially for small to mid-sized businesses. DBAs follow structured policies and procedures to make sure the database is secure, reliable, and performs well. Key Responsibilities (Functional - Open Source DBA) Installations and configuration of Enterprise, Open source Databases (MySQL, MariaDB, PostgreSQL, MongoDB) on various flavors of UNIX, LINUX and Windows environments in standalone, High availability, DR databases. Experience on MySQL, MariaDB, PostGreSQL, MongoDB DB . • Should have strong knowledge on Database Upgrade, Migration, Patch Installation and Implementation. Should have knowledge on sql query tuning, database level tuning and troubleshooting long running queries. Familiarity with database design, coding, and documentation Data base optimization and enhancement of performance Cloning of Production Instance to UAT/Dev. Strong Knowledge on backup & recovery management and troubleshooting the backup issues. Strong knowledge on database and tables refresh. User Creation, User Management, granting Roles and Privileges. Regularly updating the database security protocols Basic Shell scripting . • Creating storage database structures with high-level security features Altering storage structures to meet the evolving needs of the company . • Setting up database user accounts Finding and debugging malfunctioning programs affecting the database integrity Knowledge of programming languages and API. Ability to visualize algorithmic structures Key Performance Indicators Problem determination and resolution within SLA's. High quality of all deliverables Understand complex problem solving techniques dealing with systems engineering and support Keep the Leads informed of task accomplishment, issues and status. taking ownership of issue's Continuous improvement Reduce verbal requests for support Job Types: Full-time, Permanent Pay: ₹1,700,000.00 - ₹2,300,000.00 per year Schedule: Monday to Friday Application Question(s): Experience in MySQL, MariaDB, PostGreSQL, MongoDB DB. Experience: Oracle DBA: 5 years (Required) Work Location: On the road