Atria Group LLC Logo

Atria Group LLC

MySQL DBA

Posted 2 Days Ago
Be an Early Applicant
In-Office
Chicago, IL, USA
Senior level
In-Office
Chicago, IL, USA
Senior level
Manage and optimize MySQL transactional and data-warehouse systems for performance and availability. Administer Red Hat/CentOS web and application servers, support Rackspace VM environments, design schemas (relational, star, snowflake), optimize SQL and queries, implement replication/partitioning/high-availability, lead data-related projects, support BI/ETL (Pentaho) and scripting (Python), and drive architecture/ security and privacy initiatives.
The summary above was generated by AI
Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Company: Since starting the photo marketing revolution in 1998, eshots has evolved into the industry’s leading digital technology platform for experiential marketing. Voted one of Chicago’s Top-100 Digital Companies, eshots has continued knocking out double-digit growth through major enterprise agreements and direct technical integrations with the world’s most successful companies like General Motors, Nationwide Insurance, Mercedes-Benz, Xerox, and more. Our platform is used at a number of different events including Super Bowl, MLB, NASCAR, College Football, Auto Shows, Ride and Drives, Concerts and other client sponsored events.

 The Opportunity: We’ve spent 15 years focused on building a transparent and collaborative culture and are looking to combine high caliber talent from outside the organization with a great group of existing leaders. New customer contracts, industry-leading client satisfaction, continuous profitability and increased capital investment in our Data Capture and Business Analytics Platforms have set our company up for exponential expansion over the next 5 years. If you’re someone with marketing automation or software services experience and are ready to join an award-winning, innovative company, we have a dynamic and passionate team that would like to meet you.

What we’re looking for: We are seeking a talented MySQL DBA / System Administrator with an entrepreneurial spirit to join our expanding team. He/she will provide technical vision and leadership for our database infrastructure as well as help support our Rackspace environment. This role will also play a key role in initiatives for data privacy and data security.

 Winning Characteristics:

• Thrives in a fast-paced environment and collaborative environment.

• Enjoys new challenges and the opportunity to have a large impact on client deliverables.

• Prior experience in a smaller or fast-growth environment.

• Effective verbal and written communications skills.

• Previous experience with marketing or consumer data a plus.

 In this role, you will:

• Monitor and optimize transaction and data warehouse databases for efficient data delivery.

• Ensure peak performance of all database systems to meet ever-increasing demand for our services.

• Manage data-related technology projects.

• Provide system administration support for Red Hat /CentOS Linux web and application servers.

 Technologies you will work with:

• MySQL RDBMS (transactional databases and data warehouse)

• Red Hat/CentOS Linux web and application server experience

• Experience with Rackspace and virtual machine management, a plus

• Pentaho Data Integration (for ETL) and Python scripting experience, a plus

 You must have:

• At least 5 years of database experience, including database administration, SQL development, query optimization, and schema design.

• Experience with large scale implementations of open source database servers including MySQL.

• Knowledge of replication, partitioning, sharing, and techniques for high availability.

• Experience designing and implementing Relational, Star and Snowflake schemas.

• Advanced SQL skills.

• At least 5 years’ experience managing database, web and application servers on Red Hat/CentOS Linux

• Experience with Business Intelligence (BI) reporting tools such as Information Builders Web FOCUS or Microstrategy, a definite plus

• Experience evaluating database solutions, including Big Data and NoSQL options, desired

• Experience recommending and implementing architecture changes leading to measurable improvement.

Qualifications

• Bachelor’s degree or equivalent professional work experience.

Additional Information

  1. Good comm skills are a big priority
  2. Duration: 6-12 months + extensions
  3. Interview Process: will hire off the phone and/or Skype

Similar Jobs

2 Days Ago
In-Office
Hoffman Estates, IL, USA
Mid level
Mid level
Information Technology • Professional Services • Software • Consulting
Consultant will administer MySQL databases: set up master/slave replication, implement automated backup and recovery, perform SQL and performance tuning, manage users, use MySQL Enterprise Monitor, and train/communicate best practices to a team of developers.
Top Skills: Mysql 5.5Mysql 5.6Mysql Enterprise MonitorMysql ReplicationSQL
10 Days Ago
Remote or Hybrid
US
Senior level
Senior level
Mobile • Security • Software • Cybersecurity
Operate and optimize Keeper's cloud databases across dev, QA and production. Manage MySQL on AWS (RDS), ensure high availability, performance tuning, backups, replication, disaster recovery, schema change control with IaC tools, monitoring, incident response, automation, and participate in 24/7 on-call rotation while collaborating with engineering and DevOps teams.
Top Skills: Ai ToolsAmazon DynamodbAmazon RedshiftAws RdsLiquibaseMySQL
3 Hours Ago
Hybrid
2 Locations
217K-272K Annually
Senior level
217K-272K Annually
Senior level
Fintech • Machine Learning • Payments • Software • Financial Services
Serve as the finance leader (CFO) for Personal Loans, partnering with business and finance leaders to drive FP&A, P&L analysis, strategic decision support, senior management presentations, talent development, process improvement, and cross-functional influence in a fast-changing environment.

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account