The Senior Data Architect/DBA plays a critical role in ensuring the integrity, scalability, and reliability of the enterprise data warehouse and database administration services throughout the organization. This position is integral to overseeing Microsoft SQL Server support, developing work pipelines using the Microsoft Stack, and resolving functional and performance issues through database tuning and optimization. The ideal candidate will possess a strong mix of analytical, technical, and communication skills, thriving in a collaborative, team-oriented environment.
About the Role:
Collaborate with IT stakeholders to design and implement strategies for optimal database performance, while establishing efficient development and production pipelines on the Azure platform. Partner with the Enterprise Architect and BI Developers to analyze datasets, assess data needs, and oversee data acquisition and ETL processes in the hosted data warehouse. Troubleshoot and resolve database issues through advanced data modeling techniques. Develop and maintain data ETL processes to support efficient, accurate reporting from a single source of truth. Serve as the Release Manager, overseeing the deployment process from Development to Production. Monitor data warehouse performance to ensure data integrity for BI Developers in report creation and utilization. Coordinate with the Enterprise Architect to schedule and manage product/server upgrades, ensuring smooth rollouts. Adhere to corporate quality assurance policies and maintain required documentation. Design and document both functional requirements and detailed technical specifications. Record key decisions, issues, and main points throughout project lifecycles. Perform additional duties as required.
Required skills:
- Proven experience in Database Administration for MS SQL Server 2019 and later.
- Expertise in Azure automation management and optimization.
- Strong troubleshooting skills for resolving database-related issues.
- Proficiency in performance tuning and optimization at the server, database, and query levels.
- Experience with SSIS, SSRS, PowerBI, and other Microsoft products.
- Familiarity with integrating SQL Server with Azure Active Directory.
- Ability to manage competing priorities and meet deadlines in a dynamic, multi-tasking environment.
- Strong problem-solving abilities and interpersonal communication skills.
- Experience building and maintaining relationships across multiple teams.
- A positive, solution-oriented attitude.
- Network support experience in Azure.
- Proficiency in PowerShell scripting on MS Windows.
- 5-7+ years of experience as a Database Administrator (DBA).
- 5+ years of experience developing and maintaining ETL processes.
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
- Ability to work independently with minimal supervision.
Bonus:
- 10+ years of experience implementing DBA best practices at an organizational level.
- Experience with Snowflake in both managed and non-managed environments.
- Experience with Microsoft tools, including PowerApps and PowerAutomate.
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Flexible schedule
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Professional development assistance
- Vision insurance