SQL Server Database Architect(
Job Number : 322188)
322188)
Description
We’re more than aviation experts, we’re pioneers. We challenge what’s possible. From breaking the sound barrier to advanced tiltrotor systems.
Today, Bell is shaping the future of aviation through specialized engineering. And we want you.
Infrastructure
As a SQL Server Database Architect (DBA), you will be responsible for successful support and maintenance of the SQL Server environment.
You will collaborate with the DBA team and other IT application teams in providing efficient DBA support. Reporting to the Manager of the DBA support team, you will be involved in patching, upgrading, tuning, and stabilizing of the SQL Server environment to support our client’s core business objectives.
What you’ll be doing as a SQL Server DBA
- Establish and maintain written best practices and operational procedures as build books and checklists.
- Maintain appropriate database (DB) lifecycle and automated processes to keep Configuration Items (CI) and audit items up-to-date and easily maintained.
- Collaborate with the DBA team to monitor and resolve the incoming tickets in the DBA support queue.
- Ensure the proper setup and validation of backup and restore processes. Monitor and ensure daily backups and maintenance are working as designed and implemented.
- Analyze and document the current SQL Server environment, which includes the servers, instances, databases and their disk allocations and system allocations as Central Processing Unit (CPU) and memory.
- Support SQL Server versions 2014 - 2022 including : Database Engine, Integration Services, Reporting Services and Analysis Services, which includes but not limited to, SQL server installation, database creation according to best practices, setup of backup and recovery procedures and proactive performance tuning.
- Deliver on assigned SQL Server Infrastructure projects, including, but not limited to new software releases, patch upgrades, feature exploitation, security and audit.
Qualifications
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
- 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.
EEO StatementTextron is committed to providing Equal Opportunity in Employment, to all applicants and employees regardless of, race, color, religion, gender, age, national origin, military status, veteran status, handicap, physical or mental disability, sexual orientation, gender identity, genetic information or any other characteristic protected by law.
Applicants selected will be subject to a government security investigation and must meet eligibility requirements, including US Citizenship, for access to classified information.
This position requires use of information which is subject to the International Traffic in Arms Regulations (ITAR) and / or the Export Administration Regulations (EAR).
The ITAR / EAR defines a , ('Green Card Holder'), Political Asylee, or Refugee.Recruiting Company : Bell Textron Inc.