J OB TITLE : Senior Application Database Developer
DEPARTMENT : Global Product & Tech
LOCATION : Peterborough
REPORTS TO : Application Development Manager
Database developer with a proven track-record with hands-on database design of both schema and data access in a pure R&D product development environment.
Solid experience in OLTP systems is essential but design and development experience in reporting, BI and OLAP systems as well as some traditional non-development DBA experience will be considered.
Good communication skills and familiarity with large, complex distributed multi-tier transactional systems.
ESSENTIAL RESPONSIBILITIES :
Schema and solution design from first principles / business requirements
Writing data access TSQL stored procedures, functions, views against new and existing schema
Performance and scalability analysis of data access and schema in a large multi-tier distributed application
Assisting front-end developers with database design and development.
Reviewing and enhancing designs from other R&D teams
Understanding of complex distributed transactions, transaction structure, isolation levels, nested transactions, latch and locking behaviour, database contention risk, and strategies for managing and enabling performance and scalability in a complex OLTP system
Experience of very large distributed OLTP database environments with high transactional volumes, preferably in the financial services sector
Passion for problem solving, debugging systems and finding solutions, must be comfortable in working through unfamiliar code
Familiarity or expertise with SQL Service Broker and SQL CLR desirable
Ideally qualified to degree-level.
Agile methodologies are used on all project teams. The successful candidate must be happy expressing requirements and documentations using concise methods early in the project life cycle (SharePoint, Wiki entries, etc.)
This will involve interaction with R&D teams in the UK, US & India
We power organizations with insightful solutions that drive business success. Consistently named one of the "Most Admired Companies" by FORTUNE® Magazine, and recognized by Forbes® as one of "The World's Most Innovative Companies," ADP has over a half-million clients around the globe and 65 years of experience as a world-wide leader of business outsourcing solutions.
At ADP we are driven by your success. We engage your unique talents and perspectives. We welcome your ideas on how to do things differently and better.
In your efforts to achieve, learn and grow, we support you all the way. If success motivates you, you belong at ADP.
Explore our COVID-19 page https : / / to understand how ADP is approaching safety, travel, the hiring interview process, and more.
Diversity, Equity, Inclusion & Equal Employment Opportunity at ADP : ADP affirms that inequality is detrimental to our associates, our clients, and the communities we serve.
Our goal is to impact lasting change through our actions. Together, we unite for equality and equity. ADP is committed to equal employment opportunities regardless of any protected characteristic, including race, color, genetic information, creed, national origin, religion, sex, affectional or sexual orientation, gender identity or expression, lawful alien status, ancestry, age, marital status, or protected veteran status and will not discriminate against anyone on the basis of a disability.
We support an inclusive workplace where associates excel based on personal merit, qualifications, experience, ability, and job performance.
Ethics at ADP : ADP has a long, proud history of conducting business with the highest ethical standards and full compliance with all applicable laws.
We also expect our people to uphold our values with the highest level of integrity and behave in a manner that fosters an honest and respectful workplace.
Click https : / / to learn more about ADP’s culture and our full set of values.