Database Administrator

Job Overview

NextEra is looking for a skilled Database Administrator with proficiency in Microsoft SQL Server and Oracle databases. The role involves overseeing database administration tasks, enhancing performance, ensuring operational continuity through high availability and disaster recovery strategies, and managing upgrades and migrations within enterprise-level database environments.

Key Responsibilities

• Administer various databases including SQL Server, Oracle, PostgreSQL, and MariaDB.
• Install, configure, maintain, and continuously monitor database servers and operational processes.
• Track database health, monitor performance, ensure availability, and implement security measures.
• Guarantee sustainable high performance and system reliability.
• Design and apply database optimization strategies.
• Automate routine database management activities and maintain accurate documentation of all changes made.
• Assist application teams and developers with tuning queries and optimizing database schemas.
• Conduct scheduled maintenance and support releases deployed after work hours.
• Carry out patching for MSSQL Server and Oracle databases.
• Oversee and maintain technologies including Active-Passive Clusters, SQL Server Always On Availability Groups, and Database Replication.
• Perform disaster recovery testing and production environments switchovers.
• Manage database migrations and version upgrades specifically for MSSQL and Oracle platforms.
• Handle backup and recovery operations utilizing SQL Native Backup & Restore, Oracle RMAN Backup & Restore, Data Pump, and maintain Physical Standby Databases.
• Execute database audits and maintain compliance standards.
• Develop and update comprehensive documentation covering database standards, procedures, and definitions.
• Resolve database issues and provide necessary technical support.
• Implement and govern access control and security policies for databases.

Required Skills and Experience

• Advanced knowledge of MSSQL Server 2019/2022 and Oracle 19c.
• Proven experience in database patching, upgrades, and migrations.
• Hands-on familiarity with backup and recovery tools such as RMAN and Data Pump.
• Competency in both Windows Server and Linux operating systems.
• Understanding and application of High Availability and Disaster Recovery strategies.
• Strong troubleshooting abilities combined with solid performance tuning expertise.