santhosh kumar R P

Administrator in design and development of configuration management application for client on boarding system in oracle database. Identity Verification, application would ensure compliance with Know Your Customer (KYC).

checks to ensure compliance with various regulations, such as verifying the client's eligibility to open an account, assessing risk levels, and conducting politically exposed person (PEP) screenings, Document Management, Workflow and Approval Processes, Communication and Updates.

• Restructured database into new format which eliminated data tautology resulting 165 million rows shrunk to 2 million in one entity.
• Abridged entire size of database from 140 GB to 12 GB .
• Prepared and presented reports, analysis and presentations to various stakeholders including executives.
• Designed best practices to support continuous process automation for data ingestion and data pipeline workflows.
• Tuned database queries to improve performance by 40%
• Migrated databases from on-premise to cloud, providing high availability and scalability.
• empowered Database by integrating with Q-rep a replication utility which replicates data from Mainframe system DB 2 to oracle distributed .
• Accented over all best practices in database scripting and query writing from development to production across team .
• Collaborated with data scientists to develop machine learning models by providing the necessary data infrastructure and preprocessing tools.

Database architect in building banking products in BFSI sector specialized in Loan ordination product and credit card application processing systems . in Debt Management/Collection system.

• Database Sizing/backup plan/Suggesting Optimization Parameters
  Move to live plan and approach preparations and delivery date tracking.
• Provided DBA support level of L2 for Oracle 11G.Maintaining all instances are up and running, look for alert logs, verifying rollback segments contention, identify bad growth projections, Space-bound objects, Harmful growth rates, Tuning in I/O and network bandwidth.
• Work involved day-to-day database administration tasks including direct support of end-users, optimizing database, application performance, managing database activities.
• Security maintenance and housekeeping activities relative to system usage, disk space, memory utilization, CPU activity
  Implemented database refresh using full export.
• Used EXPORT/IMPORT to do table level and full database de fragmentation.
• Carefully monitoring and suggesting to designing rollback segments sizes, after carefully estimating the sizes.
  Implemented table partitioning to improve performance and data management.
• De fragmentation of tables and indexes for improved performance and effective space management.
  Database server tuning.
• Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
• Designed process and database tables.