Blog

Hello
Hope you are doing well.

 

 

Role Description:               
Experience: 8+ Years
Essential Skills and Role:
•    Responsibility for constructing and/or optimizing physical database designs tailored for the DB2 UDB/LUW database environment in support of various strategic application development initiatives (database/table/object/index/view/trigger/package/procedure etc.)
•    Supporting application development timelines by reviewing and assisting in the implementation of designs and/or incremental changes to database definitions.
•    Design & development Services – Physical database design and creation, partitioning, capacity planning, DDL creation update etc., view design and creation, stored procedure, trigger and query coding and tuning
•    Data Services – Data replication, reporting, adhoc query support, data correction, CDC/IIDR change tracking
•    Performance and Tuning Services – Performance Profile baseline, database tuning, index reviews, query tuning.
•    Data backup & management services – Backup requirements, backup plan, recovery plan, disaster recovery backup plan, data archiving & purge, utilities and SSIS support, reorganization strategy and maintenance plan
•    Database and OS Upgrade Services – Transition to different DBMS or operating system, support upgrade-related issues per application
•    Security Services – Non-standard Security role setup
•    HOTS turnover plan
•    Database connectivity support activities
•    Undertaking the planning and carrying out of system upgrade initiatives and database recovery actions as required and generally contributing toward the overall online availability goals of the organization.
•    Perform feasibility studies and cost estimates in response to user requests.
•    Query performance monitoring, tuning and recommendation.
•    Position requires the individual to carry a cell phone and be available at all times.

Thanks & Regards
KumaraSwamy
iTech US, Inc 
Email is the best way to reach me.