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 educationSummary 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
