Oracle Database Administrator - Mid Level (U.S. Citizens Only) ​/ Platform & Cloud

PCI Energy Solutions, is a thriving global company where you can impact millions of lives every day. Our Software helps protect the environment and lowers utility bills by optimizing energy and utility company operations. We're hiring and growing in locations throughout the U.S. with our headquarters located in Norman, OK;
We also have international offices in Peru and Mexico. We put a high value on work-life harmony by offering flexible working hours and remote work. You shall be required to work in our PCI Norman office on a hybrid basis (1 day at home and 4 days in the Norman office).

As a mid-level database administrator, you will help build, maintain, and support new and existing databases hosted in on-premises environments as well as cloud platforms. Working alongside the senior members of our database team, you will own day-to-day operational support, contribute to migration and upgrade projects, and continue building depth across our multi-RDBMS environment. This role suits a DBA who has mastered core administration tasks and is ready to take on larger, more complex work with growing independence.

• Monitor database environments, respond to alerts, and escape complex or high-impact issues to senior DBAs
• Review alert and error logs to identify and address recurring problems
• Analyze queries and recommend indexing and tuning improvements
• Identify and resolve database locks, blocking sessions, and missing or stale statistics
• Resolve routine data structure issues (invalid objects, tables, partitions, constraints)
• Deploy patches across database environments following established change management procedures
• Resolve import/export Data Pump issues

• Document service requests, changes, and incidents
• Maintain existing diagrams, architectural documents, SOPs, and run books, and draft new ones for the procedures you perform

• Collaborate with fellow DBAs, developers, vendors, and professional organizations to deliver quality service
• Participate in an on-call rotation, including occasional after-hours and weekend work for emergencies and deployments
• Support internal and external customers, corporate IT, and vendor IT, providing a high level of service and moving projects toward completion
• Contribute to database implementations and project work under the direction of senior team members
• Lead and execute Oracle database migrations across on-premises, AWS, and Oracle Cloud Infrastructure environments using AWS Database Migration Service (DMS), Oracle Golden Gate, Oracle Zero Downtime Migration (ZDM), RMAN, and Data Pump, including migrations to Oracle Exadata, Amazon RDS, and hybrid cloud architectures while ensuring minimal downtime and data integrity

• Build and maintain scripts that automate routine operational processes, with accuracy and in compliance with our security requirements

• Help support highly scalable, highly available production infrastructure across multiple RDBMS (Oracle, PostgreSQL, SQL Server, MySQL)
• Identify gaps in existing processes and recommend improvements
• Assist in developing monitoring and support solutions for our database platforms
• Stay current on new database and cloud technologies

• U.S. Citizens Only
• Motivated team player who works independently on assigned tasks and knows when to escape
• Creative problem-solving skills that require minimal supervisory prompting
• Ownership of tasks and projects with follow-through to completion

• 3+ years of experience working with databases in a corporate environment
• 3+ years of experience with Oracle installation and support in Linux and Windows environments
• 3+ years of hands-on experience with SQL performance tuning, including execution plan analysis, SQL Tuning Advisor, and indexing strategy
• 3+ years of experience with database statistics management (e.g. ) and diagnosing performance issues caused by stale or inaccurate statistics
• 2+ years of hands-on experience using Oracle Data Pump
• 2+ years of experience developing and supporting Linux scripting
• 1+ year of experience in database security: user management, profiles, encryption, and…