IT Database Administrator II

Background:

The IT Database Administrator II will implement and manage the operational aspects of cloud-native and hybrid data platform solutions built with Microsoft SQL Server and Microsoft Azure Data Services. This role will use a variety of methods and tools to perform day-to-day operations, including applying knowledge of using T-SQL for administrative management purposes.

The IT Database Administrator II will be involved in the maintenance, deployment, and monitoring of database systems while ensuring security and a high level of data availability. This individual will be responsible for delivering high-quality, timely solutions and services through the full lifecycle, including development, testing, and implementation.

Responsibilities:

• Writes solid queries, stored procedures, functions, and triggers.

• Ensures accurate database indexing, archiving, reporting, and automation.

• Participates in periodic performance reporting, trend analysis to support in growth monitoring and capacity planning.

• Develops and supports ETL processes.

• Monitors database operations and performance using native and 3rd-party tools.

• Troubleshoots data-related issues while maintaining data integrity and accuracy.

• Evaluates database performance and analyzes drifts based on known baseline data.

• Participates in continuous improvement efforts in enhancing database performance and providing increased functionality, including performing maintenance, tuning, indexing, monitoring activity, and documenting problems, changes, and solutions.

• Arranges the implementation, administration, and usage of industry tools like SQL Server Management Studio, SQL Server Reporting Services, Google BigQuery.

• Plans and manages capacity of database management systems.

• Ensures appropriate jobs are scheduled to maintain nightly maintenance jobs.

• Documents database configuration and on-going management of configuration, continuous review of existing and creation of new database processes and procedures, periodic entitlement reviews.

• Ability to stay up to date with current trends and enhancements in the systems assigned that may add value to ATC.

• Looks for and proposes opportunities for ATC where the assigned system may be used in novel ways to competitively differentiate or accelerate ATC growth, market share and/or margins.

Requirements:

• Bachelors Degree in Computer Science, Information Technology, or related field

• 3-5 years of experience in a database administration/data engineering role

• Previous knowledge of IT concepts such as Database design, layout, structures, stored procedures, tables, optimization, TCP/IP, backup and restore, IT security concepts and practices is required

• 3 years or more of experience in at least one of the following:

o Microsoft SQL Server

o 3 years or more of experience:

o Writing stored procedures, queries, functions, and triggers in T-SQL

o Monitoring, troubleshooting and performance tuning database operations

o Delivering database code via CI/CD

o Troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention issues, resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues, etc.

• 3 or more years of experience in the full software development lifecycle

• 1 or more years of experience working with cloud technologies (plus for Microsoft Azure)

• Familiarity with SSIS, SSRS and other ETL application support

• Experience in at least one Agile software development methodology (e.g. Scrum, Kanban)

• Strong collaboration and communication skills

• Ability to engage throughout the department and the company to achieve goals