A Commonwealth of Virginia Website
Virginia Mountain View

SQL Engineer Intermediate

Charlottesville

SQL Engineer Intermediate

  • R0043324
  • Charlottesville, Virginia, United States
  • Information Technology
  • UVA Medical Center
Performs advanced implementation/support for systems application and monitoring. Responsible for installing configuring and maintaining operating system workstations and servers including web servers in support of business processing requirements. Performs software installations and upgrades to operating systems and layered software packages. Schedules installations and upgrades and maintains them in accordance with established IT policies and procedures. Monitors and tunes the system to achieve optimum performance. Develops and promotes standard operating procedures. Conducts routine hardware and software audits of server to ensure compliance with established standards policies and configuration guidelines. Develops and maintains a comprehensive operating system hardware and software configuration database/library of all supporting documentation. Provides integrated team support and maintenance of Technical Services hardware and software. Provides design and implementation support for server hardware Microsoft Windows operating systems virtualization Active Directory Group Policy TCP/IP/DHCP/DNS IIS SQL Exchange Clustering Load Balancing SAN/NAS and advanced support. Provides assigned on call support during nightly on call rotation and upon escalation.

  • Implements systems/applications per defined organization standards.
  • Implement and administer Microsoft SQL Server databases within a multi-tiered environment.
  • Supports/administers/maintains assigned servers and applications.
  • Monitor and maintains servers and computers, insuring maximum performance and system integrity. Establish a baseline for system performance and capacity planning.
  • Communicate project status to manager, customer, and team members.
  • Ensure deliverables meet all relevant quality and security standards
  • Provide data to generate team performance metrics.
  • Knowledge transfer with team members to improve overall support and team education level.
  • Identify root cause defects and systematically redesign standards and methodology to provide constant improvement.
  • Security focused; knowledgeable of least privilege security model, tiered rights.
  • Performs rotating and supplemental On-Call.
  • Other duties as assigned
Position Compensation Range: $34.61 - $55.38 Hourly

MINIMUM REQUIREMENTS

Education: Bachelor's Degree in Computer Science or related field required
Experience: 3 years relevant experience. Relevant experience may be considered in lieu of a degree.
Licensure: None required

PREFERRED SKILLS AND REQUIRMENTS:
  • 3+ years of experience with Microsoft Windows Server 2019/2016/2012;
  • 3+ years of experience with Microsoft SQL Server 2019/2017/2016/2014;
  • Experience with installing, supporting, maintaining, and troubleshooting Windows Server environments.
  • Familiarity with installation of all SQL components.
  • Experience upgrading SQL version and applying SQL patches.
  • Experience with SQL high availability technologies, including clustering and replication.
  • Experience with SQL backup and recovery
  • Experience with the SSRS, SSAS and SSIS.
  • Ability to setup and maintain statistics, indexes and agent jobs
  • Advanced understanding of SQL Security.
  • Ability to run and create SQL Server health assessments reports
  • Experience profiling SQL server resource usage, performance tuning and identification of bottlenecks; including Disk/Memory/CPU utilization
  • Ability to identify queries or SQL processes that are impacting system performance.
  • Ability to troubleshoot problems related to availability of data to system users, space, database software, data flows, data storage and data access.
  • Analyze and evaluate the security procedures required for specific mission-critical business systems as defined by customer security standards. Including SQL hardening.
  • Provide Technical support for MSSQL databases including responding to help desk tickets and working with customers to resolve issues
  • Experience migrating data between SQL servers and instances.
  • Familiar with T-SQL, and can generate ad-hoc T-SQL queries.
  • Experience with SQL Server PowerShell
  • Experience with high availability technologies; i.e. Windows Clustering, NLB
  • Experience with virtualization; preferably Microsoft Hyper-V
  • Experience with Web technologies.
  • Working Knowledge of Back-End Infrastructure technologies and principles (Storage, Disaster Recovery, and Security) preferred.
  • Experience with and ability to program in one or more of the following: Visual Basic, Vbscript, HTML, PowerShell
  • Experience installing, supporting and administrating Red Hat Linux systems
  • Excellent communication skills, both oral and written, including the ability to easily convey concepts to peers, managers, and customers
  • Demonstrated interpersonal skills to build and maintain constructive relationships among customers and peers.
  • Proven ability to work independently or under only general direction
  • Excellent dependability and work ethic in a team environment
  • Critical thinker and problem-solving skills
  • Good time-management skills
  • Ability to manage multiple projects and initiatives in a fast-paced environment
  • Availability to provide after-hours support on a scheduled/non-scheduled basis
  • Familiarity with the concepts of ITIL v.3


PHYSICAL DEMANDS

This is primarily a sedentary job involving extensive use of desktop computers. The job does occasionally require traveling some distance to attend meetings, and programs.

COVID Vaccination Requirement and Guidelines

Please visitthe UVA COVID-19 Job Requirements and Guidelines webpageprior to applying for current information regarding vaccination requirementsandguidelines for employment at UVA.

The University of Virginia, i ncluding the UVA Health System which represents the UVA Medical Center, Schools of Medicine and Nursing, UVA Physician’s Group and the Claude Moore Health Sciences Library, are fundamentally committed to the diversity of our faculty and staff. We believe diversity is excellence expressing itself through every person's perspectives and lived experiences. We are equal opportunity and affirmative action employers. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender identity or expression, marital status, national or ethnic origin, political affiliation, race, religion, sex (including pregnancy), sexual orientation, veteran status, and family medical or genetic information.

 

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

Sign up for job alerts

Not You?

Thank you

Share this job

Not You?

Thank you for sharing this job

Similar Jobs

Storekeeper Senior

Dept of Corr - Central Admin 495791 STATE FARM Virginia United States 3500 WOODS WAY , STATE FARM, Virginia, United States, 23160 State Farm Complex Administrative Services
Why VADOC? Why Not? We provide job stability, 13 paid state holidays in addition to generous vacation, sick, personal leave and military leave incentive. Public Student Loan Forgiveness Program, Affordable health benefits, VRS retirement benefits,...

Meat and Poultry Inspector (Second Shift-Evenings)

Agricultural Inspectors Agriculture & Consumer Svcs 495930 RICHMOND Virginia United States 102 GOVERNOR ST , Downtown, RICHMOND, Virginia, United States, 23219-3676 Agriculture & Consumer Svcs Agriculture and Animal Health
Did you know that agriculture is Virginia’s largest private industry with an economic impact of $82.3 billion annually? Check out our job opportunities to see how you can contribute. We offer a variety of jobs and great benefits (https://www.dhrm....

Support Enforcement Specialist Senior, Manassas (WS004)

Support Enforcement Officers Department of Social Services 495909 MANASSAS Virginia United States 8551 RIXLEW LN , MANASSAS, Virginia, United States, 20109 Department of Social Services Health and Human Services
These are incredibly exciting times at VDSS! We are driving unprecedented, progressive organizational change to create platforms for industry-leading innovations with the goal of delivering the best possible outcomes for Virginians. Join our team,...

Probation Officer Senior (Reentry Team Leader)

Dept of Corr - Central Admin 495785 FREDERICKSBURG Virginia United States 5620 SOUTHPOINTE CENTRE BLVD. , FREDERICKSBURG, Virginia, United States, 22407 Div of Community Corrections Health and Human Services
WHY VADOC? WHY NOT? We provide job stability, 13 paid state holidays in addition to generous vacation, sick, personal leave and military leave incentive. Public Student Loan Forgiveness Program, Affordable health benefits, VRS retirement benefits...

Apply Now

Not You?

Thank you