Logo of Huzzle

Database Administrator - MSSQL

image

Kyndryl

8d ago

  • Job
    Full-time
    Expert Level
  • Data
    IT & Cybersecurity
  • Quick Apply

AI generated summary

  • You need a Bachelor's Degree, 12+ years of DB Admin experience, expertise in MS SQL, integration with Data Bricks/Snowflake, cloud knowledge (Azure), and strong troubleshooting and communication skills.
  • You will manage databases, execute backups and restores, perform maintenance jobs, analyze changes, and provide connectivity support while ensuring compliance with scheduled tasks and policies.

Requirements

  • Bachelor's Degree
  • Experience for about 12+ years as a Database Administrator or similar role, with expertise in one or more managing databases such as DB2, Oracle, PostgreSQL, MSSQL, MySQL, Sybase, MongoDB, Cosmos DB
  • Database Administration: Manage and maintain MS SQL databases, ensuring high availability, performance, and security.
  • Perform routine database maintenance tasks such as backups, restoration, and disaster recovery planning.
  • Optimize database performance by monitoring resource utilization, identifying and resolving bottlenecks, and tuning queries.
  • Implement security measures, including user access controls, encryption, and vulnerability assessments.
  • Troubleshoot and resolve database issues, such as performance problems, replication failures, and data corruption.
  • Collaborate with developers to design and implement database schemas, indexes, and stored procedures.
  • Integration with Data Bricks or Snowflake: Configure and integrate MS SQL databases with Data Bricks or Snowflake platforms.
  • Collaborate with data engineers and data scientists to ensure smooth data ingestion and transformation processes.
  • Develop and maintain data pipelines and ETL workflows between MS SQL databases and Data Bricks or Snowflake platforms.
  • Monitor and optimize data transfer and synchronization processes between the databases and analytics platforms.
  • Troubleshoot and resolve integration issues, such as data inconsistencies or connectivity problems.
  • Database Upgrades and Maintenance:
  • Plan and execute database upgrades, patches, and version migrations in coordination with the infrastructure team.
  • Test and validate database changes to ensure compatibility and minimize downtime.
  • Implement database monitoring and alerting solutions to proactively identify potential issues and take corrective actions.
  • Stay updated with the latest industry trends and best practices related to MS SQL databases, Data Bricks, and Snowflake.
  • Experience with cloud platforms such as Azure and knowledge of Azure database is a plus.
  • Excellent troubleshooting skills with the ability to diagnose and resolve complex issues in database environments.
  • Strong communication skills and the ability to collaborate effectively with cross-functional teams and stakeholders.
  • Microsoft Azure Administrator
  • Azure Database Administrator Associate
  • Azure Solutions Architect Expert

Responsibilities

  • Create / drop databases
  • Uninstall DBMS products and associated products and tools during decommission process or when requested
  • Execute database utilities based on Customer specific requirements and negotiated schedules (e.g., backups, reorgs, runstats)
  • Schedule and perform re-organizations, statistical data collection
  • Manage job scheduler of DBMS maintenance jobs
  • Manage DBMS system related maintenance/utility jobs
  • Provide job status on request for the jobs scheduled on the database
  • Manage physical DB import/export as, and when, required
  • Perform database backups per the agreed policy and restore database on request
  • Analyze, plan and execute database changes
  • Provide DBMS connectivity support
  • Manage the logical backup and restore, if used as a backup strategy

FAQs

What is the primary responsibility of a Database Administrator at Kyndryl?

The primary responsibility of a Database Administrator at Kyndryl is to manage and administer database management systems, ensuring high availability, performance, and security while shaping the architectural structure of the databases.

How many years of experience are required for this role?

A minimum of 12+ years of experience is required as a Database Administrator or in a similar role.

What types of databases will I be managing?

You will be managing MS SQL databases, but expertise in other systems like DB2, Oracle, PostgreSQL, MySQL, Sybase, MongoDB, and Cosmos DB is also beneficial.

Is an Azure certification necessary?

While not strictly necessary, having Azure certifications such as Microsoft Azure Administrator or Azure Database Administrator Associate is preferred.

What type of projects will I be involved in?

You will be involved in configuring, installing, maintaining, and enhancing database management systems, as well as planning and executing database upgrades and managing data integration with platforms like Data Bricks and Snowflake.

Will I have opportunities for professional development?

Yes, Kyndryl offers various training and upskilling programs, including hands-on experience and certification opportunities across multiple platforms.

How does Kyndryl ensure data security?

Kyndryl implements high standards of security measures, including user access controls, encryption, vulnerability assessments, and policies that safeguard data from external threats.

What collaboration opportunities will I have in this role?

You will collaborate with developers, data engineers, and data scientists to design and implement database schemas, develop data pipelines, and ensure smooth data transformation processes.

Is there room for career growth within the company?

Yes, Kyndryl promotes a growth mindset and offers a pathway for career progression, from Junior Administrator to Architect, with various training and mentorship opportunities available.

How does Kyndryl address employee diversity and inclusion?

Kyndryl values diversity beyond appearance or background, promoting an inclusive workplace through various initiatives like Kyndryl Inclusion Networks, ensuring all employees can bring their whole selves to work.

We design, build, manage and modernize the mission-critical technology systems that the world depends on every day.

Consulting
Industry
10,001+
Employees
2021
Founded Year

Mission & Purpose

We have the world’s best talent that design, run, and manage the most advanced and reliable technology infrastructure each day. Together, we think holistically about the health of these vital technology ecosystems. We are a focused, independent company that builds on our foundation of excellence by creating systems in new ways. Bringing in the right partners, investing in our business, and working side-by-side with our customers to unlock potential. We're raising the bar. Our experience speaks for itself: We have 90,000 highly skilled employees around the world serving 75 of the Fortune 100. But our purpose is what drives us: Advancing the vital systems that power human progress. Because when a digital ecosystem is healthy, it can more readily adapt and support continuous growth and that opens up a world of possibility for everyone. Together, we are the heart of progress.