Senior Systems Analyst

req7362

Richmond, Virginia, United States, 23284

Virginia Commonwealth University

Position Summary

Virginia Commonwealth University (VCU) is seeking a skilled and experienced Database Administrator to join our Computer Center team. The successful candidate will be responsible for delivering top-notch solutions and services to ensure the advancement and success of the University community.

Key Responsibilities

Performance, Security, and Availabilit y: Ensure the performance, security, and availability of our Microsoft SQL Server databases, spanning versions 2016 to 2022.
Database Design and Maintenance : Design, implement, and maintain databases to meet business needs.
Monitoring and Maintenance : Monitor and maintain database-related technologies, including data replication, clustering, and high availability solutions.
Database Objects Management : Create and manage database objects such as tables, indexes, and constraints.
Data Integrity and Consistency: Ensure data integrity and consistency by monitoring database performance and conducting regular backups and restores using Cohesity.
Performance Optimization: Optimize database performance by analyzing query execution plans and making appropriate adjustments to database configuration and schema design.
Security Measures: Collaborate with the University Information Security team and support VCU security policies and industry best practices, including regular security assessments and vulnerability management / remediation. Implement and maintain database security measures, including user permissions and access controls.
Upgrades and Migrations : Plan for and implement database upgrades and migrations.
Troubleshooting : Troubleshoot and resolve database issues, such as performance bottlenecks, data corruption, and connectivity problems.
Disaster Recovery: Assist with crafting and contributing to the continuous development and maintenance of disaster recovery plans and procedures to ensure continuity of University operations. Support the testing and successful execution of these plans when called upon to do so.
Collaboration: Collaborate with development teams to design and implement database changes that support application requirements. Build strong professional relationships and work closely with cross-functional teams, including application developers, system owners, server operating system and data center network engineers, information security analysts, etc. to deliver integrated solutions.
Technical Support and Assistance: Provide consultative and technical support to the user community to ensure problem resolution, system / data access, and optimal system performance. Provide technical advice and expertise to customer departments. (SSRS, SSIS, and SSMS)
Technical Knowledge Expertise and Training: Maintain a current level of knowledge on topics within the computer industry, including but not limited to attending classes, seminars and vendor presentations, reading manuals and trade journals, use of the Internet, and conversing with peers. Provide training and documentation to transfer this knowledge to other team members.
Documentation: Create, maintain, and adhere to comprehensive documentation related to database design, configuration, and operations. Utilize established VCU Technology Services, Infrastructure Services, University Computer Center, and Enterprise Platform team processes and tools for project management, technology change management, incident reporting, and more as an integral part of all support activities.
Data Connections: Manage data connections to Oracle sources while utilizing Open Query commands.

Each agency within the Commonwealth of Virginia is dedicated to recruiting, supporting, and maintaining a competent and diverse work force. Equal Opportunity Employer

Apply Now

Already applied for a job?

Sign up for job alerts

Categories 575bef8e

Employment Type 2e058e0b

Locations 2e81928a

Agency 94110b21

Not You?

Thank you

Share this job

Thank you for sharing this job

Apply Now

Thank you

Senior Systems Analyst