Beschreibung
a) Database Software installation
b) Database System Administration
c) Performance monitoring, tuning and capacity planning
d) SQL analysis and review
e) Cross platform data transfer ( using standard DBMS utilities )
f) Data backup and recovery
g) Database performance tuning
h) Preparation and maintenance of data dictionary
i) Documentation fo database related standard, guidelines and best practices
j) Review project data models for internal standards compliance, which include naming standards, logical and physical data design concepts, avoidance of data redundancy and inconsistency, Review entities and terminology in the data model object names (table and columns) in order to avoid homonyms and synonyms. Ensure DB design best practices and normalization levels appropriate to application use, workflow, data management and performance requirements
k) Providing support for database related queries and problems
l) Create physical data structure for applications in Oracle including definition of tablespaces, devices or data sets
m) Monitoring of production environments, server fog analysis and necessary performance monitoring
n) User management, maintain and administer database users and logins for Sybase and Oracle in conjunction with Cologne application security
o) Review and research bugs and defects in DB software preemptively and as encountered in development and QA processes. Work with vendor support, acquire and apply patch or recommended solution