ONSITE PRESENCE 2 DAYS PER WEEK IS REQUIRED. CONTRACT TO HIRE OPPORTUNITY.
W2 CANDIDATES ONLY .
Actively seeking a SQL Database Engineer who possesses a strong passion for designing, optimizing, refactoring, and upgrading complex data solutions. Primary product is Automotive Content, and we need someone who can help us acquire, ingest, store, organize, transform, map, relate, process, extract, and package this data using efficient, optimized, state-of-industry tools and methods to help us deliver this content to customers. The ideal candidate will have a minimum of 8 years of experience in SQL and related technologies, bringing strong capabilities in data engineering, database administration, and cloud solutions. You will be responsible for designing, implementing, and maintaining robust database solutions, ensuring optimal performance, security, and availability.
Primary Responsibilities
- Research, architect, and develop innovative multi-tiered solutions using modern tools and methodologies with a goal for technical excellence.
- Work closely with other developers, architects, and stakeholders to provide estimates based on customer experience, features, and envisioned solutions.
- Ensure architecture and design of the solution is in alignment with overall enterprise architecture.
- Solve problems and proactively look for ways to improve our products and platform.
- Monitor performance and optimize SQL queries for efficiency.
- Perform SQL Server maintenance.
- Maintain detailed documentation of database designs, configurations, and procedures.
Required Experience (must have)
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Minimum of 8 years of experience as a SQL Database Engineer.
- MUST have experience handling very large amounts of data.
- Proficiency in SQL and experience with various database management systems (SQL Server).
- Ability to design, develop, and maintain SQL queries, stored procedures, and scripts.
- Strong data engineering capabilities, including data pipeline construction and optimization.
- Proficiency in creating and managing SSIS packages for ETL processes and data integration.
- Proven database administrative skills, including performance tuning, backup/recovery, and security management.
- Proficiency in implementing and managing CI/CD pipelines in Azure for automated deployment of database changes.
- Ability to managing and integrate AWS services (EC2 and S3) with databases for optimized performance and storage solutions.
- Strong automated testing experience.
- Excellent problem-solving skills and attention to detail.
- Strong communication and teamwork abilities.
Helpful Experience (nice to have)
- TFS, Azure DevOps, or Jira project management/requirements management
- Git or TFVC version control
- Scrum and DevOps experience
- Octopus