Job Openings IT Database Administrator II

About the job IT Database Administrator II


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.


  • 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.


  • 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