IT Data Base Administrator

$115,000 - $130,000/Yr

University of Maryland - College Park, MD

posted 3 months ago

Full-time - Mid Level
College Park, MD
Educational Services

About the position

The Application Database Administrator (DBA) is a vital member of the Enterprise Data Services (EDS) team within the Division of Information Technology (DIT) at the University of Maryland, College Park. This position is responsible for providing comprehensive database optimization and administration for enterprise-level, cross-campus services. The DBA will manage various database systems, including MSSQL, Postgres, Oracle, and Redshift, ensuring their health, performance, and security. This role requires a proactive approach to database management, including monitoring, backup and recovery, and SQL tuning to optimize database performance. In addition to database management, the DBA will analyze and guide customers in writing SQL, T-SQL, and PostgreSQL queries to meet application requirements. The position demands a commitment to providing 24/7 support for critical production systems, which includes performing scheduled maintenance and supporting release deployment activities outside of regular business hours. The DBA will also implement scripting and automation tasks using tools like SSIS, contributing to the efficiency of database operations. This position is considered essential, meaning the DBA may be required to work at the normal work location or an alternative location during major catastrophic events, weather emergencies, or other operational emergencies to maintain continuity of University services. Being on call during certain periods is also a requirement of this role.

Responsibilities

  • Configuring and maintaining MSSQL (cluster on Prem, Azure, AWS), Postgres databases (AWS RDS), Oracle (AWS RDS), and Redshift data warehouse platform.
  • Monitoring database health, performance, availability, deployment, backup and recovery, and security (audit).
  • Optimizing databases and performing SQL tuning.
  • Analyzing and guiding customers with SQL, T-SQL, and PostgreSQL queries for application requirements.
  • Providing 24×7 support for critical production systems and performing scheduled maintenance after hours.
  • Implementing scripting and automation tasks (SSIS).
  • Working knowledge of AWS and Azure architecture, modern data stack, and tools for the data lifecycle.

Requirements

  • Bachelor's degree required.
  • 4+ years of Database Administration experience primarily with MSSQL, AWS RDS Oracle, and AWS RDS Postgres databases.
  • 1 year experience with Redshift data warehouse platform.
  • 7+ years configuring and maintaining MSSQL databases (including MSSQL cluster), Oracle, and Postgres databases.
  • Experience in monitoring database health, performance, availability, deployment, backup and recovery, security (audit), optimization, SSIS, and SQL/T-SQL tuning.
  • Experience in writing SQL queries, T-SQL scripts, and PostgreSQL.

Nice-to-haves

  • Microsoft Certified: Azure Data Engineer Associate.
  • SQL Server certifications.
  • Postgres Certification.
  • Oracle Certification.

Benefits

  • Medical, dental, and vision coverage designed to help you and your family live a healthy lifestyle.
  • Flexible work opportunities.
  • UMCP Tuition Remission for employees and their dependents.
  • Generous paid time off package to address work/life balance.
  • Retirement Benefits to aid employees in reaching future retirement goals.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service