Posted 3 months ago

Sr. SQL DB Admin

Full-Time
Accokeek, MD
JOB SUMMARY/OBJECTIVE:
We are seeking an experienced SQL Server DBA with detail-oriented, analytical and troubleshooting skills having a minimum of 10 years of professional experience in different related Microsoft products, on premises and cloud.  Skills should include SQL Server database administration, DB architecture, SQL programming, data modeling, gathering and analyzing business requirement and Operating Systems.  There should be a solid working experience in managing +50 large databases, backup/recovery, configuring and managing HA solutions, managing reports using SQL Reporting Services (SSRS), monitoring, performance tuning, stored procedures, triggers, functions, constraints and views etc. The professional should have a strong knowledge on using database third-party tools. The individual must be agile, customer service oriented and a highly productive senior professional that can work alone and in group settings with the internal customers, business line managers, consultants and other IT staff. The individual must be able to lead and complete mission-critical projects.
 

REQUIRED TECHNICAL SKILLS:

Database Expertise:
SQL Server 2014, 2016

Database Migration:
SQL Server to SQL Server

Database Security:
SQL server security tools

Data Encryption at rest and in motion:
SQL TDE and others - design, implementation, maintenance

Database High Availability:
SQL Always-On DB cluster - design, implementation, maintenance

Disaster Recovery Technology
: SQL backup/restore, RTO, RPO

Operating System:
Windows Server 2012R2, 2016, 2019, VMware

Languages:
Microsoft SQL

 

PREFERRED TECHNICAL SKILLS (ANY COMBINATION):

Database Expertise:
Azure SQL managed instance, Azure SQL as a Service, MS Access

Database Migration:
  Oracle to SQL Server, MySQL to SQL Server, and MS Access/Excel to SQL Server

Programming Languages:
NoSQL, T - SQL, HTML, DHTML, XML, JavaScript, ASP, ASP.net

Cloud/Azure:
Azure Services, PaaS, IaaS, Migrated on premises databases and Legacy products on Azure, deployed products on Azure, Setup development and test environment on Azure, Azure security.

ETL/Data Warehouse Tools:
SSIS/DTS, BCP

Reporting:
SSRS (SQL Server Reporting Services) - Enterprise Reporting, Microsoft PowerBI

Data Modeling Tools:
ERWin, Toad Data Modeler, Visio, SSDD (SQL Server Database Diagram)

Third Party Tools:
SolarWinds, OpNet, RedGate, Idera, ERWin, Visio, Toad Data Modeler

Domain/AD:
Active Directory, DNS, AZURE AD

Hardware/Storage:
SAN, RAID, iSCSI
 
CERTIFICATIONS:
 
REQUIRED (2 from the list below or equivalent)
  • Microsoft Certified: Azure Database Administrator Associate
  • MCSA: SQL 2016 Database Administration
  • MCSA: Windows Server 2016
 
PREFERRED (any combination of the list below or equivalent)
  • Microsoft 365 Certified: Enterprise Administrator Expert
  • Microsoft 365 Certified: Security Administrator Associate
  • Microsoft 365 Certified: Messaging Administrator Associate
  • Microsoft Certified: Azure Administrator Associate
  • Microsoft 365 Certified: Modern Desktop Administrator Associate
  • Microsoft Certified: Azure Solutions Architect Expert
  • Microsoft Certified: Azure Security Engineer Associate
  • (ISC)² CISSP
  • ISACA CISM
  • PMI Project Management Professional (PMP)
EXPERIENCE/EDUCATION:
Master’s Degree or equivalent
A minimum of 10-year work experience in information technology field preferred.
 
OTHER JOB FUNCTIONS:
Troubleshoot a wide variety of computer performance problems.
Help implement and test disaster recovery plans.
Perform other duties as assigned.
 
WORKING CONDITIONS/PHYSICAL DEMANDS: 
Utilization of PC and midrange computer systems.

Share this job:

Interested in this position? Apply now and mention that Gunjobs.com sent you.

Beretta USA