Software Dev. Sr. Advisor
Dell International Services India Pvt Ltd
Total years of experience :17 years, 9 Months
o As a Dev. Lead, responsible for handling 6 Members Team.
o Providing Technical and functional support/training to the team members.
o Handling Performance Tuning issues with SQL and PL/SQL.
o Analysis and review of BRD's and SRS's, Designing, Developing, Coding, CRQ Fixing, Enhancements and writing TDS for the same.
o Designing database objects like tables and indexes with partitions to handle and access huge data into a database.
o Managing Database space constraints using archive tables and compress tables.
o Coding includes writing PL/SQL Packages, Functions, Procedures and Triggers, and scripts in Oracle 11g.
o Writing batch scripts into Control-M to process data from flat files.
o Monitoring Control-M jobs and Oracle Golden Gate ER Replication from upstream DB’s.
o As a Technical Lead, responsible for handling 4 Members Team.
o Providing Technical and functional support to the team members.
o Handling Performance Tuning issues with SQL and PL/SQL.
o Analysis of BRD's and FRD's, Designing, Developing, Coding, Bug Fixing, Enhancements and writing technical documents for the same.
o Coding includes writing PL/SQL Packages, Functions, Procedures and Triggers, and scripts in Oracle 11g/10g/9i.
o Creating and designing a database object which includes Tables, Indexes, Views, Synonyms, and Sequences.
o Designing and developing forms and reports based on the requirement.
o Troubleshooting the functional setups along with the Oracle Tech Support.
o Handling Interface, Info center and Migration related issues.
o Writing SQL*Loader control scripts to stage data into staging tables from flat files.