"innovations". Like, cool. And stuff. Or something.
"These partnerships translate internally to create a trusting and cooperative team environment." Really? This happens through magic or black box? How much did HR pay for that drivel?
___________________________________________________________________________
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.
POSITION SUMMARY
Responsible for the design, development, support and overall management of MPS Business Intelligence solutions.
PRINCIPAL DUTIES AND RESPONSIBILITIES
•Works with business units to gather and understand requirements, rules and processes, identify Key Performance Indicators (KPI’s) and high-level reporting metric as inputs for the design and architecture of MPS business intelligence and data warehousing solutions
•Works closely with DB and Software developers to ensure BI architecture delivers enterprise-wide needs
•Evaluate and deliver enterprise-wide toolsets for varying user aptitudes
•Support the design and development of a new data warehouse through data modeling and ETL development activities
•Controls, and documents user access to reporting UI’s and underlying databases.
•Navigate, understand, and leverage existing complex data structures
•Acts as project architect and contributes to architectural decisions.
•Define, design and implement logical and physical data models
•Debugs, monitors, and troubleshoots BI solutions
•Identify opportunities to optimize performance of existing data structures
•Design and implement data quality and data auditing processes
•Develops systems testing strategies, plans, cases and conditions; monitors testing efforts; tests complex operating environments and database management systems in compliance with testing standards
•Knowledge of data, master data and metadata related standards, processes and technology
•Depicts highly complex ideas, issues and designs to varied audiences; communicates project objectives, scope and direction to project team and management
•Leads team in developing and implementing best practices and standards.
•Understands Technology Limitations/Features and sets expectations
•Increases knowledge (including new software and tools) through internal resources, company training, developer forums, external education and trade publications
•Authors process and systems documentation; participates in knowledge sharing with the database team and project teams
•Has a general understanding of IT software development methodologies
•Mentor, coach, train and encourage information exchange amongst junior level developers
•Production support responsibilities including full-spectrum documentation, internal cross-training and some on-call duties
QUALIFICATIONS
•Bachelor’s Degree in computer science or related field preferred.
•Microsoft Certifications preferred
•5-7 years’ experience translating business requirements into technical requirements
•5-7 years’ experience working with data warehouse and/or relational database concepts
•3-5 years’ experience working with Pervasive, Informatica or similar ETL toolsets, able to architect an ETL solution
•3-5 years’ experience working with the Microsoft Business Intelligence stack:
- Microsoft SQL Server Analysis Services (SSAS) 2005/2008 Development
- Microsoft SQL Server 2005/2008/2008R2
- Microsoft SQL Server Integrations Services (SSIS)
- Microsoft SQL Server Reporting Services (SSRS) 2005/2008
•3-5 years’ experience designing and building, applying data mining algorithms, writes relational and multidimensional database queries, designs reports
•3-5 years’ experience building data models for data warehousing projects using data modeling tools (i.e. Erwin, ER Studio, SQL Developer, Rational)
•3-5 years’ experience in Business Intelligence with hands-on experience building OLAP (online analytical processing) cubes, data warehouse or BI tools for business purposes (SSRS, Tableau, MicroStrategy, SAP BI, OBIEE, Business Objects, Crystal Reports, PowerPivot, SharePoint, ASP.Net, VB.Net, etc.)
•3-5 years’ experience performing development DBA activities a plus
•Experience in Payment Processing, Sales, or Finance a plus
COMPENSATION
Mercury offers competitive compensation as well as a comprehensive benefits package that includes a 401(k) plan.
About Mercury
Known as an "innovations" leader in the Payment Processing Industry, Mercury was awarded in 2011 for the 2nd year in a row the top (GOLD) award in the Payment Processing category and Best Overall Retail Technology Vendor at RSPA. We were honored with a “Best Company To Work For In Colorado” and a ColoradoBiz Magazine “Top Company” award in 2008. Headquartered in Durango, Colorado, with a second office in Denver, we offer challenging career opportunities in a fast paced, strategic work environment. EOE
___________________________________________________________________________
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
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.
Education and Experience
•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.
Skills/Abilities
•Strong written and oral communications
•Thorough reading comprehension
•Proactive troubleshooting, listening and problem solving skills
•Critical thinking using logic and reason
•Excellent time-management skills with the ability to meet deadlines
•Maintain regular and punctual attendance
•Ability to work in a fast-paced, multi-task environment
•Ability to sit for long periods of time
•Ability to interact with a diverse population
•Ability to work on computer for long periods of time
•Ability to accept and evolve with changes in policies and procedures
Physical Demands and Work Environment
While performing the duties of this job, the employee is regularly required to sit and talk or hear; both on the telephone and in a personal environment. The employee frequently is required to use hands to handle, feel or type. The employee is occasionally required to climb stairs, stand, walk, and reach with hands and arms. The noise level in the work environment is usually low to moderate.
Team Environment
Each Mercury employee plays a role in the success of company relationships with Developers, Resellers and Merchants. These partnerships translate internally to create a trusting and cooperative team environment. Both internal and external partnership success relies on every Mercury employee understanding and participating in their individual team function to their highest ability.
