SyManSys Technologies India Pvt. Ltd.
Website:
symansys.com
Job details:
Role: Senior Informix Database Administrator
No. of positions: 3
Experience: 8-10+ years
Mode: Hybrid
Location: Hyderabad, Mumbai, Gurgaon, Bengaluru, Kolkata, Pune, and Chennai Duration:
Shift Details:
The roles will follow rotational shifts.
• 7:00 AM - 2:00 PM
• 2:00 PM - 11:00 PM
• 11:00 PM 7:00 AM
Job Summary
We are looking for a Senior Informix DBA to oversee our mission-critical data infrastructure. In this role, you will lead the architecture, performance tuning, and lifecycle management of large-scale IBM Informix Dynamic Server (IDS) environments. You will be responsible for ensuring 24/7 database availability, designing robust disaster recovery plans, and guiding our transition to modern, cloud- enabled Informix platforms.
Key Responsibilities
1. Architecture & Migration: Lead large-scale modernization projects, including migrations from legacy versions (9.x, 10.x, 11.x) or XPS to the latest Informix 14.10.
2. High Availability & Replication: Design and manage complex HA topologies using HDR (High Availability Data Replication), RSS (Remote Secondary Server), SDS (Shared Disk Secondary), and Enterprise Replication (ER).
3. Modern Monitoring: Deploy and configure InformixHQ for centralized, web- based monitoring, alerting, and performance visualization.
4. Performance Tuning: Perform deep-dive optimization using onstat, oncheck, and SMI tables. Optimize complex SQL queries, stored procedures, and Stored Procedure Language (SPL).
5. Backup & Recovery: Implement automated backup strategies using onbar or ontape, including direct-to-cloud backups (e.g., Amazon S3).
6. Advanced Features: Manage innovative data types such as TimeSeries and Spatial Data, and leverage Storage Optimization (data compression) for resource efficiency.
7. Security: Enforce strict security standards, including TLS/SSL encryption, Role-Based Access Control (RBAC), and audit logging to the system log (ASL).
8. Automation: Utilize Python and Shell Scripting (Bash/Korn) to automate routine maintenance, such as space management and catalog cleanups. www.twotwolbbs.com cyan@twotwo1bbs.com Putting a thinking cap on sales
Required Qualifications
• Experience: 8-10+ years of professional DBA experience, with a heavy focus on Informix IDS in production Linux/Unix environments.
• Technical Skills: • Expertise in Informix 14.10 internals, memory management, and disk architecture (chunks, dB spaces).
• Strong proficiency in Linux/Unix administration and kernel parameter tuning for Informix.
• In-depth knowledge of Connection Manager (CM) for workload balancing.
• DBA with strong expertise in Informix architecture and database administration.
• Hands-on experience with backup and restore of database objects.
• Proficient with Informix utilities/tools: on stat, on tape/on bar, dB export, dB import.
• Strong working knowledge of Unix commands and shell scripting.
• Familiarity with PuTTY, Nagios, Grafana, and LPAR2RRD tool
• Proven experience with replication and migration of servers/boxes across environments
• Education: Bachelors or Master’s degree in Computer Science or a related field.
Preferred Certifications & Skills
• BM Certified System Administrator – Informix.
• Experience with Docker/OpenShift for containerized Informix deployments.
• Familiarity with NoSQL/JSON support via MongoDB drivers in Informix.
- • Cross-database experience with Db2 or Oracle is a plus for hybrid environments.
Click on Apply to know more.