Talent.com
TEKsystems
Database Administrator - HybridTEKsystems • Lansing, MI, US
Database Administrator - Hybrid

Database Administrator - Hybrid

TEKsystems • Lansing, MI, US
30+ days ago
Job type
  • Full-time
Job description
  • THIS IS A HYBRID ROLE THAT REQUIRES 2 DAYS A WEEK ON SITE IN LANSING, MI* *Description : * This position supports a government client within the education space and is the database environment primary for the Statewide Longitudinal Data System (SLDS) modernization with the Common Education Data Standards (CEDS). The database environment includes : • Multiple SQL Server instances • Multiple Collection Environments (Development, Quality Assurance / Testing, Pre-Release, and Production) • Numerous SQL Reporting Services Servers • 35+ collection databases • 100+ analysis databases This position is the Subject Matter Expert (SME) for the CEPI SLDS data warehouse and requires considerable independent judgment directing and coordinating the appropriate data administration and management methods, practices, procedures and tools, to complete the required assignments. Expertise is required in Microsoft SQL Server database support, and professional knowledge on CEDS standard. This position is heavily involved with strategic and tactical information design, the analysis of business areas, security, and data modeling to meet data collection needs and the transition of ETL process from on premise to cloud servers. Responsibility includes the identification, analysis, categorizing, synthesis, design, and productive use of business information. In addition, this position is responsible for enforcing / ensuring that the architectural frameworks are properly implemented and enforced, monitoring and upgrading the server infrastructure that supports the database environment. *Skills : * Database administrator, Sql, Sql server, Azure, Performance tuning, Sql database, Database management, Data *Top Skills Details : * Database administrator Sql Sql server Azure Performance tuning Sql database Database management *Additional Skills & Qualifications : * Description of work : 1. Responsible for data analysis and database management. Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Knowledge of the utilities and production tools used for data storage management to support the Application Team. Coordinates physical changes to computer databases; codes, tests, and implements physical database, applying knowledge of database management system. 2. Establishes physical database parameters. Uses structured query language (SQL) to define database objects using database definition language (DDL) and control access to database objects using data control language (DCL). Tests and corrects errors and refines changes to database. 3. Enters SQL to create production database. Uses database utility programs and 3rd party utilities to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to database management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine the impact of data base changes on other systems. 4. Evaluates users' requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance. Coordinates the use of data to ensure data integrity and control redundancy, loads databases, and reorganizes as needed. Performs data modeling and prototyping. Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. Performs security recovery procedures. 5. Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures. Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster *Experience Level : * Intermediate Level 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.
Create a job alert for this search

Database Administrator - Hybrid • Lansing, MI, US

Similar jobs

Business Analyst

RIT SolutionsLansing, MI, United States
Full-time

Location: Lansing, MI (2 days a week onsite required).The primary duty of this Business Analyst position is to act as a liaison among business stakeholders to elicit, analyze, communicate, and vali... Show more

 • Promoted

Business Analyst

Zenfreed LLCLansing, MI, United States
Full-time

Lead Business Analyst (Lead BA).The Lead Business Analyst (Lead BA) serves as the senior functional and analytical expert supporting the Department of Military & Veterans Affairs (DMVA) and Michiga... Show more

 • Promoted

Cash Disbursement Analyst

AF - GroupLansing, MI, United States
Full-time

Responsible for initiating, printing, and distributing general disbursements for the entire enterprise.Completes routine general ledger entries.Research and updates payee information.Supports daily... Show more

 • Promoted

Business Analyst

V2SoftLansing, MI, United States
Full-time

V2Soft is a global leader in IT services and business solutions, delivering innovative and cost-effective technology solutions worldwide since 1998.We have headquartered in Bloomfield Hills, MI and... Show more

 • Promoted

Business Analyst 4

SamprasoftLansing, MI, United States
Full-time

Seeking a C2C candidate located in the specified area.DTMB Agency Services is looking for a Business Analyst 4 to provide excellent customer service supporting both project and work request needs.T... Show more

 • Promoted

Business Analyst 5

