Application Database Administrator

Company: University of Maryland
Location: College Park
Posted on: February 5, 2025

Job Description:

This position is responsible for providing comprehensive database management and administration for operational and project support of enterprise level cross-campus services for the University of Maryland. This includes monitoring, analysis, database performance tuning, security and application tools. Configuring and maintaining databases including monitoring of database health, database performance, availability, deployment, backup and recovery, and security. Analyzing and guiding customers SQL queries and scripts. Perform scheduled database maintenance and support for application releases. Other duties as assigned.

Check all associated application documentation thoroughly before clicking on the apply button at the bottom of this description.



The Application Database Administrator (DBA) is a member of Enterprise Data Services (EDS) in the Division of Information Technology (DIT) at the University of Maryland, College Park. The position has responsibility for providing comprehensive database optimization and administration for enterprise level, cross-campus services.



The position is responsible for:

* Configuring and maintaining Multiple RDBMS Postgres, Oracle databases (AWS RDS) , Redshift data warehouse platform, MSSQL (Azure) including monitoring of database health, database performance, availability, deployment, backup and recovery, security (audit), tuning vector data , Optimization and SQL tuning.

* Analyzing and guiding customers with SQL, PostgreSQL Queries for the application requirements which includes writing of SQl ,PL/SQl and PostgreSQL

* Providing 24--7 support for critical production systems.

* Performing scheduled maintenance and support release deployment activities after hours.

* Configuring and maintaining the Denodo data or virtualization tool

* Independently analyzing, solving, and correcting issues on multiple tasks in real time, providing problem resolution end-to-end and prompt customer service.



Essential Duties:

Database Design and Administration: Actively participates in all aspects of the database administration such as design, implementation, delivery and administrative responsibility for monitoring and maintenance 24--7, multi databases (RDBMS) running on AWS RDS (oracle , postgres, Redshift). Participates in integration with applications and Warehouse (Redshift) in cloud services (AWS, Azure). Performs monitoring, troubleshooting and planning for achieving operational availability of the database systems and quality service assurance. Provides documentation to other team members. Participates in after-hours scheduled and emergency support. Performs User and Role Management , Data Source Connection Management , Cache management Query Optimization and Performance Tuning for Denodo Data virtualization tool



Database Maintenance and Optimization: Continuously works on Backup and Recovery of the Database system adhering to the OLA (Office of Legal Audit) policy. Implement backup setup and restore procedures in AWS Oracle RDS. Capacity management and troubleshoot performance issues related to SQl queries and CPU, Disk I/O, memory, user connections and applications data sets. Apply patches and perform database upgrades as per customer requirement. Actively participates in performance tuning (Database tuning and SQL tuning) in AWS RDS databases



Database Deployment and Customer Support: Constantly implements Database deployment changes for all the environments through multiple product lifecycle environments, from development to mission-critical production systems. Implement Denodo setup for Data access. Performs Migration of Data across environments for application support. Continuously works toward improving various services provided to campus customers and partners by performing technical troubleshooting and giving consultation to development teams. Determines root cause and documents production service failures and outages, and provides suggestions on problem remediation. Implements permanent solutions to repetitive issues and automates data administration tasks



Database Security and Compliance: Participate in implementation of database standards to ensure audit compliance by implementing policies and procedures that adhere to the University to meet State and University System of Maryland audit requirements. Work with the infrastructure/ Security team on a regular basis for Security and Risk assessment of the Database systems



Other Duties as Assigned



Physical Demands: Sedentary work. Employee will need to be able to sit for long periods of time to work on a computer, as well as travel occasionally to meet with clients and customers on and off campus. Position also requires being on call to provide some outside of business hours support. This position is considered an essential position and may be required to work at the normal work location or an alternative location during a major catastrophic event, weather emergency, or other operational emergencies to help maintain continuity of University services.



Licenses/Certifications:

* Postgres Certification

* Oracle Certification



Required Application Materials: Resume, Cover Letter, List of References

Best Consideration Date: 02/18/2025 or open until filled

Salary Range: $115,000-$130,000

Please apply at: https://umd.wd1.myworkdayjobs.com/en-US/UMCP/details/Application-Database-Administrator_JR100695?q=JR100695



Essential: This position is considered essential and may be required to work at the normal work location or an alternative location during a major catastrophic event, weather emergency, or other operational emergency to help maintain the continuity of University services.



Visa Sponsorship Information:

* DIT will not sponsor the successful candidate for work authorization in the United States now or in the future.

* F1 STEM OPT support is not available for this position.



Minimum Qualifications:

* Education: Bachelor's degree from an accredited college or university.

* Experience: Four (4) years of professional experience supporting the operations, maintenance, and administration of information technology infrastructure.

* Other: Additional work experience as defined above may be substituted on a year for year basis for up to four (4) years of the required education. Proficient with databases, including configuration, availability, deployment, security (audit) , backup/recovery, and monitoring.

* Expertise in at least two major database platforms (ex. Oracle, Postgres, MySql, etc.)

* Strong written and oral communication skills

* Ability to to lead presentations with small to medium sized groups

* Able to organize and provide direction to junior staff members

* A demonstrated commitment to customer service

* Provides leadership and helps bridge the gap between team manager and team members on technical topics

* Ability to effectively manage workload and delivery assignments on time

* Skilled in the use of office productivity software such as Office 365 or Google Workspaces



Benefits Summary: For more information on Staff Contractual CII benefits, select this link .



Background Checks: Offers of employment are contingent on completion of a background check. Information reported by the background check will not automatically disqualify anyone from employment. Before any adverse decision, the finalist will have an opportunity to provide information to the University regarding disclosable background check information. The University reserves the right to rescind the offer of employment or otherwise decline or terminate employment if the information reported by the background check is deemed incompatible with the position, regardless of when the background check is completed. (EOE)

Keywords: University of Maryland, Bel Air South , Application Database Administrator, IT / Software / Systems , College Park, Maryland