Lead Database Administrator - PostgreSQL

Who We Are

At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities.

The Role

Within our Database Administration team at Kyndryl, you'll be a master of managing and administering the backbone of our technological infrastructure. You'll be the architect of the system, shaping the base definition, structure, and documentation to ensure the long-term success of our business operations. 
Your expertise will be crucial in configuring, installing and maintaining database management systems, ensuring that our systems are always running at peak performance. You'll also be responsible for managing user access, implementing the highest standards of security to protect our valuable data from unauthorized access.
In addition, you'll be a disaster recovery guru, developing strong backup and recovery plans to ensure that our system is always protected in the event of a failure. Your technical acumen will be put to use, as you support end users and application developers in solving complex problems related to our database systems.
As a key player on the team, you'll implement policies and procedures to safeguard our data from external threats. You will also conduct capacity planning and growth projections based on usage, ensuring that our system is always scalable to meet our business needs.
You'll be a strategic partner, working closely with various teams to coordinate systematic database project plans that align with our organizational goals. Your contributions will not go unnoticed - you'll have the opportunity to propose and implement enhancements that will improve the performance and reliability of the system, enabling us to deliver world-class services to our customers.
Your Future at Kyndryl
Every position at Kyndryl offers a way forward to grow your career, from Junior Administrator to Architect. We have training and upskilling programs that you won’t find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with customers in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here.

Who You Are

You’re good at what you do and possess the required experience to prove it. However, equally as important – you have a growth mindset; keen to drive your own personal and professional development. You are customer-focused – someone who prioritizes customer success in their work. And finally, you’re open and borderless – naturally inclusive in how you work with others.

Required Technical and Professional Experience:

• Minimum of 10+ years of Experience in Database Administration

• Deep understanding of Amazon Aurora PostgreSQL architecture and its underlying storage mechanisms. 
• Expertise in PostgreSQL database administration, including query optimization, performance tuning, and data modeling. 
• Familiarity with AWS services like CloudWatch, IAM, and RDS. 
• Experience with database replication, high availability, and disaster recovery strategies. 
• Proficiency in SQL and scripting languages like Python or Bash for automation. 
• Strong analytical and problem-solving skills to troubleshoot database issues. 

• Configure Databases in accordance with logical data model.

• Assist in debugging application performance issues.

• Execute explain plans as requested by Apps teams.

• Provide application upgrade support for minor releases.

• Assist in debugging of application related issues.

• Execute DLL for Database objects with scripts provided by apps teams.

• Provide application database upgrade support

• Execute data manipulation (insert, update, delete) / Transformation, masking, scrubbing scripts provided by apps/dev team.

• Provide response Time SLA attainment analysis for all the reported incidents.

• Check the Top sessions and SQLs using more CPU and high IO.

• Periodically check the tables without PK or indexes or having more indexes.

•  Check tables need partitioning.

•  Check the database/schema sizes periodically to know the rate of data growth.

• Manage Database Incidents using the Air Canada Incident Management process

Preferred Technical and Professional Experience:

• Create and maintain standard operating procedures and documentation as appropriate.

•  Perform data archival and purging as per the capacity planning report with assistance from application owners.

• Provide Change Success report.

• Use appropriate Change Management process and tools.

• Provide RCA resolution and submission within agreed timelines.

•  Work with Physical DBAs on software Upgrades & Fixes by following the appropriate Change Management Process.

• Work closely with application and physical DBA teams to assist where applicable.

•  Create and maintain logical database standards and policies.

•  Monitor application sessions for transaction volumes, response times, concurrency levels, etc.

Being You

Diversity is a whole lot more than what we look like or where we come from, it’s how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But we’re not doing it single-handily: Our Kyndryl Inclusion Networks are only one of many ways we create a workplace where all Kyndryls can find and provide support and advice. This dedication to welcoming everyone into our company means that Kyndryl gives you – and everyone next to you – the ability to bring your whole self to work, individually and collectively, and support the activation of our equitable culture. That’s the Kyndryl Way.

What You Can Expect

With state-of-the-art resources and Fortune 100 clients, every day is an opportunity to innovate, build new capabilities, new relationships, new processes, and new value. Kyndryl cares about your well-being and prides itself on offering benefits that give you choice, reflect the diversity of our employees and support you and your family through the moments that matter – wherever you are in your life journey. Our employee learning programs give you access to the best learning in the industry to receive certifications, including Microsoft, Google, Amazon, Skillsoft, and many more. Through our company-wide volunteering and giving platform, you can donate, start fundraisers, volunteer, and search over 2 million non-profit organizations.  At Kyndryl, we invest heavily in you, we want you to succeed so that together, we will all succeed.

Get Referred!

If you know someone that works at Kyndryl, when asked ‘How Did You Hear About Us’ during the application process, select ‘Employee Referral’ and enter your contact's Kyndryl email address.