Oracle DBA

Role: Oracle DBA

Company Name: WillWare Technologies

Experience: 8+ Years

Work Mode: Hybrid / Full Time

Location: Bangalore

Role Summary:

The Sr DBA for database ops is an individual contributor role with 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.

Role:

As a Sr for Database operations: Oracle DBA typically has a wide range of technical responsibilities revolving around managing and optimizing Oracle database 11g ,12c, 19c to 23ai 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.
• Develop DB build process on EC2,On-Premise, RDS platforms using pipelines.
• DB migration using DB replication tools (Golden Gate, DMS)
• Should be excellent in performance tuning to ensure the all the databases in the DB estateoperates efficiently. Should be responsible to implement performance tuning measures such asindex optimization, SQL tuning, optimize databases to enhance overall application performance.
• Database/application Monitoring database: Should be able to provide/implement monitoringsolutions, using tools like OEM, Datadog. Should be able to write reports using OEM BI publisher
• Capacity Planning: Forecasting database growth and resource utilization to ensure that sufficientresources (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 ensuredata 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.
• 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. Expertise in ASM management is must
• TDE, SSL, TLS and other DB securities
• Expertise in troubleshooting, pro-active monitoring, backup, restore/recovery, and performance tuning.
• Good working knowledge in AWS cloud
• Exposure to Automation using CICD tools (Jenkins,Ansible, Terraform/python), DevOps skillset
• Very good knowledge of Linux/AIX/Windows and its related commands and shell scripting.
• Expertise in RMAN/OEM.