DBA

1.Database Performance & Architecture Expertise Strong experience designing, optimizing, and managing large, mission-critical databases, including indexing strategies, query performance tuning, and physical/logical database design.

2.Advanced Database Technologies & Operations Hands-on expertise with high availability, disaster recovery, replication, partitioning, and change tracking to meet strict RPO/RTO requirements in complex environments.

3. Modern Tooling & Cloud Integration Experience with GitHub and CI/CD pipelines, Snowflake, Azure-based systems, and RedGate, supporting both transactional and analytics workloads., This Database Administrator (DBA) will work closely with fellow Database Team Members and other IT teams: Development, Application Support, BI and Reporting, and the Infrastructure Teams to persist ongoing knowledge and understanding of the organization's database and information needs. The DBA, as member of the effective team, will be responsible for logical and physical database design, including the mapping of logical data models to physical database table designs. Responsible for designing, implementing, monitoring, troubleshooting and managing large mission critical databases to meet established service levels. Job Responsibilities (listed in order of importance and/or time spent): -Produces and documents conceptual, logical, and physical database design. -Contribute to team library and knowledge base, establishing and documenting management maintenance procedures. -Works with both technical and business stakeholders to understand the database needs for projects. Attend requirement sessions when necessary, communicating any concerns to project leadership. -Assists development teams and data architects in query design and query performance tuning. -Makes recommendations and assess proposals for database and database query optimization, including making index recommendations and changes as needed. -Reviews and assesses proposals requesting changes or upgrades to the existing databases. -Reviews project database to ensure that they are built in-line with the stated design. -Translates technical terminology, concepts and issues in terms understandable to technical and non-technical management and resources staff. -Monitors, Documents and Manages and Analyzes assigned databases and systems to established service levels and ensure they comply with documented standards and policies. -Attend and participate in ad-hoc and weekly Change Review Meetings, providing input as needed. -Contributes to the development and regular testing of Business Continuity solutions for the database environment, including the installation and configuration of database software and replication processes. -Participate in regular Audit Activities as requested and assigned to assure compliance with industry standards and governance. -Available on call 24/7 as required, by cellphone, with a rotation schedule, every 3rd week (rotating on Wednesday's)

Advanced level skill with database management tools, methodologies, and technologies, managing complex database environments for transactional or business analytics functions. Expertise to be demonstrated through articulate ability to design and explain the benefits and limitations of different architecture and procedural solutions for such requirements as disaster recovery, high availability, clustering, virtualization change tracking and partitioning, backup and replication techniques to achieve RPO (recovery point objective) and RTO (recovery time objective). -Experience using analytical skills, tools and techniques to investigate information and to draw conclusions. -Experience in identifying operational issues and recommending and implementing strategies to resolve problems. -Experience with GitHub / CICD. -Experience with SnowFlake / Azure Cloud based systems. -Experience with RedGate. -Experience in diagnosing, isolating, and resolving complex issues and recommending and implementing strategies to resolve problems. -Strong skills / experience with the implementation and management of change tracking and partitioning. -Adaptable to change and able to work independently and effectively with and as part of a team or with minimal supervision. -Strong interpersonal, communication, and writing skills. -Capable of managing multiple projects concurrently while maintaining a high level of attention to detail on each project. -Strong analytical / analysis skills with the ability to collect, validate, organize, disseminate, and present significant amounts of information with an attention to detail and accuracy. Skills github, performance tuning, database design, azure, snowflake, ci/cd, redgate Top Skills Details github,performance tuning,database design Additional Skills & Qualifications -10-12+ years of overall IT experience, with 5+ years in database administration or design. -Experience with data modeling, capacity planning, and supporting SLA-driven environments. -Strong analytical and problem-solving skills, with proven ability to diagnose and resolve complex infrastructure issues. -Experience working independently while collaborating effectively across cross-functional teams. -Knowledge of ITIL frameworks and experience in ITIL-based service organizations (preferred). -Bachelor's degree (Computer Science or Business preferred). -Excellent communication, documentation, and organizational skills, including the ability to manage multiple priorities concurrently. Experience Level Expert Level

This is a Contract to Hire position based out of Lake Forest, IL. Pay and Benefits The pay range for this position is $60.00 - $70.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)

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. About TEKsystems and TEKsystems Global Services We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.