Trillium Staffing - Richmond, VA

posted 4 months ago

Full-time - Mid Level
Richmond, VA
Administrative and Support Services

About the position

Trillium Professional is seeking a senior SQL Server / Azure Database Administrator to join an Oracle/SQL Server Database Administration Team in Richmond, Virginia. The selected candidate will be responsible for administering and supporting SQL Server databases throughout the organization. This role requires a proactive approach to monitoring databases to ensure uptime and availability, troubleshooting application and database issues related to connectivity, access, and security, and tuning long-running SQL queries. The candidate will also review and refine existing database tasks and processes to better align with agency and group priorities, leveraging operating system scripting utilities for database maintenance and diagnosis. In addition to these responsibilities, the selected candidate will review the existing database implementation and propose, execute, and direct necessary changes. They will perform SQL Server installations across various versions (2012, 2014, 2016) with failover clustering and provide support for SQL Server databases, including administration, support, and tuning. A solid understanding of data modeling principles is essential, as is the ability to rely on experience and judgment to plan and accomplish goals independently. The candidate will work collaboratively with a team of Oracle and SQL Server DBAs and must communicate clearly and effectively, both verbally and in writing.

Responsibilities

  • Monitor databases to maintain/ensure database uptime and availability.
  • Troubleshoot application/database issues related to connectivity, access, security, etc.
  • Tune long running SQL queries.
  • Review & refine existing database tasks and processes to better align with agency/group priorities.
  • Leverage & utilize O/S scripting utilities in support of database maintenance/diagnosis/support.
  • Review the existing database implementation and propose, execute, and/or direct necessary changes.
  • Perform SQL Server installations (2012, 2014, 2016 w/ failover clustering).
  • Support SQL Server databases (administration, support, tuning).
  • Demonstrate knowledge of data modeling principles.

Requirements

  • At least 5 years of experience with SQL Server database administration.
  • At least 2 years of Azure experience.
  • Bachelor's Degree in Computer Science, Information Systems, or other applicable and/or equivalent skills, knowledge, and/or work history.
  • Expertise working as a SQL Server DBA.
  • Expertise working with SQL clustering, mirroring, and high availability.
  • Experience working with large SQL databases.
  • Expertise in writing Transact SQL.
  • Experience tuning Oracle and/or SQL Server databases.
  • Expertise in installing, upgrading, patching, and migrating SQL Server databases.
  • Experience working in a Windows environment.
  • Experience working with SSIS, SSAS, & SSRS.
  • Experience working with Azure Cloud.

Nice-to-haves

  • Desired knowledge of and experience with SQL Server 2016-2022.

Benefits

  • Health insurance participation
  • Retirement plans participation
  • Paid holidays
  • State required leave
  • Vacation days
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service