| Production Support - Perform routine and non-routine database maintenance and upgrades to make systems more secure and efficient, and to adapt them to any new requirements.
- Document processes and train BI Database Developers to ensure they fully understand and can perform maintenance on all of NGL’s SQL databases and database applications.
- Anticipate system/application challenges and propose solutions; recommend improvements to existing database servers and software as necessary.
- Ensure all database servers are backed up, Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
- Plan and perform maintenance of NGL’s SQL databases and database applications.
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
- Install and configure new SQL Servers,
- Troubleshoot and resolve outages and database issues for both internal and third-party business customers, including after-hours and weekends.
- Assist with issue identification, investigation, and resolution process of support incidents.
- Provide off-hours support of scheduled production processing and system maintenance.
M&A Support - Collaborate with the team and business areas to develop, coordinate and execute plans to ensure successful acquisition project. Identify new data sources, data redundancy, and develop plans to incorporate data into enterprise data environment.
- Participate in efforts to convert and implement merged or acquired business.
| Other - Share ownership of the solution deployment, testing, quality, monitoring and operational excellence with the rest of the team.
- Participate in team ceremonies, meetings, and presentations to stakeholders.
- Continually develop skill-sets and abilities to keep them relevant, current and applicable to NGL's current and future needs.
- Follow software development life cycle and quality assurance best practices and governance.
- Ensure data security and data privacy stay top of mind across team
- Perform other duties and responsibilities as needed.
- Mentor peers in Data Engineering and best practices / patterns
- Follow software development life cycle and quality assurance best practices and governance.
- Ensure data security and data privacy stay top of mind across team
- Perform other duties and responsibilities as needed.
- Mentor peers in Data Engineering and best practices / patterns
| What you’ll bring: - Critical thinking; analytical, decision-making, and problem-solving skills; strong technical and non-technical communication (verbal and written) and interpersonal skills; ability to work independently and in a team; excellent organizational skills and time/priority management; ability to understand high-level architecture and design content, and how it relates to implementation deployment; advanced knowledge and understanding of relevant business and system operations, policies, and procedures; ability to disagree with coworkers and come to an agreement.
- Preferred: Bachelor's degree in Computer Science Information Technology/systems, or other related field, or 5 years equivalent work experience.
| - PostgreSQL and Transact-SQL
- Python
- Tableau
- AWS Glue, Lambda, S3, Redshift, EC2
- Transact-SQL and SQL Server Management Studio
- SSIS/ SSRS development
- SSAS Multidimensional and Tabular
- Iac using CloudFormation or Terraform??
| | |
