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.
DBA tasks, responsibilities and work assignments.
Monitor production CRM and BLE SQL Server databases
Check email alerts related to SQL agent job failures
Check Sentry One for any performance related issues
Verify no issues with backups and integrity checks
Reseed any primary keys as needed
Perform manual failover on mirrored databases
On CRM database - review and manually reorganize or rebuild indexes
Maintain SQL Server Development and Staging Environments
Maintain SQL Server JiraToChangPoint database
Assist in processing Weekly ChangePoint Timesheets
Jira tickets assigned to DBA related to CRM and BLE SQL Server databases
Requests to pull data (usually exports to csv files)
Provide professional services with custom campaign queries
Special requests to generate one time reports (usually exports to csv files)
Special requests to update table data
DDL updates
Review and apply stored procedure updates
Whataburger specific work
Adding of new store units to database
Locking accounts suspected of fraudulent activity
Setup new merchants
Provide activity details related to special campaigns
Pull data as defined by client
Verify the nightly ETL processes without error
Whatabuger uses a points based system based on order activity
It is important to understand this functionality as special requirements from client are often requested to change data or functionality
Custom code to update customer points based on client specs
Jira tickets assigned to DBA related to Snowflake administrative tasks
Run scripts as assigned by developers
Maintain updates to roles and users
Assist with Cloud MySQL administrative or SQL statement tasks
DBA skills.
SQL 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
Willingness to understand functional processes of CRM, BLE and JiraToChangePoint databases
Work change requests to update stored procedure code
Unit test sql changes
Knowledge of Google Cloud MySQL, Snowflake and Mongo databases
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.