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).
