Application Database Specialist

Keylane

Copenhagen, Denmark

At Keylane, we are looking for an experienced Application Database Specialist to bridge the gap between application and framework development and database design and operation. As part of our SDLC (Software Development Life Cycle), you will ensure that non-functional requirements related to performance, database footprint, security, and operation are aligned with business needs and implemented through close collaboration with development teams and operations. You will play a key role in designing our Life & Pension application (Plexus) with a competitive TCO (Total Cost of Ownership) offered through our SaaS services.

Key about your role

As the Application Database Specialist, you will be the go-to person for database performance, footprint, scalability, and security design. You will drive technical strategies and algorithms for integrating the database, object-relational mapper (Hibernate), and Plexus in collaboration with the framework team, application teams, and operations. You will engage in scalability and performance optimization projects and help analyze operational issues. The key technologies are the Java ecosystem, Hibernate, and Microsoft SQL (MS SQL).

Key about you

You likely have a senior developer profile supplemented with database specialist experience. The role goes beyond a traditional Database Administrator (DBA). You must understand the design and code structures in Plexus and the use of Hibernate to fully explore the potential to optimize how Plexus integrates with MS SQL. You will build recommendations on how Plexus, database, and infrastructure should be configured to achieve performance, scalability, security, and not least an acceptable cost. You also engage with customers on the recommendations.

Key Responsibilities

Data model design including tables, relationships, indexing, partitioning, stored procedures, and general MS SQL optimization;
Techniques for data lifecycle, e.g., archiving and clean-up;
Database operation and monitoring in context of Plexus;
Application and database tuning based on execution plans, capacity, caching and scaling;
Use of middleware and object relation mapper (Hibernate) and how to use database optimally;
Database security, e.g., roles, access, encryption, and compliance;
Database specific input on application algorithmic design, e.g., how to do massive inserts, deletes, updates and maybe how to avoid doing it at all;
Documented recommendations on how to configure application and database;
Internal and external communication on recommendations and problem solving;
Problem analysis and problem suggestion to be implemented in frameworks and application code;
Recommendations on database maintenance, e.g., statistics and index maintenance;
Database hardware sizing.

Key Competencies

Application and framework development experience;
Proficiency in database technology, preferably Microsoft SQL;
Proficiency in middleware, preferably Hibernate;
Programming experience with programming languages, e.g., Java and SQL;
Structured and analytic approach to problem solving;
Collaboration skills to bridge functional areas in a development organization, e.g., developers, database operators and product owners;
External communication skills in English, both written and spoken;
Experience of managing and optimizing large-scale applications.