iSeries DB2 DBA

ID 1011143

Overview:

Our Client is Global leader in IT services, digital and business solutions that partners with its client to simplify, strengthen and transform their businesses. Our Client has been recognised by Brand Finance as one of the Big 4 Global ITServices Brands, is looking for a iSeries DB2 DBA for project in Miami, Florida, below is the detail requirement.

Responsibilities:

• Bachelor’s degree in Computer Science or Information Technology, or equivalent Database Administration experience preferred.
• 3-8 years minimum experience required as iSeries Database Administrator
• Experience with database, query and system performance tuning
• Create, configure and maintain all databases required for production and non-production usage.
• Perform code migration, database change management and data management through the various stages of the development life cycle
• Setup alerts and monitor critical database processes and health
• Setup, configure, and fix failed jobs and take corrective action to issues
• Ensure backups are setup and running successfully
• Implement and test database backup and recovery plans to avoid/prevent data loss
• Respond and complete service requests and incidents within SLAs
• Perform period health check of systems and document chronic issues for follow-up and remediation when needed with level 3 support
• Perform environment refresh or clones as needed
• Patch management and version control of 3rd party products
• Perform database re-organizations as required to assist performance and ensure maximum uptime of the database as well as ongoing tuning and performance monitoring.
• Assists with impact and root analysis.
• Troubleshoots with problems regarding the databases, applications and development tools.
• Ensure that storage, archiving, back-up and recovery procedures are functioning correctly
• Work as part of a team and provide 7×24 support when required
• Implement and maintain database security, including user provisioning where applicable
• Performs other duties as required. This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.

• Troubleshooting skills for application/system performance problems by utilizing tools like IBM iDoctor, Performance Navigator, DBMON Trace is preferred
• Hands on experience with iSeries Navigator, Turnover, SoftMenu a plus
• A good working knowledge of structured query language (SQL), Command Language (CL), RPG ILE
• Good working knowledge, understanding and experience in all phases of database administration, including: configuration, physical and logical database design, security, troubleshooting, and managing backup and recovery plans.
• A good understanding with High Availability and Disaster Recovery strategies
• A good understanding with replication such as Mimix, IBM InfoSphere CDC
• A good working knowledge with monitoring tools
• A good knowledge of security management and database integrity
• Ability to handle multiple projects and deadlines
• Strong interpersonal and communications skills.
• Good technical documentation and writing skills
• Excellent presentation skills for both technical and non-technical audiences.

Qualification:

• Bachelor’s degree or equivalent, with minimum of 2 to 4 years as a iSeries DB2 DBA .
• Demonstrate excellent communication skills including the ability to effectively communicate with internal and external customers.
• Ability to use strong industry knowledge to relate to customer needs and dissolve customer concerns and high level of focus and attention to detail.
• Strong work ethic with good time management with ability to work with diverse teams and lead meetings.