Sr Oracle Dba

Sr Database Administrator - Peru

Power Costs Inc. (PCI) is the premier provider of software, superior customer support, and value-added services for energy companies worldwide. For almost 30-years, PCI has set the standard for developing customer-focused, customer-driven software to meet the constantly evolving needs of ISO/RTO market participants and bilateral traders. More than 50% of all the power generated in North America is optimized using the PCI Platform. 70% of Fortune 500 Utilities in the U.S. utilize PCI software solutions.

**Duties**:
Troubleshoot
- Actively troubleshoot any issues that arise impacting the database environments
- Ability to monitor databases and analyze error logs
- Analyze queries and advice on efficiency and improvements
- Identify and resolve database locks and lack of statistics
- Resolve data structure issues (Invalid objects, tables, partitions, constraints)
- Deploy patches as required over the database environments
- Resolve Import/export data pump issues

Document
- Document service requests, changes, and incidents
- Create and maintain SOP's and run books

Collaborate
- Collaborating with dbas, developers, vendors, and professional organizations to deliver quality service
- Occasionally working after hours and/or weekends on emergencies, maintenance, or projects
- Supporting internal and external customers, corporate IT, and IT vendors providing a high level of service and pushing projects to completion

Automate
- Automate operational processes as needed, with accuracy and in compliance with our security requirements

Innovate
- Implement, optimize, and support highly scalable, highly available production infrastructure for different RDBMS (Oracle, PostgreSQL, MySQL)
- Update our processes and design new processes as needed
- Developing and implementing strategies for database administration
- Developing solutions for monitoring and support database platforms
- R & D - Stay abreast of new technology

**Requirements**:
Highly motivated individual contributor and team player who can work independently and contribute to the maturity of the team.

Creative problem-solving skills that require minimum supervisory prompting.

Ownership of tasks and projects with 100% follow through to completion.

Experience
- 5+ years' experience working with databases in a corporate environment
- 5+ years' experience with Oracle installation and support for Linux and Windows environments
- 5+ years' solid experience using Oracle data pump
- 5+ years' experience developing and supporting Linux scripting
- 3+ years' experience in database security: User management, profiles, encryption, and audits
- 5+years' performing database engineering and operational activities including but not limiting migrations, patching and database refresh
- 5+ years' experience with PostgreSQL
- 2+ years' experience with MySQL and/or SQL Server
- Strong understanding, experience, and exposure to cloud: AWS, AZURE, OCI
- Exposure to cloud managed databases RDS/AURORA/Autonomous (ATP)
- Exposure to EC2 and Compute instances
- Experience supporting and maintaining VLDB (Multi Terabytes)
- Knowledge of database high availability and disaster recovery methods for on premise and cloud deployments
- Experience with Partitioning
- Strong experience implementing and supporting backup and recovery strategies
- Data Warehousing experience
- Oracle OCA certification or higher is a strong plus
- AWS Cloud practitioner certification or higher is a strong plus
- AWS Data Migration Services experience is a strong plus
- Oracle Golden Gate experience is a strong plus
- ITIL foundation certification is a plus
- OCI Foundations certification or higher is a plus

Technologies
- Demonstrated experience with multiple RDBMS (Oracle, PostgreSQL, SQL server, MySQL)
- Solid experience administering Oracle 12.1c and 19c databases
- Exposure to SQL Server 2019 or higher
- Exposure to PostgreSQL: 10+ and Aurora
- Cloud Service providers: AWS,AZURE,OCI
- Experience using database tools for Cloud and On-premises environments: Enterprise Manager, Cloud Watch, Enhanced Monitoring, Performance insights, Toad, Oracle SQL Developer
- Experience using OS compression tools: Tar, zip, bzip2
- Oracle features: Partitioning, Compression, Tunning
- Support portals: MOS and AWS support
- Backup and recovery tools: Data Pump/RMAN
- Preferred experience with Linux-based infrastructures, Linux/Unix administration, and AWS
- Experience with languages such as Shell, Bash, SQL, PL/SQL, and Transact SQL

**Skills**:

- Knowledge of ITIL and SDLC
- Fast learner and self-driven
- Strong technical aptitude and ability to research and solve complex issues independently
- Excellent interpersonal skills
- Ability to follow and create process
- Experience in handling and securing sensitive information and data
- Excellent documentation skills
- Great communication skills both written and oral

EO Statement
PCI is committed to creating a diverse environment and is pro