Database Support Engineer - Strong in linux, SQL and Cloud experience
Job Title: Database Support Engineer - Strong in linux, SQL and Cloud experienceLocation: Chicago, IL (Hybrid)Employment Type: ContractAbout Smart IT Frame:At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.Job Summary:Strong SQL + Linux + Bash/Python + Database Administration/EngineeringEssential Technical Skills:SQL Proficiency: Ability to create, read, update, and delete data efficiently; knowledge of MySQL, PostgreSQL, Oracle, or Microsoft SQL ServerDatabase Management Systems (DBMS): Experience managing relational databases and performing data modeling.Linux Expertise: Proficiency in Linux distributions (e.g., Red Hat Enterprise Linux, CentOS, Ubuntu); knowledge of system security, permissions, firewall rules, and shell scriptingProgramming and Scripting: Python or Bash scripting for automation and integrating data pipelinesData Tools: Familiarity with analytical tools like Power BI, Tableau, or cloud platforms (AWS, Azure) is advantageousKey ResponsibilitiesDatabase Design and Management: Develop, maintain, and optimize database schemas using SQL; design table structures and relationships to support business needsQuery Optimization: Write and improve SQL queries to enhance performance, troubleshoot slow-running queries, and implement indexing strategies.Data Analysis and Reporting: Extract, analyze, and report data from large datasets using SQL along with tools like Python or TableauLinux System Administration: Install, configure, and manage Linux servers, including user account management, file system maintenance, and process monitoringScripting and Automation: Use Bash or Python scripts to automate tasks such as backups, data import/export, and routine maintenanceTroubleshooting and Debugging: Identify and resolve issues in SQL queries, database interactions, and Linux-based applications