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 RoleSQL Server 2019 or later
DDL, DML and development of sql code
Performance tuning
sql code
indexes
purging of data
memory
disk management
Knowledge of partitioned views
Backups, restores, integrity checks and index maintenance
Mirroring
SSIS packages (ETL process)
SQL Server upgrades
Database encryption at rest
Work change requests to update stored procedure code
Unit test sql changes
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.
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. Take appropriate corrective actions based on audit results.
Schedules database back-up tasks and ensures proper completion of scheduled tasks. Executes database recovery tasks 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.
Knowledge of cloud database platforms: Google CloudSQL, AWS RDS, Azure SQL. Knowledge of other database platforms MySQL, Snowflake and MongoDB.
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. If you wish to request reasonable accommodations related to applying for employment or provide feedback about the accessibility of this website, please contact jobs@globalpay.com.