Вакансія Senior Database Administrator (DBA)

Skills

• Microsoft SQL Server
• Database testing
• Datadog
• PowerShell
• Python
• RDS
• Azure SQL
• AWS RDS
• Google Cloud SQL
• NoSQL
• MongoDB
• Cassandra

Опис вакансії

We are seeking an experienced Senior Database Administrator (DBA) with a robust background in performance tuning, optimization, and database testing. This role is essential for maintaining and enhancing the reliability, scalability, and performance of our database systems. As a Senior DBA, you will collaborate closely with development, DevOps, and infrastructure teams to enhance data performance, optimize queries, and troubleshoot complex database issues.

Responsibilities:

• Database Management: Manage, monitor, and optimize multiple database instances, ensuring high availability, scalability, and security across production environments.
• Performance Tuning: Perform advanced performance tuning and query optimization to improve application responsiveness, minimize latency, and efficiently handle peak loads.
• Benchmarking: Conduct database performance testing and benchmarking, identifying bottlenecks and recommending solutions to enhance database efficiency.
• Automation: Develop and maintain automated processes for database maintenance tasks, such as backups, indexing, and statistics updates, ensuring data integrity and disaster recovery readiness.
• Collaboration: Work with application development teams to design, review, and optimize complex queries, stored procedures, and schema changes.
• Best Practices: Establish and document best practices for database monitoring, alerting, and troubleshooting, creating dashboards and alerts for proactive issue resolution.
• Execution Plan Analysis: Analyze and optimize execution plans, identifying costly operations, and implementing indexing or partitioning strategies to improve query performance.
• Data Security Compliance: Ensure compliance with data security standards and regulatory requirements, enforcing database access controls and data masking policies.
• Disaster Recovery Planning: Develop and maintain disaster recovery plans, performing regular backup and restore tests to verify data recoverability and minimize downtime.
• Mentorship: Mentor and provide technical guidance to the team, sharing expertise in performance tuning, testing, and troubleshooting.

Qualifications:

• Education: Bachelor’s Degree in Computer Science, Information Technology, or a related field.
• Experience: 7+ years of experience as a Database Administrator, with a strong emphasis on performance tuning and optimization.
• Proficiency: Expert in SQL Server with strong skills in SQL and stored procedure optimization.
• Performance Tuning: In-depth knowledge of performance tuning techniques, including query optimization, indexing strategies, and execution plan analysis.
• Performance Testing: Experience with performance testing and benchmarking tools, capable of identifying and diagnosing performance issues at scale.
• Monitoring Tools: Strong understanding of database monitoring and alerting tools, with hands-on experience configuring database alerts and dashboards.
• HA/DR Configurations: Familiarity with high availability (HA) and disaster recovery (DR) configurations, including clustering, replication, and failover techniques.
• Scripting Skills: Experience in scripting languages (e.g., PowerShell, Python) for database automation and maintenance.
• Problem-Solving: Strong problem-solving skills, with an analytical approach to diagnosing and resolving database issues.
• Communication Skills: Excellent communication and collaboration skills, with the ability to work closely with cross-functional teams.

Preferred Skills:

• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL).
• Knowledge of NoSQL databases (e.g., MongoDB, Cassandra) and data architecture in distributed systems.