Deploy database change scripts provided by third party vendors or internal Development and Business Analysts post approvals
Manage/plan database capacity and storage, disk space and monitor database growth
Tuning T-SQL queries to improve performance
Manage, build and design Azure infrastructure to support business demand
Monitor database server health and create alerts to capture poor server performance issues
Manage Synapse pipelines and coordinate with other infrastructure team members to deliver data
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Configure SQL Server monitoring utilities to minimize false alarms
Troubleshoot data issues related to Enterprise BI platform in Azure Synapse and Power BI
Using tools like (Extended Events, DTA) and (SQL Profiler, DMV, Data Collection) to diagnose server reliability and performance issues
Install and configure new SQL Servers
Document the company’s database environment
When performance issues arise, determine the most effective way to increase performance including server configuration changes, or index/query changes
Monitor and pro-actively identify locks/blocking and resolve concurrent issues
Manage database security as defined and dictated by the company
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Promote changes in Azure DevOps to production Synapse environment
Finding DMV queries to answer questions about server-level performance
Requirements
mongodb
azure dba
sql server
mysql
etl
data modeling
To do a great job in this position, experience should include:
Experience with data modeling tools and technique
MongoDB Certified DBA
Expertise in designing database schemas, normalization, and indexing strategies.
Microsoft Certified: Azure Database Administrator Associate
On-call troubleshooting experience with at least one production SQL Server for a year. You don’t have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working.
3-7 years of experience
Experience with ETL (Extract, Transform, Load) processes and tools.
Understanding of data warehousing concepts and design.
Proficiency in disaster recovery planning and implementation.
Certified MySQL Database Administrator
Azure Analytics and Infrastructure Engineering
Knowledge of backup strategies and tools.
Benefits
Pet Insurance
Employee Assistance Program
Company-paid Short-Term Disability
Tuition Reimbursement
Company Paid Life Insurance
Company-paid Long-Term Disability
Three comprehensive Medical plan options
Voluntary Life Insurance
Supplemental Hospital Indemnity, Critical Illness, and Accident Insurance
Team Member Discount Program
Yearly Wellness Clinic
401k retirement plan with company match
Paid time off (PTO) and paid Holidays
Identity Theft Protection
Legal Insurance
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
Information not given or found
Company
Overview
Founded with a vision to redefine industry standards, this company has become a trusted partner in providing engineering, construction, and technology solutions.
This company has a reputation for tackling complex projects across a variety of sectors, ranging from infrastructure to industrial developments.
This company specializes in delivering high-quality, innovative solutions that bridge the gap between engineering expertise and technological advancements.
Throughout its history, this company has led key projects in sectors such as industrial construction and critical infrastructure development.
This company excels in leveraging technology to enhance project outcomes, optimizing efficiency, and reducing costs.
This company is known for its ability to navigate large-scale projects with precision, handling everything from early design phases to final execution.
Its services encompass a diverse set of industries, ensuring this company is a versatile leader in engineering and construction.
Culture + Values
100% Safety
Safety Commitment
Ensuring safe operations through OSHA VPP Star sites and raising industry standards.
100% Testing
Quality Assurance
Commitment to rigorous audits, seamless quality, and continuous improvement across manufacturing processes.
Obsess over manufacturing details to ensure precision every time.
Innovation is integral to every business aspect, fostering a culture of creative thinking.
Build trust through transparency and industry-leading warranties.