What are the responsibilities and job description for the Senior Database Administrator position at OKLAHOMA STATE UNIVERSITY ALUMNI ASSOCIATION?
Job Title: Senior Database Administrator
Reports To: Vice President of Finance and Operations
FLSA Classification: Exempt
Nature of Work:
The Senior Database Administrator designs, implements, and maintains databases in accordance with organizational needs. This position develops and/or maintains various data systems for daily business.
Responsibilities:
Program Management
- Develop and maintain automated business process programs
- Review, analyze, and evaluate database systems and user needs to provide recommendations and solutions parallel to overall business strategies
- Develop programs and systems to synchronize data between the Alumni Association website and other data systems
- Create, maintain, and execute data warehouse queries
- Process data requests and develop custom reports utilizing data from multiple sources, including the Alumni Association constituent database
- Provide in-house expertise and technical support to end users on database, software, and desktop-related issues:
- Identify, research, and resolve technical problems, working with outside vendors/technical support as needed, and documenting, tracking, and monitoring problems to ensure a timely resolution
- Procure, provision, and manage staff hardware, including laptops, monitors, and peripherals
- Provide technical guidance to OSUAA Information Services team
- Perform other duties as assigned
Organizational Strategy
- Train staff in the use of the Alumni Association's standard software applications/databases, as needed
- Collaborate with the OSU Foundation and OSU Information Technology to remain informed on software projects, updates, upgrades, and additional services, including the use of AI technology
- Maintain goals and objectives by providing data and analytics for information services supporting alumni association programs
- Provide excellent customer service to all constituents requesting queries and IT support
- Facilitate the effectiveness of the Information Services team
Qualifications:
Job Competencies and Experience:
Education
A bachelor's degree is required, preferably in Management Information Systems or computer science with an emphasis in database management.
SQL database experience and object-oriented programming experience are required.
Experience
Five or more years of experience in information technology, database management, or data analytics.
Skills:
- Experience using a production environment and automating data flows between diverse data systems
- Experience writing SQL queries and delivering data to stakeholders
- Analytical skills to evaluate current systems
- Familiarity with AI tools, specifically Microsoft Copilot
- Strong communication skills
- Ability to prioritize workload and complete activities without close supervision
Core Competencies:
- Effective Communication: Promotes the timely, seamless flow of high-quality information throughout and beyond the organization while encouraging the open exchange of ideas and opinions.
- Execution & Initiative: Makes decisions authoritatively and wisely, after adequately contemplating various available courses of action
- Teamwork & Interpersonal Skills: Fosters development of a common vision; coaches, motivates, encourages and gains support to accomplish specific goals
- Problem Solving & Judgement: Makes decisions on sound reasoning, evaluation of facts and consideration of alternatives; negotiates between disagreeing viewpoints with tact and diplomacy
- Adaptability: Changes behavioral style or method of approach when necessary to achieve a goal; adjusts style as appropriate to the needs of the situation
Equipment Used:
- Snowflake
- Workato
- Ascend/Salesforce database
- Tableau
- Microsoft Visual Studio Code
- Microsoft Office Suite
- Microsoft Copilot
- Encompass web platform
Work Environment:
The position is in an office setting within the OSU Alumni Center. Events and activities may be held outside, so there will be some outdoor exposure. The position requires availability to work nights and weekends, as determined by event scheduling. Travel may be required in and out of state.
Physical Demands:
- Position needs to move about inside the office to access file cabinets, office machinery, etc.
- Position needs to be able to transport parcels, packages, and other items short distances, and drive a vehicle to deliver and pick up material
- Position frequently communicates with staff and must be able to exchange accurate information
- Frequently move items weighing up to 50 pounds
Special Condition for Employment: Successful completion of a background check
This job description is not designed to cover or contain a comprehensive list of activities, duties, or responsibilities required of each employee. Duties, responsibilities, and activities may change, or new ones may be assigned at any time with or without notice.