Database Administrator (DB2 UDB/LUW)

Macpower Digital Assets Edge Private Limited

Chicago, IL

JOB DETAILS
SALARY
$55–$55 Per Hour
SKILLS
Capacity Management, Cellular Telephone, Cost Estimates, Data Description Language (DDL), Data Management, Data Recovery, Database Administration, Database Backup, Database Design, Database Management Software/Systems (DBMS), Database Optimization, Database Recovery, Database Technology, Database Triggers, Disaster Recovery, Feasibility Analysis, IBM DB2 UDB (Database 2 Universal Database), Operating Systems, Performance Analysis, Performance Tuning/Optimization, Protective Services, SQL Server Integration Services (SSIS), Software Administration, Software Development, Stored Procedures, Strategic Planning, Systems Administration/Management
LOCATION
Chicago, IL
POSTED
10 days ago
  • 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.

About the Company

M

Macpower Digital Assets Edge Private Limited