Supriya Sargar

Technology Lead @Infosys

NJ, US

Lead and oversee the successful migration of database objects fromSybase to Oracle, ensuring minimal disruption to business operations.• Analyze and document the existing Sybase database schema, objectdependencies, and code logic to ensure smooth migration and conversionto Oracle.• Collaborate with developers, DBAs, and system architects to ensure thatdata migration is accurate and complete.• Identify Sybase-specific features (like stored procedures, indexing) thatneed to be rewritten for Oracle compatibility.• Optimize Oracle queries for performance using advanced techniques suchas query rewriting, indexing, partitioning, and leveraging Oracle-specificfeatures.• Perform thorough testing and validation of converted queries to ensurecorrectness and efficiency.• Proactively monitor and address performance issues in Oracle databases,focusing on improving response times, query execution.• Identify and resolve performance bottlenecks in the databasearchitecture, such as slow-running queries, inefficient indexing.• Design and implement efficient data models and schema structures forOracle databases, incorporating normalization, denormalization, andindexing strategies as needed.• Conduct code reviews and enforce best practices for database design,ensuring high-quality, maintainable code.• Monitor Oracle database performance regularly and resolve performance-related issues as part of a proactive incident management process.• Develop and implement performance benchmarks, tuning guidelines, andbest practices tailored for banking applications and high transactionvolumes.• Create and maintain a centralized, reusable procedure for handlingexceptions across various database operations. Ensure that exceptions arelogged in a consistent format with necessary details.

Vidyalankar Institute Of Technology

BE - Bachelor of Engineering