Informix DBA

Pay Range: $55-$65/hr

1 Install, configure, and maintain Informix DB clusters.

2 Working experience as Informix Database Administrator (DBA) on Unix Platforms

3 Manage and support 24x7 production as well as development databases to ensure maximum availability for various applications

4 Incumbent should perform DBA related tasks in key areas of System Administration, Database Administration, Backup, Archive & Restore Management, Performance Management & Reporting

5 Perform capacity planning, performance monitoring and tuning, Strategies defined for backup/recovery techniques, and problem determination and resolution.

6 Role involves direct interaction with customer/vendors hence good presentation and communication skill is a must

7 Should be a good team player and ability to mentor small groups

8 Monitor database performance and ensure high availability and security.

9 Perform routine database maintenance tasks, including backups, restores, and upgrades.

10 Troubleshoot and resolve database-related issues.

11 Optimize and tune database performance for maximum efficiency.

12 Implement and manage database security measures.

13 Collaborate with development and operations teams to design and implement database solutions.

14 Document database configurations, procedures, and policies.

15 Stay updated with the latest developments and best practices in Informix DB and database administration

16 Data Replication and High Availability: Configure and manage Informix DB replication strategies to ensure data availability and durability

17 Implement data replication across multiple data centers and handle replication challenges, such as consistency and latency

18 Security and Access Control: Implement and enforce database security measures, including authentication, authorization, and encryption

19 Set up user roles and permissions to control access to databases and data

20 Regularly review and update security configurations to address emerging threats and vulnerabilities

21 Database Monitoring and Alerting: Set up database monitoring tools to proactively identify performance issues, errors, and anomalies

22 Create and configure alerts to notify relevant teams of critical database events

23 Respond to database alerts and take appropriate actions to resolve issues

24 Tuning DB parameters.

25 Correlate related incidents together into a problem ticket and manage through the problem management process.

26 Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records.

27 Restoration of database.

28 Handle DB performance related issues.

29 Manage all Service requests through the change management process.

30 Automate administration tasks where possible.

31 Manage and update all Database environment documentation.

32 Ensure DB server availability for business applications.