Engineering Development

Database Administrator

Sahibzada Ajit Singh Nagar, Punjab   |   Full Time

Watermark advances educational excellence in K-12 and higher education by providing the highest quality webbased

software and supporting services to efficiently plan and manage assessment processes, facilitate the

demonstration of learning achievement and foster continuous improvement. Capabilities include: outcomes

assessment planning, curriculum mapping, performance assessment, electronic portfolio management, rubric

scoring, lesson planning, and surveys. Our success is predicated upon our commitment to provide rapidly

developed, reliable and flexible, online tools, and world-class support to our clients. We are a rapidly growing

business, headquartered in New York City with offices all over the US and India.

Job Description: The Database Engineer will work as part of the Infrastructure Engineering team supporting

various database platforms and systems infrastructure in multiple offices, two private data centre locations and

AWS. The Database Engineer's responsibilities include but are not limited to: DB architect and administration, DB

performance tuning, DB High availability, DB Backup and Restores, automation, deployment, tools and

monitoring, and system topology design input.

Technology we use:

Deployment/Automation: Jenkins, Ansible, VMWare, Gitlab-CI, Octopus Deploy Programming Languages: Shell

scripting, Powershell, NodeJS, Elixir, Elm, Java

Databases: PostgreSQL, MySQL, MSSQL, Redis, MongoDB

Monitoring/Logging: Nagios XI, Nagios Network Analyzer, ELK Stack Cloud/Virtualization: VMware, AWS

o Work with server configuration management (infrastructure automation) tools (i.e. - Ansible, Terraform)

o Manage and maintain MongoDB, MySQL, PostgreSQL, and MSSQL database servers in all environments

o Design and implement MongoDB replica sets and sharded clusters

o Design and implement different MySQL replication topologies depending on requirements

o Perform query tuning: adding/removing/modifying indexes, rewriting queries for better performance

o Write scripts to automate the provisioning and maintenance of databases

o Plan and test automated backups and disaster recovery/failover configurations

o Troubleshoot and debug web and application servers for system and application issues

o Monitor databases for problems proactively and diagnose their origin

o Updating and amending existing databases on various platforms i.e. MS SQL, PostgreSQL and MySQL.

o Setting up and testing new database and data handling systems

o Monitoring database efficiency and Sustaining the security and integrity of data

o Creating complex query definitions that allow data to be extracted

o Build database systems of high availability and quality depending on each end user’s specialised role

o Design and implement database in accordance to end users information needs and views

o Define users and enable data distribution to the right user, in appropriate format and in a timely manner

o Use high-speed transaction recovery techniques and backup data

o Minimise database downtime and manage parameters to provide fast query responses

o Provide proactive and reactive data management support and training to users

o Determine, enforce and document database policies, procedures and standards

o Perform tests and evaluations regularly to ensure data security, privacy and integrity

o Monitor database performance, implement changes and apply new patches and versions when required

o Excellent knowledge of data backup, recovery, security, integrity and MySQL, Postgres and MS SQL

o Oversee Development of New Databases and optimize Queries on Live Data

o Plan Disk Storage Requirements and proactively Tune Database in Production and Prevent Data Loss

o Quickly Assess a Situation and Develop/Implement a Solution and Recover Lost Data

o Repair Program Bugs and Research Emerging Technology and Debug Database Issues on Live Data

o Review Existing Solutions and Setup Safety Measures to Recover Data

o Solid Project Management Capabilities and Understanding of Company’s Data Needs

o Strong Technical and Interpersonal Communication

o Test Database to Ensure Everything Operates Efficiently Without Error and Test Recovery Plans at times

o Troubleshoot Database Errors

o Work Closely with Development Teams with Regards to Database Updates and Design

o Work in an agile development environment, collaborating with Application Development and

Architecture teams to implement and evolve solutions for a wide array of challenging projects

o Take an active role in developing the long-range technical infrastructure and architecture plans, perform

regular upgrades and updates of databases

o Experiment with new technologies to optimize the reliability and performance of our software and

hardware infrastructure

o Design and implement proactive monitoring to ensure health, performance, reliability, and security of

databases in all environments

o Take part in 24/7 on-call rotations

Requirements:

□ B.S./M.S. in Computer Science or a related field

□ 4-6 years of experience working as Database Engineer

□ 4+ years of experience working as Database Engineer primarily on MySQL and PostgreSQL

□ 2+ years of experience in MongoDB

□ Proficient with Unix/Linux terminal and PowerShell console

□ Knowledge of both Linux and Windows operating systems

□ Strong problem-solving and critical thinking skills

□ Excellent verbal/written communications skills and strong interpersonal skills to interact professionally and

courteously with end-users and co-workers

□ Passion for learning new information and technologies

Plus:

□ Experience with Ansible or other configuration management tools

□ Experience with MS SQL Server

□ Experienced in managing databases in AWS Cloud (RDS and EC2) with CloudFormation

Submit Your Application

You have successfully applied
  • You have errors in applying