Systems Engineer 1

Oracle

Up to 2 yrs Bengaluru Full Time Work from office
Oracle logo
Posted : yesterday
Actively hiring

Job description

Seeking a skilled SQL Database Administrator to ensure the seamless operation, maintenance, and support of SQL Server databases. This role is crucial for monitoring database health, performance, security, and availability to guarantee reliable production services. Responsibilities include installation, configuration, patching, upgrades, troubleshooting, performance optimization, and disaster recovery planning.

This position involves active participation in a 24/7 on-call rotation, providing support during nights, weekends, holidays, and scheduled maintenance. A key aspect of the role is maintaining accurate documentation and adhering strictly to security and change-management protocols for timely incident resolution.

Responsibilities

Administer, monitor, and maintain Microsoft SQL Server environments across various platforms, including development, test, production, and disaster recovery.

Key duties involve installing, configuring, upgrading, and patching SQL Server instances and related components. You will be responsible for creating and maintaining databases, schemas, and essential database objects.

Proactively monitor database availability, performance, storage, replication, backups, and job executions, resolving issues before they impact business operations. Optimize SQL queries and database performance through indexing strategies, blocking analysis, and resource management.

Manage backup, restore, and recovery processes, regularly testing restores and supporting disaster recovery exercises. Administer high-availability and disaster-recovery solutions like clustering and Always On Availability Groups.

Manage database access and security, provision accounts, apply least-privilege permissions, and support audits. Troubleshoot diverse database incidents, including connectivity, authentication, data integrity, and performance issues.

Provide technical support to application, infrastructure, and security teams for database-related requests. Plan and execute database migrations and upgrades with thorough testing and rollback plans.

Develop and maintain comprehensive operational documentation, standards, and knowledge-base articles. Enhance automation for routine administration tasks using approved scripting and tools.

Participate in root-cause analysis for major incidents, implementing corrective actions to boost reliability. Support infrastructure and application projects by contributing database design input and ensuring production readiness.

Qualifications

This role is ideal for individuals with 0 to 2+ years of experience in SQL database administration. Fluency in English, including reading, writing, and speaking, is required.

The position involves a 24/7 on-call rotation, requiring availability during nights, weekends, holidays, and scheduled maintenance windows for critical incident response and operational support. This includes monitoring overnight operations, resolving failed SQL Agent jobs, and ensuring the availability of critical services.

Successful candidates will be adept at troubleshooting database incidents, providing technical guidance, and collaborating with various teams. A commitment to maintaining compliance with change management, incident management, security, and data-protection requirements is essential.

Development of operational documentation, adherence to security protocols, and participation in root-cause analysis for incidents are integral parts of this role. Automation of administrative tasks using scripting and tools is also a key expectation. Experience with high-availability and disaster-recovery solutions is highly valued.

Essential Skills

SQL ServerDatabase AdministrationPerformance TuningBackup and RecoveryDisaster RecoveryHigh AvailabilityClusteringAlways On Availability GroupsReplicationSecurity ManagementIncident ResolutionChange ManagementScripting

Good to Have

SSISReporting ServicesDatabase MirroringLog Shipping

Highlights

  • Actively hiring

More Details

RoleSystems Engineer 1
IndustryTechnology Operations
DepartmentDatabase Administration, Systems Engineering
Employment TypeFull Time, Work from office

About the Company

Oracle logo

Oracle

Technology Operations

Systems Engineer 1 at Oracle | SkillMX | SkillMX