DB2 LUW Database Administrator III - IGT
Sacramento, CA
About the Job
DB2 LUW Database Administrator III
Location:
Sacramento, CA, US, 95834Austin, TX, US, 78754
Requisition ID: 15657
IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all channels and regulated segments, from Lotteries and Gaming Machines to Sports Betting and Digital. Leveraging a wealth of compelling content, substantial investment in innovation, player insights, operational expertise, and leading-edge technology, our solutions deliver unrivaled gaming experiences that engage players and drive growth. We have a well-established local presence and relationships with governments and regulators in more than 100 countries around the world, and create value by adhering to the highest standards of service, integrity, and responsibility. IGT has approximately 10,500 employees. For more information, please visit www.igt.com (https://c212.net/c/link/?t=0&l=en&o=3466342-1&h=1955860405&u=https%3A%2F%2Fwww.igt.com%2F&a=www.igt.com) .
Responsibilities
Candidate must live in or near Austin, TX or Sacramento, CA and have DB2 LUW experience.
Responsible for managing all levels of the physical database design, maintenance and support functions on database platforms for all types. Provides technical assistance in identifying, evaluating systems and procedures as they relate to databases.
• Have a solid understanding of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
• Develops maintenance strategy and maintenance scripts.
• Design the migration paths from older versions of DB2 to the latest releases
• Ensures accuracy and availability of data.
• Establishes policies and procedures pertaining to database management, security, maintenance and utilization.
• Analyzes database performance statistics and performs required tuning activities to optimize database performance.
• Understands database backup/recovery procedures and develops backup scripts.
• Recommends continuous improvement in database administration.
• Shared on-call responsibilities in 24 x 7 operation.
Qualifications
Minimum Education:
• Four-year degree, or equivalent.
Years of Experience:
• 2 - 4 years of related experience Skills:
• In-depth knowledge of SQL and database performance optimization.
• Experience with DB2 first and foremost, Oracle, MySQL and SQL Server 2000.
• OBA experience in multiple operating system environments, to include Windows 2000, Linux, and AIX. Other
• Experience with DB2 8.1, 9, 10, 11.
• Experience with MySql
• Experience with Oracle to DB2 migrations
• Experience with Ctree is a plus
• Experience in optimizing SQL queries generated by ORM frameworks like hibernate
• Self-starter
• Ability to work with Customers and understand their requirements
• Good communicator
• Experience working with Enterprise level systems requiring high levels of performance and availability
• Experience working with local and remote DB recoveries
Keys to Success
• Building collaborative relationships
• Decision making
• Drive results
• Foster innovation
• Personal energy
• Self-leadership
#LI-JM1
_IGT is committed to sustaining a workforce that reflects the diversity of the global customers and communities we serve, creating a fair and inclusive culture that enables all our employees to feel valued, respected and engaged. IGT is an equal opportunity employer. We provide equal opportunities without regard to sex, race, color, religion, age, national origin or ancestry, disability, veteran status, sexual orientation, genetic information, gender identity or expression, and any other personal attributes protected by federal, state, or other laws. We thank all applicants for applying; however, only those selected to interview will be contacted._
_At IGT, we consider a wide range of factors in determining compensation, including background, skills, experience, and work location. These factors can cause your compensation to vary. The estimated starting compensation range is $85,398 - $120,437. The actual pay offered may end up being higher or lower. The Company will comply with all local pay requirements and collective bargaining agreements, where applicable._
_Base pay is only one part of our Total Rewards program. Sales roles may be eligible for commission payments, while other roles are eligible for discretionary bonuses . In addition, we offer employees a 401(k) Savings Plan with Company contributions, health, dental, and vision insurance, life, accident, and disability insurance, tuition reimbursement, paid time off, wellness programs, and identity theft insurance. Note: programs are subject to eligibility requirements._
_IGT (NYSE: IGT) is the global leader in gaming. For more information, please visit_ _www.igt.com_ _._
Location:
Sacramento, CA, US, 95834Austin, TX, US, 78754
Requisition ID: 15657
IGT (NYSE:IGT) is a global leader in gaming. We deliver entertaining and responsible gaming experiences for players across all channels and regulated segments, from Lotteries and Gaming Machines to Sports Betting and Digital. Leveraging a wealth of compelling content, substantial investment in innovation, player insights, operational expertise, and leading-edge technology, our solutions deliver unrivaled gaming experiences that engage players and drive growth. We have a well-established local presence and relationships with governments and regulators in more than 100 countries around the world, and create value by adhering to the highest standards of service, integrity, and responsibility. IGT has approximately 10,500 employees. For more information, please visit www.igt.com (https://c212.net/c/link/?t=0&l=en&o=3466342-1&h=1955860405&u=https%3A%2F%2Fwww.igt.com%2F&a=www.igt.com) .
Responsibilities
Candidate must live in or near Austin, TX or Sacramento, CA and have DB2 LUW experience.
Responsible for managing all levels of the physical database design, maintenance and support functions on database platforms for all types. Provides technical assistance in identifying, evaluating systems and procedures as they relate to databases.
• Have a solid understanding of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
• Develops maintenance strategy and maintenance scripts.
• Design the migration paths from older versions of DB2 to the latest releases
• Ensures accuracy and availability of data.
• Establishes policies and procedures pertaining to database management, security, maintenance and utilization.
• Analyzes database performance statistics and performs required tuning activities to optimize database performance.
• Understands database backup/recovery procedures and develops backup scripts.
• Recommends continuous improvement in database administration.
• Shared on-call responsibilities in 24 x 7 operation.
Qualifications
Minimum Education:
• Four-year degree, or equivalent.
Years of Experience:
• 2 - 4 years of related experience Skills:
• In-depth knowledge of SQL and database performance optimization.
• Experience with DB2 first and foremost, Oracle, MySQL and SQL Server 2000.
• OBA experience in multiple operating system environments, to include Windows 2000, Linux, and AIX. Other
• Experience with DB2 8.1, 9, 10, 11.
• Experience with MySql
• Experience with Oracle to DB2 migrations
• Experience with Ctree is a plus
• Experience in optimizing SQL queries generated by ORM frameworks like hibernate
• Self-starter
• Ability to work with Customers and understand their requirements
• Good communicator
• Experience working with Enterprise level systems requiring high levels of performance and availability
• Experience working with local and remote DB recoveries
Keys to Success
• Building collaborative relationships
• Decision making
• Drive results
• Foster innovation
• Personal energy
• Self-leadership
#LI-JM1
_IGT is committed to sustaining a workforce that reflects the diversity of the global customers and communities we serve, creating a fair and inclusive culture that enables all our employees to feel valued, respected and engaged. IGT is an equal opportunity employer. We provide equal opportunities without regard to sex, race, color, religion, age, national origin or ancestry, disability, veteran status, sexual orientation, genetic information, gender identity or expression, and any other personal attributes protected by federal, state, or other laws. We thank all applicants for applying; however, only those selected to interview will be contacted._
_At IGT, we consider a wide range of factors in determining compensation, including background, skills, experience, and work location. These factors can cause your compensation to vary. The estimated starting compensation range is $85,398 - $120,437. The actual pay offered may end up being higher or lower. The Company will comply with all local pay requirements and collective bargaining agreements, where applicable._
_Base pay is only one part of our Total Rewards program. Sales roles may be eligible for commission payments, while other roles are eligible for discretionary bonuses . In addition, we offer employees a 401(k) Savings Plan with Company contributions, health, dental, and vision insurance, life, accident, and disability insurance, tuition reimbursement, paid time off, wellness programs, and identity theft insurance. Note: programs are subject to eligibility requirements._
_IGT (NYSE: IGT) is the global leader in gaming. For more information, please visit_ _www.igt.com_ _._
Source : IGT