Database Administrator

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.
As principal database administrator, you will be responsible for architecture build and maintain new and existing databases hosted in On-prem environments as well as cloud platforms. In addition, you will contribute towards the transformation journey of our solutions providing high level expertise in database field, proactive operational support and acting as liaison in representation of the team and PCI to warranty maximum level of satisfaction of our Internal and external clients.
**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 diagrams, architectural documents, SOP's and run books.

Innovate
- Implement, optimize, and support highly scalable, highly available production infrastructure for different RDBMS (Oracle, PostgreSQL, SQL Server, 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 operational 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 with PostgreSQL, SQL Server and/or MySQL
- 2+ years' hands on experience working with cloud providers: AWS (Must), Azure (A plus)
- Oracle OCA certification or higher is a strong plus.
- AWS Cloud practitioner certification is a strong plus.
- AWS Data Migration Services experience is a strong plus.

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