SQL Server DBA (Systems level)

08 Nov 2024

Vacancy expired!

Fantastic opportunity for a SQL Server DBA (Systems Level)!Our Chicago- based client is looking for a SQL Server DBA (Systems Level) to design, administer and maintain enterprise database systems, including Oracle, SQL Server, DB2, MongoDB, Snowflake etc.Works with development and infrastructure teams to implement new applications, enhancements and upgrades. Tunes the databases for optimal performance and recommends improvements in the environment.Please submit resume with a link to your LinkedIn profile.

Major Responsibilities• Install and configure SQL Server, SSIS, SSRS and SSAS on virtual/physical machines.• Maintains database environment according to best practices and enterprise standards.• Works with development team with code tuning to ensure successful implementations.• Provides support for database architecture and systems, including upgrades.• Participates in disaster recovery tests and manages backup processes.• Monitors growth of systems to proactively prevent issues from occurring.• Participates in the evaluation of tools supporting the databases. Recommends changes and enhancements to improve the environment and provide excellent customer service.• Understands and demonstrates Core Values.• Participate in a rotating 24/7 on call support role.• Performs other duties as assigned.• Thinks Database as a product and own it.• Strong attention to detail and problem solving skills.• Diagraming, presentation and communication skills.

Skills/Knowledge Required• Minimum 3 years of experience in database technologies such as SQL and Oracle.• 1+ years experience in Azure PAAS, IAAS.• 1+ year experience with CI/CD and automation tools.• Proficient with DDL, DML, SSIS, SSRS, SSAS Powershell or other automation languages.• Understanding of database security.• Understanding of HA, Replication, DR, Always on options for SQL Server.

Experience in the following technologies is preferred:DB2, MongoDB, SnowFlake, Power BI, Azure, Azure Data Factory, Control M, Powershell, DevOPS, Automation tools, Linux.

Education and Experience• Bachelors degree in Computer Science.• Minimum 3 years database administration experience.• Certification in RDBMS preferred.Peterson Technology Partners (PTP) is an Equal Opportunity Employer that is committed to diversity and inclusion in the workforce.

About the Company:Peterson Technology Partners (PTP) has been Chicago's premier Information Technology (IT) staffing, consulting, and recruiting firm for over 23+ years. Named after Chicago's historic Peterson Avenue, PTP has built its reputation by developing lasting relationships, leading digital transformation, and inspiring technical innovation throughout Chicagoland.Based in Park Ridge, IL, PTP's 250+ employees have a narrow focus on a single market (Chicago) and expertise in 4 innovative technical areas;· Cybersecurity· Artificial Intelligence· Data Science· Cloud & DevOpsPTP exists to ensure that all of our partners (clients and candidates alike) make the best hiring and career decisions.

  • ID: #22396667
  • State: Illinois Chicago 60290 Chicago USA
  • City: Chicago
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2021-11-08
  • Deadline: 2021-12-27
  • Category: Software/QA/DBA/etc