Dinesh Kumar Email & Phone Number

Leeds, England, United Kingdom

Managing Oracle, Microsoft SQL databases and Oracle Weblogic and FMW

London Area, United Kingdom

Oracle/ MS SQL server Database Administration

Chennai Area, India

ORACLE/ MS SQL Server DBA

Chennai, India

• Cloning test and development environments from production environment.• Performing routine checks of space utilization and Extended Tablespaces by resizing/adding data files when needed.• Ensure availability of database at all time and resolve database related issues and Log Sync.• Ensure potential problems such as performance degradation, reliability and security issues are addressed proactively.• Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.• Installed, upgraded and patched Oracle software and associated applications.• Estimating DB growth and providing CAPACITY PLANNING every month. • Implemented table partitioning to improve performance and data management.• Data purging activities were performed to improve the performance of the databases.• Managing database security and creating and assigning appropriate roles and privileges as required by the application developers.• Tracing the sessions which is consuming high resources during EOD report generation hours and optimizing the same.• Assisted in performing CPU & ASM Quarterly Patching of the databases.• Performed schema refresh for UAT & QA environment.• Assisted in Database patching activity without downtime in RAC Environment.• Managing the Standby databases and Resolving the logsync gap issue with Primary databases. • Analyzing the AWR report for Top resource consuming queries and taking necessary action to optimize the problematic area. • Involved in automating of DBA task through PLSQL programs, Shell scripting

Chennai, India

Bachelor Of Engineering (B.E.), Electrical And Electronics Engineering, First Class

Higher Secondary