Mercury is an integrated transaction processing company created to enhance point-of-sale systems by offering credit, debit, check, gift card and loyalty processing. Mercury’s integrated Internet protocol (IP) or dial-up processing solutions are fast, reliable and affordable. Retailers can leverage the reliability and enhanced efficiency of integrated payment processing to increase productivity and customer satisfaction. Mercury helps resellers increase their opportunities with reseller support and superior technology. Mercury is in the business is to help other business’s prosper.
Job Summary
Ensures availability, performance and accessibility of databases to meet business needs
Essential Functions include the following. Others may be assigned.
•Production DBA Functions include
•Backup strategy, review, maintenance and annual testing
•Database recovery to meet business requirements
•SQL Server product installation
•Database installation and deployment, including patches, upgrades and utilities
•Security administration, review and audit
•Database normalization and de-normalization
•Replication and transformation services management
•Performance Tuning
•Server sizing and configuration
•Data cleanup, data refresh
•Promotes usability of databases to support business needs; Works with customers to recommend query tools to assist with data retrieval requirements
•Works with business units and customers to define data recovery requirements, SLA's and implement systems to ensure requirements are met
•Reviews and recommends improvements for current production processes operating procedures, and completes/improves on daily operational monitoring checklists
•Researches, designs, communicates, and leads to implement best practices around production database administration, operations and support
•Organizes and leads process improvement teams oriented towards continually improving database production support processes and systems
•Responsible for maintaining internal best practice library for database production operations
•Work with customers to develop and consistently update the Production Database service catalog based on the needs of the customers
•Attends change management, On Call and product-rollout meetings as required
•Ensures customer data access requests are managed appropriately and completed in a timely manner
•Teaches and assists internal customers on how to safely and efficiently access data necessary for their business needs
•Proactively reviews and troubleshoots performance issues related to production databases and data retrieval; communicates issues to senior team members for collaborative problem solving
Authors process and systems documentation; participates in knowledge sharing with the database team and other stakeholders
•Communicates production related issues to appropriate stakeholders in a collaborative, problem solving manner
•Collaborates and consults, in an urgent manner, with users, operations and developer teams to overcome significant operational and/or technical issues
•Reviews Emergency Changes, Standard Changes and recommends additions and updates of the Database Operations Standard Change Master document, in compliance with the enterprise-wide change management process
•Performs code and design reviews with the Database and Business Intelligence Development Teams
•Accepts and complete assignments with an open, cooperative, positive and team-oriented attitude
•Develops and maintains knowledge of applicable products, technologies and services as they evolve, and regularly engage in knowledge transfer with team members as appropriate
•Serve as part of an on-call rotation with some after hours work required
•Actively participates in team meetings and 1 on 1 communications
•Adheres to company policies as defined
Qualifications - to perform this position successfully, an individual must be able to perform the essential functions satisfactorily. The requirements listed below are representative of the knowledge, skills and/or ability needed or desired.
•Bachelor’s Degree in computer science or related field preferred.
•5-7 years’ experience in implementing and maintaining SQL Server production and non-production environments including clustered environments, including:
•Performance tuning, query optimization, performance monitor and other related monitoring tools
•Proficiency with indexes, including, but not limited to, management, checks, configuration and patching.
•Backups, restores, DR drills, recovery models, database shrink operations, clustering, database mirroring and replication.
•Trouble-shooting and resolving database issues including, but not limited to: integrity, performance, blocking and deadlocking, replication, log shipping, connectivity and security
•Detecting and trouble-shooting SQL Server related CPU/memory, I/O, disk space and other resource contentions
•5-7 years’ experience T-SQL programming
•3-5 years’ experience with MS Office suite
•MS SQL DBA Certifications strongly preferred
•Expert experience in implementing operational automation.
•Strong understanding of database structures, theories, principles, and practices
•Strong understanding of Virtual environments
•Strong understanding of SQL Server replication strategies
•Strong understanding of DTS/SSIS
•Functional knowledge of Windows servers, security delegation, SANs and storage components.
•Demonstrated experience in developing and implementing SSIS, SSRS and SSAS is a plus
•Exceptional verbal and written communication skills; must be able to document processes and procedures clearly and effectively (e.g. runbooks, topology, etc.).
•Ability to work well in a team environment, as well as individually.
•Ability to work a rotating 24x7 on-call support schedule.
