Trillium Staffing - Richmond, VA

posted 3 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 our Oracle/SQL Server Database Administration Team in Richmond. 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 to support database maintenance, diagnosis, and support. In addition, the selected candidate will be expected to review the existing database implementation and propose, execute, and/or direct necessary changes. Responsibilities will include performing SQL Server installations (2012, 2014, 2016 with failover clustering) and providing support for SQL Server databases, including administration, support, and tuning. A solid understanding of data modeling principles is also required. The candidate will rely on their experience and judgment to plan and accomplish goals, independently perform a variety of complicated tasks, and work collaboratively with a team of Oracle and SQL Server DBAs. Clear and effective communication, both verbal and written, is essential for success in this role.

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 OS 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 with 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service