TechClub Inc · 5 hours ago
Informix Database Administration (DBMS)
Atlanta, GA
Contract
Onsite
Mid, Senior Level
4+ years expTechClub Inc is focused on database management solutions, and they are seeking an Informix Database Administrator to manage and maintain Informix database systems. The role involves ensuring high availability, performance tuning, and providing technical support for database systems.
AnalyticsArtificial Intelligence (AI)Cloud ComputingCyber SecurityInformation TechnologySoftware
Responsibilities
User, Objects and Security management as per Informix Best practices
Hands-on experience in Statistics Management
Ability to write efficient SQL & exposure to query tuning
Good at Unix commands and basic scripting
Hands-on experience using DSA
Strong debugging skills
Well versed with ticketing system/production change request/ Incident management
Exposure to backup and restore process using Veritas netBackup(TARA)/netvault/Tivoli etc
Exposed in managing/maintaining lower environments like Development/QA boxes
Manage and maintain Informix database systems, ensuring high availability and performance
Perform database tuning, optimization, and troubleshooting for Informix instances
Implement and monitor database backups, disaster recovery, and data security
Perform installations, upgrades, and patching of Informix database systems
Work with developers to optimize queries and resolve performance issues
Implement and maintain replication and clustering solutions in Informix
Provide technical support and documentation for database systems
Conduct database health checks and audits to ensure compliance with best practices
Install, configure, and maintain Informix DB clusters
Working experience as Informix Database Administrator (DBA) on Unix Platforms
Manage and support 24x7 production as well as development databases to ensure maximum availability for various applications
Incumbent should perform DBA related tasks in key areas of System Administration, Database Administration, Backup, Archive & Restore Management, Performance Management & Reporting
Perform capacity planning, performance monitoring and tuning, Strategies defined for backup/recovery techniques, and problem determination and resolution
Role involves direct interaction with customer/vendors hence good presentation and communication skill is a must
Should be a good team player and ability to mentor small groups
Monitor database performance and ensure high availability and security
Perform routine database maintenance tasks, including backups, restores, and upgrades
Troubleshoot and resolve database-related issues
Optimize and tune database performance for maximum efficiency
Implement and manage database security measures
Collaborate with development and operations teams to design and implement database solutions
Document database configurations, procedures, and policies
Stay updated with the latest developments and best practices in Informix DB and database administration
Data Replication and High Availability: Configure and manage Informix DB replication strategies to ensure data availability and durability
Implement data replication across multiple data centers and handle replication challenges, such as consistency and latency
Security and Access Control: Implement and enforce database security measures, including authentication, authorization, and encryption
Set up user roles and permissions to control access to databases and data
Regularly review and update security configurations to address emerging threats and vulnerabilities
Database Monitoring and Alerting: Set up database monitoring tools to proactively identify performance issues, errors, and anomalies
Create and configure alerts to notify relevant teams of critical database events
Respond to database alerts and take appropriate actions to resolve issues
Tuning DB parameters
Correlate related incidents together into a problem ticket and manage through the problem management process
Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records
Restoration of database
Handle DB performance related issues
Manage all Service requests through the change management process
Automate administration tasks where possible
Manage and update all Database environment documentation
Ensure DB server availability for business applications
Qualification
Required
User, Objects and Security management as per Informix Best practices
Hands-on experience in Statistics Management
Ability to write efficient SQL & exposure to query tuning
Good at Unix commands and basic scripting
Hands-on experience using DSA
Strong debugging skills
Well versed with ticketing system/production change request/ Incident management
Exposure to backup and restore process using Veritas netBackup(TARA)/netvault/Tivoli etc
Exposed in managing/maintaining lower environments like Development/QA boxes
Manage and maintain Informix database systems, ensuring high availability and performance
Perform database tuning, optimization, and troubleshooting for Informix instances
Implement and monitor database backups, disaster recovery, and data security
Perform installations, upgrades, and patching of Informix database systems
Work with developers to optimize queries and resolve performance issues
Implement and maintain replication and clustering solutions in Informix
Provide technical support and documentation for database systems
Conduct database health checks and audits to ensure compliance with best practices
Install, configure, and maintain Informix DB clusters
Working experience as Informix Database Administrator (DBA) on Unix Platforms
Manage and support 24x7 production as well as development databases to ensure maximum availability for various applications
Incumbent should perform DBA related tasks in key areas of System Administration, Database Administration, Backup, Archive & Restore Management, Performance Management & Reporting
Perform capacity planning, performance monitoring and tuning, Strategies defined for backup/recovery techniques, and problem determination and resolution
Role involves direct interaction with customer/vendors hence good presentation and communication skill is a must
Should be a good team player and ability to mentor small groups
Monitor database performance and ensure high availability and security
Perform routine database maintenance tasks, including backups, restores, and upgrades
Troubleshoot and resolve database-related issues
Optimize and tune database performance for maximum efficiency
Implement and manage database security measures
Collaborate with development and operations teams to design and implement database solutions
Document database configurations, procedures, and policies
Stay updated with the latest developments and best practices in Informix DB and database administration
Data Replication and High Availability: Configure and manage Informix DB replication strategies to ensure data availability and durability
Implement data replication across multiple data centers and handle replication challenges, such as consistency and latency
Security and Access Control: Implement and enforce database security measures, including authentication, authorization, and encryption
Set up user roles and permissions to control access to databases and data
Regularly review and update security configurations to address emerging threats and vulnerabilities
Database Monitoring and Alerting: Set up database monitoring tools to proactively identify performance issues, errors, and anomalies
Create and configure alerts to notify relevant teams of critical database events
Respond to database alerts and take appropriate actions to resolve issues
Tuning DB parameters
Correlate related incidents together into a problem ticket and manage through the problem management process
Use trend analysis to identify, detail, categorize, prioritize and create Problems Management Records
Restoration of database
Handle DB performance related issues
Manage all Service requests through the change management process
Automate administration tasks where possible
Manage and update all Database environment documentation
Ensure DB server availability for business applications
Preferred
Good-to-Have Working Knowledge of Oracle, DB2 LUW, SQL & Casandra
Company
TechClub Inc
TechClub renders avant-garde IT solutions to corporations.
201-500 employees
H1B Sponsorship
TechClub Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (25)
2024 (13)
2023 (18)
2022 (7)
2021 (4)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase