Database Engineer - L3

Job Summary

We are looking for a Database Engineer to design, operate, and optimize reliable database platforms for business-critical applications. The role will manage schema and performance improvements, backup and recovery, security, monitoring, automation, troubleshooting, and collaboration with development teams on efficient data access patterns.

Responsibilities

• Monitor database management systems as well as evaluating database performance to maximize efficiency
• Work in an environment that practices strict change management
• Provide recommendations and participate in design session with engineering teams for data restructuring and performing complex maintenance
• Deploy and manage changes in lower environments, staging and production
• Assist engineers and product owners on SQL queries and tuning
• Perform scheduled maintenance
• Strong on T-SQL methods for optimization of existing complex stored procedures for performance improvements and contention resolution
• Rewrite stored procedures when necessary
• Manage database install, configure, monitor and upgrade towards production and non-production environments
• Perform and propose archiving, partitioning
• Implement technical support for enterprise monitoring, backup, alerting and security compliance for SQL instances
• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues
• Actively seek to optimize and simplify our architecture
• Take ownership of performance and capacity monitoring aspects of the DB
• Assist the infrastructure team in sizing hardware used for the DB
• Plan work to meet project deadlines, accommodate demands by development teams, set priorities and escalate issues appropriately

Requirements

• Relevant experience of 6-10 years
• Expertise in MS SQL Development and Administration
• Expertise in import and export activity and MS SQL Server
• Expertise in SQL Programming skills
• Design and implementation of Data Partitioning
• Optimization of hardware configuration to SQL configuration
• Experience in SQL Database Administrator (SQL DBA)
• Experience in PowerShell Automation in automating SQL Server related tasks
• Ability to participate in multiple projects concurrently
• Working knowledge of Agile/Scrum and participates in all Agile/Scrum ceremonies
• Excellent communication skills (verbal, written and presentation), customer service-oriented
• Strong problem-solving skill set, and the ability to understand new technologies quickly
• Retail and wholesale petroleum industry knowledge & experience is good to have

Skills

• MS SQL Development
• MS SQL Administration
• SQL Programming
• Data Partitioning
• PowerShell Automation
• Agile/Scrum
• T-SQL
• SQL Queries and Tuning
• Backup and Recovery

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.