Oracle Database Administrator

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 ehancement 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 Type: Full-time

Pay: ₹324,559.94 - ₹1,131,225.42 per year

Benefits:

• Work from home

Work Location: In person