
Dhrumit K
Senior Database Engineer and Cloud Architect
Kompetenzen

Meine Dienstleistungen

Arbeitserfahrung
Senior Database Administrator (Infra Technology Specialist)
Cognizant • Vollzeit
Feb 2024 - Present • 2 yrs 7 mos
Database Administration & Cloud Architecture: I manage and support enterprise database environments across Oracle, MySQL, and Vertica in production, staging, and development. I design scalable Oracle RDS instances on AWS and deploy Oracle 19c multitenant architectures (CDB/PDB) on Azure VMs. Modern Observability & Automation: I led the migration of legacy monitoring (Yamas) to modern OpenTelemetry Collector pipelines, integrating telemetry data with OTLP exporters, Chronosphere, and Grafana. I engineer custom shell automation for database health checks, telemetry ingestion, and proactive Grafana alerting. Security & Operational Automation: I developed automated workflows for Oracle Wallet management and SSL certificate renewals to ensure secure database connectivity without manual intervention. I also enhance OpsIQ automation using Jira, Git, Confluence, and Screwdriver CI. Cross-Cloud Replication & Migrations: I execute complex cross-platform data movement using Oracle GoldenGate to replicate data from AWS RDS MySQL to OCI MySQL HeatWave. I also manage on-premises to cloud migrations. High Availability & Optimization: I implement Oracle Data Guard for disaster recovery and manage standby refresh operations. I successfully executed massive database decommissioning and host retirement projects, recovering over 278 TB of storage capacity
Senior Oracle DBA (Consultant)
Atos • Vollzeit
Apr 2017 - Feb 2024 • 6 yrs 10 mos
Enterprise Database Management: I administered a massive fleet of 700+ Oracle databases for global enterprise clients, managing versions from Oracle 19c down to legacy 8i across all environments. Large-Scale Upgrades & Migrations: I planned and executed seamless, large-scale database upgrades from Oracle 10g/11g/12c to Oracle 19c. I also performed complex database migrations from on-premises infrastructure to Azure VMs. Centralized Monitoring (OEM): I installed, configured, and managed Oracle Enterprise Manager (OEM) Cloud Control 13.5, including massive agent deployment and target discovery across the client's infrastructure. Advanced Performance Tuning: I proactively troubleshot query slowness, session locking, and critical database errors by deeply analyzing AWR, ASH, and ADDM reports, and utilizing the SQL Tuning Advisor. Backup, Recovery & Scripting: I managed comprehensive backup and recovery operations using RMAN and executed critical export/import activities via Oracle Data Pump. I also authored custom shell automation scripts for database user auditing and centralized server connectivity.