We are seeking a highly experienced Senior Application DBA with deep expertise in MSSQL to lead data integrations, performance tuning, and optimization within our database environment. The ideal candidate will have at least 8 years of experience and a strong background in data warehousing. This role requires a proactive problem-solver who can optimize database performance, ensure data integrity, and support mission-critical applications.
Key Responsibilities:
- Lead and optimize data integrations between systems to ensure seamless data flow.
- Perform performance tuning and optimization (PTO) of MSSQL databases for maximum efficiency.
- Design, implement, and maintain data warehousing solutions to support business intelligence and reporting needs.
- Monitor and troubleshoot database performance, security, and availability.
- Work closely with application developers to optimize SQL queries and database structures.
- Implement best practices for backup, recovery, indexing, and partitioning strategies.
- Ensure database compliance with security policies and industry regulations.
- Provide guidance and mentorship to junior DBAs and developers.
Qualifications:
- 8+ years of experience as an Application DBA specializing in MSSQL.
- Expertise in data integration, performance tuning, and optimization.
- Strong experience in data warehousing and ETL processes.
- Proficiency in T-SQL, indexing, query optimization, and database partitioning.
- Hands-on experience with high-availability and disaster recovery strategies.
- Strong analytical and problem-solving skills.
- Ability to work in a fast-paced environment and collaborate with cross-functional teams.