We are seeking an experienced Senior Application Database Administrator with deep expertise in Microsoft SQL Server. This role involves overseeing the design, implementation, and optimization of complex databases that support critical applications. The ideal candidate will work closely with software developers, business analysts, and IT leadership to ensure the efficiency, security, and reliability of the database environment.
Key Responsibilities:
- Collaborate with application development teams to design database structures, tables, and schemas that meet business and technical requirements.
- Lead the architecture and integration of multiple databases in a high-availability environment.
- Monitor database performance, identify bottlenecks, and recommend or implement solutions to enhance performance.
- Optimize query performance and ensure efficient use of database resources.
- Implement and maintain database security best practices, including user access control and data encryption.
- Ensure databases comply with company policies and applicable regulations (GDPR, SOX, etc.).
- Design, implement, and manage robust backup and disaster recovery strategies.
- Regularly test recovery plans and ensure minimal downtime in case of database failures.
- Conduct routine database maintenance, including index optimization, statistics updates, and consistency checks.
- Proactively monitor databases to ensure availability and uptime in a 24/7 environment.
- Serve as an escalation point for complex database issues, troubleshoot problems, and provide root-cause analysis.
- Collaborate with development teams to resolve performance issues and optimize application queries.
- Forecast database storage and performance needs based on growth projections and plan accordingly.
- Develop strategies to scale database environments to meet increasing data and user demand.
- Automate routine tasks (e.g., backups, monitoring, updates) using T-SQL, PowerShell, or other scripting languages.
- Develop and implement automated solutions for database deployments and migrations.
- Work closely with application development teams to ensure best practices in database design and coding.
- Mentor junior DBAs and developers on database management, performance tuning, and SQL best practices.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or related field (or equivalent experience).
- 8+ years of experience as a SQL Server DBA or Database Engineer in a large-scale production environment.
- Experience in data integrations, performance tuning and optimization and data warehousing.
- Proven experience in designing and implementing database architectures for mission-critical applications.
- Strong knowledge of T-SQL for scripting, stored procedures, and query optimization.
- Experience with SSRS, SSIS, and SSAS.
- Familiarity with high-availability and disaster recovery solutions, such as AlwaysOn, mirroring, and replication.
- Solid understanding of indexing, partitioning, and sharding for performance and scalability.
- Familiar with database monitoring tools such as SolarWinds, Redgate, or SQL Sentry.
- Experience with cloud-based SQL solutions (e.g., Azure SQL, AWS RDS) is a plus.
- Excellent problem-solving skills with a detail-oriented mindset.
- Strong communication and teamwork skills, with the ability to collaborate effectively across departments.
- Ability to work in a fast-paced, dynamic environment and handle multiple projects simultaneously.
Certifications (Preferred):
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft Certified: Data Analyst Associate
- Microsoft Certified: SQL Server Database Administrator
Work Setup
- Remote
- Day Shift
- Project based for 6 months
