Database Administrator II

Summary

Join Experian as an aide to both the IT Infrastructure and Development teams, supporting existing systems 24x7 and administering DB2LUW environments on AIX and LINUX. Provide support for High availability systems (HADR), large RDBMS partitioned (DPF) database environments on-prem and Cloud.

Requirements

• Bachelor's degree in Computer Science or related field or equivalent
• 4 years of experience working as a DBA
• Knowledge supporting DB2LUW databases. HADR and DPF are beneficial
• Familiarity of large RDBMS systems including DB2LUW partitioned (DPF) database implementations
• Experience in review of Access Plans with the dba team and developers to make recommendations
• Familiarity with multiple data movement utilities
• Working knowledge of any Cloud Environment (AWS, Azure, GCP)
• Understand tablespace types, utilization, and management
• Shell or other scripting skills
• Practical experience monitoring databases with teammates to tune and provide a high availability service
• Knowledge of federated databases is beneficial
• Receptive to change
• Knowledge sharing and creation of knowledge articles
• Teamwork and collaboration soft skills
• Strong strategic process and procedure methodology with attention to maintaining robust audit controls
• Ability to work within different cultural environments
• Ability to work within multi-lingual environments

Responsibilities

• Support DB2LUW Databases V11.5 and MongoDb environments
• Support multiple Development, UAT, and Production environments
• Support high availability environments using HADR, Q-Replication, Attunity, or other software
• Perform database software installs, patching, upgrades, execute utilities, and assist in tablespace management
• Perform change control requests (code deployments)
• Monitor database performance and trouble-shoot log utilization, locking conditions, and poorly performing SQL
• Participate in SQL access plan analysis
• Monitor and tune DB2 databases (V11.5) and MongoDB
• Handling user requests is a given
• Participate in on-call 24X7 support of production systems on a rotation basis with other team members
• Ensure high Database availability in collaboration with the team
• Ensure alignment with current IT standards and controls

Benefits

• Medical, life and dental insurance
• Asociacion Solidarista
• International Share Save Plan
• Flex Work/Work from home
• Paid time off
• Annual Performance Bonus
• Education Reimbursement
• Family Bonding
• Bereavement Leave
• Referral Program