Naaga Santhosh SP

Specialized in the design, analysis, and implementation of business application databases across Oracle, MS SQL, PostgreSQL, and MySQL.
Worked with complex SQL and data warehouse engineering concepts.
Focused on database migration for both homogeneous and heterogeneous migrations.
Used AWS DMS to ensure smooth transitions from on-premises to cloud platforms.

Designed and implemented a robust data model within the database according to client requirements and best practices in database normalization.
Developed stored procedures and other database objects to support key business operations and streamline data access.
Implemented a data archival solution using Azure Functions to automate transfer of data older than six months from the primary database to Azure Blob Storage.
Optimized storage costs and maintained performance.

Executed a heterogeneous database migration from SQL Server to PostgreSQL using AWS DMS.
Ensured data consistency, minimal downtime, and a seamless production cutover.
Managed end-to-end schema conversion and data validation.
Aligned the migrated structure with PostgreSQL standards and optimized performance for the target environment.
Addressed compatibility challenges between SQL Server and PostgreSQL by customizing data types, functions, and stored procedures.
Ensured smooth application integration post-migration.

Performed homogeneous database migration for three applications involving a total of 12 servers.
Ensured smooth transition with no data loss and minimal downtime.
Coordinated migration planning, execution, and post-migration validation.
Maintained application integrity and system performance throughout the process.
Collaborated with application and infrastructure teams.
Ensured proper cutover, rollback planning, and stakeholder communication.

Performed homogeneous database migration from PostgreSQL on Azure to Amazon RDS for PostgreSQL using AWS DMS.
Ensured a smooth and reliable transition with minimal downtime.
Applied data normalization techniques by identifying and organizing foreign key relationships that were not enforced via constraints in the existing schema.
Engaged with the client to validate the data model approach.
Established foreign key columns by referencing parent tables to improve data consistency and maintain referential integrity.

Conducted a comprehensive assessment as part of a Modern Data Platform workshop focused on migrating the client's existing on-premises databases to modern cloud-based architectures.
Evaluated the client's data landscape and provided recommendations for leveraging cloud-native technologies to enhance scalability, performance, and cost-efficiency.
Identified and addressed challenges related to data cleaning.
Proposed standardized approaches for consolidation, normalization, and data quality improvement as part of the modernization roadmap.