Monitoring index usages & creating, dropping, coalescing & rebuilding the indexes.
Monitoring tables for partition requirements & partitioning the tables & purging the Partitions.
Monitoring & performing database or schema or table level stats gathering.
Performing Database Tuning which involves tracking hit ratios an d database wait events & re-configuring
February 2004 - December 2010 (6 years 11 months)
Applications, Infrastructure and Systems design, development and Implementation.
Systems Review (Health checks, Capacity planning, Architecture review etc)
Use of Report Generating/Designer tool (I-net CrysterClear Designer XML).
Designing, Implementing and Administering Oracle and Microsoft SQL databases.
Read and Write complex PL/SQL queries to perform application business logic.
Tuning database and optimizing/rewrite query for better performance
Software Modification and Maintenance and generation of both User and code Documentation.
Implementation of Biometric data capturing for IPPS