Navinkumar Selvarajan

About Navinkumar Selvarajan

Having professional experience in SQL, PL/SQL and Data migration Developments- Played a role in Design, Development, Maintenance & Support in Banking, Finance & Retail Domains- Designing conceptual, logical, and physical data models to ensure the database meets business needs and scalability- Good experience in SQL Query writing, optimization and handling high volumes of data- Experience & Knowledge in Creation & Modification of all the Complex database objects in Oracle- Knowledge & Experience in UNIX Commands, Shell scripting & Unix Environments- Extensive in Delivering technology, Innovation & Solutions to clients in finance and other domains- Quickly diagnose and resolve database-related issues, working closely with development teams to maintain application stability and uptime- Implementing data backup strategies and ensuring recovery procedures are in place to prevent data loss.Key competencies- Oracle Data Pump (Export/Import): Expertise in using Oracle Data Pump for high-performance data export and import operations.Proficient in performing data migration, backup, and recovery tasks using Data Pump Export (expdp) and Data Pump Import (impdp) utilities- DBMS Parallel Execute: Expertise in using DBMS_PARALLEL_EXECUTE for parallel execution of SQL statements to enhance performance for large data manipulations- DBMS Scheduler: Experience with the DBMS Scheduler package for automating database tasks and jobs, such as backups, data transfers, and reporting. Knowledge of handling complex scheduling scenarios with dependencies, time-based triggers, and execution intervals- Development Activities: Delivering an easy use, Innovative, Advanced Technological and bug free code to Client- Prod Support Activities: Root causes Analysis, Recreate the issue, Debugging the code, Impact Analysis, DAT Fix, Code Fix & Logical Fix- DB Testing Activities: Sanity check, Functional testing, Regression testing, E2E testing & System Testing.Skills worked: Oracle SQL, PL/SQL, PostgreSQL & Unix.Optimization Techniques: Query tuning, BulkCollect, Table partition, Gather stats, Table Reorg, AWR report, Explain plan, Hint based.Prod Support: Data patches, Analysis, DAT Fix, Recreate issue, Debugging, Root cause, Code Fix & Logical Fix.Documentation: Negative testing,Test cases,BRD, Implementation plan, Code check list, Integrated implementation plan & Integration Release plan.Tools used: SQL Developer, PostgreSQL, TOAD, Git, Jira, Confluence, PVCS & SVN.Always adaptive to learn new technologies and explore something new.

Experience

1. Senior Software Engineer

   Iris Software Inc.

   Sep 2022 — Present · Noida, IN

   Data migration

Education

• Sethu Institute of Technology

  B.E MECHANICAL ENGINEERING

  2013 — 2017