JangoMail

Key responsibilities

• Database design and development: Design and implement efficient database structures, schemas, and data models to support applications and business needs.
• Performance tuning: Monitor database performance, identify bottlenecks, and optimize SQL queries and database structures using tools like SQL Profiler.
• Database administration: Perform daily operational activities such as backups, restores, log monitoring, and server maintenance.
• High availability and disaster recovery: Create, implement, and maintain strategies for High Availability (HA) and Disaster Recovery (DR). This includes managing clustering, replication, and Always On availability groups.
• Security and compliance: Implement and manage database security measures, access controls, and ensure compliance with data protection and regulatory controls.
• Troubleshooting and support: Provide technical support and resolve database-related issues to ensure minimal downtime.
• Automation: Develop scripts and tools to automate database deployment, monitoring, and maintenance tasks.
• Collaboration: Work with cross-functional teams, including application developers, to ensure seamless data flow and integration.
• Documentation: Create and maintain documentation for database architecture, design decisions, and operational procedures.
• ETL and reporting: Develop and maintain ETL (Extract, Transform, Load) processes using tools like SSIS and reporting solutions like SSRS.

Required skills and qualifications

• Technical proficiency: Strong proficiency in T-SQL, including writing complex queries, stored procedures, and functions.
• Database design: Solid understanding of database design principles, normalization, and data modeling.
• Performance optimization: Experience with performance tuning, query optimization, and using related tools.
• Database administration: Experience with database installation, configuration, maintenance, and backups/restores.
• High availability: Experience with HA/DR solutions like Always On Availability Groups.
• Specific tools: Familiarity with tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) is often required.
• Analytical skills: Strong analytical and organizational skills to diagnose and resolve complex issues.
• Collaboration: Ability to work effectively in a team environment and collaborate with cross-functional teams.
• Agile experience: Experience working in Agile/Scrum teams is often beneficial.

Job Type: Full-time

Pay: $70,000.00 - $100,000.00 per year

Benefits:

• Dental insurance
• Health insurance
• Vision insurance

Work Location: In person