SQL Database Administrator
Join over 260 professionals’ team in TransUnion Lithuania in Kaunas and be part of the global TransUnion company – one of the “The Big Three” largest credit-reporting agencies.
TransUnion is US based credit reporting agency that provides data/insights and information to help consumers and businesses make informed decisions. It operates in more than 30 countries and has more than 8000 employees. The company provides customer credit reporting, portfolio management, marketing and audience segmentation, healthcare revenue cycle management, customer acquisition, investigations and collections, fraud detection and prevention, identity verification and authentication, customer analytics and consulting, data breach, and customer engagement solutions.
Key responsibilities and tasks
Primary purpose for the DBA role will be to ensure databases are secure, recoverable, fit for purpose and perform to agreed standards in both the production and testing environments
Currently DBA team consist of 6 team members and split between two locations Kaunas (LT) and Leeds (UK).
We have different SQL technologies from SQL 2008 which we looking to upgrade and you can play role in that process to SQL 2016 with HA and not limited to private cloud but in public cloud as Azure as well.
DBA Engineer Daily tasks:
- Creation of databases.
- Planning and maintenance of database configuration.
- Management and implementation of database changes.
- Taking responsibility for implementation and enforcement of database security.
- Planning and implementation of backup and recovery requirements.
- Investigating and resolving database and production system errors.
- Ensure all database performance and availability meets agreed SLAs.
- Assist in determining the effectiveness of existing technologies and processes in relation to the SQL implementation, create necessary implementation/migration plans, and recommend new solutions as required.
- Support the operations team in capacity planning, volumetric analysis, execution of database change requests.
- Member of the On-Call support team providing out of hours technical support for major incidents.
- Provide DBA guidance and support to development and operations teams.
- Creation and maintenance of technical documentation.
- Develops and implements methods and procedures for process control/improvements and testing to ensure products/systems are free of flows and function as designed.
- Designs, tests and/or implements products or systems.
- Solves a range of straightforward problems.
- Analyses possible solutions using standard procedures.
- Have exposure to, and the option to become experienced with an array of existing technologies.
- Maintains team process and procedures.
- Provides input into technical design documents/design/ implementation.
- Understands and utilizes best practices to effectively troubleshoot and solve problems.
What do we expect from you:
- Implementing and maintaining Microsoft SQL Server Database Servers.
- Good knowledge of Microsoft SQL Server database engine (versions 2012 - 2017).
- SQL replication.
- SQL Server security models.
- SQL backups & restoration.
- Experience with Windows /SQL HA technologies (Always On, clustering, mirroring, log shipping).
- Experience within a service level driven environment.
- Good command of English.
- Exposure to SSIS, SSAS & SSRS an advantage.
- Experience with large databases up to VLDB size.
- Data warehousing.
- IT Service continuity.
- Complex query design, stored procedures, views, triggers.
What you'll get in return:
- A chance to be a part of highly motivated team and collaborate with high performing professionals in TransUnion global community.
- Wide career progression path and guidelines.
- Access to a community of talented individuals to learn from.
- Health insurance package.
- Team building and company events.
- Competitive salary and performance-based bonuses.
- Numerous best in kind online training resources available.
- Employee referral program.
- An option to book your ticket in Kaunas Žalgiris arena sky-box (when available