SAUMIK DE

• Experienced in Oracle RAC administration, RAC architecture and end to end management, RAC configuration and maintenance, ASM administration. Installed, configured, upgraded, and administered Oracle 10g, 11g, 12c, and 19c databases on Linux, Unix platforms.
• Experienced in Oracle Exadata administration including quarterly full stack Exadata patching including DB patching, Grid infrastructure patching, OS patching, Cell node patching, and IB switch patching. Coordinated with vendors in resolving hardware related issues like memory upgrades, disk replacement. Cell node, IB switch and ILOM management. Exadata health check using exachk reports.
• Expert in Oracle performance tuning using AWR, ADDM, SQL tuning advisor, Memory and segment advisors, database indexing and partitioning, table and index reorganization and defragmentation, SQL profiles and SQL baselines.
• Experienced in Oracle database cloning and refresh using advanced Oracle data pump export and import concepts, RMAN backup based and active database duplication.
• Implemented and managed high availability solution using Oracle Data Guard, data guard broker and Observer. Experienced in manual and automatic switchover and failover techniques, implementing Disaster recovery processes, and participating in numerous DR test exercises.
• Developed backup strategies using RMAN to ensure data protection and recovery. Expert in RMAN backup and restore and backup based and active database duplication using RMAN.
• Conducted regular updates and maintenance of Oracle database systems. Documented procedures and guidelines for database management practices. Automated daily DBA tasks using shell scripting and cron jobs. Created PL and SQL procedures and functions for automating day-to-day operations of the organization's systems.
• Used OEM for monitoring, diagnosing and resolving problems quickly. End to end OEM administration including installation, configuring targets, configuring metric threshold, incident rules, notification methods, OEM upgrade and patching.
• Performed trouble shooting of any issues related to Oracle Database server or applications accessing it. Troubleshooting complex issues and ORA errors. Database tuning and diagnostics. Basic Golden Gate management and patching. Oracle Audit vault basic administration.
• AWS database migration - Heterogeneous data migration
  Source: Oracle 12c on premise
  Target: Aurora PostgreSQL hosted on AWS
  Participated in daily scrum calls, requirement analysis, problem analysis and solution design done throughout project life cycle. Worked on design document creation, data migration solution design. Performed schema conversion using AWS Schema Conversion Tool (AWS SCT). Performed thorough analysis for objects that required manual intervention for Oracle to Aurora PostgreSQL format conversion and taken necessary actions. Worked closely with AWS administration team to design DMS (Data Migration Service) jobs for Full load and CDC (continuous data capture) to sync tables from Source to Target. Designed proper user privileges for CDC on both sides. Worked closely with development and testing teams to fix data anomalies caused by uncontrolled table updates on both sides and erroneous operations by designing data fix scripts. Performed all due diligence and analysis required to decide phase wise table sync deactivation as different application modules went live on AWS.
• SQL Server administration
  Installation, upgrade, Database creation, Access management, Backup and restore, maintenance jobs setup, Database cloning.
• On-site project experience:
• Deputed at client location in St Louis, Missouri, US for a leading private sector coal mining company for 2 years. Worked as Oracle and SQL Server database administrator supporting and managing SAP and Legacy database systems, worked closely with the client and carried out all DBA responsibilities including backup, recovery, patching, refresh, performance tuning, user access management, data center duty to rotate backup tapes for TSM and coordinate with offsite tape archival vendor.
• Deputed at client location in San Ramon, California, US for a leading Utilities sector company for 1 year. Worked closely with the client as senior Oracle database administrator supporting a large database environment spanning over 300 production databases and 500+ nonproduction databases hosted on multi node RAC environments on AIX servers. Managed patching and security vulnerability remediations, performance tuning for inefficient SQLs and improving database throughput, managing periodic environment wide DR exercises, automating several manual processes through shell scripts, database refreshes, database upgrade and installation, and training junior team members.
• Deputed at client location in Denver, Colorado, US for a leading Utilities sector company for 2 years (current). Worked closely with the client as senior Oracle Exadata and Database administrator supporting a large landscape of Oracle Exadata X8M systems with RAC hosting over 250+ Oracle production databases and 400+ nonproduction databases. Managed end to end backup solution using RMAN and ZDLRA (Zero data loss recovery appliance), Full stack Exadata patching, DR solutions using data guard, extensive SQL and database performance tuning, process improvements through numerous automations, supporting many projects for different applications.

· Soft skills: Excellent communication skills in English, Hindi and Bengali. Team leading capabilities, Quick learning and complex analytical abilities.

· Spearheaded SOX compliance reporting and deliverables by creating automated jobs for periodic reporting from Oracle audit vault, creating monthly and quarterly audit reports, and performing final reviews.

• Administered Oracle databases to ensure system reliability and performance. Implemented backup and recovery strategies for data protection and integrity. Monitored database performance and tuned SQL queries for efficiency. Collaborated with development teams to optimize application database interactions. Troubleshot database issues and resolved incidents to maintain service continuity.
• Trained junior staff on best practices in Oracle database administration.
• Generated periodic reports about system performance and resource utilization trends. Implemented physical database design including tablespaces, storage optimization and partitioning.
• Managed user accounts, roles and privileges in the database environment.
• Worked closely with Application teams in identifying and fixing application related issues due to access issues, data issues, firewall/network issues, inefficient SQL queries etc. Provided technical support during project implementations by troubleshooting complex production issues. Migrated databases from one platform to another using tools like export and import, data pump.
• Involved in capacity planning activities by analyzing current usage patterns and predicting future growth trends.