Database Analyst

**About Us**:Capitol Canary provides access to the most comprehensive intelligence on every level of government nationwide, the most accurate contact information available, and the proven advocacy tools needed to mobilize and maximize support.Our innovative platform delivers the intelligence and insights you need to make informed and impactful decisions wherever you are, and the ability to engage and mobilize people with our pioneering suite of advocacy tools.**Our Tech Stack**:SQL Server, MySQL, Oracle, C#.NET, VB6, Microsoft Azure**What is Expected**:- Bachelor's degree (BA/BS) in a related field such as information systems, mathematics, or computer science.- Typically has 6 years of relevant work experience. Consideration given to equivalent combination of education and experience.- Excellent written and verbal communication skills. Strong organizational and analytical skills.- Expertise in Data Extraction, Transformation, Loading, Data Analysis, Data Profiling, and SQL Tuning.- Data Engineer with Expertise in Relational & Dimensional Databases in engines like SQL Server, MySQL, Oracle- Assemble large, complex data sets that meet functional / non-functional business requirements. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL Server, SSIS, T-SQL, C#.NET, VB6- Work with stakeholders including the Product, Data, Design, Frontend and Backend teams to assist with data-related technical issues and support their data infrastructure needs- Write complex SQL, T-SQL queries, stored procedures, functions, cursors in SQL Server and knowledge of GEO and Spatial data.- Analyze the long running queries/functions/procures, design and develop performance optimization strategy.- Create and manage SSIS packages and/or Informatica to perform day to day ETL activities. Use variety of strategies for complex data transformations using an ETL tool- Perform DBA activities like maintaining the systems health and performance tuning, manage database access, deployments to higher environments, on-call support, shell scripting and python scripting is a plus- Participate in employing the Continuous Deliver and Continuous Deployment (CI/CD) tools for optimal productivity. Collaborate with scrum team members during daily standup and actively engage in sprint refinement, planning, review and retrospective- AWS / Azure cloud technologies, Agile methodologies and DevOps is a big plus- Experience with developing CI/CD pipelines in Jenkins or Azure DecOps.- Configure and maintain database servers, backups and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.- Manage and implement SQL Server replication through Snapshot, Transactional and Merge replication options.**Company Benefits & Perks**:- Robust and competitive benefits package fully paid by the company- Health and Dental insurance- Flexible food stamp- Work from home allowance- English tutoring- All the Alura Courses available for all the employees- Mental Health Incentive- Flexible working hours- A highly accountable culture with coaching and development to support personal and professional growth- Teambuilding activities and lots of collaboration- An opportunity to meet and interact with leaders from government, organizations, and technology- Capitol Canary is an Equal Opportunity Employer_