Sr. Database Administrator-Oracle/ SQL Server

Company: H&R Block
Location: Kansas City
Posted on: January 14, 2021

Job Description:

What you'll do... JOB SUMMARY Provides technical expertise in the planning, design, implementation, and maintenance of database management systems (DBMSs) that support H&R Block business applications. Install and maintain DBMS software. In addition provide day-to-day monitoring, optimizing, database maintenance, and developer support. Develop backup and recovery procedures both from an application view point as well as disaster recovery. Assists other DBAs with database security requirements. JOB DUTIES

• Reviews and understands data models and ensures those models are mapped effectively and efficiently into physical data models that take advantage of the characteristics of the specific database management system (DBMS).
• Manages the storage requirements for database. Monitor space usage and develop thresholds to signal a need to increase space.
• Monitors application databases to optimize database performance and resource usage. Maintains development, test, and production DBMS environments.
• Monitors and maintains database security and database software, in cooperation with data security administrators.
• Provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
• Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.
• Creates procedures and maintains various database related documents.
• Serves as the primary or backup on-call DBA for assigned projects, may provide 24 hour on-call support.
• Improves current DBMS knowledge with respect to relevant state-of-the-art technology, equipment, and/or systems.
• Provides SQL tuning and performance statistics feedback to development teams.
• Provides utilities and reports to application teams to assist in system and performance monitoring. This includes but is not limited to space utilization, key/index usage, and memory usage reports. Pay range for this position is $95,800.00 to $143,500.00 salary. This information is posted pursuant to the Colorado Equal Pay for Equal Work Act to provide Colorado applicants with information about what they might be eligible to receive. Individual pay decisions will depend on job-related factors such as experience, education, skill, performance, and geographic location where work will be performed. Successful candidates may be able to participate in one or more incentive compensation or short-term incentive plans, which could generate additional earnings in accordance with the terms of each plan. H&R Block offers competitive medical, prescription drug, dental and vision benefits for regular associates and/or their eligible dependents. Eligible associates can also participate in the H&R Block Retirement Savings Plan (401(k) Plan), Employee Stock Purchase Program, Employee Assistance Program, Tuition Assistance Program, (virtual) fitness center programs, associate discount program, flexible spending and health savings accounts, and a variety of wellness programs. Associates also receive Tax Prep benefits, paid time off benefits, Life Insurance, AD&D coverage, Short Term Disability and Business Travel Accident Insurance coverage. About H&R Block... We're here to live our purpose to provide help and inspire confidence in our clients and communities everywhere. We take our work personally, because we know what it represents: Families and homes. Livelihoods and lives. We've been true to that purpose since brothers Henry and Richard Bloch founded our company in 1955. Since then, we've grown to approximately 12,000 tax offices throughout the United States and around the world. When you join our team, you'll add to the momentum of a forward-thinking company one that defined an industry and is now leading its transformation. It would be even better if you also had... Skills with Mongodb and/or Cosmodb strongly desired. #KR-LI1 What you'll bring to the team... JOB REQUIREMENTS • Bachelor's degree in Computer Science or related field or the equivalent through a combination of education and work experience *Five (5) years minimum IT experience.. • Four (4) years DBA experience with Relational Database Management Systems (Microsoft SQL Server, Oracle) including database planning, implementation, tuning, troubleshooting and maintenance. • Four (4) years experience with industry standard operating systems (UNIX, MS Window, Linux). • Hands-on SQL Server 2005 administration, database tuning and troubleshooting experience. • Must have strong knowledge of all the standard SQL Server tools. • Strong understanding of database structures, theories, principles, and practices. • Must have strong SQL, T-SQL, and SSIS package skills. • Effective oral, written and interpersonal communication skills. • Teamwork skills • Developer skills #hrbjob #LI-KR1

Keywords: H&R Block, Kansas City , Sr. Database Administrator-Oracle/ SQL Server, IT / Software / Systems , Kansas City, Kansas