REQUIRED SKILLS AND EXPERIENCES:
5+ years in MS SQL Server (2008 – 2017) DBA experience in an OLTP production environment with strong knowledge in database backups, restores and recovery models.
Proficient in SQL replication that includes Transactional Replication, Always On Availability Groups (AG), mirroring, log shipping, maintenance plans and DR recovery strategies.
Experience in database performance tuning and optimization, using native monitoring and troubleshooting tools that includes Profiler, Index Tuning Wizard, Dynamic Management Views and Functions (DMVs) and other third-party tools.
Strong experience with enterprise monitoring tools.
Capable to develop T-SQL stored procedures, functions and PowerShell scripts to automate processes and improve system performance.
Knowledge with data mapping with logical and physical data modeling.
Bachelor Degree in computer science or equivalent experience
Should be a US national to work on Aviation Export Control activities
Microsoft SQL Server certification(s) is a major plus.