Job Description

MSSQL DB L3
This 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.
:
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 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: .
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.

Skills Required