Sr Database Administrator - PeruPower 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 issuesDocument- Document service requests, changes, and incidents- Create and maintain SOP's and run booksCollaborate- 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 completionAutomate- Automate operational processes as needed, with accuracy and in compliance with our security requirementsInnovate- 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 plusTechnologies- 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 oralEO StatementPCI is committed to creating a diverse environment and is pro
