Application Database Administrator

Posting DetailsPosting DetailsPosition Number:129257Title:IT Data Base AdministratorFunctional Title:Application Database AdministratorCategory Status:35-Exempt Contingent Category 2Applicant Search Category:StaffUniversity Authorized FTE:1.00Unit:DIT-EE-Enterprise Data ServicesCampus/College Information:Founded in 1856, University of Maryland, College Park is the state's flagship institution. Our 1,250-acre College Park campus is just minutes away from Washington, D.C., and the nexus of the nation's legislative, executive, and judicial centers of power. This unique proximity to business and technology leaders, federal departments and agencies, and a myriad of research entities, embassies, think tanks, cultural centers, and non-profit organizations is simply unparalleled. Synergistic opportunities for our faculty and students abound and are virtually limitless in the nation's capital and surrounding areas. The University is committed to attracting and retaining outstanding and diverse faculty and staff that will enhance our stature of preeminence in our three missions of teaching, scholarship, and full engagement in our community, the state of Maryland, and in the world.Background ChecksOffers of employment are contingent on completion of a background check. Information reported by the background check will not automatically disqualify someone from employment. Prior to any adverse decision, finalists have an opportunity to provide information to the University regarding the background check.The University reserves the right to rescind offers 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.Offers are contingent on providing proof of employment eligibility in the United States no more than 3 days after the initial start date. If this proof is not provided within this timeframe, the offer may be rescinded or employment terminated.Position Summary/Purpose of Position: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 MSSQL (cluster on Prem, Azure, AWS) , Postgres databases (AWS RDS) ,Oracle (AWS RDS) and Redshift data warehouse platform, including monitoring of database health, database performance, availability, deployment, backup and recovery , security (audit), Optimization and SQL tuning.• Analyzing and guiding customers with SQL , T-SQL , PostgreSQL Queries for the Application requirements which includes writing of SQL , T-SQl and PostgreSQL• Providing 24x7 support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours.• Working knowledge of AWS and Azure architecture, modern data stack and tools for the data lifecycle.• Implementing scripting, and automation tasks (SSIS)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. This position also requires being on call during certain periods.Benefits SummaryTop Benefits and Perks:Contingent II Benefits SummaryMinimum Qualifications:Education:Bachelor's degree required.Experience:• 4 plus years of Database Administration experience primarily with MSSQL , AWS RDS Oracle and AWS RDS Postgres Databases.• 1 year experience of Redshift data warehouse platform.• 7 plus years configuring and maintaining MSSQL databases (including MSSQL cluster), Oracle , Postgres databases including monitoring of database health, database performance, availability, deployment, backup and recovery, security (audit), Optimization, SSIS and SQL/ T-SQL tuning.• Experience in Azure and AWS database architecture, Warehouse data stack and tools for the data lifecycle.• Experience in writing SQL queries , T-SQL scripts and PostgreSQL.Knowledge, Skills, and Abilities:• Working knowledge of AWS and Azure architecture, warehouse data stack and tools for the data lifecycle.• Skilled in SQL, T-SQL/PostgreSQL query tuning and Database Tuning, Analyze database performance reports and Recommend best practice for SQL code deployment in production environments for database optimization.• Ability to work independently and concurrently on multiple projects, adjust rapidly to occasional significant changes in priorities, and respond efficiently and effectively 24 by 7 for critical production systems.Preferences:Preferences:• Microsoft Certified: Azure Data Engineer Associate.• SQL Server certifications.• Postgres Certification.• Oracle Certification.Additional Certifications:Additional Information:Benefits Included:• 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 to grow and achieve greatness.• Generous paid time off package to address work/life balance and maintain well-being.• Retirement Benefits created to aid employees in reaching future retirement goals.• And many more...Salary range $115,000-$130,000• *This position does not provide sponsorship for Visas.Job RisksNot Applicable to This PositionPhysical 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 servicesPosting Date:08/12/2024Closing Date:Open Until FilledYesBest Consideration Date09/02/2024Diversity Statement:The University of Maryland, College Park, an equal opportunity/affirmative action employer, complies with all applicable federal and state laws and regulations regarding nondiscrimination and affirmative action all qualified applicants will receive consideration for employment. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, religion, sex, national origin, physical or mental disability, protected veteran status, age, gender identity or expression, sexual orientation, creed, marital status, political affiliation, personal appearance, or on the basis of rights secured by the First Amendment, in all aspects of employment, educational programs and activities, and admissions.