B.Tech(Information technology) Adhiparasakthi Engg College
Summary
Over 9.8 years of experience in IT, main area of experience in the Database Design, Development & Support of Oracle 10, 11g,12c and MS-QL 2008 R2, 2012,2014,2016, Netezza for Production/development.
Good working experience and design knowledge in OLTP, OLAP Databases using Star schema and Snowflake schema concepts.
Experienced in Creation of Primary Database storage structures (Table Space with data files) and objects like Tables, Indexes, Stored Procedures, Packages, Triggers (Compound Triggers) and Functions etc.
Oracle10g/11g & SQL Server 2008/12 – Performed database server installation in both Windows and Linux OS server (Using GUI/Silent Mode Method).
Writing Shell scripts in Linux server to Schedule Auto database backup and dump file transfer process using CRONTAB.
Replication Configuration (Transaction, Snapshot, Merge) in MSSQL 2008/2012.
Database Mirroring Configuration.
Experience in Database Recovery Model Concepts.
Worked on Database High Availability Concepts (Clustering).
Worked on Database Multi Instance environment.
Good Knowledge on Database/SQL Scripts Performance Tuning and Query Optimization Concepts.
Responsible for index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases at regular intervals for better performance.
Good working knowledge of Collections concepts in PL/SQL programs.
Good Working experience to create Partitions for improving performance in large tables (List, Hash, Range and Compound).
Expertise to implement Exception handling Process in PL/SQL programs.
Good Working & Configuration Knowledge of Oracle and SQL Server.
Experienced in Life Sciences - Enterprise Management (Revenue Management and Revenue Recognition).