Sharmila S

Senior database administrator specializing in cloud database migration and administration, with 9+ years in oracle[9i,10g,11g,12c,19c] 4 years in PostgreSQL [12,13,15] on azure and aws. successfully led oracle-to-oracle lift-and-shift method migration in azure, oracle-to-postgresql migrations to azure paas — for enterprise clients such as Apollo hospital, Basf, Chevron, and Microsoft. oracle-to-postgresql migrations to azure paas and implemented automated high-availability architecture (patroni, etcd). Automated backup and recovery, and performance tuning across Linux. Mentoring junior dbas while ensuring compliance, security, and zero-disruption operations.

Technical Lead Oracle DBA / PostgreSQL DBA - NEUREALM TECHNOLOGIES PVT LTD - Chennai

(2024-03 - 2026-04)

• Lead dba operations for production oracle & PostgreSQL databases supporting Healthcare, Telecommunication, Banking production systems.
• Excellent experience in handling 24/7 Production Database Support & Maintenance environment.
• Contributed to successful audits, ensuring full compliance with data governance and regulatory requirements.
• Database cloning – used to create/refresh development and test databases from production backups –using RMAN as well as exp/imp and data pump.
• Conducted yearly dr-drill tests (fail-over/switch over) using dg broker.
• Created and optimized automated scripts for routine maintenance for improving workflow efficiency using shell script
• Proposed enhancements aimed at streamlining monitoring processes and minimizing administrative tasks.
• Managed, monitored, and maintained Active Data Guard on 10g/11g/12c databases to ensure zero data loss.
• Performed Switchover and Failover operations to test and ensure high availability of Oracle databases.
• Used Dataguard broker to monitor Dataguard configuration.
• Created detailed technical and functional documentation to outline database intentions and requirements effectively. and detailing operational procedures and system logs.
• Engineered Oracle RDS instances within AWS environment.
• Executed minor version upgrades in AWS Oracle RDS across UAT and production environments.
• Facilitated schema refresh from production to test environments on AWS RDS Oracle and ensured data integrity and consistency.
• Utilized monitoring tools like SolarWinds, Dynatrace to track CPU utilization trends and communicated findings to application team.
• Managed the implementation of quarterly patches, ensuring timely updates and compliance with security protocols.
• Established server setup to enhance operational capabilities in new environment.

Technical Lead Oracle DBA / PostgreSQL DBA - SOFTEON PVT LIMITED - Chennai

(2022-12 - 2024-02)

• Have Migrated Oracle database from on-prem to Azure and provisioned the environment using terraform scripts in azure. [Lift and shift method].
• Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
• Coordinate the migration plan with application teams with change process.
• Decommissioning of the database
• Apply PSU patches on databases using Opatch utility.
• Upgrade oracle database from 11.2.0.4 to 12.1.0.2 or 12.2.0.2.
• Configured PostgreSQL databases and established user accounts to support efficient data management.
• Established and optimized Patroni configuration with etcd across production and development servers to support robust database operations.
• Communicated effectively with key stakeholders regarding database changes or improvements that affected their responsibilities within the organization.
• Conducted regular assessments of system health to detect and resolve issues proactively.
• Setting up recommended parameters in postgresql.conf, controlling access using pg_hba.conf.
• Conducted systematic vacuuming and archiving of PostgreSQL databases to enhance system efficiency and reliability.
• Used pg_stat_statment for native query tuning to arrest performance issues.
• Administered, Monitored the databases using Dynatrace, and solar winds.
• Engaged with customers and external partners [Microsoft] to facilitate DBA operations.

Technical Lead Oracle DBA / PostgreSQL DBA - WIPRO LIMITED, EDOC AND DU - Chennai

(2021-08 - 2022-11)

Technical Lead Oracle DBA / PostgreSQL DBA - TECH MAHINDRA LIMITED, CHENNAI - Chennai

(2016-07 - 2021-08)

Technical Lead Oracle DBA / PostgreSQL DBA - INDIA PROPERTY ONLINE PRIVATE LIMITED - Chennai

(2013-12 - 2016-07)

Technical Lead Oracle DBA / PostgreSQL DBA - POLARIS FINANCIAL TECHNOLOGIES - Chennai

(2011-07 - 2013-12)

MCA - Fatima College/Madurai Kamaraj university, Madurai (2006 - 2009)

BSc - Physics - Fatima College/Madurai Kamaraj university, Madurai (2003 - 2006)