Job
Description
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. Who You Are Youre 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, youre open and borderless naturally inclusive in how you work with others. Required Technical and Professional Experience: Minimum of 7+ years of Experience in Database Administration Configure Databases in accordance with logical data model. Database users creation with required privileges. Assist in debugging application performance issues. Perform SQL query tuning to improve performance. Assist in debugging of application related issues. Execute DLL for Database objects with scripts provided by apps teams. Strong understanding of MySQL database concepts, including query optimization, indexing, and database design. Expertise in managing Amazon Aurora MySQL clusters, including configuration options and scaling mechanisms. Proficiency in AWS services like IAM, CloudWatch, and RDS. Experience with database scripting languages like SQL and PL/SQL for automation and data manipulation. Familiarity with database security best practices, including data encryption and access control. Ability to monitor and analyse database performance metrics to identify bottlenecks and optimize queries. Strong problem-solving and troubleshooting skills 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,
