Requirements
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 -
Bachelors 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)."
Bachelors degree in CS/IT or related field. 7 years Informix DBA experience in enterprise environments. Strong knowledge of Informix architecture replication partitioning and scaling. Expertise in performance tuning HA/DR backup & recovery. Proficiency in scripting (REXX Python Shell JCL). Experience with monitoring tools (Dynatrace Azure Monitor Nagios). Knowledge of automation tools (Ansible Terraform). Experience supporting cloud DB environments (Azure/GCP). Strong troubleshooting documentation and communication skills