5/29/2023 0 Comments Aqua data studio 10![]() me have worked with infrastructure team to install and configure, DB server with instance, databases, deployed code into QA, UAT.Have ran monitoring report to get teh threshold table spaces, data files, log file etc.Used in house database tool “db2ts” for schema compare, import/export, to grant/revoke permission and T/O.Used snap shot monitor for locks, load, session etc, Have used db2pd and db2top tools for trouble shooting.Involved in database and query tuning, ran explain plan for long running queries and analyzed teh results.me have done import/export, data refresh, Monitored transaction log, table space using db2top & db2pd tools.Installed, configured, monitored and trouble shooted teh Postgress SQL database.Created Buffer Pools, Indexes, MQT, Temporary Tables, Alias, Grants (select, insert, update, delete).Generated different types of reports like user query, data analysis, performance, replication etc.,.Resolved Data base connectivity issue for Linux/Unix client and Kerberos Connectivity.Installed and configured IBM DB2 9.7/10.x and teh IBM Data Studio tool.Used Power Designer for Physical & Logical data modeling and Reverse Engineering.Working as Database Administrator for MDM(Master Data management) Project.Installed, configured and monitored teh Postgress SQL database for a separate application.Created users, groups, roles, Schema, tables, views, stored proc, triggers and other DB objects. ![]()
0 Comments
Leave a Reply. |