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

Troubleshoot

• Monitor database environments, respond to alerts, and escalate 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

• 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

• 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 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 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 escalate
• Creative problem-solving skills that require minimal supervisory prompting
• Ownership of tasks and projects with follow-through to completion

Experience

• 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. DBMS_STATS) 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 audits
• 2+ years performing database operational activities including migrations, patching, and database refreshes
• Working exposure to at least one of PostgreSQL, SQL Server, or MySQL
• 1+ 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 instances
• Working knowledge of backup and recovery strategies and tools
• Familiarity with database high availability and disaster recovery methods for on-premises and cloud deployments
• Exposure to partitioning and to supporting large databases (multi-terabyte) is a plus
• Data warehouse exposure is a plus
• Oracle OCA certification or higher is a plus
• AWS Cloud Practitioner certification is a plus
• ITIL Foundation, Azure Fundamentals, or OCI Foundations certification is a plus

Technologies

• Experience with one or more RDBMS platforms, with Oracle as the primary
• Solid experience administering Oracle 12c and 19c databases
• Exposure to SQL Server 2019
• Exposure to PostgreSQL 10+ and Aurora
• Cloud service providers: AWS, Azure, OCI
• Database tools for cloud and on-premises environments: Enterprise Manager, CloudWatch, Enhanced Monitoring, Performance Insights, Toad, Oracle SQL Developer, SQuirreL
• OS compression tools: tar, zip, bzip2
• Oracle features: partitioning, compression, tuning
• Support portals: My Oracle Support (MOS) and AWS Support
• Backup and recovery tools: Data Pump and RMAN
• Preferred experience with Linux-based infrastructures, Linux/Unix administration, and AWS
• Languages such as Shell, Bash, SQL, PL/SQL, and Transact-SQL

Skills:

• Familiarity with ITIL and SDLC concepts
• Fast learner and self-driven
• Strong technical aptitude and the ability to research and solve complex issues independently
• Excellent interpersonal skills
• Experience handling and securing sensitive information and data
• Excellent documentation skills
• Strong written and verbal communication skills
• Ability to follow established process and contribute to improving it

• Competitive salary
• Performance-based bonus
• Clear career growth opportunities
• 100% private health insurance coverage
• Hybrid work model
• Unlimited snacks and beverages available in the office

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).