Skip to main content

SQL Server Database Architect

Technology
1 week ago
Service contract

Job description

Apex is looking for an Senior Database Architect (Senior DBA). This is an Architect Level, and the SQL Server DBA will be setting up the environment; including the system, setting up the alerts, configuring the dashboards and be in charge of network/storage connectors. This is not a Senior DBA who monitors existing database and systems; but someone who can come into an organization and build the systems/network/storage systems that the SQL Databases will sit on.

Someone who will create and configure the dashboards for monitoring; not simply a DBA monitoring said systems. This individual would have strong OS understanding and able to set up the environment from scratch.

  • 10+ years of SQL Server Database Administrator
  • Expertise on SQL Compression and Dashboard creation/configuration.
  • Must have experience supporting SQL Server Databases running on VMware including
    • Strong experience with SQL Controllers such as Pvscsi and nvme-f.
  • Self-motivated for excellence
  • Proven SQL development history for Database Administration needs
    • Able to develop scripts for custom alerts and or PowerShell scripting for automation
    • Knows how to generate reports for monitoring index/statistic maintenance including for clustered columnstore indexes
  • Solid foundational knowledge to architect new databases for best performance
    • Given a database size, able to determine Windows OS/storage layout requirements – e.g. 1 mount for all database files or creating separate drives for each database file, etc.
    • Able to use performance monitoring to fine tune sql server settings
    • Up-to-date on best practices for database security
  • Experience and know-how for monitoring and effectively performance tuning queries
    • Able to effectively use DMVs to troubleshoot queries and suggest options for achieving goals
    • Able to document repeatable steps for co-workers to follow to help them learn to perform same duties
  • Willing to learn 3rd party vendor application as it relates to database support
  • Willing to participate in 24x7 on call rotation support

Required Skills : 10+ years of SQL Server Database Administrator

Expertise on SQL Compression and Dashboard creation/configuration.

Must have experience supporting SQL Server Databases running on VMware including

Strong experience with SQL Controllers such as Pvscsi and nvme-f.

Basic Qualification :

Additional Skills : Could lead to long term contact!

Background Check :Yes

Notes :REMOTE - 100%

Selling points for candidate :Could lead to long term contact!

Project Verification Info :Client Letter

Apex Letter

Exhibit A

Exclusive to Apex :Yes

Face to face interview required :No

Candidate must be local :No

Candidate must be authorized to work without sponsorship ::No

Interview times set : :No

Type of project :Administration/Support

Master Job Title :Big Data: DBA

Branch Code :Philadelphia

Interested in this role?