SQL​/AWS Senior Database Engineer, Plano

Job Description Summary

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 Postgre

SQL. This position demands a strong command of AWS database services, including Amazon RDS, Aurora, and Dynamo

DB.

Candidates must be located in the Dallas–Fort Worth Metroplex, as this is a hybrid role requiring four days per week on-site.

• $120K to $140K, + 10% Yearly bonus target.
• 3-day in office hybrid - 3100 E Plano Pkwy, Plano, TX 75074

• Design, implement, and maintain scalable AWS database solutions, including Amazon RDS, Aurora Postgre
  
  SQL, and Dynamo
  
  DB.
• 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 Cloud Formation, Terraform, and AWS-native services (IAM, AWS Backup).
• Develop and maintain CI / CD pipelines for database deployments leveraging AWS Code Pipeline, Code Build, and Lambda.
• Collaborate with Dev Ops, 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 Postgre
  
  SQL.
• 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.

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.