Sr Database Engineer (Hybrid)

Under the general direction of the Manager, the Senior Database Engineer maintains the integrity of enterprise-wide Oracle, SQL Server and Postgres databases and associated applications. Performs database and software lifecycle upgrades to ensure the highest level of systems performance and availability in compliance with business requirements. Collaborates with the business unit personnel to analyze and resolve related issues in a time-critical environment participates in the development, customization, integration, implementation, and administration of company-wide databases.  Expertise in Oracle technologies, including Data Guard for high availability and disaster recovery, coupled with proficiency in UNIX Shell and PL/SQL scripting, will be crucial to ensuring the performance, security, and stability of our data systems.  Provide 24x7 rotating on-call technical support as required.PRINCIPAL DUTIES AND RESPONSIBILITIES: Database engineering and administration: Design, build, configure, and maintain Oracle 19c databases in production and non-production environments.High availability and disaster recovery: Implement, configure, and manage Oracle Data Guard to ensure high availability, data protection, and disaster recovery. Perform failover and switchover tests.Performance tuning: Conduct advanced performance analysis and tuning of Oracle databases and complex PL/SQL code to optimize query execution and system efficiency.Database scripting and automation: Develop, maintain, and execute PL/SQL scripts, stored procedures, functions, and packages to support application development and automate database management tasks.Backup and recovery: Design, implement, and manage robust backup and recovery strategies using Oracle RMAN to ensure data integrity and minimize downtime.  Knowledge of Dell Networker/DPS very desirableSecurity and compliance: Implement and enforce database security best practices, including access control, auditing, and compliance with company policies and federal regulatory standards (NERC-CIP).Mentorship and collaboration: Work closely with application development, IT operations, and other cross-functional teams. Provide technical guidance and mentorship to junior database administrators.Troubleshooting and support: Provide advanced troubleshooting and resolution of database-related incidents. Participate in a 24x7 on-call rotation as required.Attends business meetings, and collaborates with ISO colleagues to develop "best practices" policies and procedures, and to identify and resolve issues to help create a flexible and efficient organization.