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