Database Administrator Sql

Year    Mumbai, Maharashtra, India

Job Description


Who We AreAt 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 RoleWithin 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 wont 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 AreYoure 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 Expertise

  • Monitoring of all the critical parameters for the database such as:
- Table space, segment
- Availability of background processes
- Buffer cache utilization
- Redo log contention
- Resource intensive queries through AWR reports
- Fragmentation of table spaces, tables and indexes
- Perform maintenance activities like index maintenance as per the * 4 years\' experience in SQL database administration
  • Database activity and performance monitoring
  • Real Time Alerting across Multiple database metrics as listed above.
  • Proactive Remedy of Alerted Issues by DB team.
  • Email alert for all tickets
  • Monitoring error logs and event logs and resolve the error
  • DC and DR sync verification, using native utility cloud
  • Ensure optimal performance of your Azure services
  • Monitor and tune Azure SQL in the Azure portal
  • Azure AND AWS ORACLE RDS, SQL Database and Azure SQL Managed Instance resource monitoring.
  • Query Performance Insight in Azure SQL Database
  • Generate intelligent assessments of performance issues
  • Monitor alerts for Azure SQL Database and Azure Synapse Analytics using the Azure portal.
  • Create an alert rule on a metric with the Azure portal for monitoring
  • Create, modify and delete database and database objects
  • Create, modify and delete users and properties
  • Create, modify and delete jobs
  • Perform periodic database performance tuning as per the documented procedures
  • Perform periodic housekeeping of Database
  • Perform orderly start-up and shutdown of database services
  • Restore databases in the event of a server crash with the help of Kyndryl/Customer designated onsite personnel at the Customers data centre
  • Add, modify and delete permissions to database objects and troubleshoot user login
  • Rectify database configuration problems
  • Based on Customers policy provided during transition:
  • Perform regular defragmentation activities for better space management and performance
  • Grant and revoke database access to users.
  • Participation in DR drill
  • Housekeeping on DR server- cleaning up of Archive logs and Alert logs/transaction log
  • Escalation Management, if required
  • Maintain Documentation all the incidences and solution provided captured as part of incident resolution & RCA.
  • Evaluate Releases and Recommend Paths for Upgrading based on recommendation from application team
  • DB Patching
\xc2\xb7 Backup verification
\xc2\xb7 Health Check and database tune up
\xc2\xb7 Database Parameter Tuning and checking across all servers as and when required.
\xc2\xb7 Operating System Parameter Tuning
\xc2\xb7 Enable Capacity Planning by providing utilization & DB growth to FG Application teams.
\xc2\xb7 Index Efficiency and Maintenance
\xc2\xb7 Table Maintenance and Optimization and archival
\xc2\xb7 Quarterly Trend Analysis on Capacity/Space,
\xc2\xb7 Database Technical Support with Production SLAs
\xc2\xb7 Status Meetings and Reports on Ongoing Environment Health and Activities on monthly basis
\xc2\xb7 Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end within defined SLA.
\xc2\xb7 Purging of DB logs and trace files
\xc2\xb7 Risk and mitigation plan
\xc2\xb7 Deployment of azure virtual machine and cloud services (PaaS role instance) into secure VNets.
\xc2\xb7 Azure SQL db configuration and maintenance of Elastic db poolsBeing YouDiversity is a whole lot more than what we look like or where we come from, its how we think and who we are. We welcome people of all cultures, backgrounds, and experiences. But were 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. Thats the Kyndryl Way.What You Can ExpectWith 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.

Kyndryl

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD3444516
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Mumbai, Maharashtra, India
  • Education
    Not mentioned
  • Experience
    Year