Senior SQL Database Administrator (DBA)

Job Overview:

Charisma Financial Information Processing is seeking an experienced Senior SQL Database Administrator (DBA) to join our team in Tehran, Iran. The ideal candidate will manage, maintain, and optimize SQL Server databases, ensuring high availability, performance, and security. You will play a pivotal role in designing database solutions, troubleshooting complex database issues, and supporting our development and operations teams.

Key Responsibilities:Database Administration & Maintenance

• Install, configure, and maintain SQL Server instances, including clustered and standalone environments.
• Monitor database performance, implement performance tuning, and optimize queries and indexes.
• Plan and implement database upgrades, patches, and migrations.
• Manage and maintain database backups, restoration, and disaster recovery strategies.

Design & Development

• Collaborate with development teams to design database structures, queries, and stored procedures.
• Design and implement high-availability (HA) and disaster recovery (DR) solutions, including Always On Availability Groups and Distributed Availability Groups.
• Analyze and recommend improvements to database designs to meet business needs.

Monitoring & Troubleshooting

• Set up and maintain monitoring tools to ensure database availability and performance.
• Troubleshoot and resolve database-related issues, including locks, deadlocks, and performance bottlenecks.

Security & Compliance

• Implement and enforce database security measures, including user roles, permissions, and encryption.
• Ensure compliance with organizational data governance policies and applicable regulations.
• Conduct regular security assessments and audits of database environments.

Collaboration & Leadership

• Mentor junior DBAs and provide technical guidance to the team.
• Work closely with application developers, system administrators, and network engineers to ensure database stability and scalability.
• Develop and maintain comprehensive database documentation, including procedures, standards, and architecture diagrams.

Qualifications:Required:

• Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• 7+ years of experience as a SQL DBA with a strong focus on SQL Server.
• Proficiency in database design, performance tuning, and query optimization.
• Expertise in high-availability solutions, including Always On Availability Groups and Distributed Availability Groups.
• Experience with monitoring tools like SQL Server Management Studio (SSMS) or Azure Data Studio
• Strong knowledge of database backup and disaster recovery strategies.
• Hands-on experience with T-SQL, SSIS, SSRS, and PowerShell scripting.

Preferred:

• Knowledge of NoSQL databases, particularly MongoDB, is a plus.
• Experience with relational databases such as MySQL and PostgreSQL.
• Experience with automation and CI/CD pipelines for database deployments.
• Familiarity with ELK Stack (Elasticsearch, Logstash, and Kibana), particularly Elastic Beats for database monitoring and analytics.

Why Join Us?

• Opportunity to work on cutting-edge database technologies at Charisma Financial Information Processing.
• A collaborative and inclusive work environment.
• Competitive salary, benefits, and professional development opportunities.