Datbase platforms developer

SUMMARY
The Database Developer will perform day-to-day database management, maintenance and troubleshooting by providing Tier 1 and Tier 2 support for diverse platforms including, but not limited to, MS SQL, Azure SQL, MySQL,
PostgreSQL and Amazon Redshift.

They are responsible for maintaining functional/technical support documentation
and operational documentation as well as reporting on performance metrics associated with job activity and platform
stability.

Must adhere to SLAs pertaining to data movement and provide evidence and supporting documentation for incidents that violate those SLAs.

Other responsibilities include API development and integrations via Azure
Functions, C# or Python.


Essential Duties and Responsibilities

• Advanced problem-solving skills
• Excellent communication skills
• Advanced T-SQL scripting skills
• Query optimization and performance tuning familiarity with traces, execution plans and server
logs
• SSIS package development and support
• PowerShell scripting
• Report visualization via SSRS, Power BI and/or Jupityr Nootbook
• Maintain functional/technical support documentation
• Maintain operational documentation specific to automated jobs and job steps
• Develop, implement and support user defined stored procedures, functions and (indexed) views
• Monitor database activities and provide Tier 1 and Tier 2 production support
• Provide functional and technical support to ensure performance, operation and stability of
database systems
• Manage data ingress and egress
• Track issue and/or project deliverables in Jira
• Assist in RDBMS patching, upgrades and enhancements
• Prepare database reports for managers as needed
• API integrations and development
Background/Experience
• Bachelor or advanced degree in computer science
• Microsoft SQL Server 2016 or higher
• Working knowledge of MySQL, PostgreSQL and/or Amazon Redshift
• C# and/or Python


Supervisory/Budget Responsibility

• No Supervisory Responsibility/No Budget Responsibility


Level of Authority to Make Decisions

The Database Developers expedite issue resolution pursuant to the functional/technical documentation available.

Issue escalation is at their discretion and should result in additional functional/technical documentation for future
reference.

However, individual problem solving, decision making and performance tuning will constitute 75% of their time.