Skills You Bring to This Role
· Experience in performance analysis and tuning skills such as tracing and profiling and Dynamic Management Views and Functions (DMVs) and the ability to run down scenarios such as deadlocks, concurrency, locking/blocking related incidents.
· T-SQL and ANSI SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, windowed functions, CTEs, recursive queries, pivots, merge, upsert, and advance analytic techniques.
· Experience with VLDBs of 20 TB and an understanding of partition/compression is required. Experience with other enterprise grade features in SQL Server such as replication, mirroring is a plus.
· Experience with SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI Report Server (PBIRS), Power BI (PBI) and ability to work with and interact with data engineers in helping define appropriate secure techniques for doing Extract, Transform, Load (ETL) within the environment.
· Understanding of Windows Server operating system performance monitoring and associated tools.
· Exposure to and usage of Redgate tools is a plus.
· Experience with logical and physical data models in partnership with the data architects, and applications developers.
What you need to be Successful:
· Bachelor’s Degree in Computer Science, Software Engineering, Management Information Systems, or other relevant degree.
· 10 years experience in the design, implementation, and support of SQL Server databases.
· In-depth understanding of Windows Server Failover Cluster (WSFC) and enterprise SQL Server Failover Cluster installations/SQL Server Always On is required.
· Knowledge of related infrastructure, tools, and services in support of SQL Server databases such as storage, compute, backup technologies, and disaster recovery.
· Proficiency in Microsoft PowerShell for scripting.
· In-depth knowledge and use of tools such as DBAtools and other modules is required.
· Ability to obtain a U.S. Government Security Clearance is required.
· SQL Server certification(s) preferred.
What we offer you in return
You’ll be off every other Friday with our 9/80 work schedule
80 hours of Personal Time Off (PTO)
120 hours Vacation time
12-13 paid holidays per year
6 weeks parental leave
Tuition reimbursement
Competitive salary
Comprehensive health insurance
On-site clinic, pharmacy, physical therapy, and licensed counselor
Access to more than 11 Employee Resource Groups
And so much more
It’s time to make your mark on the future of aviation. Join us on this mission, and let’s make history together.
We are on a journey to amplify innovation, cultivate purpose and bridge experiences by fostering a culture that is driven by unique perspectives, voices and values.