Senior Database Administrator

Job Description

Job Description

Energy Services Group (ESG) is the leading provider of Software as a Service (SaaS) solutions for the retail and wholesale energy industries. Today, consumers are demanding more control of their energy use – and are switching away from traditional electric and gas utilities to more nimble, data centric suppliers and retailers. ESG has over 300 retailer/supplier clients supporting over 20 million residential, commercial and industrial consumers spanning the worlds largest energy markets including US, Canada, Mexico and UK. Our solutions include usage and data management, billing, pricing, demand scheduling, pipeline and storage management, and data analytics. We are the only software company with the scale, global reach and expertise to uniquely support this rapidly changing marketplace.

In April 2016, ESG received a major investment from Accel-KKR to enable the company to accelerate its vision and product roadmap. Since then, ESG has expanded our products and services, acquired key competitors and partners in North America, and established a global presence in Europe and Asia. Accel-KKR is one of the leading technology-focused investment firms with $5.0 billion in capital commitments to its current funds. The firm invests in software and IT enabled businesses well positioned for topline and bottom-line growth.

This is an exciting opportunity to join a growing company in an exciting evolving industry. We are seeking a Senior Database Administrator to support our Infrastructure team. This is a hybrid position and we expect to be onsite for 2-3 days per week at our Norwell, MA office.

POSITION SUMMARY

You have the unique opportunity to work with modern and highly scalable global systems. You must be an avid technology enthusiast with experience supporting large and dynamic database environments, both physical and cloud-based servers in a production environment and can understand, automate, and troubleshoot large and complex data infrastructure.

Senior Database Engineer is responsible for maintaining and scaling both Oracle, PostgreSQL and other SQL database environments, driving optimization and automation, safeguarding production availability and performance, migrating systems between platforms and clouds, enhancing observability, and guiding both technical standards and cross-team collaboration.

POSITION RESPONSIBILITIES

• Design, implement, and optimize Oracle and PostgreSQL database architectures.
• Collaborate with application teams to understand their requirements and ensure database solutions support application performance and reliability.
• Develop migration strategies, testing plans, and rollback procedures.
• Monitor, troubleshoot, and optimize database performance and scalability.
• Implement security protocols and ensure compliance with data governance standards.
• Lead end-to-end migrations from Oracle to PostgreSQL, ensuring minimal downtime and data integrity.
• Automate routine database management tasks and develop scripts for maintenance and deployment.
• Lead efforts for database backup, recovery, and disaster recovery planning.
• Document database schemas, configurations, and procedures.
• Mentor junior team members and foster best practices across the database team.
• Establish and enforce database standards, policies, and procedures.
• Review and optimize SQL and PL/SQL code for performance improvements.
• Participate in capacity planning and performance tuning to support business growth.
• Stay current with emerging database technologies, trends, and best practices, and recommend innovative solutions.
• Act as a technical lead during cross-team projects involving database design, migration, or integration.
• Provide expert guidance on cloud database architecture, especially AWS RDS and other cloud platforms.

POSITION QUALIFICATIONS

Experience

• Strong knowledge of SQL, PL/SQL, and PostgreSQL extensions.
• Extensive experience with Oracle, SQL Server and PostgreSQL (RDS and Aurora) database management.
• Proven experience in performance tuning, query optimization, and high-availability solutions.
• Experience with cloud database platforms, particularly AWS RDS , or other cloud-based database services, is highly preferred.
• Demonstrated success in leading Oracle to PostgreSQL migrations, with a focus on application-focused migrations.
• Familiarity with cloud architecture, security, and scalability best practices.
• Excellent problem-solving, leadership, and communication skills.
• Ability to lead projects and work collaboratively across teams.
• Experience with Aurora Global Databases to replicate and promote clusters across multiple AWS regions.
• Experience with complex Oracle and PostgreSQL system configuration and tuning for best performance.
• Experience supporting enterprise SaaS environments including production, test, and pre-production
• Maintain relationships with vendors and proactively manage trouble tickets, and follow through to ensure 3rd party work is completed timely, accurately, and cost effectively
• Knowledge of LAN and WAN networks, TCP/IP, DNS, DHCP and
• Knowledge and experience with Containerization (Kubernetes/Docker/etc)
• Familiar with ITSM tools and processes – ITIL Incident/Problem/Change management using Atlassian Jira and/or Confluence
• Technical knowledge of several monitoring and analytics tools such as PRTG, DataDog/NewRelic, Icinga, Solar Winds, Splunk, and AWS Cloudwatch
• Experience maintaining a secure production environment
• Ability to plan, prioritize, and hold self and others accountable to SLAs and schedules
• Effective oral and written communication skills.
• Flexible, versatile, and adaptable to day-to-day activities
• On call Support and maintenance as needed over weekdays and weekends.

Education

• Bachelor's degree in Computer Science, Information Technologies or related field, or an equivalent combination of experience, education, and training

Preferred Skills

• Certifications such as Oracle Certified Professional (OCP), PostgreSQL Certified Professional, or relevant cloud certifications (AWS Certified Solutions Architect).
• Experience with automation tools and scripting languages (Bash, Python, etc.).
• Strong understanding of application development lifecycle and DevOps practices in database management.