Job Description :
Role: SQL Server Database Architect Duration: 6 months should be extendable Location: 100% remote Visa: w2/c2c role Rate: Depends on experience 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. Job Description : 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 o Strong experience with SQL Controllers such as Pvscsi and nvme-f. ? Self-motivated for excellence ? Proven SQL development history for Database Administration needs o Able to develop scripts for custom alerts and or PowerShell scripting for automation o 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 o 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. o Able to use performance monitoring to fine tune sql server settings o Up-to-date on best practices for database security ? Experience and know-how for monitoring and effectively performance tuning queries o Able to effectively use DMVs to troubleshoot queries and suggest options for achieving goals o 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 -- , Kalyan| Technical Recruiter Thoughtwave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk, Cell EXTN: 148 Email: Website: linkedin:


Client : NO

             

Similar Jobs you may be interested in ..