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.
Interested in this position? Apply now and mention that Gunjobs.com sent you.