The DBA will be responsible for infrastructure support of our Client s Informix v.11 Databases. Responsibilities include support of multiple mission critical retail applications providing performance tuning, enforcement of standards, support to high availability database replication, documentation, capacity planning & trending analysis, backup/recovery, and 24x7 production on-call support.
Must haves include:
- Korn Shell Scripting
- Performance Tuning
- Application DBA ( Dev and Support)
Assist team of Informix DBAs in leading technology challenges and the support of high number of production and lower lifecycle Informix Instances
Assist Informix DBAs in hardware capacity planning and database upgrades
Provide Informix database administration/management and apply performance tuning techniques.
Provide technical troubleshooting for applications and database systems with emphasis on root cause analysis
Write and maintain documentation describing changes and architecture modifications to all systems and databases
Perform exports, backups and data extracts as required
Implement application related DML and DDL in production environment following Change Management guidelines
Participate in the researching solutions to various business and technical problems, evaluate alternatives and provide recommendations/justifications to management
Manage database related projects, design, implement and support moderate to large sized databases with minimal supervision.
Define and implement database backup/recovery and security strategies as well as other monitoring activities.
Partner with developers and Data Modelers to create database structures for business applications for all life cycles.
Provide advanced Informix v.11 performance tuning and troubleshooting.
Provide on-call support for assigned databases 24x7.