Gray Matter Systems
Database Analyst
Gray Matter Systems - Cleveland, Ohio, us, 44101
Work at Gray Matter Systems
Overview
- View job
Overview
Join to apply for the
Database Analyst
role at
| GrayMatter | 16 hours ago Be among the first 25 applicants Join to apply for the
Database Analyst
role at
| GrayMatter | A t GrayMatter , we transform operations and empower people. Our consulting, implementation and technology curation services help industrial companies modernize their production environments and support operators working on the plant floor. Clients collaborate with GrayMatter to achieve their manufacturing efficiency goals, create intuitive data visualizations, reduce cybersecurity threats and guide successful digital transformation initiatives.
And thats where you come in.
GrayMatter is dedicated to creating a team of unmatched talent in industrial technology. Our organizational culture encourages opportunities to learn and collaborate. Five core values woven into our DNA make Team GrayMatter stand above the rest:
Accountability, Integrity, Respect, Innovation and Teamwork.
We are seeking a an experienced
Database Analyst (DBA)
with a minimum 5 years of hands-on experience as a SSIS and SSRS developer (SSIS: SQL Server Integration Services, SSRS: SQL Server Reporting Services), supporting HA (high availability) environments and large databases (5TB+) across 50+ data base servers to join our team. The ideal candidate will have a strong ability to work independently with minimal supervision while managing our SQL Server databases and associated tools. The DBA will play a crucial role in ensuring database performance, security, and reliability, while actively participating in reporting and ETL processes to support organizational data needs.
General Job Duties
Utilize SQL Server Management Studio (SSMS) to manage SQL Server databases, including the configuration and maintenance of High Availability Groups. Create, troubleshoot, and tune T-SQL queries to optimize database performance and ensure efficient data retrieval. Use Visual Studio to create and modify reports using SQL Server Reporting Services (SSRS), ensuring that reports meet user requirements and provide accurate insights. Collaborate with stakeholders to gather reporting needs and develop tailored solutions. Design, implement, and maintain ETL processes using SQL Server Integration Services (SSIS) through Visual Studio, ensuring streamlined data flows and integrity between systems. Regularly review and optimize existing ETL processes for efficiency and reliability. Monitor database performance using SSMS, identifying and resolving bottlenecks to maintain optimal operational efficiency. Conduct regular database maintenance tasks, including backups and restorations, to ensure data integrity and availability. Implement and manage database security protocols, ensuring user access controls and permissions are appropriately configured. Maintain documentation of database configurations, processes, and compliance with industry standards. Work closely with application developers and system Analyst s to enhance database usage and resolve issues as they arise. Utilize SQL Developer for occasional database management tasks to support various database environments. Write and execute PowerShell scripts as needed to automate routine tasks and streamline database management processes. Manage data transfers and integrations using FTP as required to facilitate smooth data operations and ensure data consistency across platforms. On-Site presence required Occasional after-hour support may be required
Knowledge, Skills And Experience Needed
Bachelors degree in Computer Science , Information Technology, or a related field. Minimum of 5 years of experience as a Database Analyst or in a similar role. Strong proficiency in SQL Server Management Studio (SSMS) and T-SQL. Experience with Visual Studio for report development (SSRS) and ETL processes (SSIS). Familiarity with SQL Developer for database management tasks. Knowledge of PowerShell for scripting and automation tasks. Understanding of data transfer protocols, including FTP. Excellent problem-solving skills, with the ability to work independently and manage multiple tasks effectively. Strong communication skills, both verbal and written.
Featured Benefits
Medical, dental, and vision insurance beginning day one of employment Employer paid short term disability and life insurance 401(k) with up to 4% company match Paid holidays, paid time off, paid sick leave, and paid parental leave Additional benefits available such as long term disability, accident, critical illness, hospital indemnity, EAP, telemedicine, HSA and FSA Seniority level
Seniority level
Not Applicable Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Automation Machinery Manufacturing Referrals increase your chances of interviewing at | GrayMatter | by 2x Sign in to set job alerts for Database Analyst roles.
Research Database Administrator - Computing Service
Business Intelligence (BI) Analyst Healthcare Data
Rocky River, OH $80,000.00-$90,000.00 2 months ago Richfield, OH $120,000.00-$145,000.00 3 weeks ago Cleveland, OH $61,900.00-$141,000.00 2 days ago Cleveland, OH $113,825.40-$146,919.75 2 days ago Cleveland, OH $61,900.00-$141,000.00 2 days ago Cleveland, OH $80,000.00-$100,000.00 1 week ago Cleveland, OH $80,412.00-$188,164.00 8 hours ago Associate Engineer Data Platform - US Based Remote
Analyst, Business Intelligence (Food & Beverage)
Cleveland, OH $107,000.00-$200,200.00 1 day ago Senior Oracle Database / E-Business Suite Engineer
Cleveland, OH $113,825.40-$146,919.75 2 weeks ago Cleveland, OH $85,000.00-$100,000.00 4 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Database Analyst
role at
| GrayMatter | 16 hours ago Be among the first 25 applicants Join to apply for the
Database Analyst
role at
| GrayMatter | A t GrayMatter , we transform operations and empower people. Our consulting, implementation and technology curation services help industrial companies modernize their production environments and support operators working on the plant floor. Clients collaborate with GrayMatter to achieve their manufacturing efficiency goals, create intuitive data visualizations, reduce cybersecurity threats and guide successful digital transformation initiatives.
And thats where you come in.
GrayMatter is dedicated to creating a team of unmatched talent in industrial technology. Our organizational culture encourages opportunities to learn and collaborate. Five core values woven into our DNA make Team GrayMatter stand above the rest:
Accountability, Integrity, Respect, Innovation and Teamwork.
We are seeking a an experienced
Database Analyst (DBA)
with a minimum 5 years of hands-on experience as a SSIS and SSRS developer (SSIS: SQL Server Integration Services, SSRS: SQL Server Reporting Services), supporting HA (high availability) environments and large databases (5TB+) across 50+ data base servers to join our team. The ideal candidate will have a strong ability to work independently with minimal supervision while managing our SQL Server databases and associated tools. The DBA will play a crucial role in ensuring database performance, security, and reliability, while actively participating in reporting and ETL processes to support organizational data needs.
General Job Duties
Utilize SQL Server Management Studio (SSMS) to manage SQL Server databases, including the configuration and maintenance of High Availability Groups. Create, troubleshoot, and tune T-SQL queries to optimize database performance and ensure efficient data retrieval. Use Visual Studio to create and modify reports using SQL Server Reporting Services (SSRS), ensuring that reports meet user requirements and provide accurate insights. Collaborate with stakeholders to gather reporting needs and develop tailored solutions. Design, implement, and maintain ETL processes using SQL Server Integration Services (SSIS) through Visual Studio, ensuring streamlined data flows and integrity between systems. Regularly review and optimize existing ETL processes for efficiency and reliability. Monitor database performance using SSMS, identifying and resolving bottlenecks to maintain optimal operational efficiency. Conduct regular database maintenance tasks, including backups and restorations, to ensure data integrity and availability. Implement and manage database security protocols, ensuring user access controls and permissions are appropriately configured. Maintain documentation of database configurations, processes, and compliance with industry standards. Work closely with application developers and system Analyst s to enhance database usage and resolve issues as they arise. Utilize SQL Developer for occasional database management tasks to support various database environments. Write and execute PowerShell scripts as needed to automate routine tasks and streamline database management processes. Manage data transfers and integrations using FTP as required to facilitate smooth data operations and ensure data consistency across platforms. On-Site presence required Occasional after-hour support may be required
Knowledge, Skills And Experience Needed
Bachelors degree in Computer Science , Information Technology, or a related field. Minimum of 5 years of experience as a Database Analyst or in a similar role. Strong proficiency in SQL Server Management Studio (SSMS) and T-SQL. Experience with Visual Studio for report development (SSRS) and ETL processes (SSIS). Familiarity with SQL Developer for database management tasks. Knowledge of PowerShell for scripting and automation tasks. Understanding of data transfer protocols, including FTP. Excellent problem-solving skills, with the ability to work independently and manage multiple tasks effectively. Strong communication skills, both verbal and written.
Featured Benefits
Medical, dental, and vision insurance beginning day one of employment Employer paid short term disability and life insurance 401(k) with up to 4% company match Paid holidays, paid time off, paid sick leave, and paid parental leave Additional benefits available such as long term disability, accident, critical illness, hospital indemnity, EAP, telemedicine, HSA and FSA Seniority level
Seniority level
Not Applicable Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
Automation Machinery Manufacturing Referrals increase your chances of interviewing at | GrayMatter | by 2x Sign in to set job alerts for Database Analyst roles.
Research Database Administrator - Computing Service
Business Intelligence (BI) Analyst Healthcare Data
Rocky River, OH $80,000.00-$90,000.00 2 months ago Richfield, OH $120,000.00-$145,000.00 3 weeks ago Cleveland, OH $61,900.00-$141,000.00 2 days ago Cleveland, OH $113,825.40-$146,919.75 2 days ago Cleveland, OH $61,900.00-$141,000.00 2 days ago Cleveland, OH $80,000.00-$100,000.00 1 week ago Cleveland, OH $80,412.00-$188,164.00 8 hours ago Associate Engineer Data Platform - US Based Remote
Analyst, Business Intelligence (Food & Beverage)
Cleveland, OH $107,000.00-$200,200.00 1 day ago Senior Oracle Database / E-Business Suite Engineer
Cleveland, OH $113,825.40-$146,919.75 2 weeks ago Cleveland, OH $85,000.00-$100,000.00 4 weeks ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr