Job Description:
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