Responsibilities
The Senior Database Administrator will manage and support the SQL landscapes within the environment
This role will coordinate and work with other team members on the technical design, development and ongoing improvements relating to our SQL needs
Demonstrate safety as a core value and establish a safe work environment by Setup and administering of high availability, redundancy, security ann and non-production environments
Monitor and respond to all issues to ensure success of all scheduled jobs
Execute database related activities for changes to all database objects primarily in OLTP designs
Performance tuning (SQL query, stored procedures & DB engine)
Must have python, Linux and shell scripting experience.
Must have data warehouse, ETL experience.
Must be proficient in T-SQL.
Assist development teams in creating database procedures and triggers
Ability to identify production performance issues, blocking and deadlocks and long running queries
Aid with client problem escalation where applicable
Participate in our monthly release process
Ability to effectively communicate and document designs, processes and work
Develop, document and institute best practice of performance monitoring of all relational databases
Must have experience and be available to provide support in a 24X7 environment.
Additional Qualifications:
able to understand the dependencies that require SQL services and can take technical ownership of the SQL landscape
able to work within a team and ensure that SQL services are available for our needs and that the technology grows to the needs of the company
able to adapt to change and be willing to understand how SQL services are being consumed and not only provide best practices, but mentor and guide others on how best SQL can be used
willing to learn and expand their knowledge outside of just supporting SQL
Last updated on Jul 1, 2022