What are the responsibilities and job description for the Database Administrator/Analyst position at William & Mary?
Position Information
Position Number
FP147V
Position Title
Database Administrator/Analyst
Employment Category
Full Time Professional
Location
VIMS - Gloucester
Department
111820 ITNS
Unit Mission Statement
The mission of the Virginia Institute of Marine Science and the Batten School of Coastal and Marine Sciences is to seek and broadly communicate knowledge in marine and coastal science to the Commonwealth of Virginia, the nation, and the world through research, education, and advisory service.
Information Technology and Network Services facilitates the missions of VIMS/Batten School (education, research, and advisory services) and enhances the productivity of the VIMS/Batten School community (faculty, staff, and students) through information technology.
Information Technology and Network Services facilitates the missions of VIMS/Batten School (education, research, and advisory services) and enhances the productivity of the VIMS/Batten School community (faculty, staff, and students) through information technology.
Position Summary
The Database Administrator/Analyst manages and organizes electronic data according to Institute data administration policies and standards to develop and maintain databases and web interfaces in support of the Institute’s advisory, scientific, educational, and administrative units and ensure that the information needs of Institutional users are met. This position reports to the Senior Database Administrator/Analyst at VIMS/Batten School.
Core responsibilities include but are not limited to:
Development:
- Database project planning and implementation to include needs-analysis, scope definition, design, and execution plan.
- Deployment of database solutions along with logical infrastructure, including requisite hardware and software.
- Design digital interfaces for users and administrators that optimize business processes.
- Migration of bespoke legacy systems to SQL.
Maintenance:
- Monitor system integrity, including data integrity, security, and performance.
- Apply security policies, standards, and practices at both application and server level.
- Maintain database systems software, including upgrades, patching, performance tuning, disaster recovery and backup.
Coordinated support:
- Provide problem analysis and management, including communication of issues and solutions with team members and appropriate staff.
- Provide system and user support by analyzing, documenting, and tracking reported system problems while providing timely solutions.
- Coordinate with other ITNS staff when necessary to provide solutions for the installation, enhancement, troubleshooting and repair of network assets and resources.
- Provide consulting and training services for other members of the VIMS Community and ITNS Staff as appropriate.
- Provide consultation and industry standard solutions in configuring network systems and applications.
Conditions of Employment
- This position is subject to additional hours beyond the typical workday/week, to include evenings and weekends, in order to meet the business needs of VIMS.
- This position requires administrative access to VIMS’ information systems and/or sensitive data. The incumbent is expected to be aware of and adhere to the Information Security policies of VIMS and William & Mary (W&M)as well as all applicable federal, state, and local laws and follow information security best practices applicable to their job area and to pursue information security training and awareness opportunities when possible.
Essential Designation
No
FLSA
Exempt
Position Restricted?
Yes, the appointment is limited due to funding availability
Position Term
Position Months
Faculty or Staff: 12 month
Required Qualifications
- Bachelor’s degree in Information Science or related field or the equivalent combination of education and experience.
- Experience with advanced relational database administration and management tools.
- Experience developing applications to support and enhance internal business rules, data flow considerations and strategies, and logical structure.
- Experience with security policies, standards, and practices at both an application and server level.
- Able to develop strategic enterprise-level IT solutions using contemporary methodologies with in-depth analysis, attention to detail, and best practices encompassing user acceptance testing, quality assurance, and usability testing.
- Relational database administration and management skills.
- Strong working knowledge of database systems, with the proven ability to maintain database systems software, including upgrades, patching, performance tuning and disaster recovery and backup with the demonstrated ability to administer server platforms hosting database services.
- Working knowledge of security policies, standards, practices at both an application and server level.
- Strong database and application skills with the ability to design and implement database systems and develop applications to support and enhance internal business rules, data flow considerations and strategies, and logical structure.
- Excellent analytical and problem-solving skills with the demonstrated ability to review, analyze, and evaluate institutional information systems and user needs.
- Strong planning and writing skills with the ability to document requirements, define scope and objectives, with the skill to formulate systems to parallel overall business strategies, and the ability to provide system and user support by analyzing, documenting, and tracking reported system problems while providing timely solutions.
- Excellent interpersonal, oral, and written communication skills with the ability to effectively communicate and collaborate with users across campus as well as work as a cohesive team member.
- Strong forecasting and organizational skills, with the ability to manage multiple priorities within deadlines including change management and status reporting.
- Ability to prepare technical documentation.
Preferred Qualifications
- Master’s degree in Information Science or related field
- Data Management Certification highly preferred
- PMP Certification
- Experience with Workday ERP
- Familiarity with web design with the ability to update and maintain sites/pages
- Proficient in Quality Assurance (QA)
- High Attention to Detail
- Proficient in Software Development Life Cycle (SDLC) including usability testing
- Knowledge of GIS software
- Experience with MS SQL Server, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Migration Assistant (SSMA), MS Excel, and MS Access
- Substantive in the design and implementation of database systems and associated hardware and software
- Experience in higher-education setting providing IT solutions in a customer service driven environment
- Familiarity with collaboration tools, such as MS Teams, MS SharePoint, MS OneDrive, JavaScript, VBA, HTML, and Application Programmable Interface (API) calls
- Adobe ColdFusion experience
- GIS experience
Is the position remote work eligible?
Not eligible
Remote Work Disclaimer
Remote work eligibility is not guaranteed and is subject to approval. Employee eligibility depends on the likelihood of the employee succeeding in a remote work arrangement and the supervisor’s ability to manage remote workers. Departments and/or Human Resources may amend, alter, change, delete, or modify eligibility.
Advertised Pay Range
Up to $75,000
Advertised Pay Range Statement
All hiring rates are commensurate with relevant experience up to the advertised amount considering internal alignment.
University Salary Range
U13
Benefits Summary Statement
William & Mary offers our employees a full array of benefits including retirement, health insurance with options for expanded dental and vision along with group and optional life insurance with coverage for spouse and children, flexible spending accounts, and an EAP (Employee Assistance Program).
Our employees enjoy additional university benefits such as educational assistance, professional development, wellness benefits, and a robust holiday schedule. All employees have access to fitness facilities on campus. Staff members also have access to the university libraries, and much more. To learn more, go to: https://www.wm.edu/offices/uhr/benefits/index.php?type=none
Our employees enjoy additional university benefits such as educational assistance, professional development, wellness benefits, and a robust holiday schedule. All employees have access to fitness facilities on campus. Staff members also have access to the university libraries, and much more. To learn more, go to: https://www.wm.edu/offices/uhr/benefits/index.php?type=none
Job Open Date
02/11/2025
Review Begin Date
Job Close Date
03/07/2025
Open Until Filled
No
Special Application Instructions
We will not sponsor applicants for work visas for this vacancy.
Background Check Statement
William & Mary is committed to providing a safe campus community. W&M conducts background investigations for applicants being considered for employment. Background investigations include reference checks, a criminal history record check, and when appropriate, a financial (credit) report or driving history check.
EEO Statement
William & Mary values diversity and invites applications from underrepresented groups who will enrich the research, teaching and service missions of the university. The university is an Equal Opportunity/Affirmative Action employer and encourages applications from women, minorities, protected veterans, and individuals with disabilities.
Salary : $75,000
