Prerna Ahuja

As an Oracle and MS SQL Server DBA with over 4 years of experience, I have a strong understanding of database architecture, administration, and optimization. I have experience in managing both Oracle and MS SQL Server databases and have expertise in installation, configuration, backup and recovery, performance tuning, and troubleshooting. Proven expertise in high-availability solutions, including SQL Server AlwaysON, database mirroring, and disaster recovery strategies.

Adept at handling complex AWS database migrations, including cross-region projects, ensuring seamless transitions with minimal downtime. Strong track record of delivering secure, scalable, and high-performing database solutions that support business-critical applications.

Senior Database Analyst at HCL TECH PRIVATE LIMITED (2022-01 – Present)

• Coordinated closely with business teams and external stakeholders to align database solutions with organizational needs.
• Created and maintained database backups, ensuring reliable recovery during data loss incidents.
• Monitored and optimized database performance, proactively identifying and resolving bottlenecks.
• Developed automated scripts to maintain database consistency and accuracy.
• Migrated databases from on-premises to cloud (AWS), enabling high availability and scalability.
• Ensured database integrity through robust data validation checks.
• Designed and implemented disaster recovery plans to guarantee data availability during outages.
• Administered Oracle RAC 11g R2 and Oracle 12c databases.
• Executed Oracle 12c upgrade activities with minimal downtime and full data integrity.
• Performed database creation, space management, and storage optimization.
• Managed users, roles, object privileges, and schema-level access for production databases.
• Creation and maintenance of Tablespace, Expdp/Impdp of schema.
• Supervised proper maintenance of production databases and continuously improved system performance.
• AWS console management, including monitoring resource utilization, database, and system performance.
• Performed backup and restore operations on MS SQL Server (AWS RDS & EC2).
• Uploaded dump files into S3 buckets (RDS).

B.Tech in Computer Science – BHAGAT PHOOL SINGH MAHILA VISHWAVIDYALAYA, GOVERNMENT UNIVERSITY (2018-01 – 2022-12)