Database Administrator

Position Summary:

The Database Administrator (DBA) is responsible for the deployment, administration, maintenance & technical support for all database environments. Investigate operational or systematic problems, provide resolution using advanced analytical skills and tools as well as be responsible for analyzing database performance issues & recommending tuning changes to improve performance. Works closely with development teams and senior architects to design and implement hybrid cloud and cloud native solutions using Azure infrastructure, platform and software as a service (IaaS, PaaS, SaaS) offerings as well as other cloud-based SaaS tools. Works with Identity & Access Team to provide access and maintain database security.

Essential Job Functions:

• Involved in the design, implementation, security, scaling, and support of SQL Server & Azure SQL workloads.

• Assists with environment/database refreshes.

• Troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (i.e. SQL cluster, Always On, Log Shipping, DB replication) and other issues in production and development.

• Monitor and maintain database security & perform DB user/service account administration.

• Actively monitor overall SQL system health, database performance and schema review following best practices

• Database software and server installation, migrations, configuration and management

• Assists with Installing changes to database software, service packs and hot fixes as needed.

• Database backups, restores, consolidation and reorganization.

• Optimizes and tunes database systems to maximize their performance and operation.

• Defines and improves the overall release process for database systems.

• Monitor and support existing product and custom developed databases.

• Troubleshoot production support issues post-deployment and come up with solutions as required.

• Write T-SQL code and stored procedures to monitor, automate and support DBA tasks.

• Ability to provide code review and offer suggestions for improvements to T-SQL code and stored procedures.