Database Administrator II

$69,000 - $109,417/Yr

International Game Technology - Austin, TX

posted 2 months ago

Full-time - Mid Level
Austin, TX
10,001+ employees
Amusement, Gambling, and Recreation Industries

About the position

As a Database Administrator II at IGT, you will play a crucial role in managing the physical database design, maintenance, and support functions across various database platforms. This position requires a solid understanding of data dictionaries, database structures, and the installation, upgrading, and management of database applications. You will be responsible for developing maintenance strategies and scripts, ensuring the accuracy and availability of data, and establishing policies and procedures related to database management, security, and utilization. In this role, you will analyze database performance statistics and perform necessary tuning activities to optimize performance. You will also be involved in understanding database backup and recovery procedures, developing backup scripts, and recommending continuous improvements in database administration practices. Additionally, you will share on-call responsibilities in a 24/7 operational environment, ensuring that database systems are always available and performing optimally. The ideal candidate will have experience with various database systems, including DB2, Oracle, MySQL, and SQL Server, and will be comfortable working in multiple operating system environments such as Windows, Linux, and AIX. You will need to be a self-starter with strong communication skills, capable of working with customers to understand their requirements and deliver effective database solutions.

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 within the database systems.
  • Establish policies and procedures for database management, security, maintenance, and utilization.
  • Analyze database performance statistics and perform tuning activities to optimize performance.
  • Understand and develop database backup and recovery procedures, including backup scripts.
  • Recommend continuous improvements in database administration practices.
  • Share on-call responsibilities in a 24/7 operational environment.

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 DB2 versions 8.1, 9, 10, and 11.
  • Experience with Oracle to DB2 migrations.
  • Experience with Ctree is a plus.
  • 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.
  • Experience with local and remote database recoveries.

Nice-to-haves

  • Experience with multiple operating system environments, including Windows 2000, Linux, and AIX.
  • Self-starter attitude and ability to work independently.

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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service