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*:
- * 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*
- * work change requests to update stored procedure code*
- * unit test sql changes*
- * 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).
*
- * 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.