About the Role
We seek a highly skilled and versatile Database SME with deep expertise across various database types. The ideal candidate excels at problem-solving and technical negotiation, possesses strong software development knowledge (data persistence, microservices, cloud native development), and thrives in dynamic environments. This role requires proactive leadership, cross-functional collaboration, seamless context switching, and a commitment to operational efficiency in modern application ecosystems. The SME will also guide product teams on database best practices and provide WSO2 customer support.
Your Key Responsibilities
- Administer, maintain, and optimize relational databases (e.g., MySQL, PostgreSQL, Oracle, SQL Server).
- Ensure database reliability, scalability, and performance optimization for all environments.
- Help product teams in optimizing the DB schemas of products.
- Guide product teams in implementing database best practices and optimizing SQL scripts.
- Provide guidelines and other related best practices for data access to developers.
- Verify and validate the database interaction architecture for all product components.
- Analyze and resolve complex database issues impacting performance and uptime.
- Identify and mitigate potential bottlenecks and challenges within database systems and their interactions with applications.
- Proficient in analyzing SQL execution plans, troubleshooting database performance issues, and implementing rapid solutions.
- Collaborate with development teams to ensure database compatibility with Java-based applications and microservices architectures.
- Advise on schema design, query optimization, and database interaction patterns.
- Work with containerized environments (e.g., Docker, Kubernetes) to support microservices-related data needs.
- Implement and manage database solutions in cloud platforms (e.g., AWS, Azure, GCP).
- Implement robust database security measures, including encryption, access control, and auditing.
- Ensure compliance with data governance policies and regulations such as GDPR, HIPAA, or SOC2.
- Develop and maintain backup and disaster recovery strategies for critical databases.
- Perform regular testing of recovery processes to ensure data integrity and availability.
- Monitor and optimize database performance using tools and metrics.
- Design indexes, manage replication, and implement sharding strategies as required.
- Perform application performance tuning related to data access and persistence.
Database Management
Provide Leadership to Product Teams on DB Best Practice
Problem Solving and Troubleshooting
Integration and Development Support
Microservices and Cloud Technologies
Security and Compliance
Backup and Recovery
Performance Monitoring and Tuning
Qualifications and Skills
- Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
- Strong background in Java-based development related to data persistence and microservices-related technologies.
- 5+ years of experience in the Computer Science field with a passion in working with relational database management systems.
- Proficient in relational databases (e.g., MySQL, Oracle, SQL Server) and NoSQL databases (e.g., MongoDB, DynamoDB).
- Experience with cloud databases (e.g., Aurora, Cosmos DB) and in-memory data stores (e.g., Redis).
- Exceptional problem-solving and critical-thinking abilities.
- Familiarity with microservices and containerization (e.g., Docker, Kubernetes).
- Expertise in database performance tuning, replication, and clustering.
- Understanding of CI/CD pipelines and integration with databases.
- Excellent communication and strategic negotiation skills.
- Proactive leader who takes initiative and drives projects to achieve desired results.
- Ability to work collaboratively in cross-functional teams.
Education
Experience
Technical Skills
Soft Skills
Please note that candidates must have the legal right to live and work in India or Sri Lanka to be eligible for this position.
In Addition to a Competitive Compensation Package, WSO2 Offers:
- A work culture and environment where we value both hard work AND flexibility.
- A flexible vacation/leave plan that fits your needs.
- Health, dental, and life insurance for you and your family.
Diversity Drives Innovation:
We've built our business on a commitment to diversity and inclusion. We believe it's important to foster an environment that values and respects each individual's strengths, perspectives, and ideas. Doing so not only drives innovation; it also ensures that we can create superior experiences for our customers, partners, and employees worldwide. We value the diversity of our team regardless of race, ethnicity, religion, gender, age, national origin, disability, sexual orientation, or veteran or marital status, and we do not tolerate any form of discrimination.