Deepak Ranjan Mohapatra

• Enterprise Database Operations : Manage Oracle, PostgreSQL, MySQL, and Redis databases supporting mission-critical telecom and government systems with 24/7 availability.
• Performance Optimization : Conduct advanced performance tuning using AWR, ASH, query optimization, and capacity planning to support high-volume transactional workloads.
• High Availability & DR : Implement and maintain RAC, Data Guard, replication, PITR, and failover strategies to ensure business continuity and disaster recovery readiness.
• Cloud Database Management : Lead AWS RDS and EC2-based database operations, including provisioning, monitoring, backup automation, and cost optimization.
• DevOps Integration : Embed database health checks and validation processes into CI/CD pipelines using Jenkins and Git to improve release stability.
• Automation & Scripting : Develop Shell and Python scripts to automate monitoring, replication checks, failover testing, and routine DBA tasks, reducing manual effort by 50%.
• Security & Compliance : Enforce database security hardening, access controls, auditing, and compliance aligned with MOI and organizational cybersecurity standards.
• Incident & Stakeholder Management : Resolve production incidents through ITSM processes, perform RCA, and collaborate with cross-functional teams to minimize downtime.

AWS & DEVOPS PROJECT EXPERIENCE AWS RDS
Migration Project - Oracle to AWS RDS

• Cloud Migration Planning : Led end-to-end migration of on-premise Oracle 12c databases to AWS RDS, defining migration strategy, timelines, and risk mitigation plans.
• Data Migration Execution : Performed database migration using Oracle Data Pump and RMAN, ensuring data integrity, minimal downtime, and controlled cutover.
• High Availability Architecture : Implemented Multi-AZ RDS deployment, automated backups, and retention policies to meet RTO and RPO requirements.
• Monitoring & Automation : Configured AWS CloudWatch alarms, logging, and automated backup verification to enable proactive monitoring and operational visibility.
• Cost & Performance Optimization : Optimized instance sizing, storage, and backup configurations, achieving improved performance and approximately 25% reduction in operational costs.

• Data Architecture Design : Designed enterprise-level conceptual, logical, and physical data models supporting analytics, reporting, and system integrations.
• Database Lifecycle Management : Led cloning, refresh, migration, and environment synchronization using RMAN, Data Pump, and cross-platform methods.
• ETL & Data Governance : Managed ETL pipelines, data lineage, metadata management, and governance frameworks ensuring data integrity and consistency.
• Change & Release Control : Executed controlled schema changes and database releases across development, QA, and production environments.
• Security & Compliance Oversight : Implemented database auditing, access governance, and compliance controls aligned with internal and government regulations.
• Cross-Functional Collaboration : Worked closely with application, analytics, and infrastructure teams to align data platforms with business requirements.
• Performance & Scalability Planning : Supported database scalability, storage planning, and optimization for large distributed systems.
• Technical Leadership : Provided technical guidance, documentation, and best practices to DBA and development teams across multiple projects.

• Database Installation & Configuration : Installed and configured Oracle 11g and 12c databases including RAC clusters and high-availability environments.
• Backup & Recovery Operations : Managed RMAN-based backup strategies, cloning, and recovery to ensure data protection and operational stability.
• Performance Tuning : Conducted performance analysis using AWR, Statspack, and SQL tuning techniques to improve system responsiveness.
• Patching & Upgrades : Performed database patching, upgrades, and maintenance with minimal impact on production systems.
• User & Security Management : Administered database users, roles, privileges, and audit trails in line with security policies.
• Monitoring & Troubleshooting : Monitored database health, resolved incidents, and supported production issues in a high-demand enterprise environment.
• Documentation & Reporting : Maintained operational documentation, backup reports, and compliance records.
• Operational Support : Collaborated with infrastructure and application teams to ensure stable and reliable database services.

• Database Monitoring : Performed daily monitoring of database logs, listener services, and standby synchronization activities.
• Backup Execution : Supported schema-level and full database backups using Data Pump and Export/Import utilities.
• User Administration : Managed user account creation, access provisioning, and privilege assignments under supervision.
• Operational Support : Assisted senior DBAs with routine maintenance, health checks, and issue resolution.
• Log & Storage Management : Monitored alert logs, archive logs, and tablespace utilization to prevent outages.
• Documentation Support : Maintained backup records, operational checklists, and standard operating procedures.
• Incident Assistance : Supported troubleshooting activities during database incidents and recovery exercises.
• Learning & Compliance : Gained hands-on exposure to enterprise database operations, security practices, and IT service delivery models.