Solving the World’s Common Problems, One Product at a time. Join the Dream Team!

Database

Database Administrator

Job Summary
The Database Administrator is responsible for providing a seamless flow of information throughout the company, considering both back-end data structure and front-end accessibility for end-users. Role involves designing, testing, planning, implementing, protecting, operating, managing and maintaining our company’s databases. This would include maintaining back-up, performance tuning, capacity planning, monitoring critical events and documentation.

Responsibilities

  • Create and manage databases( SQL and NoSQL based ) and assist in capacity planning.
  • Monitor, maintain database systems and troubleshoot problems that may arise.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
  • Develop strategies and implement solutions for managing back-ups, restoration and replication.
  • Create and manage constraints and indexes.
  • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
  • Implement and manage company data management practices and policies
  • Proactive housekeeping/archiving and shrinking of databases.
  • Manage production, QA and development database environments.
  • Create detailed documentation including diagrams of database infrastructure and maintain detailed database related documentation.
  • Master relevant business processes and understand the data flow, criticality and dependencies.
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
  • Set up and maintain database infrastructure for the company’s needs

Requirements

  • Experience with many of the following: MongoDB, PostgreSQL, Casandra, CouchDB, MySQL, Microsoft SQL Server.
  • Good understand database design, implementation, troubleshooting and maintenance.
  • Excellent knowledge of data backup, recovery, security, integrity and SQL
  • Experienced in ETL (Extract-Transform-Load) development / data integration.
  • Have hands on experience on working with Active-Active and Active-Passive database
    architecture.
  • Sense of ownership and pride in your performance and its impact on a company’s success.
  • Able to multitask, prioritize, and manage time efficiently.
  • Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies
  • Accurate and precise attention to detail
  • Strong written and verbal communication skills
  • Team player, Critical thinker, problem solving skills and ability to think algorithmically
  • Ability to develop procedure documents and maintain detailed database related documents.
  • Good have experience with cloud managed database like AWS RDS, AWS Aurora, Elasticsearch, Azure cosmo

Experience: 6+ years

Location: Hyderabad/Noida