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.
We Offer:
- Innovation: Work in an environment focused on solving complex challenges with cutting-edge technology.
- Professional Development: Opportunities to advance and expand your expertise in a dynamic industry.
- Flexible Work Environment: Collaborate with a talented team and enjoy flexible work options.
This role offers an opportunity to shape our database stack and drive the development of cutting-edge applications. If you’re passionate about software and want to work with a highly skilled, motivated team, we encourage you to apply now!