Database Engineer (Azure & On-Premises)
Purple Hires
Dice Job Match Score™
👤 Reviewing your profile...
Job Details
Skills
- Database
Summary
Position Title: Database Engineer (Azure & On-Premises)
Domain: IT Infrastructure
Location: USA (Remote)
Mandatory: Designing both OLTP and OLAP database architectures
Ideal experience:
- Bachelor’s degree in computer science or a related technical field.
- Minimum of 4 years of experience as a Database Engineer, Database Administrator, or equivalent technical role.
- Proven proficiency in Microsoft SQL Server (2016 or newer) and Azure SQL Database.
- Strong command of T-SQL, stored procedures, views, and indexing strategies.
- Data Modeling & Normalization: Develop normalized database schemas (1NF through BCNF) to eliminate redundancy and ensure data integrity. Apply denormalization techniques when appropriate to optimize read performance for analytics and reporting. Collaborate with development and analytics teams to translate business requirements into efficient logical and physical models.
- Performance Optimization & Maintenance: Monitor and tune database performance through indexing, query optimization, and resource utilization management. Implement proactive monitoring using tools such as Azure Monitor, SQL Profiler, or Query Store. Maintain efficient backup, recovery, and disaster recovery procedures.
- Demonstrated experience in:
- Data normalization and relational schema design.
- Table partitioning and data striping implementation.
- Performance tuning and query optimization for large-scale data systems.
- Hands-on experience with ETL/ELT pipelines and Azure Data Factory or SSIS.
- Familiarity with high availability, failover clustering, and disaster recovery techniques.
Preferred Qualifications
- Knowledge of data warehousing, dimensional modeling, and BI integration (Power BI, SSAS).
- Exposure to DevOps and CI/CD pipelines for database deployments.
- Scripting experience using PowerShell, Python, or similar languages.
- Knowledge of MISMO is a plus.
Core Competencies
- Strong analytical and problem-solving skills.
- Exceptional attention to detail and data accuracy.
- Ability to work independently and manage multiple priorities effectively.
- Clear and professional communication skills, both written and verbal.
- Collaborative mindset with a focus on continuous improvement.
- Dice Id: 91170791
- Position Id: 8997369
- Posted 13 hours ago
Company Info
About Purple Hires
At Purple Hires, we are dedicated to consistently delivering an outstanding recruitment experience that benefits both our clients and candidates.
We are committed to excellence in every aspect of our recruitment process. From understanding client requirements to sourcing, screening, and presenting the most suitable candidates, we maintain high standards and a results-driven approach. Our goal is not just to fill positions but to add genuine value to our clients’ teams by finding the right talent.
Honesty and openness are at the heart of our recruitment practices. We believe that clear, consistent communication fosters trust and reliability. Whether discussing job requirements, candidate expectations, or process timelines, we ensure that all parties remain well-informed and engaged. Transparency is key to building long-term relationships and ensuring mutual satisfaction.
Respect for both clients and candidates underpins our entire approach. We treat every individual with dignity and professionalism, recognizing that a positive experience leaves a lasting impact. From initial engagement to final placement, we handle each interaction with empathy and consideration, promoting a respectful and inclusive environment.
By combining performance, transparency, and respect, we create a seamless, rewarding recruitment experience. Clients can rely on us for consistent quality and integrity, while candidates feel valued and supported throughout their journey. This holistic approach allows us to build sustainable relationships and maintain a reputation as a trusted recruitment partner.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs