Roopsi Narang

Client – Audi, Dyson, Anthem, DXL, DuPont, CNHI, HCSC (Health Care Service Corporation).

• Administered MySQL versions 5.x and 8.x, PostgreSQL versions 10-14, and MongoDB versions 5.0-7.0 across Linux-based systems and cloud environments (Azure and AWS), ensuring version-specific optimization, security hardening, and high availability configurations.
• Designed and implemented robust backup and recovery strategies, safeguarding data integrity, and ensuring rapid restoration in disaster scenarios.
• Troubleshoot and resolve critical database performance and availability issues, reducing unplanned outages, and improving system reliability.
• Configured replication and clustering setups, enhancing database resilience, scalability, and fault tolerance in production environments.
• Optimized database configurations and query performance across MySQL, PostgreSQL, and MongoDB, delivering measurable improvements in response time and resource utilization in both cloud and on-prem setups.
• Streamlined day-to-day database operations by automating tasks using shell scripting, enhancing efficiency, and reducing manual overhead across cloud and on-prem setups.
• Led Root Cause Analysis (RCA) for major incidents, ensuring permanent fixes, and reducing recurrence in production environments across both cloud and on-prem.
• Collaborated with application, infrastructure, and DevOps teams to streamline data workflows, improve accessibility, and align with business needs.
• Implement security best practices, including encryption, role-based access, and auditing, to meet HIPAA and GDPR compliance.
• Promoted knowledge sharing within the DBA team through documentation, mentoring, and peer learning sessions.

Client – Eircom and CPW (Car Phone Warehouse).

Worked with the EIRCOM client as a senior database consultant for MySQL technology in Dublin, Ireland, through Tech Mahindra from August 2016 to October 2016.

• Managed MySQL v5.x and MSSQL Server databases (2000-2014), ensuring high availability, disaster recovery readiness, and minimal downtime in mission-critical environments.
• Implemented robust backup and recovery strategies, including point-in-time recovery, to guarantee data protection and business continuity.
• Configured and maintained complex replication topologies, ensuring real-time data synchronization and consistency across distributed systems.
• Led the implementation of high-availability architectures, such as failover clustering and replication, to ensure seamless database access and system reliability.
• Monitored and analyzed performance metrics, identifying resource bottlenecks, and applying targeted optimizations to enhance database throughput and stability.

Client – Diageo.

• Managed MySQL and MSSQL Server databases, ensuring optimal performance, reliability, and alignment with business requirements.
• Implemented MySQL replication strategies, improving data availability, system resilience, and recovery capabilities across environments.
• Performed regular backups, patching, and maintenance, minimizing downtime, and mitigating risks of data loss through proactive management.
• Upgraded MySQL and MSSQL instances across major and minor versions, enhancing system performance, security, and application compatibility.
• Administered database user accounts and access controls, ensuring data security and compliance with organizational policies.