Debasish Mahatwo

Azure Database Migration Project

Throughout a recent project, I successfully managed the end-to-end migration of on-premise databases to Azure. My responsibilities included:

• Assessment: I began by performing a comprehensive inventory of on-premise databases and analyzing their compatibility for migration to Azure.
• Planning: I then selected the optimal migration strategies and tools, such as Azure Migrate and Database Migration Service (DMS), to ensure a smooth transition.
• Costing: I estimated Azure resource requirements and projected the monthly costs to provide a clear financial outlook for the project.
• Setup: I configured the target Azure environment, setting up the necessary networking, security, and database infrastructure.
• Migration: I executed the data replication and transfer from the on-premise environment to Azure, ensuring data integrity throughout the process.
• Schema Transfer: I was responsible for migrating database objects, including complex stored procedures and functions, to the new environment.
• Testing: I conducted thorough pre-migration and post-cutover performance validation to guarantee the new setup met all performance benchmarks.
• Cutover: I executed the final data synchronization and seamlessly switched applications over to the new Azure database, minimizing downtime.
• Optimization: Following the migration, I tuned the databases for performance and cost efficiency, ensuring we were getting the most out of our Azure resources.
• Documentation: I created detailed runbooks and documented the entire migration process, providing a clear reference for future maintenance and operations.

• Data Engineer
• Designed, developed, and maintained scalable ETL/ELT pipelines to ingest and process petabytes of data from diverse sources.
• Optimized database performance by refactoring complex SQL queries and tuning data models, resulting in a 30% reduction in query execution time.Built and managed data lakes and warehouses (e.g., Redshift, Snowflake, BigQuery) to support business intelligence and advanced analytics.
• Collaborated with data scientists and analysts to ensure data quality and availability for reporting and machine learning initiatives.
• Implemented data governance policies and security protocols to ensure data integrity and compliance.
• DevOps Engineer
• Engineered and managed CI/CD pipelines using tools like Jenkins, GitLab CI, or GitHub Actions to automate software builds, testing, and deployments.
• Managed infrastructure as code (IaC) with tools such as Terraform and Ansible to provision and maintain consistent, reproducible cloud environments.
• Monitored system and application performance, proactively identifying and resolving issues to ensure high availability and reliability.
• Implemented and maintained containerization technologies (Docker, Kubernetes) to streamline application deployment and scaling.
• Collaborated with development and operations teams to foster a culture of automation, reliability, and continuous improvement.

Technical Skills
Professional Experience

• Database Administration: Oracle 11g/12c/19c, RAC, Data Guard, GoldenGate, RMAN, ASM.
• Operating Systems: Linux (RHEL, OEL), AIX, Windows
• Scripting: Shell scripting (Bash/Ksh)
• Monitoring & Tools: OEM Cloud Control, AWR, shell Scripts.

Senior Oracle Database Administrator

• Managed and maintained mission-critical Oracle databases (11g/12c/19c) in a high-availability RAC (Real Application Clusters) environment, ensuring 99.99% uptime.
• Configured and administered Oracle Data Guard for disaster recovery, including monitoring redo apply rates and managing switchover and failover procedures.
• Implemented and monitored GoldenGate for real-time data replication, ensuring data consistency and low latency between production and reporting systems.
• Analyzed and resolved database performance issues using tools like AWR and ADDM. Conducted SQL query tuning and optimized database parameters to improve system efficiency.
• Developed and executed comprehensive RMAN backup and recovery strategies, performing regular restores to validate integrity and ensure data survivability.
• Managed database security, including user and role management, auditing, and implementing data encryption (TDE) to comply with corporate security policies.
• Planned and performed quarterly database patching and major version upgrades (e.g., from 12c to 19c) with minimal to zero downtime.
• Troubleshot and resolved complex database issues, including corruption, deadlocks, and connectivity problems, serving as the highest level of technical escalation.
• Automated routine tasks such as database health checks and space management using Shell scripts , OEM, improving operational efficiency.
• Provided 24/7 on-call support for critical production environments, responding to and resolving incidents promptly.

