• Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Chat with the recruiter

...Minimize

Hey I'm Online! Leave me a message.
Let me know if you have any questions.

Senior Principal Database Administrator

In United States

Save this job

Senior Principal Database Administrator   

Click on the below icons to share this job to Linkedin, Twitter!

JOB TITLE:

Senior Principal Database Administrator

JOB TYPE:

JOB SKILLS:

JOB LOCATION:

Reston, VA United States

JOB DESCRIPTION:

 

Our client is seeking a senior level database administrator to manage Microsoft SQL Server 2012-2019 databases. The ideal candidate should have a minimum of 10 years of experience with managing and supporting Microsoft SQL Server environments and a total of 12+ years in IT. In addition seeking Cloud experience with AWS Relational Database Service (RDS) for SQL Server as well as managing Cloud Data Warehousing using AWS Redshift. The candidate should be a self-starter, have excellent communication skills, work seamlessly in a team environment

 

Skills

  • Excellent communication, presentation, and customer relationship skills 
  • Ability to work individually with minimal supervision 
  • Proven ability to work creatively and analytically in a problem-solving environment 
  • Autonomous DBA with "Can-do" attitude, pro-active, takes the initiative as well as ownership of problem/project

 

Experience

  • Microsoft SQL Server (2012-2019) – candidate should be able to install, configure, upgrade and maintain a SQL Server 2012-2019 instance build 
  • Extensive experience with SQL 2012-2019 Architecture i.e. Availability Groups. 
  • Install, configure and maintain MS SQL Server 2012-2019 cluster environment including Always On Availability Groups and Active-Active failover clustering implementations 
  • Experience in migrating and supporting databases in AWS RDS for SQL Server 
  • Experiences with supporting Cloud Data Warehousing using AWS Redshift 
  • Extensive Windows Powershell experience required o Support and configure security settings – support users as well as maintain security standards 
  • ETL tool development experience (SSIS – SQL Server Integration Services)
  • Experience working with MS Business Intelligence and Data Warehouse environments, in particular PowerBI 
  • Multi-Dimensional and Tabular Model development including knowledge of MDX and DAX (SSAS – SQL Server Analysis Services) 
  • SQL Server 2012-2019 performance tuning – experience with analyzing query plans, tuning stored procedures, troubleshooting deadlocks, blocks and long running queries, isolating and resolving I/O bottlenecks and CPU bottlenecks o Extensive experience with MS SQL Server hotfixes and service packs and have a very good understanding of Microsoft SQL Server and BI licensing 
  • Experience with installing, configuring and supporting SSRS, SSIS and Analysis Services o Knowledge of Microsoft Reporting Tools (PowerPivot, PowerView, SQL Server Reporting Services, Performance Point) 
  • Complete understanding of DR technologies utilizing log shipping and Availability Groups and can demonstrate/ensure that log shipping and AG are in sync. 
  • Experience with designing a disaster recovery solution between AG groups o SQL Server administration activities – database health check, DMV queries, index optimization, performance tuning, query optimization, maintenance plans, link servers, etc. 
  • A thorough understanding of DMV views and how to utilize them to improve performance and monitoring. 
  • Extensive understanding of Microsoft backup methodologies, their implementation via GUI as well as scripts. 
  • Experience with setup and scheduling of backups, creating and scheduling jobs, alerts and operators using SQL Server Agent as well as successful database restores o Exposure managing Microsoft Analytics Platform System (Parallel Data Warehouse) including APS DW Loader

 

Education

  • Bachelor's Degree with 12+ years overall IT database experience, 10 years' experience with SQL Server.

 

 

 

Position Details

POSTED:

Jul 06, 2022

EMPLOYMENT:

INDUSTRY:

SNAPRECRUIT ID:

S1649894415128960

LOCATION:

United States

CITY:

Reston, VA

Job Origin:

OORWIN_ORGANIC_FEED

A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Senior Principal Database Administrator    Apply

Click on the below icons to share this job to Linkedin, Twitter!

