Viveka Selvaraj

Lincoln Financial Group

• Designed and implemented database solutions using MySQL, including procedures, triggers, and views, to support client requirements.
• Collaborate with software developers and system architects to optimize database designs for performance and scalability.
• Developed and maintained shell scripts for automating database‐related tasks and system administration.
• Implemented security best practices to ensure data integrity and confidentiality.
• Monitored database performance and identified opportunities for optimization.
• Troubleshooted database issues and coordinated with cross‐functional teams to resolve them in a timely manner.
• Developed PL/SQL procedures and database triggers for the validation of input data and to implement business rules.
• Created custom PL/SQL procedures to read data from flat files to dump to oracle database using SQL Loader.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Creation of database objects like tables, views, materialized views, procedures, packages using Oracle tools like SQL Loader and Extracted data from existing data stores and perform ad‐hoc queries.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. Extracting the data from simple flat text files in the operational database.
• Gathered the requirements from business users and passed on the requirements to the team.
• Knowledge of Linux or windows environments/infrastructure with application handling experience.
• Demonstrate experience in supporting and managing large number of complex multi-server, multivendor, multi-technology infrastructure.
• Working knowledge of the multiple application architecture, functionality, Autosys jobs and analyzing the issue/ error logs for issues in real time and applying the patches to fix the issue using change management.
• Proficient at time and priority management and Responsible for trouble shooting different software issues and documenting the results.

Kotak Mahindra Bank

• Worked in BFS domain, Following Pre-defined processes, and procedures of Incident Management with a good understanding of the multiple application architecture and functionality.
• Analyzing the PLSQL stored procedures and finding a solution to the application issues and Customer issues, ability to diagnose and address application issues in real-time. Analyze the Log files for troubleshooting the issues from the server and Perform backups/restores using tar, gunzip, and gzip tools and find the RCA for the issue as a technical team.
• Experienced in working with a relational database like ORACLE, MYSQL and interacting with development team for adding functionalities in database objects (stored procedures/triggers/views) and performing code review to ensure proper design and implementation of database systems.
• Create, develop, and maintain SQL processes for channel performance data warehousing and closely working with the development manager and onsite team to deliver solutions.
• Approved the releases for the version update for enhancing the Application.