Orion Innovation is a premier, award-winning, global business and technology services firm. Orion delivers game-changing business transformation and product development rooted in digital strategy, experience design, and engineering, with a unique combination of agility, scale, and maturity. We work with a wide range of clients across many industries including financial services, professional services, telecommunications and media, consumer products, automotive, industrial automation, professional sports and entertainment, life sciences, ecommerce, and education.
Sr. MS SQL Database Engineer (DBA)
Job Summary: The Senior MSSQL Server Database Engineer/Administrator is responsible for the configuration, maintenance, and troubleshooting of Microsoft SQL Server environments. This role supports data integrity, performance optimization, automation, and secure data transfer processes within SQL and Windows Server platforms. The ideal candidate will have a proactive approach to database administration with expertise in Always On Availability Groups, experience in building Azure databases, and familiarity with migration from on-premises environments to Azure or AWS.
Required Skillset and Qualifications:
- Bachelor’s Degree in Computer Science, Information Technology, or a related field, or equivalent experience.
- 8+ years of experience as a SQL Server Database Administrator with a strong focus on installation, configuration, and administration of Microsoft SQL Server databases. Experience ensuring optimal performance, scalability, high availability, performance tuning, automation, and data security.
- Proficiency in SQL Query Language and experience with PowerShell and Python scripting for automation.
- Strong knowledge of Windows Server and basic network connectivity troubleshooting.
- Experience with monitoring tools like Splunk and Dynatrace is preferred.
- Experience with Always On Availability Groups, configuring and maintaining high availability environments.
- Experience in building Azure databases, including Azure SQL Database and Managed Instances.
- Familiarity with migration processes from on-premises SQL Server to Azure or AWS, including best practices and tools for smooth transitions.
Key Responsibilities:
- SQL Server Management: Install, configure, and administer Microsoft SQL Server databases, ensuring optimal performance, scalability, and high availability.
- Query Optimization and Tuning: Write and optimize SQL queries to improve database performance, focusing on efficient data retrieval and transaction processing.
- Database Backup and Recovery: Manage backup, restore, and recovery plans to ensure data protection and disaster recovery.
- Security Management: Implement and maintain database security protocols, access controls, and encryption, following best practices and compliance standards.
- Automation and Scripting: Develop PowerShell and Python scripts for automating routine database tasks, file processing, and report generation to enhance productivity.
- Performance Monitoring: Use monitoring tools like Splunk, Dynatrace, and SQL Server Profiler to track database health, detect performance issues, and conduct root cause analysis.
- Technical Product Implementations: Support and perform SQL DBA and Windows Server administration for technical product deployments, ensuring smooth integration with existing systems.
- Cross-Platform Database Support: Provide support for IBM Db2 and other database platforms as needed, ensuring a cohesive data infrastructure.
- Collaboration with Cross-Functional Teams: Work closely with infrastructure, development, and business teams to align database solutions with organizational goals and support stability.
Additional Information:
- This position may require participation in an on-call rotation for database support and maintenance.
Orion is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, citizenship status, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
Candidate Privacy Policy
Orion Systems Integrators, LLC and its subsidiaries and its affiliates (collectively, “Orion,” “we” or “us”) are committed to protecting your privacy. This Candidate Privacy Policy (orioninc.com) (“Notice”) explains:
- What information we collect during our application and recruitment process and why we collect it;
- How we handle that information; and
- How to access and update that information.
Your use of Orion services is governed by any applicable terms in this notice and our general Privacy Policy.
Top Skills
Similar Jobs
What you need to know about the Charlotte Tech Scene
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
