Skip to Main Content

Job Title


Oracle Database Administrator


Company : CitiusTech


Location : Lucknow, Uttar pradesh


Created : 2026-03-20


Job Type : Full Time


Job Description

Key Skill - Oracle, DB2, Cloud DatabasesMandatory Skill -Strong experience with Oracle 12c & 19c administrationExpertise in DB2 database managementHands on experience with cloud databases (Cosmos DB or similar)Proficiency in tablespaces, schemas, and storage managementSQL query optimization and Oracle performance tuningGood understanding of Oracle Multitenant architecture (CDB/PDB)Shell scripting (bash/ksh) for automationOn prem to cloud database migration experienceDesired Skills - Experience performing routine DBA tasks such as:Database reorganizationStatistics gatheringIndex rebuildsDB cleanup activitiesExperience creating database documentation, standards, and metadataAbility to monitor DB performance and manage parameters to ensure fast query responseExperience handling production incidents, including DB shutdown/offline operationsAbility to design or enhance database utilities and automated reportingExperience applying Oracle PSU/patch updatesCollaboration skills for working with technical, application, and operations teamsRoles and Responsibilities – Install, configure, and maintain Oracle (12c/19c), DB2, and cloud databases (e.g., Cosmos DB).Perform database upgrades, including Oracle version upgrades (12c → 19c), patching, and applying PSU/CPU updates.Manage tablespaces, schemas, storage, users, and privileges in multi tenant architectures (CDB/PDB).Conduct routine maintenance tasks such as reorganization, statistics gathering, index rebuilding, and cleanup.Monitor database performance and tune SQL queries, indexes, and system parameters for optimal response times.Ensure high availability and disaster recovery readiness through backups, restores, replication, and DR drills.Troubleshoot production database issues, including performance degradation, locking, capacity, and connectivity problems.Perform database startup/shutdown operations during planned or emergency events.Develop and maintain automation scripts using bash/ksh for housekeeping and monitoring tasks.Manage on premise to cloud database migration activities, ensuring data consistency and minimal downtime.Implement strong security controls including user access management, encryption, and audit compliance.Create and maintain database documentation, metadata definitions, standards, and operational procedures.Collaborate closely with development, application, infrastructure, and operations teams to support business needs.Build and enhance database utilities, monitoring dashboards, and automated reporting solutions.Ensure adherence to data governance standards and support audit activities as required