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). Oracle Database Administrator - Mid Level (US Citizens Only) 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. Duties Troubleshoot Monitor database environments, respond to alerts, and escalate complex or high-impact issues to senior DBAsReview alert and error logs to identify and address recurring problemsAnalyze queries and recommend indexing and tuning improvementsIdentify and resolve database locks, blocking sessions, and missing or stale statisticsResolve routine data structure issues (invalid objects, tables, partitions, constraints)Deploy patches across database environments following established change management proceduresResolve import/export Data Pump issues Document Document service requests, changes, and incidentsMaintain existing diagrams, architectural documents, SOPs, and run books, and draft new ones for the procedures you perform Collaborate Collaborate with fellow DBAs, developers, vendors, and professional organizations to deliver quality serviceParticipate in an on-call rotation, including occasional after-hours and weekend work for emergencies and deploymentsSupport internal and external customers, corporate IT, and vendor IT, providing a high level of service and moving projects toward completionContribute to database implementations and project work under the direction of senior team membersLead and execute Oracle database migrations across on-premises, AWS, and Oracle Cloud Infrastructure environments using AWS Database Migration Service (DMS), Oracle GoldenGate, 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 Automate Build and maintain scripts that automate routine operational processes, with accuracy and in compliance with our security requirements Improve Help support highly scalable, highly available production infrastructure across multiple RDBMS (Oracle, PostgreSQL, SQL Server, MySQL)Identify gaps in existing processes and recommend improvementsAssist in developing monitoring and support solutions for our database platformsStay current on new database and cloud technologies Requirements U.S. Citizens OnlyMotivated team player who works independently on assigned tasks and knows when to escalateCreative problem-solving skills that require minimal supervisory promptingOwnership of tasks and projects with follow-through to completion Experience 3+ years of experience working with databases in a corporate environment3+ years of experience with Oracle installation and support in Linux and Windows environments3+ years of hands-on experience with SQL performance tuning, including execution plan analysis, SQL Tuning Advisor, and indexing strategy3+ years of experience with database statistics management (e.g. DBMS_STATS) and diagnosing performance issues caused by stale or inaccurate statistics2+ years of hands-on experience using Oracle Data Pump2+ years of experience developing and supporting Linux scripting1+ year of experience in database security: user management, profiles, encryption, and audits2+ years performing database operational activities including migrations, patching, and database refreshesWorking exposure to at least one of PostgreSQL, SQL Server, or MySQL1+ year of hands-on experience with cloud providers: AWS (must), Azure (a plus)Exposure to cloud-managed databases (RDS, Aurora)Hands-on experience working with EC2 or comparable compute instancesWorking knowledge of backup and recovery strategies and toolsFamiliarity with database high availability and disaster recovery methods for on-premises and cloud deploymentsExposure to partitioning and to supporting large databases (multi-terabyte) is a plusData warehouse exposure is a plusOracle OCA certification or higher is a plusAWS Cloud Practitioner certification is a plusITIL Foundation, Azure Fundamentals, or OCI Foundations certification is a plus Technologies Experience with one or more RDBMS platforms, with Oracle as the primarySolid experience administering Oracle 12c and 19c databasesExposure to SQL Server 2019Exposure to PostgreSQL 10+ and AuroraCloud service providers: AWS, Azure, OCIDatabase tools for cloud and on-premises environments: Enterprise Manager, CloudWatch, Enhanced Monitoring, Performance Insights, Toad, Oracle SQL Developer, SQuirreLOS compression tools: tar, zip, bzip2Oracle features: partitioning, compression, tuningSupport portals: My Oracle Support (MOS) and AWS SupportBackup and recovery tools: Data Pump and RMANPreferred experience with Linux-based infrastructures, Linux/Unix administration, and AWSLanguages such as Shell, Bash, SQL, PL/SQL, and Transact-SQL Skills Familiarity with ITIL and SDLC conceptsFast learner and self-drivenStrong technical aptitude and the ability to research and solve complex issues independentlyExcellent interpersonal skillsExperience handling and securing sensitive information and dataExcellent documentation skillsStrong written and verbal communication skillsAbility to follow established process and contribute to improving it Benefits Competitive salaryPerformance-based bonusClear career growth opportunities100% private health insurance coverageHybrid work modelUnlimited snacks and beverages available in the office EO Statement PCI is committed to creating a diverse environment and is proud to be an equal-opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. PCI is also committed to compliance with all fair employment practices regarding citizenship and immigration status Company Website: https://www.pcienergysolutions.com/