UXCam Pvt. Ltd

UXCam Pvt. Ltd

Software Industry

Lalitpur

"Enable businesses to deliver the best experience." We are in the midst of an once-in-a-century shift in business models. Consumers are choosing experience over services. UXCam is at the heart of this shift: We want to enable businesses to cut through the competitive landscape and establish themselves as an experience business. ...

View Company Profile

Sr. Database Engineer

Apply Before : 2021-06-14 (Closed) View: 6905

Job summary

  • No. of Vacancy
    : 1
  • Job Type
    : Full Time
  • Offered Salary
    : Negotiable
  • Gender
    : Both
  • Career Level
    : Senior Level
  • Experience
    : 4 Years
  • Apply Before
    : 2021-06-14 Closed
  • Skills
    :
    Analytical
    Databases
    SQL

Job Description:

UXCam is the market leader in mobile experience analytics, empowering organizations to easily understand, optimize and deliver an optimal user experience. To achieve this we are recording, processing and storing billions of data points that are being recorded on mobile devices and sent to our servers every month, and due to our increasing customer base this data load is constantly growing.

We are looking for an outstanding database engineer who can manage, optimize and extend the distributed database engine (CitusDB/Postgres) which powers our analytical dashboard and the product. The major responsibilities include:

  • Design schemas, review existing schema, develop data models and maintain documentation of the database and data structures
  • Optimize schema and queries for analytical data which includes graphs and funnels producing result in sub-second latency
  • Plan, design, and optimize for data throughput and query performance issues
  • Provide database support to include creating databases, tables, triggers, queries, reports and troubleshooting assistance in collaboration with software developers
  • Setup, deploy and manage the database cluster in the cloud
  • Configure and tune PostgreSQL database core parameters to ensure the sound health and efficiency of the database 
  • Setup/extend database monitoring dashboard for detailed visibility on the health and performance of the system
  • Regularly monitor and supervise database usage and scale system accordingly
  • Ensure proper database backup strategies and redundancy for failover protection, preventing data loss and recovery
  • Implement security policies and ensure that credentials are properly handled
  • Constantly review and improve the Citus database architecture to ensure scalability and high performance while keeping down the costs
  • Research on new trends and ensure that we use the best available technologies
  • Assist, train, and guide fellow team members

Required Knowledge, Skills, and Abilities:

  • Strong proficiency with SQL queries
  • Experience in troubleshooting and resolving performance issues, database integrity issues, blocking and deadlocking issues, connectivity issues, etc
  • Experience with performance tuning and optimization using monitoring tools
  • Experience working with high volume data 
  • Strong analytical and problem-solving skills.
  • Outstanding supervision,  mentorship abilities - leading a substantive area of work, or line management of a team. 
  • Capacity to foster a healthy, stimulating work environment that frequently harnesses teamwork.

Nice to have:

  • Experience with deploying and managing database on AWS (or any) cloud
  • Ability to code in any of the modern programming languages

Education + Experience:

  • Hands-on experience (4+ years) as a Database Engineer or similar role working with PostgreSQL (or other SQL databases )

Benefits:

  • Lunch at office 
  • Flexible working hours 
  • Knowledge sharing Opportunity 
  • Attractive Salary
  • Annual, Monthly, and Quarterly Events
  • PF, Gratuity and Medical Benefits
  • Learning and Development Opportunities

Apply Instruction:

Interested candidates are requested to send their resume to jobaxlenp@gmail.com with "Application for Sr. Database Engineer" on the subject line.