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?
