Krishnakumar

Technical Lead- Database
placeholder
Location Chennai
view-icon
Total Views51
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 10 Year
  • Cost
    Hourly Rate$30
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnMay 18, 2022
Key Skills
DatabaseOracleMS-SQLPython
Education
2006-2010

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).
Copyright : 2022 – OnBenchMark All Right Reserved.