Database Engineer

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 Engineer (DBE) 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 engineering and administration and a

passion for ensuring data integrity and availability, we invite you to apply for this exciting

opportunity.

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.

Qualifications:

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.

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