Job Description

• Bangalore, India

About Us:

Apica is a leading provider of innovative software solutions in the Observability space, designed to revolutionize how businesses gain insights into their systems and applications. We are dedicated to delivering cutting-edge products that streamline processes and enhance user experiences. Our mission is to empower organizations to thrive in the digital age through intuitive and visually compelling software.

Job Description:

We are seeking an experienced and highly skilled Database Administrator (DBA) to join our dynamic team at Apica. In this role, you will be a key contributor to our software development team, ensuring the performance, availability and security of our MS SQL Server/PostgreSQL/MongoDB Server databases. Beyond routine maintenance, you’ll play a crucial role in planning, designing and implementing database strategies that align seamlessly with our evolving business needs. You will work closely with cross-functional teams to deliver high-quality software solutions that meet our customer’s needs and contribute to the growth of our business.

If you have a strong background in database administration and a passion for ensuring data integrity and availability, we invite you to apply for this exciting opportunity.

Key Responsibilities:

• Administer, maintain and optimize high-availability/always-on and sharded MS SQL Server/PostgreSQL/MongoDB database clusters, ensuring data security, integrity and performance.
• Develop, maintain and optimize stored procedures, triggers, and other database objects to support efficient data manipulation and retrieval.
• Implement and oversee backup and recovery strategies to safeguard data against loss or corruption.
• Monitor database performance, identify and resolve bottlenecks and optimize query performance.
• Collaborate with developers, system administrators and other stakeholders to ensure efficient and effective use of database resources.
• Conduct regular security audits and implement measures to protect sensitive data.
• Troubleshoot and resolve database-related issues promptly to minimize downtime.
• Plan and execute database migration and upgrade projects.
• Create various reports from the databases as per requirements.
• Stay informed about emerging database technologies and best practices.

Requirements:

• Bachelor’s or Master’s degree in Computer Science, Software Engineering or a related field (or equivalent work experience).
• Proven experience as a Database Administrator with expertise in managing high-availability/always-on and sharded MS SQL Server, PostgreSQL and MongoDB database clusters.
• Strong knowledge of database design principles, normalization and data modeling.
• Proficient in writing and optimizing complex SQL queries, stored procedures, triggers and functions.
• Experience in database performance tuning and optimization.
• Familiarity with high availability and disaster recovery solutions, such as database mirroring, log shipping and clustering.
• Knowledge of database security best practices and the ability to implement and enforce security measures.
• Excellent problem-solving and debugging skills, attention to detail, and the ability to work collaboratively in a team environment.

Nice-to-Have Skills:

• Certification in SQL Server administration is preferred.
• Experience with any type of Timeseries Databases like InfluxDB, Prometheus, Graphite, Elasticsearch.
• Broad high-level knowledge of NoSQL databases and their specific strength and weaknesses.
• Familiarity with languages like .NET, C++ and Java.
• Familiarity with server-side scripting languages like Python and Go.
• Experience with cloud platforms (e.g., AWS, Azure, Google Cloud).