Data Administrator

POSTION SUMMARY & KEY AREAS OF RESPONSIBILITY:

Ownership of assigned critical implementation/production events and providing technical analysis and insight into the current condition and recommended solution. Participating in the subsequent analysis to determine the source of the issue and a recommended plan to avoid it in the future. Analysis of key customer service and implementation issues.

• Installation, configuration and upgrading database software and tools.
• Understands all current features and evaluate new platform features and determine strategy for the application of new features
• Establish and maintain sound backup and recovery policies and procedures. Create, plan and test scenarios
• Implement and maintain database security policies.
• Perform database tuning and performance monitoring
  • Performance analysis (physical database tuning, reorganizations, optimization, optimal hardware environment, capacity planning).
• Setup and maintain documentation and standards.
• Verify/Review project plans and scope of production upgrades, application releases and implementations.
• Create and implement maintenance plans for releases and upgrades.
• Execute physical database changes required by applications
  • Add space to tables and tablespaces.
  • Add or modify rollback segments, undo retention, etc.
  • Add or modify datafiles - increase or decrease to change size of the database, relocate.
  • Add, modify, and/or remove databases objects (tablespaces, tables, storage procedures), users roles and profiles.
• Monitoring - performance, process log, troubleshoot database related issues.
• Maintain database support scripts.
  • Scripts - develop and maintain database startup, shutdown, backup scripts.
  • Plus, develop and maintain database or system specific scripts such as load, clone, standby, purge, report, etc.
• Maintain documentation on production database environments.
• Maintain Database Platform Application Processes
  • Such as Concurrent Manager, Oracle Application Users, replication etc .
• Solves complex performance issues
• Owns the long term vision and evolution of the production database environment, and translates the database architect’s strategic direction, into the strategy for their domain