Database administrator

Posted Yesterday
Be an Early Applicant
2 Locations
Hybrid
Mid level
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Role
The Consultant Database Administrator will manage and optimize DB2 and PostgreSQL databases, writing complex SQL queries, ensuring data integrity, and implementing security measures.
Summary Generated by Built In

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.

This is a hybrid position and involves regular performance of job responsibilities virtually as well as in-person at an assigned TU office location for a minimum of two days a week.

TransUnion Job Title

Consultant, Database Administration and Storage

Top Skills

Db2
Postgres
SQL

What the Team is Saying

Patrick
Tiana
Jason
Lauren
TC
Jay
Aayushi
Paul
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
13,000 Employees
Year Founded: 1968

What We Do

TransUnion is a global information and insights company that makes trust possible by ensuring that each consumer is reliably and safely represented in the marketplace.

We do this by having an accurate and comprehensive picture of each person.

This picture is grounded in our legacy as a credit reporting agency which enables us to tap into both credit and public record data; our data fusion methodology that helps us link, match and tap into the awesome combined power of that data; and our knowledgeable and passionate team, who stewards the information with expertise, and in accordance with local legislation around the world.

Because of our work, organizations can better understand consumers in order to make more informed decisions, and earn their trust through great, personalized experiences, and the proactive extension of the right opportunities, tools and offers. In turn, consumers can be confident that their data identities will result in the opportunities they deserve.

We make trust possible, so businesses and consumers can transact with confidence and achieve great things. We call this Information for Good®—it’s our purpose, and what drives us every day.

Why Work With Us

Our culture is welcoming, energetic and innovative. There’s an overall synergy that flows throughout TransUnion, creating a sense of unity in knowing that we’re all working to achieve the same overall goal. We’re dedicated to providing opportunities for our people to get involved and stay connected with their colleagues across the globe.

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

TransUnion Teams

Team
Invested in Tech Teams
About our Teams

TransUnion Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

Typical time on-site: Flexible
HQChicago, IL
MX
Amsterdam, NL
Bengaluru, IN
Boca Raton, FL
Bogotá, Colombia
Burlington, ON
South Africa
Cerqueira César, Sao Paulo
Chennai, IN
Cherry Hill, NJ
Cork, County Cork
Crum Lynne, PA
Denver, CO
Greenwood Village, CO
Guaynabo, PR
Gurugram, IN
Hamburg, DE
Hyderabad, IN
Johannesburg, ZA
TransUnion UK Head Office
London, GB
Louisville, KY
Madrid, ES
Makati, PH
Mumbai, IN
New York, NY
Pune, IN
Reston, VA
San Luis Obispo, CA
Santiago, CL
Sydney, NSW
Toronto, ON
Ulloa, La Aurora
Washington, US
White Plains, NY
Learn more

Similar Jobs

TransUnion Logo TransUnion

Java Engineer

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
2 Locations
13000 Employees

TransUnion Logo TransUnion

Engineer

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
2 Locations
13000 Employees

TransUnion Logo TransUnion

Engineer

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
2 Locations
13000 Employees

TransUnion Logo TransUnion

Engineer

Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Hybrid
2 Locations
13000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account