DB2 LUW Database Administrator III

$85,398 - $120,437/Yr

International Game Technology - Sacramento, CA

Full-time - Mid Level

Sacramento, CA

10,001+ employees

Amusement, Gambling, and Recreation Industries

About the position

The DB2 LUW Database Administrator III role at IGT involves managing the physical database design, maintenance, and support functions across various database platforms. The position requires a solid understanding of database structures, performance optimization, and backup/recovery procedures, ensuring data accuracy and availability while establishing policies for database management. The role also includes shared on-call responsibilities in a 24/7 operational environment.

Responsibilities

• Manage all levels of physical database design, maintenance, and support functions on database platforms.
• Provide technical assistance in identifying and evaluating systems and procedures related to databases.
• Develop maintenance strategies and scripts for database applications.
• Design migration paths from older versions of DB2 to the latest releases.
• Ensure accuracy and availability of data.
• Establish policies and procedures for database management, security, maintenance, and utilization.
• Analyze database performance statistics and perform tuning activities to optimize performance.
• Understand database backup/recovery procedures and develop backup scripts.
• Recommend continuous improvements in database administration.
• Share on-call responsibilities in a 24 x 7 operation.

Requirements

• Four-year degree or equivalent education.
• 2 - 4 years of related experience in database administration.
• In-depth knowledge of SQL and database performance optimization.
• Experience with DB2, Oracle, MySQL, and SQL Server 2000.
• Experience with multiple operating system environments, including Windows 2000, Linux, and AIX.
• Experience with DB2 versions 8.1, 9, 10, and 11.
• Experience with MySQL and Oracle to DB2 migrations.
• Experience in optimizing SQL queries generated by ORM frameworks like Hibernate.
• Ability to work with customers and understand their requirements.
• Good communication skills.
• Experience working with enterprise-level systems requiring high performance and availability.

Nice-to-haves

• Experience with Ctree is a plus.
• Self-starter with personal energy and self-leadership.

Benefits

• 401(k) Savings Plan with Company contributions
• Health insurance
• Dental insurance
• Vision insurance
• Life insurance
• Accident insurance
• Disability insurance
• Tuition reimbursement
• Paid time off
• Wellness programs
• Identity theft insurance