Database administrator, DBA

Job Summary:
The DBA is a key member of the Technology team
We are looking for a highly motivated, detail-orientated and reliable self-starter.
This position will be a member of a high-performing technology team.
Specifically, this position will be to perform the database administration, query
development and tuning, developer query code review and coach teams on how
to apply the principles of data management and query.

Responsibilities:
- Effectively manage day-to-day tasks in coordination with a team of
developers and stakeholders to meet deliverables.
- Strong programming capabilities in SQL and other DB technologies– Stored Procedures, Functions, Triggers, Views, Transactions, Data Flow.
- Participate in the physical database design process. Ensures databases
provide required functionality to meet identified business needs.
Implements databases for testing and production.
- Assist in monitoring capacity and performance for test and production
databases to ensure they are reliable, efficient, cost effective, and provide
the required functionality.
- Create and maintain appropriate documentation (Database, Architecture,
etc.)
- Assist in analyzing and diagnosing problems reported to the support and
operations teams
- Work with the DBA team in the data modelling and database design of
product and efficient SQL for fast application performance, including
advanced architectural techniques.
- Assist in DevOps, working with Architects and Engineers to automate code
promotion and deployment up the stack of environments, ensuring
successful, repeatable deployments through Production, with consistent
quality.
- Performance Optimization – Performance monitoring, measurement and
capacity planning of Production Software solutions, recommending changes
to products and “standardized” System configurations.
- Participate in regular code review for all new code deployment efforts as
code is advanced through the development life cycle.

- Accurately estimate efforts and fully participate in Scrum ceremonies
- Stay current with the database technologies, both SQL and NoSQL.

Qualifications/Experience
- 5+ years database product knowledge preferred
- Cloud based SQL and NoSQL knowledge and experience strongly preferred
- Experience with debugging and performance tuning of SQL code, Stored
Procedures, Functions, and Indexes.
- Advanced data storage and retrieval mechanisms strongly preferred.
- Exposure to at least 1 NoSQL database technology (e.g. Cosmos DB)
- Azure Cloud experience/SQL Server on VM/Managed DBs/Azure SQL.
- Experience with DataFactory (Azure)
- Experience with SQL Server Integration Services (SSIS), SQL Server Analysis
Services (SSAS), SQL Server Reporting Services SSRS.
- Exposure to Power BI
- Experience with JIRA and Confluence required