AWS Senior Database Engineer, Plano

Job Description

Summary

The Database Engineer, Senior will work closely with the engineering team members to design, develop and enhance Microsoft SQL Server and PostgreSQL database solutions. AWS experience is necessary. Emphasis on RDS, AWS, Aurora.

Compensation

$120K to $150K, +10% yearly bonus target

Duties and Responsibilities

Design, implement, and optimize AWS database solutions, including Amazon RDS, Aurora PostgreSQL, and DynamoDB

Lead database migrations from on-premises SQL Server to AWS while ensuring high availability, minimal downtime, and data integrity

Use AWS tools and services such as CloudFormation, Terraform, AWS Backup, and AWS IAM to support database automation, security, and monitoring

Implement CI/CD pipelines for database deployments using AWS tools like CodePipeline, CodeBuild, and AWS Lambda for automation

Work with DevOps, IT, and security teams to harden AWS and SaaS applications, implement security controls, and conduct security audits

Strong MS-SQL, Pg -SQL, experience writing, tuning queries based on application requirements, performing debugging on database scripts and programs, and resolving conflicts.

Lead database migration efforts from on-premises SQL Server to AWS, ensuring minimal downtime and maintaining data integrity.

Highly skilled problem-solver and communicator that is fluent in most data manipulation languages

Design and code a high volume of SQL Queries, stored procedures, and SSIS packages

Actively participate as part of matrixed product development teams providing advice on the design and tuning of database objects, queries, and overall data architecture.

Use of tools and utilities to monitor, load, and unload data, generate, and edit test data

Effectively plan and organize daily work following priorities, ensuring timely completion of projects and user support

Work with the different Technology and business team members to ensure that the associated compute resources are allocated to the databases and to ensure high availability and optimum performance.

Provide trend analysis to the service management team to make informed decisions regarding resource management.

Develops a continually growing knowledge of the Company's internal business practices, processes, and the daily IT operational needs of the users

Provide query and performance expertise in support of code development

Monitor long-running transactions and optimize query executions with index tuning and optimized T-SQL coding technique

Problem escalation to the development team and third parties as appropriate

Implementation and release of database changes as submitted by the development team

Documenting technical environments and processes as necessary

Participate in the on-call rotation

Qualifications & Requirements

In-depth SQL knowledge is required, including advanced tuning skills

Expertise in Microsoft SQL Server or PostgreSQL

Experience with clustering and log shipping

Strong communication skills and the ability to share ideas and work well in small teams

Possesses excellent problem-solving capabilities

Independent and self-motivated

Bachelor's degree in computer science, engineering, business, or the equivalent is preferred, and five plus years of database development experience is preferred

Experience with Microsoft SQL Server 2008 and SSIS is required

Knowledge of other programming languages is a plusCompany 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.

Full-time