Subject Matter ExpertSQL DBA

Job Description

Your Role and Responsibilities You and IBM India IBMs Purpose is to be essential to our clients, to the world and one another and we are confident that together as IBMers we will drive this purpose. When you join IBM you join a culture of openness, teamwork, trust, and the invitation and expectation to have a voice. Join us and Do your Best Work Ever. We are recognized gold standard for inclusion, reflected in winning, to name a few, the 2018 Catalyst Award for advancing women in business, the National Award Best Employer of People with Disabilities and being named one of the top 5 2018 Top Companies for Women Technologists for building an inclusive workplace We advocate for fairness and equality as everyone is, and always has been, welcome at IBM. Join a brand with a history of continuous re-invention, transforming itself throughout its 100-plus years. In the past five decades alone, IBM has ushered in the eras of the mainframe, the personal computer, IT services and enterprise software. In its current transformation, IBM is once again leading the reordering of the technology industry. Our IBM Global Technology Services (GTS) helps clients plan, implement and lead an efficient, resilient, flexible IT infrastructure. Be it groundbreaking outsourcing tied to business outcomes or integrated managed services or discrete services - IBM GTS is the partner of choice for infrastructure services. Come join our team of IBM experts, who are leaders with vision, distinguished engineers and IT architects who have worked with thousands of clients to transform enterprise IT, migrate to cloud, apply automation and ensure business continuity. We help client run their IT better, accelerate innovation and deliver unmatched performance with the power automation. Who you are:

1. SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of applications.
2. This is a hands-on position requiring solid technical skills, as well as good interpersonal and communication skills.

What will you do

• Installs, maintains, administers, and tunes MS SQL Server databases. Completes database back-ups and maintains backup procedures.
• Maintains database high availability and the upkeep and availability of other Database systems as required.
• Creates automation scripts to perform repetitive tasks and to ensure high data integrity. Serves as backup to the Senior Database Administrator role.
• Determines database management needs and recommends system upgrades as necessary. Ensures that databases are restored in a timely and efficient manner in the event of system failure.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Assist developers with complex query tuning and schema refinement. Provide 24x7 support for critical production systems.
• Perform scheduled maintenance and support release deployment activities after hours.

Required Technical and Professional Expertise

• Minimum 6+ years MS SQL Server Administration experience required
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with back-ups, restores and recovery models
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience working with Windows server, including Active Directory
• Excellent written and verbal communication. Flexible, teammate, get-it-done personality
• Ability to organize and plan work independently. Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams. MCTS, MCITP, and/or MVP certifications a plus

Preferred Technical and Professional Expertise

• Experience in scripting for automation of application deployments and other infrastructure components
• Monitored Applications, Generated core dumps and Heap dumps with support from team members.
• Experience on urban code.

,

Keyskills :
customerrelations sla quality sme reporting mssqlserver sqlserveradministration mssql sqlserver itservices querytuning windowsserver globaldelivery audiomastering activedirectory qlserverdba