Database Architect

Top Skills' Details
1. SQL database experience (5 plus years) - it terms of optimization and knowledge they're looking for a comprehensive skill SQL around optimization, process, and architecture clean up. They have particular interest in people with extensive experience with parts of SQL server database tools and analysis services. (SSAS)
2. **DEEP understanding of SQL server*** This person will be optimizing and administrating the SQL server database environment. Working in their project management tool which is Azure DeVops. They have an early rising but promising infrastructure coming up with python processes working with azure data factory and SQL server. They need someone who is familiar with working in combination in python and SQL server and optimizing that.
3. Infrastructure background - (VMware, hardware configurations). SSAS cubes in VMware. Needs to know partitioned memory allocation and how it can be used to optimize reads and writes.
4. Communication - This person needs to have a high-level understanding but very good verbal and written communication skills. They need to have experience with creating official processes and documentation.
Database Admin/Database Architecture - one of the things they're looking for is analysis services infrastructure. They have a lot of needs around this, there SQL infrastructure are very specific to hardware, VM ware configuration, hardware utilization, and a lot of strategy around the actual design and layout of their server infrastructure. There is a lot of work going on with the network team.
Seeking a Database Architect to help expand and continually improve the backend of their next generation reporting stack and data model. As a Database Architect, they will implement, maintain, and optimize their database environment in concert with their IT Engineers while working at the cutting edge of the Microsoft BI Tech Stack.
The ideal candidate is eager to improve or even redesign components of an already robust database environment. That candidate would work hand in hand with BI Developers to level up existing processes and set new levels of excellence with the launch of new ones.
5 years of experience building SQL optimizations that facilitate faster and scalable processes.
5 years of experience working in a DevOps SQL environment.
5 years of experience with configuring database environments and process optimizations.
Self-starting and results oriented team player with a passion for collaborating within a
development team.
5 years of experience with optimizations and infrastructure related to the SQL Server Data Tool suite.
5 years of experience administrating SQL Server IAM.
5 years of experience working with Visual Studio Database Projects.
**Bachelor's degree in computer sciences, Information Systems, or related field. **
Preferred Education and Experience
Skills:
Sql, Etl, azure, devops, python, Sql server, communication and people skills, database architecture, powershell, power bi, aws
Top Skills Details:
Sql,Etl,azure,devops,python,Sql server,communication and people skills,database architecture,powershell
Additional Skills & Qualifications:
Duties and Responsibilities:
Lead the technical development and innovation of our database environment.
Curate database environments such that new development can be fully vetted through our DevOps process.
Evaluate all incoming requests for specific and measurable impact to existing systems.
Work closely with BI and IT leadership to shape the future of DevOps
Accurately diagnose and resolve environment issues in tandem with the IT Engineering team.
Keep up-to-date documentation of all objects and optimizations.
Help Development staff manage their work via SQL Source Control
Required Education and Experience
-Experience with optimizations specifically related to memory utilization.
-Experience with optimizing SQL Server / Python Interactivity
-Experience working in Azure DevOps
-Experience working in a highly parameterized ETL environment.
***This role only supports W2***

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.