Sr Database Engineer (Hybrid)
Share
Job Location:
Folsom, CA - USA
Monthly Salary:
Not Disclosed
Posted on:
4 hours ago
Vacancies:
1 Vacancy
Job Summary
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 desirable
- Security 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.
Qualifications :
Level of Education and Discipline:
A Bachelors degree (BA BS) or equivalent education training or experience in Information Technology Management of Information Systems Computer Science Engineering or related technical field. Masters Degree preferred.
Amount of Experience:
Equivalent years of education and training plus five (5) or more years related experience.
Certifications:
Oracle DBA Certification preferred. Certifications in any other database platform desirable.
Type of Experience:
Required: Oracle database administration as a developer and/or administrator. Experience working in corporate information technology including development engineering security or administration. Extensive systems knowledge working in a highly complex environment
Desirable: Cassandra RDBMS Postgres RDBMS LDAP Oracle Transparent Application Failover PowerShell scripting Administration of Block and/or NFS Filesystems Experience with NERC-CIP compliance standards
Additional Skills and Abilities:
Strong verbal and written communication and documentation skills required with a demonstrated attention to detail. Ability to use deductive reasoning and analytical thinking with sound judgment and decision-making skills. Strong interpersonal and conflict resolution skills are also essential. Must be self-starting and willing and able to work independently in a dynamic corporate organization under pressure of tight deadlines and aggressive expectations. Problem solving skills with the ability to influence others without direct authority. Must be able to work effectively in a team environment as facilitator and team member. Must be proficient with Microsoft Office Suite.
Additional Information :
The pay range for the Sr Database Engineer is $121125 - $201875 annually.
All your information will be kept confidential according to EEO guidelines.
Remote Work :
Yes
Employment Type :
Full-time
Key Skills
- Databases
- SQL
- Database Development
- Microsoft SQL Server
- Database Design
- Performance Tuning
- NoSQL
- MySQL
- Postgresql
- Database Administration
- MongoDB
- Oracle
About Company
The California Independent System Operator (ISO) manages the flow of electricity across the high-voltage, long-distance power lines that make up 80 percent of California's power grid. We safeguard the economy and well-being of 30 million Californians by operating the grid reliably 24/ ... View more
