Sandesh Madaik
Customer & quality focused IT operations, Solutioning and Support
Hire this person
Send a job offer directly to this candidate
About
Experienced Senior Database Administrator with expertise in Oracle Database RAC, ASM, RMAN, Golden Gate, Data Guard, and multiple database platforms (SQL Server, PostgreSQL, Couchbase, MariaDB, MongoDB). Proficient in Linux/Unix Shell scripting and AWS core services. Proven track record of infrastructure builds, business continuity, capacity planning, and cost reductions across telecommunications and banking sectors.
Experience
Senior Database Administrator at Verizon Wireless Inc (2015-10 – 2025-12)
Cost Savings, SLAs and Performance, Client satisfaction, Tech Solutioning & Support
- Executed end-to-end installation, configuration, and zero-downtime upgrades of Oracle RAC and standalone databases on Linux (12c→19c), including proactive application of 19c RU patches for enhanced security and database stability.
- Optimized ASM disk groups by adding/removing disks and rebalancing workloads, improving I/O performance and ensuring high availability for critical database systems.
- Implemented and optimized RMAN with recovery catalog and retention policies, enhanced performance by 30–45% using Block Change Tracking (BCT) and parallelized channels, and ensured recoverability through scheduled BACKUP and RESTORE VALIDATE operations.
- Performed Performance Tuning tasks using tools like AWR, ADDM, and ASH diagnostics for root-cause analysis of database and application performance issues, tuning SQL execution plans via Explain Plan, SQL Profiles, tkpprof and SQL Plan Baselines.
- Implemented, maintained, and troubleshot Oracle Data Guard replication to ensure high availability and robust disaster recovery, executing seamless switchovers and failovers during planned maintenance and Bi-annual DR drills.
- Upgraded Oracle GoldenGate (12c–19c) on Linux/Unix for real-time replication and automated gg monitoring with shell/Ansible scripts.
- Configured and managed Extract, Data Pump, and Replicat processes for high-volume transactional databases, maintaining seconds latency for critical business operations.
- Implemented Conflict Detection and Resolution (CDR) in bi-directional setups to automate data reconciliation.
- Tuned integrated capture and delivery settings (e.g., parallelism, batch processing) to handle peak transaction volumes without impacting source system performance.
- Provisioned core AWS services (EC2, S3, IAM) using least-privilege security policies.
- Deployed high-availability databases (RDS, Aurora) within secure, private VPC subnets.
- Optimized performance via CloudWatch and Performance Insights to reduce query latency.
- Handled critical production issues for Oracle, Couchbase, MariaDB, and MS SQL Server, collaborating with support and application teams; acted as solution architect for new requirements, infrastructure design, and capacity planning, while preparing and executing MOPs for maintenance, crash testing, and point-in-time recovery.
- Upgraded MS SQL Server-2008 to MS SQL Server-2016.
- Configuring and Monitoring SSIS jobs and setup alerts if threshold exceeded SLA limit.
- Implementation and monitoring of backup to NetBackup.
- Troubleshooting performance issues for long running queries and various others database performance.
Assistant Vice President - Database Services at Citigroup (2015-01 – 2015-10)
Cost Savings, SLAs and Performance, Client satisfaction, Tech Solutioning & Support
- Managed and supported multiple critical databases with 24x7 operations and minimal downtime, coordinating onsite and offshore teams to ensure uninterrupted global fund transfers across NAM, EMEA, and ASIA.
- Acted as solution architect for new and ongoing requirements, driving infrastructure design, capacity planning, and scalability for new and existing databases.
- Designed and standardized business continuity with Oracle Data Guard (physical and logical standby) for Citi's mission-critical systems.
- Implemented Flashback for rapid recovery, and developed/documented procedures for periodic database switchovers, crash testing, and point-in-time recovery exercises.
- Defined and enforced database encryption standards for Oracle (TISO compliance), while optimizing access controls, release deployments, and activity audits.
Assistant Vice President - Database Services at Citigroup (2012-09 – 2013-03)
Sr. Database Administrator at National Systems Consulting, L.P. (2013-04 – 2014-12)
Customer: Bank of America, Addison TX
- Coordinated and executed Proof of Concept for Bank of America on Exadata Half Rack in collaboration with Oracle team.
- Configured ASM disk groups and managed ASM storage to optimize database performance.
- Performed RDBMS database cloning, patching (CPU/PSU), and maintenance tasks.
- Restored and recovered databases as needed, ensuring minimal downtime and service continuity for clients.
Sr. Database Administrator at AMDOCS INC (2011-03 – 2012-09)
Customer: AT&T
Database Administrator at AMDOCS INC (2002-01 – 2010-02)
Customer: Sprint/Cingular/Metro PC
- Installed and configured Oracle Servers (9i, 10g, 11g) on AIX, SUN, HP, and Linux platforms.
- Deployed Oracle Client software and created customer-specific databases tailored to business requirements.
- Managed RMAN backups and recovery to ensure data integrity, availability, and disaster recovery.
