Database Administrator

Project Role : Database Administrator

Project Role Description : Design, implement and maintain databases. Install database management systems (DMBS). Develop procedures for day-to-day maintenance and problem resolution.

Must have skills : Oracle Database Administration (DBA)

Good to have skills : NA

Minimum 5 Year(s) Of Experience Is Required

Educational Qualification : 15 years full time education

Summary As a Database Administrator, you will administer, develop, test, or demonstrate databases. Perform many related database functions across multi-customers, including designing, implementing and maintaining new databases, backup/recovery and configuration management. Install database management systems (DBMS) and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance. Roles & Responsibilities Database Administration and Support:

• Handle all P1, P2, P3, and P4 incidents, changes, and service requests related to Oracle Database administration, ensuring prompt and efficient resolution within SLAs.
• Manage day-to-day database operations, including backup/restore, health checks, performance tuning, and resource optimization.
• Proactively monitor database systems using tools like Zabbix, CheckMK, or Extended Events, ensuring optimal performance and uptime.
• Implement and manage high availability (HA) and disaster recovery (DR) solutions such as Always On Availability Groups, clustering, replication, and log shipping.
• Perform Oracle Database upgrades, patching, migrations, and configuration changes with minimal disruption to business operations. Technical Expertise and Problem Solving:
• Troubleshoot and resolve complex database issues, collaborating with other senior team members or SMEs when necessary.
• Perform root cause analysis for recurring incidents and propose preventive measures to avoid future occurrences.
• Optimize database performance by identifying and addressing bottlenecks, inefficient queries, or hardware limitations.
• Utilize automation tools, SQL, and Shell scripts to reduce manual interventions and streamline repetitive tasks. Customer Interaction and Coordination:
• Act as the first point of contact for all Oracle Database-related issues allocated to your team, ensuring professional and timely communication with customers.
• Collaborate with the SME/Team Manager for escalations, providing detailed analysis and proposed resolutions.
• Provide guidance to customers on best practices, database strategies, and technical solutions when needed. Mentorship and Collaboration:
• Assist junior DBAs in resolving complex tickets, enhancing their troubleshooting skills, and providing technical guidance.
• Share knowledge with peers and juniors through training sessions, documentation, or informal mentoring.
• Coordinate effectively with other DBAs, SMEs, and Team Managers to ensure seamless operations across shifts and teams. Process Adherence and Reporting:
• Follow established processes, including ITIL-based incident, change, and problem management workflows, to maintain service quality.
• Maintain and update documentation for assigned tasks, incidents, and solutions for future reference and audits.
• Regularly review and contribute to process improvements and knowledge-sharing initiatives. Continuous Learning and Development:
• Stay updated on emerging Oracle Database technologies, tools, and best practices to enhance technical expertise.
• Participate in training, certifications, and workshops to remain proficient in Oracle Database administration. Professional & Technical Skills
• Must to have skills: Proficiency in High Availability (HA) and Disaster Recovery (DR) solutions for Oracle Database. Solid experience in performance tuning and query optimization, including troubleshooting and resolving database performance issues.
• Communication Skills: Strong verbal and written communication skills, with the ability to collaborate effectively within teams and with stakeholders.
• Work Tenure: A consistent career track record, with an average of at least 2 years spent in each previous organization.
• Work Flexibility: Willingness to work in a 24x7 environment as needed, adapting to rotational shifts.
• Escalation Handling and Customer Interaction: Experience in managing escalations and interacting directly with customers to resolve issues and ensure client satisfaction.
• Strong understanding of multi-geographic support environments, effectively addressing diverse customer needs while ensuring consistent, high-quality database support.
• Expertise in Oracle Database, with proficiency in high availability (HA) and disaster recovery (DR) solutions such as datagaurad and RAC.
• Proficient in Oracle Database performance optimization and tuning to ensure optimal database performance and responsiveness for critical systems.
• Skilled in planning and executing Oracle Database upgrades and migrations, minimizing downtime and ensuring seamless transitions.
• Proficient in Oracle database patching-standalone and RAC.
• Proficient in SQL or Shell scripting for automation and task optimization.
• Familiarity with cloud technologies for database-related components, with a preference for hands-on experience.
• Proficient in SQL or Shell scripting for automation and task optimization.
• Experience managing and supporting Oracle Database, ensuring reliable analytics and reporting functionalities.
• Strong troubleshooting skills on Unix/Windows platforms.
• In-depth knowledge of backup and recovery processes, ensuring data integrity and availability in critical situations.
• Good understanding of ITIL processes, ensuring structured incident management, change control, and service delivery.
• Demonstrate strong customer handling skills, with the ability to interact directly with clients, understand their requirements, and contribute to delivering tailored database solutions and strategic recommendations. Additional Information
• High level of acceptance and flexibility to accept change and requirement according to industry demand.
• Should be enthusiastic to learn new technologies and enhance troubleshooting skills.
• The candidate should have a minimum of 6+ years of experience in Oracle Database Administration (DBA)
• This position is based at our Gurugram office
• A 15 years full time education is required