Responsibilities
- Design, implement and manage database infrastructure on-premises and in the cloud.
- Collaborate with developers, network/system engineers, vendors, and support staff in an open and creative environment.
- Analyze procedures to control the access and allocation of data
- Oversee real-time business metric aggregation, data warehousing and querying, schema and data management, and related duties
- Maintain security controls in supported databases
- Establish relationships with internal customers and team members to drive collaboration.
- Primary owner of 24x7 on-call external DB support team
- Database and SQL tuning, including reduction in I/Os, views and triggers.
- Creating indexes where required while taking a look at the fill factor for existing ones.
Skills And Expectations
- Proven experience building and supporting highly available database platforms and services at scale in a fast-paced environment.
- Proficient in the following database technologies, MySQL, MongoDB, HBase
- Experience in performance tuning and optimization using native monitoring and troubleshooting tools.
- Proficient at scripting in at least one common scripting language.
- Experience supporting managed database solutions (AWS RDS, Dynamo DB, AWS Document DB, Firestore).
- Experience building/managing database platforms through Infrastructure as Code (IaC)
- Strong working knowledge of HA/DR best practice architecture.
- Strong documentation/training/communication skills.
- Automation using Python , Shell scripts and PowerShell
- Automation using Chef/Puppet would be a plus
- Experience with config management systems
- Strong analytical and problem solving skills
- Experience operating under SOX/PCI/PII governance
- Experience with Cassandra, Redis and/or Elastic Cache.
- Knowledge of Installation, configurations and maintenance of Mysql database.
- Experience in Provisioning MySQL instances, both in clustered and non-clustered configurations.
- Handle common database process, such as upgrade, backup, recovery, migration, etc.
- Set up monitoring / alarming for production DB environments.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options.
- Expertise in designing and maintaining MySQL .
- Experience in Linux performance, memory management, I/O tuning, cluster management, Data durability, security, networking, and system crash analysis.
- Experience in setting up and operating Highly Available MySQL.
- Knowledge of shell scripting.
- Experience in working with Percona and innoDB engine. .
Experience
- 1-3 years industry experience
Qualification
- Graduate, Post graduate in Technical Field or a related field.
- Employment Type: Full-time
- Industry: Financial services
Disclaimer
This job description is intended to outline the general nature and key responsibilities of the position. It is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the role.
The responsibilities and qualifications described may be subject to change, and other duties may be assigned as needed.
Employment is at-will, meaning the employee or the employer may terminate the employment relationship at any time, with or without cause, and with or without notice.
Data Utilization Disclaimer
By applying for this position, you acknowledge and agree that any personal data you provide may be used for recruitment and employment purposes.
The data collected will be stored and processed in accordance with our privacy policy and applicable data protection laws.
Your information will only be shared with relevant internal stakeholders and will not be disclosed to third parties without your consent, unless required by law.
(ref:hirist.tech)
