Job Description

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




15 years full time education