Lead NoSQL Database Administrator (28604)
Database administrator job in Waukegan, IL
Lead NoSQL Database Administrator/Architect
Pay: $121,000 - $185,000 per year + benefits
Key Skills: Cassandra or DataStax, ETL, database administration/architecture, automation
Are you driven to optimize large-scale database performance and design cutting-edge data solutions? We're seeking a Lead NoSQL Database Administrator to act as a hand-on technical lead in designing and guiding the evolution of enterprise data systems and champion automation across critical platforms.
What You'll Do
Design complex databases, tables, indexes and other database objects as well as Extract, Transform and Load (ETL) solutions.
Manage and guide the architecture and roadmap for the DataStax platform.
Work with a highly technical team in the management and administration of complex systems.
Provide hands-on mentoring and support to a team of Database Administrators.
What We're Looking For
Bachelor's degree with 7+ years experience in database administration, architecture, and topology.
Proven expertise with Apache Cassandra or DataStax Database Management System.
Proficient in database architectures and topology.
Ability to build and deploy complex architectures and highly available solutions for NoSQL platforms.
Database Administrators (Professional, Scientific, and Technical Services)
Database administrator job in Moline, IL
Mercor is recruiting **Database Administrators who work in the Professional, Scientific, and Technical Services Sector** as independent contractors working on a research project **for one of the world's top AI companies. ** This project involves using your professional experience to design questions related to your occupation as a Database Administrator.
Applicants must: - Have **4+ years full-time work experience** as a Database Administrator; and - **Be based in the US, UK, or Canada** Here are more details about the role: - We aim to make **the hourly compensation rate offered to you competitive based on your professional background and geographic location** (please note that the listed hourly compensation scale is for U.
S.
-based applicants and that that scale will differ depending on where a candidate is geographically based) - The work is **fully asynchronous** and can be done around your schedule - This project requires that you be able to commit a **minimum of 15 hours per week** - The work **will last for approximately 3-4 weeks after you begin the project** - Please note you will need access to a desktop or laptop computer for this project and that we **cannot accept applicants who use chromebook computers** With respect to pay and legal status: - **We can meet industry-standard compensation expectations for your current role** - We will pay you out weekly via Stripe Connect based on the number of project work hours that you log - You will be classified as an “at-will” contractor to Mercor - Please note that we **cannot currently support H1-B or STEM OPT status candidates**
Database Administrator
Database administrator job in Chicago, IL
Job description of DB Administrator/IT Analyst
An individual skilled in business system applications, processes, and workflow in supporting a dynamic business and environment.
The individual needs to possess the following technical skills:
Operational System/Application Administration:
Experience with Softrax or other subscription management application
System security, including identity access management
Application upgrades and enhancements
System configuration/customization
Troubleshooting issues
Responding to incidents and requests
System Interfaces:
SQL Server Integration Services package creation and deployment
SQL Interface Scripts
SQL Server Database Expertise:
Database Administration
Database Security
Writing Queries (complex joins) and creating Database views
Writing Stored Procedures
Database updates - one-off updates as well as mass inserts/updates
Scheduling SQL Jobs
Preferred Qualifications/Skills:
Project management
Good interpersonal, coordination, and analytical skills.
Knowledge of basic business concepts.
Familiar with compliance standards, such as SOX, healthcare, operational, regulatory, etc.
Good systems analysis and/or programming skills.
Knowledge of MS applications - Word, Excel, Project, Visio, Outlook
Regards
Rahul Bansiwaal
**********************************************
************ | Office: ************** EXT: 444
rahulb@net2source>com
www>net2source>com
270 Davidson Ave, Suite 704, Somerset, NJ 08873, USA
Knowledge is Power>
Lead Database Administrator
Database administrator job in Springfield, IL
About defi SOLUTIONS:
It's an exciting time to join defi!
defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.
Position Purpose:
The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.
You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.
This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24/7 support and rapid response to production issues or outages.
Essential functions:
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting/monitoring.
Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
Support both Azure and AWS SQL Enviornments
Interact with clients, analysts, and other team members to resolve issues.
Assist less experienced team members and assist in problem resolution as necessary.
Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
Stay Current on emerging technologies
Collaborate with other members of the Operations Team to design and implement solutions
Open and Escalate cases with Microsoft when required
**
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Required education and experience:
Bachelor's degree or equivalent work experience
10+ years' experience in an IT operations environment performing database administration.
3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
3+ years of experience with SQL Server Always On Availability Groups
PowerShell Scripting experience
Deep knowledge of SQL internal functionality including but not limited to
Query Processing and Optimization
Reading and Analyzing Execution plans, table statistics, data distribution and execution times
Indexing Mechanisms
Types, Maintenance and impact
Transaction Management
Isolation levels, Locking mechanisms, deadlocks, etc.
Storage Architecture
Data Pages, filegroups, row/page compression, etc.
Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
Backup and Recovery
Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
Security and Access Control
Authentication, Encryption, auditing, access requirements, etc.
Monitoring and Performance Tuning
Wait Statistics, Dynamic Management Views, Query Store, etc.
Experience with Datadog, Elastic or New Relic
Maintenance and Housekeeping
Database Consistency checks, statistics updates, index maintenance, log file management.
Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
Effective analytical, communication, interpersonal and problem-solving skills.
No management experience is required.
Preferred education and experience:
Knowledge in Snowflake Administration
Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional eligibility requirements:
An achiever, self-starter, and eager to learn
You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
Travel required:
Travel is potential to be 10% of time
Affirmative Action/EEO statement:
defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.
SQL DBA
Database administrator job in Chicago, IL
Job Title: SQL DBA Duration: 6 Months Job Description: Provide deep technical expertise to support delivery and maintenance of IT solutions. Provide IT teams and business personnel with technology solutions by weighing advantages of technology standards, market availability of products, and risks and benefits of technology to meet business/IT needs. Significant customer engagement, work planning, project management services provided to IT customers. Expected to work under minimal supervision.
Responsibilities:
Bachelor's degree in Computer Science or related discipline and typically 5 - 7+ years hands-on experience MS SQL Server, or equivalent combination of education and work experience.
Experience in migration of users, databases, and/or database servers
Broad technical expertise with deep technical knowledge in MS SQL Server. Experience with Database Mirroring, AlwaysOn Technology.
Excellent communications skills - Able to effectively communicate highly technical information in non-technical terminology (written and verbal)
Understanding of change management principles associated with new technology implementations.
Understands and applies project management principles when leading and directing work
Expected Skills:
MS SQL Server 2005, 2008, 2008 R2, 2012, 2014
MS Office
Preferred:
Technical certification in Technical Area of Specialty
Additional Information
Thanks & Regards'
________________________________________________________________________
___
Vikram Bhalla
|
Team Recruitment
|
Mindlance, Inc.
|
W
:
************
All your information will be kept confidential according to EEO guidelines.
SQL Developer/ Database Programmer/ Database developer/ DBA Programmer (Cont. to Hire)
Database administrator job in Lisle, IL
Collabera is ranked amongst the top 10 Information Technology (IT) staffing firms in the U.S., with more than $550 million in sales revenue and a global presence that represents approximately 12,000+ professionals across North America (U.S., Canada), Asia Pacific (India, Philippines, Singapore, Malaysia) and the United Kingdom. We support our clients with a strong recruitment model and a sincere commitment to their success, which is why more than 75% of our clients rank us amongst their top three staffing suppliers.
For consultants and employees, Collabera offers an enriching experience that promotes career growth and lifelong learning. Visit ***************** to learn more about our latest job openings. Awards and Recognitions --Staffing Industry Analysts: Best Staffing Firm to Work For (2016, 2015, 2014, 2013, 2012) --Staffing Industry Analysts: Largest U.S. Staffing Firms (2016, 2015, 2014, 2013) --Staffing Industry Analysts: Largest Minority Owned IT Staffing Firm in the US.
Job Description
Location: Lisle, IL 60532
Job Title: Database Programmer
Duration: 12+ Months (Contract to hire)
Responsibilities:
· Design database for OLTP and OLAP applications
· Define database standards for tables, columns, indexes
· Handle the daily responsibilities of supporting the build and release needs of Agile scrum teams
· Provide guidance to cross-team and team members in database best practices and procedures
· Support all pre-production, managed environments for middleware services and applications
· Deploy code and otherproactivemaintenance activities to keep the services up and running
· Own specific deployment problems and provide active coordination between various groups including internal and external groups in resolving a specific problem
· Work with Development, QA and other teams to understand changes to the existing production environment on an ongoing basis and for environment support
· Update documentation that communicates standards and best practices of the engineering team
· Implement metrics, Success Factors and KeyPerformance Indicatorsfor the process and the team
Qualifications
· BS in Computer Science or equivalent
· 3+ years of experience Database Programming/Management
Should Have:
Database capacity planning
C# or Java Programming
· PostgreSQL
· MongoDB
· NOSQL
Required Skills:
· Database Design
· T-SQL Programming
· Stored procedures/Functions/ Trigger Development
· MS SQL Server Installation, configuration
· Query optimization, Execution plan Analysis
· MS SQL Server Job setup
· Database Performance Monitoring
· MS SQL Server Database Optimization
Additional Information
To apply for this position, or to learn more about the role, please contact:
Himanshu Prajapat
************
**********************************
Easy ApplySQL Server DBA (Local to IL)
Database administrator job in Rosemont, IL
Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.
Job Description
Title: Lead SQL Server DBA
Location : Rosemont, IL
Contract to Hire
Description:
GENERAL POSITION SUMMARY
This is a non-supervisory position. The incumbent is responsible for the installation, configuration, maintenance, operation and support of SQL Server databases. Works as a team member on technical functions related to creating and maintaining databases, performance and tuning analysis, software upgrades, backup and recovery procedures.
The incumbent will provide technical expertise and support to staff members within CTS and less experienced DBAs. Additional responsibilities are likely to include planning, development and troubleshooting.
The tasks and duties outlined below do not include all possible tasks and do not limit the assignment of tasks for these positions.
DUTIES AND RESPONSIBILITIES
Installation, configuration and upgrades of SQL Servers.
Monitor, optimize and report on system performance.
Develop, manage and test back-up and recovery plans.
Manage security of databases in production and test environments.
Assist developers in performance tuning of SQL statements.
Code migration of all objects following established change control procedures.
Create and refresh test database instances.
Provide on call 24 hour, 7 day per week database support for production databases.
Troubleshoot, investigate, offer and execute resolution to database issues.
Monitor and report on database storage utilization.
Create and execute various ad-hoc database queries, as needed.
Required Qualifications
Minimum 6 years SQL DBA experience
Recent experience in MS SQL Server versions 2008/2012/2014;
Experience in troubleshooting and resolving database problems;
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models;
Experience with SQL Server High Availability (HA) and Disaster Recovery (DR).
Extensive knowledge with T-SQL.
Experience implementing operational automation using scripts;
Expertise with SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
Strong verbal and written communication skills with the ability to interact professionally with all levels in the organization.
Education (R-Required, P-Preferred)
Certifications
Additional Information
Titles:SQL Server DBA, Lead SQL DBA, SQL Database Admin, SQL Server Database Admin
Skills : SQL DBA, PTO,
Performance Tuning and Optimization, T-SQL, SSIS, SSRS,
Oracle E-Business Suites DBA
Database administrator job in Chicago, IL
360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.
Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and JQuery mobile.
Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one's business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel's through us.
We make sure that we deliver performance driven products that are optimally developed as per your organization's needs. Take a shot at us for your IT requirements and experience a radical change.
Job Description
Position Description/Responsibilities:
Equal Opportunity Employer is seeking an Oracle E-Business Suites (EBS) Database Administrator to join a team of professionals providing IT services to a large Public Sector client.
The work location is conveniently located downtown Chicago near all major public transportation channels.
We want to speak to talented EBS DBAs who are ready for a challenging, long term engagement. You will join a team of three (3) CAI EBS DBAs supporting the client's ERP applications.
You will report to client's DBA manager and will perform the following activities as directed:
Oracle database installation, patching, and upgrading
Application installation, configuration, patching, upgrading and cloning
Code installation
System and SQL tuning
Backup/recovery
Security implementation
System monitoring and health checks
SR support with Oracle
Standards/best practice implementation and enforcement
On-call/afterhours support on rotation basis
Position Requirements/Technical Skills:
Requirements/Skills
Primary/ Secondary
Skill level (1-5)
Comments
E-Business Suite Application DBA Skills (7+ years experience)
R12 (2+ years)
Primary
4
10+ Preferred
R12 EBS Application Installation, patching and upgrading
Primary
4
Experience in Payroll, HRMS and Financials (Mandatory)
Worked in Multinode Architecture Environment
Primary
4
Mandatory
Worked in Unix/Linux Environments
Primary
4
Mandatory
Should have working knowledge of Oracle RAC and ASM
Primary
4
Mandatory. Experience in Exadata, definite plus
Application cloning using rapid clone
Primary
4
Mandatory
Application backup and recovery
Primary
4
Mandatory
Application Load balancing using HW load balancer
Secondary
3
Desired
Experience with OEM Grid Control
Primary
3
Desired
Oracle Sql Query Tuning
Primary
3
Working knowledge of Oracle Performance tuning and diagnostic utilities
Secondary
3
Desired
Oracle Backup and recovery using Rman
Primary
3
Desired; Exposure to any other backup tools is a plus. Commvault backup tool, definite plus.
Working knowledge of Application Patching, maintenance and diagnostic utilities
Primary
4
Mandatory
Application and database auditing
Secondary
3
Experienced in data life cycle management
Secondary
3
Any ILM tool experience is a plus
Unix Shell Scripting, Perl, Awk
Secondary
3
Desired
Communication Skills
Primary
3
Documentation Skills
Secondary
4
Highly desired
Working knowledge of Oracle customer support, Product Support, Certification and product end of life policies
Primary
3
Mandatory
DMZ environment
Secondary
3
Desired
Data warehouse experience
Secondary
3
Desired
Additional Information
Unfeigned Regards,
Preeti Nahar| Sr. Talent & Client Acquisition Specialist - TAG US | 360 IT Professionals Inc.
C: +1 510-254-3300 ext. 140
Database Analyst
Database administrator job in Chicago, IL
Database Analyst needs two years of professional work experience in financial operations, banking, database management, gift processing or similar field
Database Analyst requires:
Experience analyzing, investigating and solving database issues.
Experience using Business Objects or other database reporting software.
Ability to manage confidential information with discretion and tact.
Ability to act with integrity, professionalism, and confidentiality.
Ability to work collegially and collaboratively in a team setting.
Ability to prioritize multiple projects and independently follow through with detail.
Database Analyst duties:
Ability to manage confidential information with discretion and tact.
Ability to act with integrity, professionalism, and confidentiality.
Ability to work collegially and collaboratively in a team setting.
Ability to prioritize multiple projects and independently follow through with detail
Manage, approve, and record a variety of gifts according to University policies and other related guidelines.
Coordinate and record gift data uploaded through automated and semi-automated interfaces between the database and other related databases.
SQL Server DBA
Database administrator job in Chicago, IL
About Us :
Scadea Solutions is a global talent acquisition and executive search company. We work exclusively with some of the most reputed and admired clients across various sectors and geographies. This is a very urgent role.
Title: SQL Server DBA
Location: Lake Forest, IL(Need Locals)
Length: 2 Months (Potential Extension)
Visa: USC, GC
Skype Interview allowed if candidate can start ASAP
:
The DBA provides production and project support for designated databases deployed throughout the company. The DBA must also provide database consulting/guidance services to other Grainger business areas. Works with project teams to design and deploy databases
• Performs database upgrade, install and patching
• Monitors database performance and implements changes necessary to maintain acceptable performance levels.
• Ensures the availability and recoverability of all databases.
• Develops and document processes and procedures for maintenance, installation, upgrade, backups and recoveries of production and test databases as required by the business
• Provides 24x7 production database support on a rotational basis if needed
• Troubleshoots and tracing database related transactions in a multi-tier application across internal and ISP networks, firewalls and different platforms (Unix/Linux/Windows)
• DBA will create documentation and provide Knowledge Transfer (e.g. documentation, training) to other Grainger DBAs.
Major responsibilities and duties:
All aspects of SQL Server database and associated technologies.
- 5 years in SQL Server database administration
Mandatory Technical Skills
• Must have SQL Server experience with SQL 2008 through current versions and editions and support experience from Development to Production landscapes.
• Experience SQL Server management tools, Configuration tools, Integration services and Reporting services
• Knowledge of Solarwinds DPA monitoring and experience and use to troubleshoot issues.
• Must have worked hands-on in a SQL Server administrator role in implementing database ystems and providing VPT and production support in large active environments
• Familiarity with VM environments
Nice to have technical skills:
SQL Server certification, knowledge of Powershell
Soft Skills:
• Strong problem analysis and resolution (debugging) skills.
• Time management skills to balance priorities and deliver assignments on time and within budget
• Ability to effectively communicate technical issues to software suppliers and to the business representatives.
• An understanding of production environments including the requirement for high availability and team oriented 24x7 support capabilities.
• Must have the ability to multi-task in a very fast-paced environment.
• Ability to handle high pressure situations and quickly respond and resolve production problems
Additional Job Requirements
DBA MUST have worked in MicroSoft SQL 2012 using Always On configuration with at least one implementation.
MUST have experience with SQL server and Active Directory security configuration.
Qualifications
Bachelors
Additional Information
Required Skills:
Job Description:
Performs highly complex application programming/systems development and support Performs highly complex configuration of business rules and technical parameters of software products Review business requirements and develop application design documentation Build technical components (Maximo objects, TRM Rules, Java extensions, etc) based on detailed design.
Performs unit testing of components along with completing necessary documentation. Supports product test, user acceptance test, etc as a member of the fix-it team. Employs consistent measurement techniques Include testing in project plans and establish controls to require adherence to test plans Manages the interrelationships among various projects or work objectives
SQL DBA / Systems Analyst
Database administrator job in Chicago, IL
Job DescriptionSQL DBA / Systems AnalystEmployment Type: Full Time, Mid-level Department: Information Technology CGS is seeking a SQL DBA / Systems Analyst to join our team supporting a wide-ranging technical support initiative for a large Federal agency.CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others.
Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success:- Advanced processing of Electronic Stored Information (ESI) into multiple systems including hands-on file manipulations and conversions.- Designing and implementing action plans to upgrade new litigation support tools within established environments by participating in Change Control Board Meetings.- Leading user acceptance testing efforts and validating the rollout of new software upgrades; and integrating legal systems to improve efficiencies by creating scripts and advanced queries and introducing automated workflow concepts.- Assists in administering database organizations, standards, controls, and procedures.- Provides technical consulting in the definition, design, and creation of a database environment.- Maintains documentation and develops database dictionaries.
Qualifications:- Undergraduate degree (or equivalent) with five years of professional experience, including four years performing tasks related to ESI Processing or upgrading and integrating technical systems.- Knowledge of file manipulation applications, scripting, and the eDiscovery industry.- Certification in an eDiscovery program or related software package (i.e., Concordance, Relativity, Clearwell).- Must be willing to achieve Relativity Certified Administrator credential within 6 months of hire.- Must have experience working within a network environment supporting an eDiscovery platform.- Must have experience in Performing eDiscovery application system maintenance, upgrades, and day-to-day administration.- Must have three years of experience designing, administering, maintaining, and updating databases.- Must be familiar with government network operating environment standards and security requirements.
Ideally, you will also have:- 10+ years of experience supporting eDiscovery teams with SQL DBA requirements.- Technical certifications or other pertinent graduate degrees preferred.- Technology-assisted review experience is a plus. Our Commitment:Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems.
For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work.
Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.
We care about our employees. Therefore, we offer a comprehensive benefits package.- Health, Dental, and Vision- Life Insurance- 401k- Flexible Spending Account (Health, Dependent Care, and Commuter)- Paid Time Off and Observance of State/Federal Holidays
Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Join our team and become part of government innovation!Explore additional job opportunities with CGS on our Job Board:**************************************** more information about CGS please visit: ************************** or contact: Email: *******************
#CJ
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
Easy ApplySQL Server DBA - INTL India
Database administrator job in Lincolnshire, IL
A large retail company is looking for an experienced Microsoft SQL Server Database Administrator based in India to join our offshore DBA team, providing round-the-clock support for a large-scale retail environment with over 200 databases supporting 200+ store locations. Working closely with one other offshore DBA, the Lead SQL Server DBA, and the onshore team, you will play a critical role in maintaining system availability, driving upgrades and migration projects, resolving incidents, optimizing performance, and ensuring robust security and disaster recovery capabilities for mission-critical retail systems targeting 99.99% uptime. MUST BE ABLE TO START WITHIN 3 WEEKS FROM OFFER!
Pay Rate: 20-25/hr
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to ********************.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: ****************************************************
Skills and Requirements
- 5+ years hands-on Microsoft SQL Server DBA experience (2016-2022)
Expertise in upgrades, migrations, patching, backup/restore
- Strong AlwaysOn Availability Groups and Failover Clustering experience
- Proven performance tuning and troubleshooting (queries, indexes, execution plans)
- Solid SQL Server security implementation (roles, permissions, auditing, encryption)
- Hands-on experience with Idera Diagnostic Manager or SolarWinds DPA
- Knowledge of Azure SQL Database or SQL Managed Instance
- Scripting/automation skills using PowerShell or T-SQL
- Availability for follow-the-sun shifts, night/weekend work, and on-call rotation
- Excellent English communication and remote collaboration skills - Experience in retail or POS environments
- Familiarity with ITIL processes and ticketing systems (e.g., ServiceNow, Jira)
- Microsoft certifications (e.g., MCSA/MCSE: Data Management and Analytics or DP-300)
SQL DBA
Database administrator job in Evanston, IL
MUST HAVE: •5+ years of progressive MS SQL DBA experience •Experience with database design, scripting, implementation and maintenance •Experience with data modeling tools and data model development •From SQL side knowledge of the following: Build and maintain SQL scripts
Manage job processes and log files
Perform backup and restore procedures and maintain user profiles and scripts on production databases
•Experience with developing and establishing reporting, process, documentation and policies related to the data base environment
•Experience with legacy technologies including AS/400
•Strong written & verbal communication skills
NICE TO HAVE:
•DB2/400 experience
•PostgreSQL and other relational databases
•RPG experience
•Java expeirnice
•Experience with transitions and migrations
Additional Information
All your information will be kept confidential according to EEO guidelines
Lead Database Administrator
Database administrator job in Dix, IL
It's an exciting time to join defi! defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn.
Position Purpose:
The Lead Database Administrator is responsible for managing all operational aspects of production and non-production database environments across multiple data centers supporting defi SOLUTIONS. This role oversees daily database performance, backups, tuning, patching, and overall maintenance of all database systems.
You will collaborate with operational and engineering teams to define requirements, architect solutions, and deliver reliable database services. Additionally, you'll work closely with Client Services, Relationship Management, and various development and technical teams to ensure the operational needs of both clients and internal users are consistently met.
This is a multifaceted role requiring strong communication, leadership, and technical expertise to maintain high availability, performance, and security across all database platforms. Participation with On-Call is a critical aspect of this role, ensuring 24/7 support and rapid response to production issues or outages.
Essential functions:
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
* Setup, configure and manage SQL Server Always On Availability Groups on virtual machines.
* Primary responsibilities include installation, configuration, security management, patching, upgrades, backups, restores, environment refreshes, performance tuning, routine maintenance, disaster recovery planning and alerting/monitoring.
* Support ongoing database maintenance tasks, many of which must be completed within defined maintenance windows to ensure system availability and compliance.
* Support both Azure and AWS SQL Enviornments
* Interact with clients, analysts, and other team members to resolve issues.
* Assist less experienced team members and assist in problem resolution as necessary.
* Critical On-Call support to participate in incident and problem management processes and provide support as needed to ensure system reliability and timely issue resolution.
* Stay Current on emerging technologies
* Collaborate with other members of the Operations Team to design and implement solutions
* Open and Escalate cases with Microsoft when required
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Required education and experience:
* Bachelor's degree or equivalent work experience
* 10+ years' experience in an IT operations environment performing database administration.
* 3+ years of experience with Azure portal and all topics in Azure related to database maintenance including SQLMI and AzureSQL with failover groups as well as Azure CLI
* 3+ years of experience with AWS portal including CLI, S3, EC2, EBS and infrastructure knowledge
* 3+ years of experience with SQL Server Always On Availability Groups
* PowerShell Scripting experience
* Deep knowledge of SQL internal functionality including but not limited to
* Query Processing and Optimization
* Reading and Analyzing Execution plans, table statistics, data distribution and execution times
* Indexing Mechanisms
* Types, Maintenance and impact
* Transaction Management
* Isolation levels, Locking mechanisms, deadlocks, etc.
* Storage Architecture
* Data Pages, filegroups, row/page compression, etc.
* Expert in large database design (logical, physical, conceptual) for OLTP and data warehouse environments using the Microsoft platform.
* Backup and Recovery
* Backup types, Recovery Models, PITR, Disaster Recovery Planning, etc.
* Experience with maintaining high availability SQL environments and Disaster Recovery Strategies.
* Security and Access Control
* Authentication, Encryption, auditing, access requirements, etc.
* Monitoring and Performance Tuning
* Wait Statistics, Dynamic Management Views, Query Store, etc.
* Experience with Datadog, Elastic or New Relic
* Maintenance and Housekeeping
* Database Consistency checks, statistics updates, index maintenance, log file management.
* Experience using SQL Server Agent to develop and schedule administration jobs, alerts and groups.
* Effective analytical, communication, interpersonal and problem-solving skills.
* No management experience is required.
Preferred education and experience:
* Knowledge in Snowflake Administration
* Knowledge and experience working on Azure Cloud, Azure SQL and SQL Managed Instance is a plus
* Knowledge in Azure resources such as Storage Accounts, Blob Storage, Keyvault, Azure Active Directory
Additional eligibility requirements:
* An achiever, self-starter, and eager to learn
* You'll have a proven track record of results as we'll expect you to act decisively, think big, and manage your time and your team's time to meet deadlines in a fast-paced, high-volume environment.
* Most importantly, you'll want to contribute to a diverse, supportive, and talented team.
Travel required:
* Travel is potential to be 10% of time
Affirmative Action/EEO statement:
defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.
Database Administrators
Database administrator job in Rockford, IL
Mercor is collaborating with a leading AI organization to identify experienced Database Administrators for a high-priority training and evaluation project. Freelancers will be tasked with performing a wide range of real-world database operations to support AI model development focused on SQL, systems administration, and performance optimization. This short-term contract is ideal for experts ready to bring practical, production-grade insights to frontier AI training efforts. * * * **2\. Key Responsibilities** - Design and optimize complex SQL queries using EXPLAIN plans and indexing strategies - Implement schema changes with CREATE/ALTER statements and rollback planning - Configure and validate automated backup and restoration procedures - Manage user roles and permissions following defined security policies - Export/import data between systems with validation checks and encoding integrity - Execute data quality checks and report violations with remediation scripts - Apply statistics updates, manage transaction logs, and test failover recovery - Perform compliance data extractions, patching, and system audits for enterprise use cases - Document processes and performance findings in clear, reproducible formats * * * **3\. Ideal Qualifications** - 5+ years of experience as a Database Administrator working in production environments - Expert-level SQL skills and proficiency with PostgreSQL, MySQL, and/or SQL Server - Strong background in performance tuning, security, data integrity, and schema design - Familiarity with compliance standards (e.g., SOX), data export formats, and backup tooling - Comfortable handling large datasets, interpreting execution plans, and managing database infrastructure end-to-end - Ability to produce production-quality scripts and documentation for technical audiences * * * **4\. More About the Opportunity** - Remote and asynchronous - work on your own schedule - **Expected commitment: minimum 30 hours/week** - **Project duration: ~6 weeks** * * * **5\. Compensation & Contract Terms** - $90-100/hour for U.S.-based freelancers (localized rates may vary) - Paid weekly via Stripe Connect - You'll be classified as an independent contractor * * * **6\. Application Process** - Submit your resume followed by domain expertise interview and short form * * * **7\. About Mercor** - Mercor is a talent marketplace that connects top experts with leading AI labs and research organizations. - Our investors include Benchmark, General Catalyst, Adam D'Angelo, Larry Summers, and Jack Dorsey. - Thousands of professionals across domains like law, creatives, engineering, and research have joined Mercor to work on frontier projects shaping the next era of AI.
SQL Developer/ Database Programmer/ Database developer/ DBA Programmer (Cont. to Hire)
Database administrator job in Lisle, IL
Collabera is ranked amongst the top 10 Information Technology (IT) staffing firms in the U.S., with more than $550 million in sales revenue and a global presence that represents approximately 12,000+ professionals across North America (U.S., Canada), Asia Pacific (India, Philippines, Singapore, Malaysia) and the United Kingdom. We support our clients with a strong recruitment model and a sincere commitment to their success, which is why more than 75% of our clients rank us amongst their top three staffing suppliers.
For consultants and employees, Collabera offers an enriching experience that promotes career growth and lifelong learning. Visit ***************** to learn more about our latest job openings. Awards and Recognitions --Staffing Industry Analysts: Best Staffing Firm to Work For (2016, 2015, 2014, 2013, 2012) --Staffing Industry Analysts: Largest U.S. Staffing Firms (2016, 2015, 2014, 2013) --Staffing Industry Analysts: Largest Minority Owned IT Staffing Firm in the US.
Job Description
Location:
Lisle, IL 60532
Job Title: Database Programmer
Duration: 12+ Months (Contract to hire)
Responsibilities:
· Design database for OLTP and OLAP applications
· Define database standards for tables, columns, indexes
· Handle the daily responsibilities of supporting the build and release needs of Agile scrum teams
· Provide guidance to cross-team and team members in database best practices and procedures
· Support all pre-production, managed environments for middleware services and applications
· Deploy code and otherproactivemaintenance activities to keep the services up and running
· Own specific deployment problems and provide active coordination between various groups including internal and external groups in resolving a specific problem
· Work with Development, QA and other teams to understand changes to the existing production environment on an ongoing basis and for environment support
· Update documentation that communicates standards and best practices of the engineering team
· Implement metrics, Success Factors and KeyPerformance Indicatorsfor the process and the team
Qualifications
· BS in Computer Science or equivalent
· 3+ years of experience Database Programming/Management
Should Have:
Database capacity planning
C# or Java Programming
· PostgreSQL
· MongoDB
· NOSQL
Required Skills:
· Database Design
· T-SQL Programming
· Stored procedures/Functions/ Trigger Development
· MS SQL Server Installation, configuration
· Query optimization, Execution plan Analysis
· MS SQL Server Job setup
· Database Performance Monitoring
· MS SQL Server Database Optimization
Additional Information
To apply for this position, or to learn more about the role, please contact:
Himanshu Prajapat
************
**********************************
Easy ApplySQL Server DBA (Local to IL)
Database administrator job in Rosemont, IL
Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark McGee, the President and CEO. Sonoma Consulting has two business divisions - IT Consulting Services & Executive Search to serve its 150 national clients which range from entrepreneurial start-ups to Global Fortune 500.
Job Description
Title: Lead SQL Server DBA
Location : Rosemont, IL
Contract to Hire
Description:
GENERAL POSITION SUMMARY
This is a non-supervisory position. The incumbent is responsible for the installation, configuration, maintenance, operation and support of SQL Server databases. Works as a team member on technical functions related to creating and maintaining databases, performance and tuning analysis, software upgrades, backup and recovery procedures. The incumbent will provide technical expertise and support to staff members within CTS and less experienced DBAs. Additional responsibilities are likely to include planning, development and troubleshooting.
The tasks and duties outlined below do not include all possible tasks and do not limit the assignment of tasks for these positions.
DUTIES AND RESPONSIBILITIES
Installation, configuration and upgrades of SQL Servers.
Monitor, optimize and report on system performance.
Develop, manage and test back-up and recovery plans.
Manage security of databases in production and test environments.
Assist developers in performance tuning of SQL statements.
Code migration of all objects following established change control procedures.
Create and refresh test database instances.
Provide on call 24 hour, 7 day per week database support for production databases.
Troubleshoot, investigate, offer and execute resolution to database issues.
Monitor and report on database storage utilization.
Create and execute various ad-hoc database queries, as needed.
Required Qualifications
Minimum 6 years SQL DBA experience
Recent experience in MS SQL Server versions 2008/2012/2014;
Experience in troubleshooting and resolving database problems;
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
Experience with backups, restores and recovery models;
Experience with SQL Server High Availability (HA) and Disaster Recovery (DR).
Extensive knowledge with T-SQL.
Experience implementing operational automation using scripts;
Expertise with SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
Strong verbal and written communication skills with the ability to interact professionally with all levels in the organization.
Education (R-Required, P-Preferred)
Certifications
Additional Information
Titles:SQL Server DBA, Lead SQL DBA, SQL Database Admin, SQL Server Database Admin
Skills : SQL DBA, PTO, Performance Tuning and Optimization, T-SQL, SSIS, SSRS,
SQL DBA / Systems Analyst
Database administrator job in Chicago, IL
SQL DBA / Systems AnalystEmployment Type: Full Time, Mid-level Department: Information Technology CGS is seeking a SQL DBA / Systems Analyst to join our team supporting a wide-ranging technical support initiative for a large Federal agency.CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others.
Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities. Skills and attributes for success:- Advanced processing of Electronic Stored Information (ESI) into multiple systems including hands-on file manipulations and conversions.- Designing and implementing action plans to upgrade new litigation support tools within established environments by participating in Change Control Board Meetings.- Leading user acceptance testing efforts and validating the rollout of new software upgrades; and integrating legal systems to improve efficiencies by creating scripts and advanced queries and introducing automated workflow concepts.- Assists in administering database organizations, standards, controls, and procedures.- Provides technical consulting in the definition, design, and creation of a database environment.- Maintains documentation and develops database dictionaries.
Qualifications:- Undergraduate degree (or equivalent) with five years of professional experience, including four years performing tasks related to ESI Processing or upgrading and integrating technical systems.- Knowledge of file manipulation applications, scripting, and the eDiscovery industry.- Certification in an eDiscovery program or related software package (i.e., Concordance, Relativity, Clearwell).- Must be willing to achieve Relativity Certified Administrator credential within 6 months of hire.- Must have experience working within a network environment supporting an eDiscovery platform.- Must have experience in Performing eDiscovery application system maintenance, upgrades, and day-to-day administration.- Must have three years of experience designing, administering, maintaining, and updating databases.- Must be familiar with government network operating environment standards and security requirements.
Ideally, you will also have:- 10+ years of experience supporting eDiscovery teams with SQL DBA requirements.- Technical certifications or other pertinent graduate degrees preferred.- Technology-assisted review experience is a plus. Our Commitment:Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems.
For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work.
Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.
We care about our employees. Therefore, we offer a comprehensive benefits package.- Health, Dental, and Vision- Life Insurance- 401k- Flexible Spending Account (Health, Dependent Care, and Commuter)- Paid Time Off and Observance of State/Federal Holidays
Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Join our team and become part of government innovation!Explore additional job opportunities with CGS on our Job Board:**************************************** more information about CGS please visit: ************************** or contact: Email: *******************
#CJ
Auto-ApplyLead SQL DBA
Database administrator job in Lincolnshire, IL
You will be responsible for leading a team of 4 SQL Server + 2 Oracle/EBS DBAs (onshore/offshore) in a 50%+ hands-on role within a distributed enterprise environment (SQL 2012-2022, physical/virtual/cloud) supporting nationwide retail, e-commerce, POS, CRM, and ERP systems; spend the first 3-6 months diving deep into complex query optimization, performance tuning, escalations, troubleshooting, monitoring database health, implementing DR/backups, and collaborating with dev teams on database design-while establishing leadership through performance management, mentoring, and skill development; long-term, drive licensing consolidation and optimization to reduce costs, eliminate single-instance dependencies, enforce standards and best practices, ensure security and compliance, implement automation and tooling improvements (Dynatrace/Idera), support hybrid cloud migration planning, partner with the VP of IT Infrastructure on strategy, capacity planning, and technology roadmap, and maintain a sharp technical edge with no fade to management-only.
Pay Rate: 90-100/hr
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to ********************.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: ****************************************************
Skills and Requirements
- 10+ years of hands-on Microsoft SQL Server database administration experience
- 3+ years of leadership experience with ability to provide strategic direction while remaining technically proficient
- Expert-level knowledge of SQL Server 2012, 2016, 2019, and 2022 administration
- Extensive experience working with multiple SQL Server versions in complex enterprise environments
- Advanced T-SQL programming skills including stored procedures, functions, triggers, and query optimization
- Deep expertise in SQL Server performance tuning, execution plan analysis, and troubleshooting
- Strong understanding of disaster recovery and backup strategies (critical requirement)
- Experience with database security implementation and compliance requirements
- Proven ability to manage both onshore and offshore team members
- Experience in distributed, multi-location enterprise environments
- Strong problem-solving skills with ability to quickly diagnose and resolve complex database issues
- Excellent communication skills-able to explain technical concepts to both technical and non-technical stakeholders
- Self-starter who can "go with the flow but also be driven and provide direction and have opinions"
- Comfortable working in environments with legacy systems and technical debt - Experience in retail, e-commerce, or multi-location operational environments
- Background supporting high-transaction systems (POS, inventory management, e-commerce platforms)
- Familiarity with Oracle databases (helpful but not required-understanding is a plus)
- Experience with cloud platforms (Azure/AWS) and hybrid infrastructure
- Knowledge of database licensing optimization and consolidation strategies
- Experience with Dynatrace, Idera, Redgate, SolarWinds, or similar monitoring tools
- Proficiency with PowerShell scripting for automation
- Understanding of SSIS, SSRS, SSAS
- Microsoft SQL Server certifications (MCSA, MCSE, Azure Data certifications)
- Experience working in leaner IT organizations where you wear multiple hats
- Background in environments requiring minimal downtime for maintenance
Database Administrators
Database administrator job in Elgin, IL
Mercor is collaborating with a leading AI organization to identify experienced Database Administrators for a high-priority training and evaluation project. Freelancers will be tasked with performing a wide range of real-world database operations to support AI model development focused on SQL, systems administration, and performance optimization. This short-term contract is ideal for experts ready to bring practical, production-grade insights to frontier AI training efforts. * * * **2\. Key Responsibilities** - Design and optimize complex SQL queries using EXPLAIN plans and indexing strategies - Implement schema changes with CREATE/ALTER statements and rollback planning - Configure and validate automated backup and restoration procedures - Manage user roles and permissions following defined security policies - Export/import data between systems with validation checks and encoding integrity - Execute data quality checks and report violations with remediation scripts - Apply statistics updates, manage transaction logs, and test failover recovery - Perform compliance data extractions, patching, and system audits for enterprise use cases - Document processes and performance findings in clear, reproducible formats * * * **3\. Ideal Qualifications** - 5+ years of experience as a Database Administrator working in production environments - Expert-level SQL skills and proficiency with PostgreSQL, MySQL, and/or SQL Server - Strong background in performance tuning, security, data integrity, and schema design - Familiarity with compliance standards (e.g., SOX), data export formats, and backup tooling - Comfortable handling large datasets, interpreting execution plans, and managing database infrastructure end-to-end - Ability to produce production-quality scripts and documentation for technical audiences * * * **4\. More About the Opportunity** - Remote and asynchronous - work on your own schedule - **Expected commitment: minimum 30 hours/week** - **Project duration: ~6 weeks** * * * **5\. Compensation & Contract Terms** - $90-100/hour for U.S.-based freelancers (localized rates may vary) - Paid weekly via Stripe Connect - You'll be classified as an independent contractor * * * **6\. Application Process** - Submit your resume followed by domain expertise interview and short form * * * **7\. About Mercor** - Mercor is a talent marketplace that connects top experts with leading AI labs and research organizations. - Our investors include Benchmark, General Catalyst, Adam D'Angelo, Larry Summers, and Jack Dorsey. - Thousands of professionals across domains like law, creatives, engineering, and research have joined Mercor to work on frontier projects shaping the next era of AI.