11145 Thompson Ave Lenexa,
KS66219US
| Work from home flexibilityTELECOMMUTEUS
Posted: 08/25/20232023-08-252023-10-19Employment Type:Contract to HireJob Category:Database TechnologiesJob 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
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.
Required Qualifications
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.
Preferred Qualifications
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 offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation, and holidays.
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.
There are currently no related jobs. Please sign up for Job Alerts.
Loading...
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!
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.