Title: Technical Specialist-Cloud & Infra Engg
About Birlasoft
Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run businesses with unmatched efficiency and innovation. As part of the CK Birla Group, a multibillion-dollar enterprise, we boast a 12,500+ professional team committed to upholding the Group's 162-year legacy. Our core values prioritize Diversity, Equity, and Inclusion (DEI) initiatives, along with Corporate Sustainable Responsibility (CSR) activities, demonstrating our dedication to building inclusive and sustainable communities. Join us in shaping a future where technology seamlessly aligns with purpose.
Area(s) of responsibility
- Implementation and management of multitenant databases.
- Database Backup and Recovery.
Creating and scheduling RMAN backups, deciding relevant backup strategies.
Database recovery including point in time recovery.
- Database restoration/refresh
- Database Upgrade and Patching.
- Database Performance Tuning.
This includes query optimization, database initialization parameter tuning, reading and analyzing AWR, ASH and ADDM reports.
- Database Maintenance
Database indexing, Statistics gathering, De-fragmentation, Corruption detection and repairing.
- Oracle Data Guard implementation, management and administration.
Creation of Physical standby and monitoring of archivelog synchronization between Primary and Standby.
Archivelog gap resolution.
- Database Storage Management like tablespace/datafile resizing
- Database monitoring, availability and Disaster Recovery Management.
- Oracle Datapump activities.
- Collaboration with product developers, vendors and users to solve database issues.
Essential job tasks
- Oracle DBA with minimum 4 years of hands-on experience on Production and Non-Production environments. This role demands troubleshooting database/query level performance issues and provide relevant guidance/ solutions.
- Basic knowledge of SQL.
- Capacity planning
- Storage management
- Strong technical knowledge of Operating Systems like Windows, Linux etc.
- Awareness on Database best practices.
- Database job scheduling through Windows task scheduler.
- Available to support for weekend database activities.
- Willingness to provide extended support, if required.
- Keen to learn and adopt new database technologies like Mongo, MSSQL, MySQL etc.