DB2 Mainframe Database Administrator Specialist

Company: TSYS
Location: Columbus
Posted on: February 16, 2020

Job Description:

Every day, the people of TSYS-- and Netspend-- improve lives and businesses around the globe through payments. We make it possible for millions of people to move money between buyers and sellers using our payments solutions including credit, debit, prepaid and merchant services. We are "People-Centered Payments", and our team has the unique opportunity to help create a world in which payments make people's lives easier and better. This is both a tremendous honor and an important responsibility for those who accept the challenge. If you are looking to make a valuable difference for people everywhere - and for yourself - we may have the right place for you.Summary of This RolePlans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system.What Part Will You Play?Coordinates and performs testing of database software, utilities and fixes within a test (sandbox) environment prior to production roll out and review testing results to make a Go/No-Go recommendation. Assists less experienced Database Administrators (DBAs) with issue resolution during testing. Coordinates the migration of tested/approved software, utilities, and fixes to the production environment. Develops with various database configurations by creating database objects per specified business requirements and the necessary sandbox environments and assist by interpreting business requirements and advising less experienced DBAs. Works in close liaison with application developers, identifying potential impacts and provide insightful guidance/issues resolution to ensure best practices are applied to mitigate potential impacts to the various user groups and/or other database configurations. Coaches/mentors less experienced DBAs as they begin to perform routine/basic database administration tasks.Ensures the proper scheduling of database back-up tasks and the completion of scheduled tasks. Coordinates database recovery tasks during a disaster recovery and/or disaster recovery exercise and ensure compliance with Service Level Agreements (SLAs) recovery requirements.Monitors current usage levels of database storage, identify and analyze growth trends and forecast future storage requirements based on analysis results. Develops recommendations for long-term capacity plans taking into account hardware lifecycles, current and scheduled project requirements. Oversees and performs routine maintenance such as data compression and defragmentation (online reorg).Monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provide comprehensive recommendations for corrective actions. Applies routine and non-routine database tuning and optimization techniques, such as rebuilding indexes, determine when and create additional indexes and perform in-depth reviews of queries to maintain database performance. Performs and reviews database statistic reporting on a regularly scheduled basis and provide recommendations to improve performance and maintain the high availability of the supported database(s).Liaises with the Applications Team while performing troubleshooting to determine the source of application failures. Acts as a point of escalation for unresolved or complex failures. Recommends and develops solutions to minimize the potential of future application failures and assists in the implementation.Produces and reviews operational database documentation, such as DB2 Disaster Recovery, DB2 Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.Provides training and familiarization to less experienced DBAs regarding company policies and procedures, techniques and current server/database configurations.What Are We Looking For in This Role?Minimum QualificationsBachelor's DegreeRelevant Experience or Degree in: No degree specifiedTypically Minimum 6 Years Relevant ExpInstallation, customization, testing, and maintenance of database systems within a production environmentPreferred QualificationsBachelor's DegreeIT related fieldTypically Minimum 8+ Years Relevant ExpTechnical lead, including the mentoring of less experienced DBAsWhat Are Our Desired Skills and Capabilities?Skills / Knowledge - Having wide-ranging experience, uses professional concepts and company objectives to resolve complex issues in creative and effective ways. Some barriers to entry exist at this level (e.g., dept./peer review).Job Complexity - Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results. Networks with key contacts outside own area of expertise.Supervision - Determines methods and procedures on new assignments and may coordinate activities of other personnel (Team Lead).DBMS Knowledge - Extensive knowledge of multiple database disciplines and technologiesDBMS Utilities - Extensive knowledge of multiple utilities utilized to manage, monitor and maintain database systemsDBMS Recovery - Extensive knowledge of recovery technologies for local and geographically disperse systemsNot Ready to Apply? Join Our Talent Community!!US Applicants:TSYS is an equal opportunity employer (EOE) committed to employing a diverse workforce and sustaining an inclusive culture. For more information about your rights, click here.Qualified individuals with disabilities may be entitled to reasonable accommodations to assist in their pursuit of employment with TSYS. This includes assistance in completing the job application (online or otherwise) and reasonable accommodations during the hiring process. For assistance with reasonable accommodations needed to apply for a job, please contact the TSYS Pay and Benefits Center between 8 a.m. and 7 p.m. Eastern Monday-Friday at +1.706.644.8747 or +1.877.644.8747 or email at [Click Here to Email Your Resum--].EOE/Minorities/Females/Vet/DisabilityOutside of US Applicants:TSYS is committed to diversity and equal opportunities for everyone. We are committed to ensuring that all job applicants and team members are treated equally, without discrimination because of gender, sexual orientation, marital or civil partner status, gender reassignment, race, colour, nationality, ethnic or national origin, religion or belief, disability, age or any other characteristic prohibited by law. For more information, please refer to our Code of Business Conduct and Ethics, found here.--SDL2017

Keywords: TSYS, Columbus , DB2 Mainframe Database Administrator Specialist, IT / Software / Systems , Columbus, Georgia