SQL/AWS Sr. Database Engineer (Hybrid)

Data Analysis Inc.•Plano, TX

33d•Hybrid

About The Position

About UsData 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! SummaryThe Senior Database Engineer is responsible for designing, optimizing, and maintaining high-performance database systems that support critical business applications. This role requires deep expertise in Microsoft SQL Server architecture, performance tuning, and production operations, with the ability to diagnose complex database performance issues and maintain highly available database environments. The engineer will work closely with development, infrastructure, and operations teams to design scalable database solutions, troubleshoot performance bottlenecks, and ensure reliable data platform operations. This position requires hands-on experience managing production database environments, implementing high availability and disaster recovery solutions, and maintaining strong security and compliance standards.

Requirements

5+ years of hands-on experience managing and optimizing Microsoft SQL Server environments
Strong expertise in T-SQL development, performance tuning, and database architecture
Experience diagnosing database performance issues using DMVs, wait statistics, and execution plan analysis
Experience implementing high availability solutions such as Always On Availability Groups
Experience designing and maintaining enterprise backup and disaster recovery strategies
Strong troubleshooting skills in high-transaction production environments
Experience supporting database security, access control, and compliance practices
Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience)

Nice To Haves

Experience with PostgreSQL environments
Experience with SQL Server Integration Services (SSIS)
Familiarity with cloud database platforms (AWS EC2 / RDS)
Experience with database monitoring and observability tools (Datadog, SolarWinds DPA, etc.)
Knowledge of database automation or scripting languages

Responsibilities

SQL Server Architecture & Performance Optimization
Design, develop, and optimize complex T-SQL queries, stored procedures, and database objects to support application performance and scalability.
Analyze SQL Server execution plans and tune queries using advanced performance diagnostics tools and methodologies.
Investigate and resolve performance issues using SQL Server DMVs, wait statistics, and query analysis tools.
Implement effective indexing strategies including clustered, nonclustered, and filtered indexes while balancing read performance with write overhead.
Monitor long-running transactions and optimize query performance through indexing improvements and optimized query design.
Diagnose and resolve database bottlenecks including CPU contention, I/O latency, memory pressure, and query inefficiencies.
Troubleshoot and resolve concurrency issues such as blocking, deadlocks, and transaction conflicts in high-transaction environments.
High Availability & Disaster Recovery
Design, implement, and maintain SQL Server high availability solutions, including Always On Availability Groups, clustering, and log shipping.
Manage failover configurations and ensure database resilience during outages.
Develop and maintain enterprise backup and restore strategies for large and high-transaction databases.
Design and test disaster recovery procedures aligned with RPO and RTO requirements.
Conduct regular recovery validation and failover testing to ensure operational readiness.
Security & Compliance
Implement and maintain database security practices including encryption, access controls, and audit logging.
Manage and support encryption technologies such as Transparent Data Encryption (TDE), Always Encrypted, and column-level encryption.
Support security and compliance initiatives involving data classification and regulatory requirements (PCI, SOC2, HIPAA, etc.).
Ensure appropriate separation of duties between development and database administration roles.
Operational Database Management
Deploy database schema changes safely using structured release and change management processes.
Support database version control and deployment frameworks (e.g., Flyway, SSDT, or similar tools).
Monitor and maintain production databases using both native SQL Server monitoring tools and enterprise observability platforms.
Provide technical guidance to engineering teams on database design, query optimization, and performance best practices.
Investigate and resolve production database incidents and implement preventive improvements.
Database Upgrades & Platform Evolution
Plan and execute SQL Server upgrades and migrations, including transitions from legacy SQL Server versions to modern releases.
Identify upgrade blockers and plan remediation strategies.
Support modernization initiatives involving database platform improvements and architecture optimization.
Cloud & Hybrid Environments
Experience supporting SQL Server deployments on AWS EC2 or Amazon RDS.
Familiarity with AWS database operations including snapshot backups and parameter groups.
Exposure to cloud migration strategies for SQL Server workloads.