SQL/AWS Database Engineer

We are looking for an experienced and driven Senior SQL/AWS Database Engineer to join our team. You will play a pivotal role in designing, developing, and optimizing database solutions using Microsoft SQL Server and PostgreSQL. This position demands a strong command of AWS database services, including Amazon RDS, Aurora, and DynamoDB., * Design, implement, and maintain scalable AWS database solutions, including Amazon RDS, Aurora PostgreSQL, and DynamoDB.

• Lead seamless database migrations from on-premises SQL Server to AWS, ensuring minimal downtime and data integrity.
• Automate infrastructure and deployment processes using tools like CloudFormation, Terraform, and AWS-native services (IAM, AWS Backup).
• Develop and maintain CI/CD pipelines for database deployments leveraging AWS CodePipeline, CodeBuild, and Lambda.
• Collaborate with DevOps, IT, and security teams to enforce security best practices and conduct audits for AWS and SaaS environments.
• Write and optimize complex SQL queries, stored procedures, and SSIS packages; troubleshoot and resolve database conflicts and performance issues.
• Act as a technical advisor within cross-functional product development teams, offering guidance on data architecture and performance tuning.
• Monitor long-running transactions; implement indexing strategies and efficient T-SQL coding to optimize query execution.
• Support resource allocation for databases and ensure high availability and performance.
• Provide performance analysis and trend reporting to support infrastructure planning and management.
• Contribute to the ongoing documentation of technical environments and processes.
• Participate in the team's on-call support rotation.

• Extensive SQL expertise, including advanced query tuning and optimization techniques.
• Hands-on experience with AWS database services; AWS certification is highly preferred.
• Deep knowledge of Microsoft SQL Server and PostgreSQL.
• Experience with clustering, log shipping, and database security hardening.
• Proficient in writing, debugging, and optimizing SQL scripts.
• Familiarity with Microsoft SQL Server 2008 and SSIS is required.
• Strong communication and collaboration skills, especially in small team environments.
• Demonstrated ability to solve complex problems independently.
• Bachelor's degree in Computer Science, Engineering, or a related field preferred.
• Knowledge of additional programming languages is a plus.

Company Description Data Analysis Inc (DAI) is the parent company of a global group of privately held firms in fields ranging from institutional equity markets to digital investment news and information to omnichannel communication solutions. DAI provides leadership, oversight, and strategic direction and shapes the purpose, vision, and mission of these firms. Shared services include administration, finance, and human resources. DAI's global team embraces an entrepreneurial focused environment fostering collaboration, teamwork, and creativity with a dynamic culture that emphasizes the value of its associates and their dedication to success. We strive to be leaders in our field, innovators with a history of being in the forefront of using technology to deliver our services. Company Description Data Analysis Inc (DAI) is the parent company of a global group of privately held firms in fields ranging from institutional equity markets to digital investment news and information to omnichannel communication solutions. DAI provides leadership, oversight, and strategic direction and shapes the purpose, vision, and mission of these firms. Shared services include administration, finance, and human resources. DAI's global team embraces an entrepreneurial focused environment fostering collaboration, teamwork, and creativity with a dynamic culture that emphasizes the value of its associates and their dedication to success. We strive to be leaders in our field, innovators with a history of being in the forefront of using technology to deliver our services.