Diverse Lynx - Phoenix, AZ

posted 3 months ago

Full-time
Remote - Phoenix, AZ
Professional, Scientific, and Technical Services

About the position

The MS SQL DBA position at Diverse Lynx LLC is a fully remote role that requires a strong understanding of the MS SQL database platform, with hands-on experience across all versions of MS SQL. The successful candidate will be responsible for a variety of database management tasks, including database upgrades and migrations, maintenance activities, and ensuring the overall performance and security of the databases. This role is critical as it serves as the key interface to all application areas, facilitating data design components and providing essential database tuning and monitoring services. In this position, the DBA will engage in standard operational activities related to backup management, database patch management, and recovery processes. The role demands excellent communication skills, as the DBA will need to define and adhere to strong process management activities. The candidate will also be expected to execute DML operations using TSQL queries and manage public DBMS objects shared by the application team across different environments. Additionally, experience with SSAS and SSRS reporting databases is essential, as well as familiarity with DBMS feature implementations such as partitioning, compression, archival, and purging. Overall, this position is designed for a detail-oriented individual who can manage complex database environments while ensuring high levels of performance and security. The DBA will play a vital role in maintaining the integrity and efficiency of the database systems, contributing to the overall success of the organization.

Responsibilities

  • Manage and maintain MS SQL databases across all versions.
  • Perform database upgrades and migrations as needed.
  • Oversee database maintenance activities including backup, refresh, and recovery.
  • Monitor and tune SQL performance and relational database performance management.
  • Conduct standard operational activities related to backup and database patch management.
  • Serve as the key interface to all application areas, facilitating data design components.
  • Provide database tuning, monitoring database security, and system performance.
  • Execute DML operations using TSQL queries and manage public DBMS objects.
  • Handle SSAS and SSRS reporting databases effectively.
  • Implement DBMS features such as partitioning, compression, archival, and purging.

Requirements

  • Strong knowledge of the MS SQL database platform and hands-on experience on all MS SQL versions.
  • Good experience in database upgrade and migration.
  • Strong knowledge of clusters and database maintenance activities.
  • Experience with backup, refresh, and recovery processes.
  • Strong knowledge of SQL, relational database tuning, and overall performance management.
  • Experience with DBA related standard operational activities around backup and database patch management.
  • Excellent communication skills and ability to define and adhere to strong process management activities.
  • Good experience with database security features.
  • Ability to create and execute DML operations using TSQL queries.
  • Experience handling SSAS and SSRS reporting databases.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service