As a Systems Engineer III for Database operations:
Oracle DBA typically has a wide range of technical responsibilities revolving around managing and optimizing Oracle database 11g to 19c in Exadata; On-premises and in cloud. Here are some typical roles and responsibilities:
- Database Design and Architecture: Collaborate with architects; application developers; and stakeholders to design and implement scalable; high-performance database solutions that meet business requirements and align with organizational goals.
- Database Administration: Manage all aspects of the Oracle database along working with application teams; including fresh installation; configuration; monitoring; tuning; backup; recovery; and maintenance.
- Should be excellent in performance tuning to ensure the all the databases in the DB estate operates efficiently. Should be responsible to implement performance tuning measures such as index optimization; SQL tuning; optimize databases to enhance overall application performance.
- Database/application Monitoring database: Should be able to provide/implement monitoring solutions; using tools like OEM; Datadog
- Capacity Planning: Forecasting database growth and resource utilization to ensure that sufficient resources (storage; CPU; memory) are available to support current and future database workloads.
- Database Security: Implementing and maintaining security measures to protect sensitive data stored in databases; including user authentication; access control; and encryption.
- Backup and Recovery: Developing and maintaining backup and recovery procedures to ensure data integrity and minimize downtime in the event of hardware failures; data corruption; or other disasters.
- High Availability and Disaster Recovery: Designing and implementing high availability and disaster recovery solutions.
Should be expert in managing RAC and Dataguard.
- Patch Management and Upgrades: Expert in in Applying patches; fixes; and upgrades to address security vulnerabilities; bugs; and performance enhancements.
- Database Monitoring and Alerting: Setting up monitoring tools and alerts to proactively identify and resolve database/application issues preventing service disruptions.
- Compliance and Governance: Ensuring that databases comply with relevant industry regulations
(e.g.; GDPR; HIPAA) and internal governance policies regarding data privacy; security; and auditability.
Should be good in using OEM generate reports that required for management.
- Vendor Management: Interacting with Oracle & other vendors to stay updated on product roadmaps; licensing agreements; and support services related to database.
- Troubleshooting and Incident Response: Investigating and resolving database/application -related incidents and service outages in a timely manner; collaborating with other IT teams (e.g.; application support; network; system administration) as needed.
- Continuous Improvement: Staying current with emerging technologies; industry trends; adapt best practices database administration and recommend application teams that they align with database standards. Proactively identifying opportunities for process improvements and automation to streamline database management tasks.
Technology Skills
- Expertise in managing multiple oracle 11g;12c; & 19c databases on medium to large systems.
- Expertise in managing databases in Exadata.
- TDE; SSL; TLS and other DB securities
- Expertise Performance tuning
- Good knowledge in AWS cloud
- Very good knowledge of Linux/AIX/Windows and its related commands and shell scripting.
- Expertise in RMAN/OEM.
2
- Expertise in troubleshooting; pro-active monitoring; backup; restore/recovery; and performance tuning.
- High availability features – Oracle dataguard; RAC.
- Valuable analytical skills and team player.
- 24X7 on-call support on rotational basis.
- Having knowledge of other RDBMS & NoSQL along with automation/cloud skills will be an added advantage.
Leadership & Potential:
- Collaborate across multifunctional departments to drive forward the development and adoption of existing and new technologies to the Cloud Technology stack.
- Collaborate with a wider area or teams to drive overall enterprise design.
- Collaborate with Engineering team with clear expectations and project deliveries.
- During volatile and uncertain situations able to anticipates and overcomes obstacles with a pragmatic approach to achieve goals and commitments. While exhibiting high responsiveness by reacting quickly and positively to significant and major events
Qualifications
- Graduation/Post Graduation.
- Minimum 12-15 years of technology experience in Level 1&2 support.
Qualifications The Systems Engineering III for database ops is an individual contributor role with an expertise in
Oracle database who is responsible to maintain & support critical database systems 24x7. Experience in managing other RDBMS/SQL RDBMS DBs both in On-premises and Cloud along with automation skills.
📌 Oracle DBA (Bengaluru)
🏢 Quess Corp
📍 Bengaluru
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.