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 Description
The Database (DB) Developer II will be responsible for responding to ad hoc and project-driven database development requests as well as database user support activities. The DB Developer II plays an important role in the design, development and application of database standards, techniques, methodology, process management, tools and quality improvement initiatives. The DB Developer II will drive the continual tuning and improvement of DB structure and processes and should have proven success on large initiatives with extensive knowledge of SQL DB systems. The DB Developer II will be client facing and must have clear and concise communication skills.
Essential Functions include the following. Others may be assigned.
Responsible for the design, development, and support of the MPS Database environment
•Works with business units to gather and understand requirements, rules and processes as inputs for the design and architecture of MPS Database solutions
•Communicates status of projects, issues and solutions to project managers, software developers and project stakeholders
•Coordinates the design of database architecture and integration solutions to meet the needs of MPS, and guides code/design reviews with the QA and Software Development teams
•Contributes to the definition, design and implementation of logical and physical data models
•Debugs, monitors, and troubleshoots the MPS database environment
•Participates in process improvement teams to identify and improve database development processes, and optimize performance of existing data structures
•Supports the design and implementation of data quality and data auditing processes
•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
•Has a general understanding of IT software development methodologies
•Accepts and completes assignments with an open, cooperative, positive, and team oriented attitude
•Contributes to process and systems documentation including best practices and standards; participates in knowledge sharing with the database team and project teams
•Identifies opportunities for indexes, identifies and implements indexes where appropriate
•Has a general understanding of database source control
•Adheres to company policies as defined
•Actively participates in team meetings and 1 on 1 communications
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
•3-5 years of back-end application development using SQL, Stored Procedures, triggers, functions, indexes, synonyms, views, tables, SSIS, SSAS and SSRS.
•3-5 years of DBA experience with SQL Server databases including set up, performance enhancement, stored procedure development, storage hardware, migration and maintenance
•1-2 years with integration tools desired (SSIS, Pervasive, Informatica, Cast Iron, et al)
• Microsoft certification (MCDBA, MCTS: SQL, MCSA, MCITP, MCM : SQL, MCA or other certification relevant to this job description) strongly desired.
• 1+ years of SQL Server 2008 or SQL Server 2008 R2 experience required.
•Experience with setup, administration and optimization of SQL Server high availability technologies desired (clustering, mirroring, replication, etc).
• Strong Windows Server operating system administration skills.
•Familiarity with Agile project management methodology
• Strong written and verbal communications skills.
• Proven ability to work with developers, testers, and other through the product lifecycle.
• Able to learn and adapt to new technologies through self-directed training.
•Experience in Payment Processing, Sales, or Finance a plus
•Comfortable translating business requirements into database designs
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
About Mercury
Mercury is known as an "innovations" leader in the Payment Processing Industry. In 2012 Mercury was awarded the top (GOLD) award in the Payment Processing category and Best Overall Retail Technology Vendor at RSPA for the 3rd consecutive year in a row. We were honored with a “Best Company To Work For In Colorado” and a ColoradoBiz Magazine “Top Company” award in 2008. In 2012 Mercury also won for Technology Company of the Year at the Colorado Technology Association's Apex Awards. Headquartered in Durango, Colorado, with a second office in Denver, we offer challenging career opportunities in a fast paced, strategic work environment. EOE
About Durango, Colorado
Durango is situated at the southwestern foot of the Rocky Mountains at an elevation of 6,500 feet. The population is about 17,000 (50,000+ countywide). Surrounded by some two-million acres of San Juan National Forest land, the area is a natural playground for all who appreciate spectacular views and outdoor experiences. Though Durango is a geographically, culturally, and economically diverse area, the thread that ties its citizenry together is quality of life.
Durango was recently ranked the #1 “micropolitan” area in the United States by an independent economic research firm, Policom. Durango was ranked first out of 576 micropolitan (less than 50,000 people) areas studied. The study ranked over 23 different economic factors, including wages and earnings. Large corporations and small main street shops thrive in Durango. Mercury is among Durango’s largest employers.
Small enough to feel personal and uncongested, Durango is large enough to offer a diverse selection of recreational, entertainment, cultural, and educational opportunities. Locals and tourists alike enjoy Durango for its high mountain vistas, powder skiing, cycling, kayaking, rafting, fishing, and lingering hints of western lore. Our playground is the entire four corners area, from hot desert to mountain summits.
No wonder why Durango residents are some of the most fulfilled in Colorado and the US.
