The Consultant Database Administrator will manage and optimize DB2 and PostgreSQL databases, writing complex SQL queries, ensuring data integrity, and implementing security measures.
TransUnion's Job Applicant Privacy Notice
What We'll Bring:
Job Description: As a Consultant Database Administrator, you will play a critical role in managing, optimizing, and securing our clients' database systems. Your primary responsibility will be to provide expert guidance and hands-on support in the maintenance and performance tuning of DB2 and PostgreSQL databases. In addition, you will be responsible for writing complex SQL queries, creating and optimizing database schema, and ensuring the integrity and reliability of data.Key Responsibilities:
• Install, configure, and maintain DB2 and PostgreSQL database systems.
• Monitor and optimize database performance, ensuring high availability and scalability.
• Develop and implement security policies and procedures to safeguard data.
• Write and optimize complex SQL queries to retrieve and manipulate data.
• Collaborate with development and IT teams to support database-related projects.
• Troubleshoot and resolve database-related issues promptly.
• Perform routine database backups, restoration, and disaster recovery procedures.
this is an on-call role . 3 week rotation required
What You'll Bring:
Job Description: As a Consultant Database Administrator, you will play a critical role in managing, optimizing, and securing our clients' database systems. Your primary responsibility will be to provide expert guidance and hands-on support in the maintenance and performance tuning of DB2 and PostgreSQL databases. In addition, you will be responsible for writing complex SQL queries, creating and optimizing database schema, and ensuring the integrity and reliability of data.
Key Responsibilities:
- Install, configure, and maintain DB2 and PostgreSQL database systems.
- Monitor and optimize database performance, ensuring high availability and scalability.
- Develop and implement security policies and procedures to safeguard data.
- Write and optimize complex SQL queries to retrieve and manipulate data.
- Collaborate with development and IT teams to support database-related projects.
- Troubleshoot and resolve database-related issues promptly.
- Perform routine database backups, restoration, and disaster recovery procedures.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience as a Database Administrator with a focus on DB2 and PostgreSQL.
- Strong proficiency in SQL and the ability to write complex queries.
- Knowledge of database security and data protection best practices.
- Experience with database performance tuning and optimization.
- Excellent problem-solving and troubleshooting skills.
- Strong communication and teamwork abilities.
Preferred Qualifications:
- Certification in DB2, PostgreSQL, or a related database technology.
- Experience with other relational and NoSQL databases.
Impact You'll Make:
Preferred Qualifications:
- Certification in DB2, PostgreSQL, or a related database technology.
- Experience with other relational and NoSQL databases.
TransUnion Job Title
Consultant, Database Administration and StorageTop Skills
Db2
Postgres
SQL
TransUnion Pune, Mahārāshtra, IND Office
6th Floor, Tower B, Panschil Business Park, Vimanaggar, Pune, India, 411014
Similar Jobs at TransUnion
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Engineer will design, develop, test, and deploy scalable Java/J2EE applications, work with RESTful APIs, implement Keycloak for security, and collaborate with teams to deliver solutions.
Top Skills:
J2EeJavaKeycloakMicroservicesOracleReactRestful Apis
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
As a People Operations Representative, you will provide front-line support for employee queries globally, collaborate with cross-functional teams, and manage Workday data administration tasks while ensuring compliance with local regulations and maintaining documentation.
Top Skills:
ConcurExcelOutlookSkype For BusinessWorkday
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Full Stack Dotnet Developer is responsible for designing, developing, and supporting cloud-native microservices and front-ends, collaborating with agile team members, and ensuring adherence to security best practices.
Top Skills:
.Net.Net CoreAngularAWSAzure DevopsC#DockerIisKubernetesNo SqlRdbmsSpecflowTypescriptWeb Api
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