• Database Administration & Performance Tuning: I have a strong background in day-to-day database administration, including installation, configuration, and patching. My primary focus is on advanced performance tuning, utilizing tools such as AWR, ASH, and SQLT to diagnose and resolve complex performance bottlenecks at the SQL, instance, and OS levels.
• High Availability & Disaster Recovery: I specialize in implementing and managing Oracle's high-availability solutions. My experience includes the design, deployment, and administration of Oracle Real Application Clusters (RAC) and Data Guard. I am proficient in executing graceful switchovers and urgent failovers to minimize downtime and ensure business continuity.
• Oracle Cloud Infrastructure (OCI): I have hands-on experience with OCI, including migrating on-premises databases to the cloud, managing autonomous databases, and leveraging various cloud services to optimize performance and cost.
• ASM & Storage Management: I am skilled in managing and troubleshooting Oracle Automatic Storage Management (ASM) environments. This includes configuring disk groups, monitoring rebalancing operations, and ensuring data redundancy and integrity.
• Security & Compliance: I have a solid understanding of database security best practices. I have implemented and managed Oracle's security features, including Database Vault, to protect sensitive data and ensure compliance with industry regulations.
• Mentorship & Leadership: I have a track record of mentoring junior DBAs, leading small teams on projects, and acting as a subject matter expert for cross-functional teams, including developers and system administrators.

• Database Administration & Maintenance: Administer, maintain, and support Oracle standalone database instances, ensuring high availability, security, and performance. This includes managing tablespaces, data files, and storage.
• Performance Tuning & Optimization: Proactively monitor, analyze, and tune database performance using tools like AWR, ADDM, and SQLT. Identify and resolve performance bottlenecks related to SQL queries, memory, and I/O.
• Backup and Recovery: Implement and manage database backup and recovery strategies using Oracle RMAN to ensure data integrity and disaster recovery preparedness. Conduct regular restore tests to validate the process.
• Troubleshooting & Support: Provide expert-level support for database-related incidents, diagnosing and resolving issues promptly. Collaborate with application teams to troubleshoot and fix production problems.
• Patching and Upgrades: Plan and execute database patching, upgrades, and migrations to keep the environment secure and leverage new features.
• Capacity Planning: Monitor database growth and perform capacity planning to ensure sufficient resources are available for future needs.
• Security Management: Enforce database security policies by managing user accounts, roles, privileges, and auditing.
• Scripting & Automation: Develop and maintain shell scripts (e.g., ksh, bash) to automate routine DBA tasks and streamline operational processes.
• Documentation: Create and maintain detailed documentation for database configurations, operational procedures, and support runbooks.
• On-Call Support: Provide 24/7 on-call support on a rotational basis to handle critical production issues.

• Core Competencies and Technical Skills
• ServiceNow Ticketing: I have experience managing and resolving IT support tickets within the ServiceNow platform. My responsibilities include prioritizing issues, documenting all troubleshooting steps, and ensuring clear communication with end-users until resolution.
• Database Administration: I'm skilled in core Oracle database administration tasks, including user management, security, and performance monitoring. I have hands-on experience in managing different database environments, from development to production.
• Backup, Restore, and Recovery
• RMAN Backups: I routinely perform and monitor physical backups using Oracle Recovery Manager (RMAN). This includes backing up data files, control files, and archived redo logs to ensure data integrity and recoverability.
• Logical Backups: I use Oracle Data Pump (expdp/impdp) to perform logical backups and exports, which I utilize for data migration and the recovery of specific database objects.
• Disaster Recovery: I am proficient in performing database restore and recovery operations from RMAN backups. I can restore databases to a specific point in time, which is critical for disaster recovery and business continuity.
• Database Maintenance and Operations
• Database Cloning: I'm capable of performing database cloning to create replicas of production databases for development, testing, and quality assurance environments, utilizing various methods, including RMAN.
• Patching and Upgrades: I have experience applying Oracle database patches to address security vulnerabilities and bugs. I also assist with database upgrades to newer versions, ensuring a smooth and efficient transition.