Experience

Eagle Software India Pvt Ltd.

• 1 - 100 Employee

• DBA

  • Mar 2010 - Present

  • Installation and configuration of SQL DATABASE SERVER for Windows. • Creating Primary Database storage structures (table space, data files) and objects like Tables, Indexes, and Profiles. • Managing the physical and logical objects of the database. • Rebuilding the indexes, analyzing tables and Schemas for better performance. • Identifying Chained Rows and rectifying them. • Enrolling new users and maintaining system security (Profiles), Roles, System and Object Privileges and managing user quotas. • Monitoring the unwanted User Session and killing them if needed. • Monitor physical and logical backup strategies. • Monitoring the Database growth. • Monitoring database and collecting statistics by using EXPLAIN PLAN, SQL Trace. • Using TKPROF, STATSPACK to find ways to improve the database’s performance. • Creation of Clone database for the test database environment using RMAN. • Logical Backup of Databases using Export and Import Utility as well as using Data pump. • Data file Consistency using DB Verify. • Using SQL Loader utility load the data into oracle database from external files. • Experience in implementation and maintaining Physical Standby. Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases. • Conduct knowledge transfer within the team and help team members in understanding the client business and existing systems Provided 24x7 on-call technical supports. Show less