Senior Staff Database Administrator

Reports To

Senior Manager,SRE

What You Will Be Doing

Database Design and Management: 

• Architect, implement, and maintain scalable and highly available database systems for MySQL, PostgreSQL, and MongoDB. 

• Collaborate with engineering teams to design schema models optimized for application performance and scalability. 

• Manage database lifecycle operations, including upgrades, migrations, and capacity planning for large-scale environments. 

Performance Tuning and Optimization: 

• Identify and resolve database performance issues through SQL query optimization, index tuning, and schema design improvements. 

• Conduct regular performance reviews to eliminate bottlenecks and improve system throughput. 

• Provide insights into query plans and recommend adjustments to developers for enhanced performance. 

Application Integration and Collaboration: 

• Partner with application and engineering teams to align database architecture with application requirements. 

• Develop and implement database integration strategies for large-scale, data-intensive applications. 

• Support application teams in troubleshooting and resolving database-related issues during development and production. 

Automation and Tooling: 

• Develop and maintain automation scripts for database deployment, maintenance, and monitoring. 

• Build tools to streamline performance monitoring, troubleshooting, and database health checks. 

Data Security and Governance: 

• Implement robust security measures, including access control, encryption, and auditing, to protect sensitive data. 

• Ensure databases comply with industry standards and regulatory requirements such as GDPR/FedRAMP. 

Leadership and Mentorship: 

• Lead database-related initiatives and contribute to long-term database strategy. 

• Mentor and guide junior DBAs, fostering a culture of excellence and collaboration. 

Incident Management and Reliability: 

• Provide on-call support for high-priority database incidents, ensuring quick resolution and minimal downtime. 

• Conduct root cause analysis and implement preventive measures for database failures. 

What You Will Bring to ChargePoint

Data Integrity and Security:

Ensures data accuracy and consistency: Implement and maintain robust data quality checks, preventing errors and inconsistencies that can lead to costly business decisions. 

Protects sensitive data: Design and implement strong security measures, such as access controls, encryption, and regular backups, to safeguard critical information from unauthorized access, breaches, and data loss. 

Database Performance and Availability: 

Optimizes database performance: Fine tuning database configurations, index structures, and query execution plans to maximize query speed and minimize response times, improving application performance and user experience. 

Maintains high availability: Implement strategies like database replication and clustering to ensure continuous database availability, minimizing downtime and ensuring business continuity. 

Database Administration and Maintenance: 

Manages database resources: Monitor database resource utilization (CPU, memory, disk space), proactively address performance bottlenecks, and ensure optimal resource allocation. 

Performs regular maintenance tasks: Perform updates, and upgrades to ensure database stability, reliability, and compliance with industry standards. 

Database Development and Support: 

Assists with database development: Provide guidance and support to application developers on database design, schema creation, and efficient data access strategies. 

Troubleshooting database issues: Diagnose and resolve complex database issues, including performance problems, data corruption, and application errors related to database interactions. 

Evaluate and recommend new technologies: Stay abreast of the latest database technologies and trends, evaluating and recommending new solutions that can improve database performance, scalability, and security. 

Reduce costs: By preventing data loss, minimizing downtime, and improving operational efficiency, DBAs help businesses reduce costs associated with data-related incidents and improve their bottom line. 

Comply with regulations: By implementing robust security measures and ensuring data integrity, DBAs help businesses comply with relevant data privacy regulations such as GDPR and CCPA. 

 

Requirements

• 10+ years of experience managing large-scale database systems, including MySQL, PostgreSQL, Cassandra, and MongoDB. 

• Expertise in SQL optimization, query tuning, and database performance troubleshooting. 

• Proven experience designing and managing databases for large-scale, high-transactional applications. 

• Strong understanding of indexing, partitioning, and caching strategies. 

• Hands-on experience with database automation tools and scripting languages such as Python, Bash, or Ansible. 

• Familiarity with cloud-native database services and environments (e.g., AWS RDS, GCP Cloud SQL, MongoDB Atlas). 

• Deep knowledge of database replication, clustering, and disaster recovery mechanisms. 

Location

Bangalore