facebook linkedin

Lead Database Engineer

Hyderabad , India

Ref#: 20024014

Date published: 10-Oct-2020

Share with: Facebook LinkedIn Twitter Send to a friend

Position : Senior or Lead Database Engineer, 

Experience : 7-12 years 

 

Primary Job Duties:

·   Coordinate planning, administration, monitoring, tuning and performance optimization of SQL Server/Postgresql production databases, including optimization of stored procedures, triggers, tables, indices, and configuration settings.

·   Perform database creation, definition of physical and logical structures, documentation, definition of operational guidelines, and data protection.

·   Formulate and monitor database management policies, procedures, and standards, and propose as well as implement improvements to performance and reliability of database systems.

·   Work to identify and resolve poorly performing queries that require tuning and/or optimization, as well as, monitor open support tickets, determine trends, and identify areas for improvement.

Must Have 

  • 5-7 years of relevant experience, as well as a Bachelors degree.
  • 4-6 Postgresql Database experience, and be able to demonstrate that experience.
  • 2-3 SQL Server Database experience, and be able to demonstrate that experience.
  • experience to work in Cloud environments. AWS preferably.
  • knowledge on ETL/ELT processes.
  • performance tuning skills
  • Design & Modelling skills for OLTP & OLAP. Exposure to data modelling tools. ERWin preferably
  • Knowledge on NoSQL databases (atleast experience in one like MongoDB/Cassandra )

 

Good to Have 

  • ability to plan, implement, maintain, and troubleshoot high-availability techniques such as hot standby servers, clustering, database mirroring, and AlwaysOn.
  • experience on  SSIS/SSRS
  • experience with Python
  • understanding/knowledge of Scripting languages like Shell, Pearl, etc.
  • exposure to database deployment automation (CI/CD & version control)