KyybaLansing, MI, United States
Full-time

Are you a Business Analyst 5 seeking a dynamic and rewarding opportunity? Our client Public sector client is looking for a talented Business Analyst 5 to join their growing team in Lansing, MI.Foun... Show more

 • Promoted

Business Analyst

Auto-Owners InsuranceLansing, MI, United States
Full-time

A career at Auto-Owners is challenging and rewarding.Our group of caring associates create financial security by helping individuals and businesses make a new start when a loss occurs.We offer a me... Show more

 • Promoted

Business Analyst 3

KaavLansing, MI, United States
Full-time

Software Development Lifecycle Manager.We are looking for someone who understands and has experience with the software development lifecycle as they will be managing work requests to support operat... Show more

 • Promoted

Business Analyst 5

Hudson Data LLCLansing, MI, United States
Full-time

The Business Analyst 5 position will work as a contract resource for the State of Michigan - Department of Technology, Management and Budget (DTMB) supporting multiple projects for the Department o... Show more

 • Promoted

Business Analyst 4

KyybaLansing, MI, United States
Full-time

Are you a Business Analyst 4 seeking a dynamic and rewarding opportunity? Our client Public sector client is looking for a talented Business Analyst 4 to join their growing team in Lansing, MI.Foun... Show more

 • Promoted

Programmer Analyst 6

Argyle InfotechLansing, MI, United States
Full-time

The Department of Health and Human Services (DHHS), Eligibility group is responsible for public assistance programs that provide essential support to individuals and families across Michigan.The El... Show more

 • Promoted

Business Analyst -II

Select Minds LLCLansing, MI, United States
Full-time

We are seeking an experienced Business Analyst II with strong expertise in business analysis, user experience design, and enterprise application modernization.The ideal candidate will have experien... Show more

 • Promoted

Business Analyst - Lansing, MI

Georgia IT, Inc.Lansing, MI, United States
Full-time

ON-SITE: 2 days/week required Duration: Contract Rate: DOE.US Citizens, GC, EAD (H4, L2), E3 TN visa holders preferred, NO third party corp to corp accepted for this job.Business process design and... Show more

 • Promoted

Senior Business Analyst

Vital Tech Solutions LLCDimondale, MI, United States
Full-time

Senior Business Analyst Enterprise Application Modernization.We are seeking an experienced Senior Business Analyst to lead requirements gathering and technical design activities for a high-visibil... Show more

 • Promoted

Business Analyst Sr

LanceSoftLansing, MI, United States
Full-time

Risk Adjustment Business Analyst.Resource will be required to come onsite 1 time a week.This engagement requires a highly skilled Risk Adjustment Business Analyst who can bridge regulatory requirem... Show more

 • Promoted

Sr Buisness Analyst

Arete TechnologiesLansing, MI, United States
Full-time

Consulting and Outsourcing services, bridging the gap between requirements and outputs of various dexterous and facile companies worldwide.The thrust of providing global deliverables with focus on ... Show more

 • Promoted

Business Analyst

Software Technology, Inc.Lansing, MI, United States
Full-time

MUST be willing to do face-to-face interview during normal business hours.Top Skills & Years of Experience:.Candidate MUST have excellent communication skills.Agile development processes including ... Show more

 • Promoted

Business Analyst 5

InstantServe LLCLansing, MI, United States
Full-time

Skill Type Skill Name Knowledge of business analysis methodologies and process modeling Experience in the estimation, planning and forecasting of projects.Experience in the documenting and gatherin... Show more

 • Promoted

Business Analyst 5

My3TechLansing, MI, United States
Full-time

Lansing, MI - IT - DTMB - Agency Services - Treasury - Business Analyst 5.Location: Lansing, MI (Candidates MUST be local within a commutable distance.Manager is not interested in candidates who ne... Show more

 • Promoted

Business Analyst 5

Software Technology, Inc.Lansing, MI, United States
Full-time

The Business Analyst 5 position will work as a contract resource for the client - Department of Technology, Management and Budget (DTMB) supporting the Department of Health and Human Services (DHHS... Show more