Image Loading

Database Administrator

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

Skills

  • Database Administration
  • Database Design
  • C++
  • Java
  • Cloud platform
  • GO
  • Python

Education

  • Master's Degree
  • Bachelor's Degree

Job Information

Job Posted Date

Apr 11, 2024

Experience

4 to 8 Years

Compensation (Annual in Lacs)

₹ Market Standard

Work Type

Permanent

Type Of Work

8 hour shift

Category

Information Technology

Copyright © 2022 All Rights Reserved. Saas Talent