Mssql Db L3

MSSQL DB L3This role has been designed as ''Onsite' with an expectation that you will primarily work from an HPE partner/customer office

Who We Are:

Hewlett Packard Enterprise is the global edge-to-cloud company advancing the way people live and work. We help companies connect, protect, analyze, and act on their data and applications wherever they live, from edge to cloud, so they can turn insights into outcomes at the speed required to thrive in today's complex world. Our culture thrives on finding new and better ways to accelerate what's next. We know varied backgrounds are valued and succeed here. We have the flexibility to manage our work and personal needs. We make bold moves, together, and are a force for good. If you are looking to stretch and grow your career our culture will embrace you. Open up opportunities with HPE.

Job Description:

HPE Operations is our innovative IT services organization. It provides the expertise to advise, integrate, and accelerate our customers' outcomes from their digital transformation. Our teams collaborate to transform insight into innovation. In today's fast paced, hybrid IT world, being at business speed means overcoming IT complexity to match the speed of actions to the speed of opportunities. Deploy the right technology to respond quickly to market possibilities. Join us and redefine what's next for you.

What you will do:

We are seeking an experienced SQL Database Administrator to join our team. The ideal candidate will have strong technical skills and experience in managing and supporting MS SQL Database including Failover Cluster, Always ON Setup and new server provisioning, Transaction replication, Link Servers,

Hardening, patching in day-to-day operations. Experience on team management

What you will bring:

• 8-10 Years relevant experience
• B.E./Diploma/BSC/BTech (No education gap, Full time) B.E. / Diploma [ In Computers Science, IT , Electronics & Telecommunication] [ Civil and Mechanical not preferred]
• B.Sc. -IT, BCA or MCA [Full time course from a reputed University] No gap in education [Passing year for S.S.C, H.S.C. and Degree/Diploma to be mentioned] (Relevant Certification (Preference) )
• Database troubleshooting and Failover cluster, Always ON working experience is Mandatory plus team management

Key Responsibilities:

• Monitor generated log and event files indicating errors that may result in incidents

• Perform DR database availability monitoring

• Monitor database log replication

• Report the status of log replications as per agreed schedules

• Conduct session/query/log/latch monitoring

• Monitor the database for failures and logged system events that indicate imminent failure

• Purge database logs and trace files

• Perform periodic configuration reviews to maintain consistent configurations

• Review and provide recommendations to maintain database availability

• Prepare monthly reports on database availability

• Reconfigure log shipping as required

• Configure transaction replication

• Configure linked servers

• Manage failover clustering

• Configure and maintain Always ON availability groups

• Respond to database-related incidents and drive corrective actions

• Tune database parameters for performance optimization

• Correlate related incidents into problem tickets and manage through the problem management process

• Use trend analysis to identify, categorize, prioritize, and create Problem Management Records

• Restore databases as needed

• Support the SQL Database L2 team in handling critical issues

• Handle database performance-related issues

• Manage end-to-end major incidents and communicate with customers on production issues

• Create jobs/job schedules for routine or maintenance tasks and rebuild indexes

• Purge database logs and trace files and manage performance

• Perform database defragmentation and performance tuning

• Manage all service requests through the change management process

• Automate administrative tasks where possible

• Manage and update all database environment documentation

• Ensure SQL patch and hardening compliance

• Ensure database server availability for business applications

Technical Skills / Knowledge Requirements

• Team management experience (Must)

• Handling major incidents and preparing RCA reports

• Database installation and troubleshooting (Must)

• Always ON cluster configuration and management (Must)

• Failover cluster management (Must)

• Patching in Failover Cluster and Always ON environments (Must)

• Replication and linked server configuration (Must)

• Database patching and hardening (Must)

• Job scheduling and maintenance planning

• Prepare POA and rollback plans for database migration (Must)

• Plan and execute new database-related projects

• Troubleshoot database performance issues

Additional Skills:

Accountability, Accountability, Active Learning, Active Listening, Bias, Business Growth, Change Management, Client Expectations Management, Coaching, Creativity, Critical Thinking, Cross-Functional Teamwork, Customer Centric Solutions, Customer Experience (CX), Customer Feedback, Customer Lifetime Value, Customer Relationship Management (CRM), Design Thinking, Empathy, Follow-Through, Growth Mindset, Infrastructure as a Service (IaaS), Intellectual Curiosity (Inactive), Long Term Planning, Managing Ambiguity {+ 5 more}

What We Can Offer You:

Health & Wellbeing

We strive to provide our team members and their loved ones with a comprehensive suite of benefits that supports their physical, financial and emotional wellbeing.

Personal & Professional Development

We also invest in your career because the better you are, the better we all are. We have specific programs catered to helping you reach any career goals you have — whether you want to become a knowledge expert in your field or apply your skills to another division.

Unconditional Inclusion

We are unconditionally inclusive in the way we work and celebrate individual uniqueness. We know varied backgrounds are valued and succeed here. We have the flexibility to manage our work and personal needs. We make bold moves, together, and are a force for good.

Let's Stay Connected:

Follow @HPECareers on Instagram to see the latest on people, culture and tech at HPE.

#india#operations

Job:

Services

Job Level:

Specialist

HPE is an Equal Employment Opportunity/ Veterans/Disabled/LGBT employer. We do not discriminate on the basis of race, gender, or any other protected category, and all decisions we make are made on the basis of qualifications, merit, and business need. Our goal is to be one global team that is representative of our customers, in an inclusive environment where we can continue to innovate and grow together. Please click here: Equal Employment Opportunity.

Hewlett Packard Enterprise is EEO Protected Veteran/ Individual with Disabilities.

HPE will comply with all applicable laws related to employer use of arrest and conviction records, including laws requiring employers to consider for employment qualified applicants with criminal histories.

---