Database Administrator, SQL

Be part of the team that drives our company forward, transforming ideas into real-world tools and platforms that support the business and spur innovation.

North Haven, CT

CONNECTION

<p><strong>At Connection, our purpose is simple: we connect people with technology. From hardware&mdash;PCs, printers, servers, and more&mdash;to cutting-edge cloud, cybersecurity, and professional IT services, we design, build, and support the IT solutions that thousands of companies, schools, and government agencies rely on every day. We like to think of ourselves as the IT Department for our customers&rsquo; IT Department. Our company started out almost 40 years ago with two employees and a phone line. Today we&rsquo;re a Fortune 1000 IT solutions partner operating in 174 countries around the world&mdash;still driven by that startup mentality and guided by our original purpose.</strong></p> https://www.connection.com/

keywords: position summary,position details,reporting,technical,support,quality assurance,education & experience,proficiency

Full Time

$40.00/Hr. - $45.00/Hr.

Overview: <p>Connection has a fantastic opportunity through our Technical Staffing division for a Database Administrator in North Haven, CT. This is an onsite opportunity. This is a contract to hire opportunity with a potential of full-time, offering great benefits.</p> <p>We are seeking a highly analytical and technically skilled Data Warehouse &amp; Reporting Analyst to manage, enhance, and support our enterprise reporting environment. This role focuses on designing and maintaining robust data pipelines, ensuring data quality and availability, and developing insightful reports to drive business decisions. You'll collaborate with business stakeholders to translate requirements into scalable data solutions while ensuring the security, accuracy, and integrity of the data ecosystem.</p>
Responsibilities: <div class="iCIMS_InfoMsg iCIMS_InfoMsg_Job"> <div class="iCIMS_Expandable_Container"> <div class="iCIMS_Expandable_Text"> <ul> <li>Design, build, and maintain data pipelines and ETL workflows using tools like&nbsp;<strong>SSIS</strong>&nbsp;to support data warehousing and reporting needs.</li> <li>Analyze business reporting requirements and architect data models to support ongoing and future reporting demands.</li> <li>Create and optimize&nbsp;<strong>SQL queries</strong>, stored procedures, and complex joins to extract, transform, and present meaningful data insights.</li> <li>Develop, modify, and deliver dashboards and reports using business intelligence tools and platforms (e.g.,&nbsp;<strong>CRMBI, Power BI</strong>).</li> <li>Ensure database reliability through proactive monitoring, performance tuning, and implementation of backup/recovery strategies.</li> <li>Maintain detailed documentation for data mappings, database schema, ETL processes, and security practices.</li> <li>Implement and manage database security protocols to protect sensitive business information.</li> <li>Serve as a resource for cross-functional training and provide backup support for other IT team functions.</li> <li>Deliver projects within agreed timelines and standards.</li> <li>Maintain high data integrity and system availability across the reporting environment.</li> <li>Proactively identify and resolve data quality or performance issues.</li> <li>Support disaster recovery testing and ensure alignment with organizational recovery metrics.</li> <li>Ensure readiness and compliance for audits and implement remediation as needed.</li> </ul> </div> </div> </div>
Requirements: <ul> <li><strong>Education:</strong>&nbsp;Bachelor&rsquo;s or Master&rsquo;s degree in&nbsp;<strong>Computer Science</strong>,&nbsp;<strong>Information Systems</strong>, or related field; equivalent work experience accepted.</li> <li><strong>Experience:</strong>&nbsp;3&ndash;5 years of experience in a similar role focused on data integration, reporting, and analytics.</li> <li>Strong proficiency in&nbsp;<strong>SQL</strong>&nbsp;and relational database design (normalization, indexing, optimization).</li> <li>Experience with&nbsp;<strong>SQL Server</strong>,&nbsp;<strong>PostgreSQL</strong>,&nbsp;<strong>MySQL</strong>, and&nbsp;<strong>SSIS</strong>.</li> <li>Skilled in&nbsp;<strong>data modeling</strong>, ETL development, and performance tuning.</li> <li>Familiarity with&nbsp;<strong>reporting tools</strong>&nbsp;and creating visual dashboards.</li> <li>Understanding of&nbsp;<strong>data security</strong>,&nbsp;<strong>privacy compliance</strong>, and&nbsp;<strong>disaster recovery</strong>&nbsp;strategies.</li> <li>Knowledge of&nbsp;<strong>financial systems</strong>&nbsp;or reporting in a financial services environment is a plus.</li> </ul>