MSSQL DB L3 at Hewlett Packard Enterprise

Mumbai, Maharashtra, India

Hewlett Packard Enterprise Logo
Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
IT Services, TechnologyIndustries

Requirements

  • 8-10 years relevant experience
  • B.E./Diploma/BSC/BTech (No education gap, Full time) in Computer 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 experience
  • Failover cluster working experience (Mandatory)
  • Always ON working experience (Mandatory)
  • Team management experience

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
  • 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

Skills

MSSQL
SQL Server
Failover Cluster
Always ON
Server Provisioning
Transaction Replication
Linked Servers
Database Hardening
Patching
Team Management

Hewlett Packard Enterprise

Provides enterprise IT solutions and services

About Hewlett Packard Enterprise

Hewlett Packard Enterprise provides enterprise IT solutions with a focus on cloud services, artificial intelligence, and edge computing. Their products include HPE Ezmeral for managing containers, HPE GreenLake for cloud services, and HPE Aruba for networking. These solutions help businesses improve their performance and adapt to digital changes. HPE's business model includes selling hardware, software, and services, as well as offering subscription-based services and long-term contracts. What sets HPE apart from competitors is its commitment to open-source projects and its active developer community, which supports collaboration and innovation. The company's goal is to empower organizations to transform digitally and optimize their operations.

Houston, TexasHeadquarters
1939Year Founded
IPOCompany Stage
Hardware, Enterprise Software, AI & Machine LearningIndustries
10,001+Employees

Risks

Integration challenges with Juniper Networks may delay AI-driven networking benefits.
Competition from startups like Flywheel could impact HPE's AI and cloud services.
HPE's acquisition strategy may strain resources and distract from core operations.

Differentiation

HPE's GreenLake offers a unique hybrid cloud platform for diverse IT environments.
HPE Ezmeral provides advanced container management, enhancing enterprise AI and analytics capabilities.
HPE's Aruba solutions integrate cloud security and networking for seamless, secure connectivity.

Upsides

HPE's acquisition of Juniper Networks boosts AI-driven innovation in networking.
OpsRamp acquisition enhances HPE's IT management with AI-based automation capabilities.
Axis Security integration strengthens HPE's cloud security offerings with SASE solutions.

Land your dream remote job 3x faster with AI