Database Engineer, Senior

About Us

Data Analysis Incorporated (DAI) is the controlling entity of the O’Neil family of businesses. DAI and its subsidiaries operate in diverse industries worldwide, including global equity markets, health care, financial services, digital news, and insurance. Our global footprint allows our teams to be responsive to customer needs in a timely and efficient manner. We are dedicated to using technology and innovation to bring change and growth to our businesses. We believe in a dynamic workplace, creating engaging, informative products and services that help our customers succeed. Integrity is an essential characteristic for our firms and our associates; if this describes you, please apply!

Summary

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

Compensation and Location

• $120K to $140K yearly, 10% yearly bonus target.
• 3100 E Plano Prkwy, PLano TX, 75074

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 plus

Working Conditions

Must be able to perform essential job duties. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods (66% each work day), the ability to hear the telephone, the ability to enter data on a computer, and may also require the ability to lift to 10 pounds.

Equal Opportunity Employer

Data Analysis Inc is an equal opportunity employer. All aspects of employment, including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.