Database Administrator

 About The Role  

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
SummaryAs 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 & ResponsibilitiesDatabase 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 FlexibilityWillingness 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 Qualification 15 years full time education