SQL DBA With Python Viha Digital Commerce

About Viha Digital Commerce

Job Description

Job Description Key Responsibilities Data Infrastructure: Support new data sources, data cleanup, or automation projects as scheduled during May/June and September/October biannual roadmap planning sessions. Database Management: Install, configure, and maintain on-premises SQL Server instances to ensure high availability and performance. The on-premise SQL server is to be migrated to the Samsung Cloud as of September 2025. This role will help prep/test the environment for the transition and the role will transition from on prem maintenance to cloud based server work after the transition is complete. Performance Optimization: Monitor and tune database performance using tools such as SQL Profiler, Activity Monitor, and Performance Monitor. Security Enforcement: Implement user access controls, encryption, and auditing practices in line with company policies. Maintain and update security controls as required. Backup and Recovery: Develop and manage backup to protect data integrity and business continuity. Data Pipeline Monitoring: Monitor and troubleshoot data pipeline processes to ensure efficient and accurate data flow. Cross-Team Collaboration: Work closely with application and data engineering teams for query optimization, schema design, and data integration. Documentation: Maintain accurate documentation of database configurations, maintenance procedures, and compliance requirements. Regulatory Compliance: Ensure all database systems comply with relevant governance policies and industry standards. Required Qualifications 810 years of experience as a SQL Server DBA in production environments. Strong proficiency in T-SQL and experience with SQL Server versions 2016 or later. Strong proficiency in Python Solid understanding of backup, recovery models, and disaster recovery best practices. Hands-on experience with high availability solutions such as Always On Availability Groups, replication, or log shipping. Preferred Qualifications Experience with SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS). Experience working in environments aligned with data governance and compliance frameworks. Experience with Alteryx (Designer & Server) is a plus. Soft Skills Strong analytical and troubleshooting skills. Effective written and verbal communication. Ability to work independently and within cross-functional teams. Highly organized and detail-oriented with a proactive mindset. Job Type: Permanent Schedule: Evening shift Work Location: Remote,