ITC Infotech
Website:
itcinfotech.com
Job details:
Senior Oracle DBA (10+ Years Experience): Please apply only if your notice period is 30 days
Job Qualifications:
- 10+ Years of experience with Computer Science or equivalent degree Preferred
- Strong knowledge of database management, data warehouse management and decision support tools
- Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
- Ability to use database access tools for application delivery
- Demonstrated ability to work independently and with others
Job Responsibilities:
- Assesses future information requirements in order to develop long-range, comprehensive database plans
- Develops policies and procedures designed to ensure the integrity of the database environment
- Develops and maintains routines to facilitate database use
- Keeps informed on latest developments in the database management field
- Plans and coordinates migration to new data management system software levels
- Assures that appropriate database management software is available and effectively used
- Understands benchmarking processes and techniques
- Determines, implements, and enhances standards on database security
- Promotes and recommends appropriate database software for new application systems
- Educates applications programmers about database concepts and efficient access techniques, and assists them in analysis and problem resolutions pertaining to database
- Performs database performance monitoring and implements efficiency improvements
- Designs or supervises the designing of the procedures necessary to save and recover databases from hardware and software failures
- Supervises the design and maintenance of database structures
- Performs related work as assigned
Technical Knowledge:
- Install, configure, upgrade, and patch Oracle databases (11g / 12c / 19c or higher).
- Manage and support hybrid database environments across on-premises data centers and cloud platforms (Azure / AWS / OCI).
- Manage production, QA, and development databases with high availability.
- Perform regular database health checks, backups, recovery, and maintenance activities.
- Monitor database performance and ensure maximum uptime.
- Administer and support Oracle RAC (Real Application Clusters) environments.
- Configure and maintain ASM (Automatic Storage Management).
- Manage Data Guard (physical & logical standby databases) for DR setup.
- Handle failover, switchover, and cluster troubleshooting.
- Optimize RAC performance and resolve interconnect/network-related issues.
- Design and manage RMAN backup and recovery strategies.
- Perform point-in-time recovery, disaster recovery testing, and restore validations.
- Implement database security measures including user access control, roles, privileges, and auditing.
- Apply quarterly security patches (CPU/PSU).
- Diagnose and resolve critical production issues within SLA.
- Perform root cause analysis (RCA) for recurring incidents.
- Troubleshoot database crashes, corruption issues, and performance degradation.
- Work closely with infrastructure teams for OS, storage, and network-related issues.
- Provide guidance on best practices for database design and coding standards.
- Support CI/CD pipelines and automation for database deployments.
- Develop scripts using Shell, Python, or SQL for automation and monitoring.
- Automate routine DBA tasks such as backups, health checks, and alerting.
- Experience with tools like OEM (Oracle Enterprise Manager) or similar monitoring tools.
- Work within SLA timelines in a 24x7 support environment.
Click on Apply to know more.