Database Administrator I

Company: Texas A&M University
Location: College Station
Posted on: August 1, 2020

Job Description:

Job TitleDatabase Administrator IAgencyTexas A&M UniversityDepartmentAcademic Affairs Recruiting OfficeProposed Minimum SalaryCommensurateJob LocationCollege Station, TexasJob TypeStaffJob Description

Our Commitment

Texas A&M University is committed to enriching the learning and working environment for all visitors, students, faculty, and staff by promoting a culture that embraces inclusion, diversity, equity, and accountability. Diverse perspectives, talents and identities are vital to accomplishing our mission and living our core values.

Who we are

The Provost IT Office provides information technology support for the Provost Office and all units that report to the Provost except for academic and Division of Information Technology units and offices. The Provost IT Office services 48 offices. PITO is responsible for the management of IT operations and provides IT services and support, information system design, IT consultation, project management, IT security reviews, and IT contracts and vendor management. The office manages and maintains more than 1,400 desktops across 13 buildings on campus. Through Instructional Media Services, the department supports AV in 181 classrooms and 22 conference rooms in 35 buildings across Texas A&M.

The Academic Affairs Recruiting Office assisted with the creation and posting of this job requisition for the Provost IT Office.

What we want

The Database administrator I performs performs routine database development and administration support functions at Texas A&M University and provides client and technology support to users of custom databases and database applications. Our selected candidate will subscribe to and support our commitment to Inclusion, Diversity, Equity and Accountability (IDEA) as stated above. If the above description sounds interesting to you, we invite you to apply to be considered for this opportunity.

What you need to know

COVID-19 information:Texas A&M University monitors and updates our recruiting, hiring and onboarding processes to align with local, state and federally mandated health guidelines to keep employees, prospective employees, and visitors as safe as possible. Each department has established both remote and in-person procedures for conducting these processes, which include sanitizing common spaces, a mask policy, and maintaining safe physical distancing to the extent possible. Departments will provide the procedures to be followed at each step of the recruiting process.

Required Education and Experience:

• 
  
• Bachelor's degree or any equivalent combination of education and experience
• Two years of related experience in database architecture and administration
  
  Required Knowledge, Skills, and Abilities:
  
  • 
    
  • Must be able to work well in a collaborative team environment
  • Must be detail oriented and have excellent interpersonal skill
  • Ability to meet deadlines and maintain a high level of accuracy, professionalism, and customer service orientation
  • Ability to multitask and work cooperatively with others
    
    Other Requirements or Other Factors:
    
    • 
      
    • Position is required to work outside regularly scheduled hours as determined by supervisor (in cases of critical system upgrades, critical system support, and/or the timely completion of major information technology projects)
      
      Preferred Experience:
      
      • 
        
      • SQL Server, Oracle, MySql, and Mainframe experience.
        
        Preferred Special Knowledge, Skills, and Abilities:
        
        • 
          
        • Microsoft SQL Server, Oracle, SSIS, T-SQL, PL/SQL, Tableau, Visual Studio
          
          Responsibilities:
          
          • 
            
          • Database Development & Testing - Write, update, and test T-SQL queries and joins. Designing and modifying normalized databases. Programming and testing changes to views, stored procedures, and functions. Developing new and modifying existing data extraction, transformation, and loading (ETL) processes using SQL Server Integration Services (SSIS). Write and update reports. Develop and test using database tools: SQL Server Management Studio, Microsoft Visual Studio, and Red Gate Deployment tools.
            
            
            • 
              
            • Database Administration - Synchronize and migrate data and database objects between development, quality assurance, and production environments using database synchronization tools. Perform SQL query tuning. Assist lead database administrators with activities associated with the installation, management, security, database backup/recovery, and operation of database platforms. Use database administration tools SQL Server Management Studio, SQL Server Profiler, and Red Gate Database tools.
              
              
              • 
                
              • Requirements Analysis - Consult with customers to gather and analyze business requirements (work items) for designing database reports, objects, and storage. Track work items according to internal procedures.
                
                
                • 
                  
                • Procedures & Reports - Utilize internal system and database standards. Document database designs, functions, procedures, deployments, and ETL packages. Follow internal project and change management procedures. Complete reports and summaries for management and/or users including status reports, problem reports, progress summaries, and system utilization reports.
                  
                  
                  • 
                    
                  • Client & Technology Support - Establish business relationships with both internal and external clients. Attend meetings. Answer questions and provide technical guidance and/or training to clients to ensure the success of databases and database applications.
                    
                    
                    • 
                      
                    • Professional Development - Learn new advancements in database technologies, database development techniques, and work processes as directed by supervisor. Keep current in growth as a professional database administrator through a combination of reading online blogs and articles, watching videos and seminars; reading books; conversing with fellow database administrators; and instructor led training. Perform other duties as assigned.
                      
                      Instructions to Applicants: Applications received by Texas A&M University must either have all job application data entered or a resume attached. Failure to provide all job application data or a complete resume could result in an invalid submission and a rejected application. We encourage all applicants to upload a resume or use a LinkedIn profile to pre-populate the online application.
                      
                      All positions are security-sensitive. Applicants are subject to a criminal history investigation, and employment is contingent upon the institution's verification of credentials and/or other information required by the institution's procedures, including the completion of the criminal history check.
                      
                      Equal Opportunity/Affirmative Action/Veterans/Disability Employer committed to diversity.Apply now

Keywords: Texas A&M University, College Station , Database Administrator I, IT / Software / Systems , College Station, Texas