Job Title: Informix DBA
Timing: General Shift
Locations: (Hyderabad, TG/ Bengaluru, KA/ Mumbai, MH/Pune, MH/Gurugram, HR/ Chennai, TN or Kolkata, WB)
Mode of work: Hybrid model - 2 to 3 days of coming to work.
Years of Experience: 8+ years of experience
Job Type: C2H
Notice Period: Immediate joiner - 30 days only
Job Description:
Role Overview -
We are looking for an experienced Senior Informix DBA having atleast 7+ years of experience to join our team, providing round-the-clock (24x7x365) database administration and operational support for enterprise Informix database environments. The ideal candidate will have a strong track record in troubleshooting, performance tuning, and database operations of Informix on on-premise environments.
Key Responsibilities -
- Provide 24x7 production support for Informix databases by participating in rotational shifts and on-call duties.
- Administer, monitor, and maintain Informix databases in production and non-production environments.
- Implement and manage backup, recovery, tuning, high availability (HDR, ER, replication) and DR (Disaster Recovery) strategies.
- Perform routine health checks, proactively identify performance bottlenecks, and optimize queries and database configurations.
- Automate routine operations and reporting using mainframe utilities, scripting languages, or job scheduling tools (JCL, REXX, Python, Shell etc.).
- Manage database security, user permissions, and compliance with organizational policies.
- Coordinate and execute database patching, upgrades, and migrations with minimal downtime.
- Collaborate with application and infrastructure teams to support deployment activities and resolve database-related issues.
- Monitor and resolve incidents, including root cause analysis and documentation of resolutions.
- Automate routine operational tasks using scripts or management tools.
- Maintain accurate documentation of database procedures, configurations, and support processes for internal knowledge sharing.
Required Skills and Experience -
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 7+ years of hands-on experience as a DBA managing Informix database environments
- In-depth knowledge of Informix DB architecture, scaling, global distribution, partitioning, consistency models, and throughput management.
- Strong scripting and database troubleshooting skills.
- Proactively analyze and optimize database performancetuning queries, indexes, and configurations.
- Enforce security best practices, including authentication, access control, data encryption, and compliance monitoring
- Proficiency with mainframe utilities, JCL, scripting (REXX, Python, Shell or other), and automation tools.
- Support cloud database deployments, migrations, and upgrades within Azure and GCP environments,
- Automate and optimize routine operational tasks using scripting (Python, shell scripting, IaC etc) and Azure automation tools.
- Deep knowledge of high availability (HA), replication, backup/recovery, and failover strategies for Informix.
- Experience with database monitoring tools - Dynatrace, Azure Monitor, Nagios etc and automation frameworks such as Ansible and Terraform .
- Solid understanding of database security best practices.
- Proven experience with patching, upgrading, and migrating databases.
- Ability to manage multiple priorities in a fast-paced operations setting.
- Ability to support DB audit requirements and license management.
- Excellent communication and documentation skills.
Preferred Qualifications -
- CExposure to Informix integration with other databases (DB2, Oracle, SQL Server) or migration projects.
- Experience supporting modernization or migration projects (mainframe to distributed/cloud platforms).
- Exposure to cloud-based database services (Azure, GCP etc).
- Experience with automation tools (e.g., PowerShell, Ansible, Terraform, Shell, Perl scripting).