<p> </p> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Our client is seeking a senior level database administrator to manage Microsoft SQL Server 2012-2019 databases. The ideal candidate should have a minimum of 10 years of experience with managing and supporting Microsoft SQL Server environments and a total of 12+ years in IT. In addition seeking Cloud experience with AWS Relational Database Service (RDS) for SQL Server as well as managing Cloud Data Warehousing using AWS Redshift. The candidate should be a self-starter, have excellent communication skills, work seamlessly in a team environment</span></span></span></span></span></span></span></p> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"> </p> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Skills</span></span></span></span></span></span></span></p> <ul> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Excellent communication, presentation, and customer relationship skills </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Ability to work individually with minimal supervision </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Proven ability to work creatively and analytically in a problem-solving environment </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Autonomous DBA with "Can-do" attitude, pro-active, takes the initiative as well as ownership of problem/project</span></span></span></span></span></span></span></li> </ul> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"> </p> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Experience</span></span></span></span></span></span></span></p> <ul> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Microsoft SQL Server (2012-2019) – candidate should be able to install, configure, upgrade and maintain a SQL Server 2012-2019 instance build </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Extensive experience with SQL 2012-2019 Architecture i.e. Availability Groups. </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Install, configure and maintain MS SQL Server 2012-2019 cluster environment including Always On Availability Groups and Active-Active failover clustering implementations </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Experience in migrating and supporting databases in AWS RDS for SQL Server </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Experiences with supporting Cloud Data Warehousing using AWS Redshift </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Extensive Windows Powershell experience required o Support and configure security settings – support users as well as maintain security standards </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">ETL tool development experience (SSIS – SQL Server Integration Services)</span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Experience working with MS Business Intelligence and Data Warehouse environments, in particular PowerBI </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Multi-Dimensional and Tabular Model development including knowledge of MDX and DAX (SSAS – SQL Server Analysis Services) </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">SQL Server 2012-2019 performance tuning – experience with analyzing query plans, tuning stored procedures, troubleshooting deadlocks, blocks and long running queries, isolating and resolving I/O bottlenecks and CPU bottlenecks o Extensive experience with MS SQL Server hotfixes and service packs and have a very good understanding of Microsoft SQL Server and BI licensing </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Experience with installing, configuring and supporting SSRS, SSIS and Analysis Services o Knowledge of Microsoft Reporting Tools (PowerPivot, PowerView, SQL Server Reporting Services, Performance Point) </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Complete understanding of DR technologies utilizing log shipping and Availability Groups and can demonstrate/ensure that log shipping and AG are in sync. </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Experience with designing a disaster recovery solution between AG groups o SQL Server administration activities – database health check, DMV queries, index optimization, performance tuning, query optimization, maintenance plans, link servers, etc. </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">A thorough understanding of DMV views and how to utilize them to improve performance and monitoring. </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Extensive understanding of Microsoft backup methodologies, their implementation via GUI as well as scripts. </span></span></span></span></span></span></span></li> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Experience with setup and scheduling of backups, creating and scheduling jobs, alerts and operators using SQL Server Agent as well as successful database restores o Exposure managing Microsoft Analytics Platform System (Parallel Data Warehouse) including APS DW Loader</span></span></span></span></span></span></span></li> </ul> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"> </p> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:700"><span style="font-style:normal"><span style="text-decoration:none">Education</span></span></span></span></span></span></span></p> <ul> <li aria-level="1" style="list-style-type:disc"><span style="font-size:10pt; font-variant:normal; white-space:pre-wrap"><span style="font-family:'Times New Roman'"><span style="color:#000000"><span style="background-color:#ffffff"><span style="font-weight:400"><span style="font-style:normal"><span style="text-decoration:none">Bachelor's Degree with 12+ years overall IT database experience, 10 years' experience with SQL Server.</span></span></span></span></span></span></span></li> </ul> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"> </p> <p style="line-height:1.2; text-align:justify; background-color:#ffffff; padding:0pt 0pt 0pt 5pt"> </p> <p> </p>


Please wait..!!