Oracle Database Administrator

Every day, Global Payments makes it possible for millions of people to move money between buyers and sellers using our payments solutions for credit, debit, prepaid and merchant services. Our worldwide team helps over 3 million companies, more than 1,300 financial institutions and over 600 million cardholders grow with confidence and achieve amazing results. We are driven by our passion for success and we are proud to deliver best-in-class payment technology and software solutions. Join our dynamic team and make your mark on the payments technology landscape of tomorrow.

Summary of This Role

Plans 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?

• Performs testing of database software, utilities and patches within a test environment prior to production roll out. Identifies and resolves issues while in the test environment. Performs the migration of tested/approved software, utilities, and patches to the production environment. Develops basic to moderately complex database configurations by creating database objects per specified business requirements and the necessary test environments. Works in close liaison with application developers to ensure best practices are applied to mitigate potential impacts to the various user groups and/or other database configurations. Coaches/mentors less experienced Database Administrators (DBAs) as they begin to perform routine/basic database administration tasks.
• Completes authentication and authorization requests by creating/purging/maintaining user accounts, adding/deleting/modifying table and data permissions. Performs and/or sets up a scheduled database audit procedure to track the who/when changes are made or new items are created. Takes appropriate corrective actions based on audit results.
• Schedules database back-up tasks and ensure proper completion of scheduled tasks. Executes database recovery task during a disaster recovery and/or disaster recovery exercises.
• Monitors current usage levels of database storage to identify and report growth trends and assists in the forecasting of future storage requirements. Assists with the development of long-term capacity plans. Performs routine maintenance such as data compression, defragmentation, dropping temp tables, clearing transaction logs, archiving inactive databases, load balancing and evaluating server hardware to provide recommendations for performance improvements.
• Actively monitors database performance to identify bottlenecks, such as inefficient queries, inconsistent and/or corrupt indexes, database design, and provides recommendations for corrective actions. Performs database statistic reporting on a regularly scheduled basis. Ensures the high availability of the supported database(s).
• Works closely with the Applications Team while performing troubleshooting to determine the source of application failures. Assists in the development of solutions to minimize the potential of future application failures. Supports the implementation of solutions.
• Produces and maintains operational database documentation, such as SQL Disaster Recovery, SQL Recovery Presentation, Naming Standards, Performance and Tuning, to ensure database configurations are well documented in preparation for disaster recovery.
• Assists in the training and familiarization of less experienced DBAs regarding company policies and procedures, techniques and current server/database configurations.

What Are We Looking For in This Role?

Required Experience:
• 8 - 10 Years of experience in Oracle Database Administration and Oracle Golden Gate.
• Excellent knowledge in Oracle Database Administration and maintenance.
• Experience in a high volume, highly scalable transaction processing environment.
• Experience with workflow automation tools such as Ansible
• Well versed with day to day schema changes and database maintenance.
• Assists in developing and implementing best practices for DR and Backups.
• Assists in Defining and implementing maintenance plans for the database system.
• Performance Optimization, SQL Optimization, Troubleshooting.
• Responsible for solving production problems in a timely manner, including off hours and

weekend support when necessary.
• Knowledge of supporting Oracle on GCP will be a plus

Minimum Qualifications:
• Must be authorized to work in the United States
• Must have good problem-solving, troubleshooting and communication skills
• Flexible with multitasking in a rapidly changing environment
• Ability to work well within a team
• The Database Administrator will frequently work with other infrastructure teams as well as application development teams, and strong communication skills both written and oral are a must.

Education:

Bachelor's degree in Computer Science, Electrical/Electronic Engineering, Information Technology or another related field or Equivalent.

Preferred Qualifications:
• Good knowledge of Oracle Architecture and Concepts.
• Experience with Oracle Database 12c and above
• Expert knowledge of Oracle backup and recovery scenarios using RMAN.
• Good knowledge of Oracle Tools and Utilities.
• Must have experience optimizing SQL and PL/SQL.
• Must have experience writing scripts using Shell
• Must have Oracle Data Guard experience.

Global Payments Inc. is an equal opportunity employer.

Global Payments provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex (including pregnancy), national origin, ancestry, age, marital status, sexual orientation, gender identity or expression, disability, veteran status, genetic information or any other basis protected by law. Those applicants requiring reasonable accommodation to the application and/or interview process should notify a representative of the Human Resources Department.