"Understands Technology Limitations/Features and sets expectations"
Wow, looks great. Will the organization allow realism and limits?
___________________________________________________________
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.
POSITION SUMMARY
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.
PRINCIPAL DUTIES AND RESPONSIBILITIES
•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
•2-4 years of back-end application development using SQL, Stored Procedures, triggers, functions, indexes, synonyms, views, tables, SSIS, SSAS and SSRS.
•2-4 years of DBA experience with SQL Server databases including set up, performance enhancement, stored procedure development, storage hardware, migration and maintenance
•MySQL server development skills such as stored procedures, triggers, database creation, back-up, restore, database scripts, and database table creation
•2-4 years experience with MySQL: server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backup, HA, etc
•Additional experience with NoSQL and AmazonRDS is a plus
•Microsoft certification (MCDBA, MCTS: SQL, MCSA, MCITP, MCM : SQL, MCA or other certification relevant to this job description) strongly desired.
•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
