About Me

I worked on different environments and different versions of DB2. I have worked for four clients in my 5.5 years of experience. Im the trainer for Linux and DB2 SQL in our organization for the new recruited batches. Installation of DB2 product on Lin...ux and DB2 SQL in our organization for the new recruited batches. Installation of DB2 product on Linux/windows platforms and connecting through client to server. Expertise on fix-pack installation. Have experience in Upgrading DB2 product. Performed systems analysis, wrote a requirement, and a project plan for this effort. Handled the Database backup and recovery. Experienced on Incremental backup and restore. Implemented redirect restores in all production, test and dev environments. Implemented shell scripts for DB backups. Written shell scripts for database maintenance. Maintaining system storage according to the DB usage. Creating tablespaces, bufferpools and have good knowledge on managing them. Experienced in working with large tablespaces, processing and maintenance of partitioned tablespaces. Have good knowledge on Unix commands Experienced on Shell Scripting. Written shell scripts to automate the daily backups, image checking, space checking, and to restore a database. Developed and maintained shell scripts to improve and attend to the teams needs. Knowledge on creating reports and ER Model using ERWin Data Modeler Tool. Have basic knowledge on Replication. Implementation of High Availability Disaster Recovery. Successfully implemented read-only standby using HADR. Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, EXPLAIN, DB2 catalog queries), data movement and organization (IMPORT, EXPORT, db2move, db2look, LOAD, REORG), etc. Can recognize the problem using db2diag log. Have hands on experience on db2pd, db2top. Log file management. Monitored Top Ten Longest Running SQL and tuned the reoccurring SQL. Have knowledge on SQL & PL/SQL, T-SQL. Written Triggers, Procedures and Functions for a development project. Prepared detailed improvement plans of problem records and their resolutions. Voluntarily assumed additional responsibilities to facilitate installation of a new application. Solved many issues in our organization. Have hands on experience on Log Shipping. Query Optimization. Written complex queries for the application teams Worked on db2gcf tool which is used to check the status of Instance running state. Worked on db2dart and relocate db commands. Have knowledge on SQL Server Administration. Can install and configure SQL Server product. Have knowledge on SQL Server data export and import. Experience in SQL Server backup and restore in SQL Server. Managing logins, roles, users and user permissions in SQL Server. Experience in log shipping and mirroring in SQL Server. Have knowledge on Clustering. Have knowledge on blocking. Have knowledge on Python scripting, such as datatypes, modules, functions etc..