Employment Services
We help you find the correct IT placement
Adaptive Solutions Group
http://www.adaptivesg.com
http://www.adaptivesg.com
true
Data Analyst
11145 Thompson Ave Lenexa, KS 66219 US | Work from home flexibility TELECOMMUTE US
Posted: 08/25/2023
2023-08-25
2023-10-19
Employment Type:
Contract to Hire
Job Category: Database Technologies
Job Number: 16233
Job Description
Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the Kansas City and St. Louis areas.
We are currently looking for a Data Analyst to join our team.
Responsibilities
Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.
We are currently looking for a Data Analyst to join our team.
Responsibilities
- Provides effective use of Agile methods for KANBAN or SCRUM when working with development teams.
- Coordinate workflow of tasks to ensure uptime of databases in support of achievement of business requirements.
- The goal is to achieve a seamless flow of information throughout the organization, considering both backend data structure and frontend accessibility for employees and members.
- Analyze existing SQL Server installation, Server Configuration, and Database settings and recommend improvements.
- Focus in Data Analytics.
- Administer database replication between servers, specifically Always On Availability Groups.
- Tune and optimize database objects.
- After hours on call through department rotation.
- Recognize issues that impact business and how it relates to IT owned solutions.
- Communicates effectively in written and verbal form in a cross-functional setting with business partners.
- Investigate and implement effective monitoring of enterprise systems.
- Assess risks; communicate and create mitigation plans for these risk.
- 5+ years of experience with 2016, or higher, MS SQL Server database administration.
- Bachelor’s degree in a Computer Science discipline or equivalent certification/training/experience in relational database management systems.
- Advanced knowledge of SQL Server Management Studio (SSMS).
- Advanced ability to write T-SQL and design schemas.
- Advanced experience with indexing.
- Advanced knowledge of query performance tuning.
- Basic understanding of PowerShell for automation.
- Basic understanding of Visual Studio.
- Intermediate understanding of version control systems.
- Strong ability to create SSRS or Power BI reports as needed.
- Experience with performance tuning & system optimization database health, security data analysis, problem analysis database installation, backups, replication, validation, and patching.
- Good problem-solving skills.
- Ability to build positive working relationships with teammates, strong team player.
- Excellent customer service skills.
- Excellent interpersonal and communications skills (verbal and written).
- Ability to learn new job skills by engaging in the technical aspects of the job and applying new skills as they are taught.
- Experience with 2022 MS SQL Server database administration.
- Experience with Git.
- Experience with the following applications and software:
- Microsoft Dynamics AX
- ER/Studio
- Azure DevOps
- Microsoft Teams
- Microsoft Synapse
- Azure SQL
- Local to the Kansas City, Metro.
Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.
Job Requirements
MS SQL Server, T-SQL, design schemas, Power BI
Meet Your Recruiter
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Lenexa, KS
Join us in the vibrant job market around Lenexa, Kansas! This thriving area offers a perfect blend of career opportunities and quality of life. Located in the heart of Johnson County, Lenexa boasts a friendly community, excellent schools, and a variety of dining options ranging from BBQ joints to food trucks. Enjoy outdoor adventures at Shawnee Mission Park or catch a show at the Theatre in the Park. With close proximity to Kansas City's renowned art galleries, professional sports teams like the Kansas City Chiefs and Royals, and iconic venues like the historic Kauffman Center for the Performing Arts, Lenexa is the ideal place to grow your career while embracing a unique culture and irresistible charm. Explore our job listings today and discover the exciting possibilities this region has in store for you!