What are the responsibilities and job description for the Database Administrator position at Lumiere Systems?
Skills: DB2 UDB/LUW database environment, HOTS turnover plan, Data Services - Data replication, reporting, adhoc query support, data correction, CDC/IIDR change tracking
Job Description
Job Description
- 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.
