Stranco ยท 1 day ago
Database Engineer, Senior
Plano, TX
Full-time
Onsite
Senior Level
$120K/yr - $140K/yr
5+ years expData Analysis Inc is a company that operates in diverse industries worldwide, focusing on technology and innovation for growth. The Senior AWS/SQL Database Engineer will collaborate with the engineering team to design, develop, and enhance database solutions using Microsoft SQL Server and PostgreSQL, emphasizing AWS technologies.
AnalyticsConsultingInformation Technology
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
Qualification
Required
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
Experience with Microsoft SQL Server 2008 and SSIS is required
Preferred
Bachelor's degree in computer science, engineering, business, or the equivalent is preferred, and five plus years of database development experience is preferred
Knowledge of other programming languages is a plus
Benefits
10% yearly bonus target
Company
Stranco
Established in 1973, Stranco provides superior services and equipment in a unique set of services in the oil and gas industry.
51-200 employees
H1B Sponsorship
Stranco has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2023 (1)
2021 (1)
2020 (3)
Funding
Current Stage
Growth StageCompany data provided by crunchbase