Principal Database Engineer

Job Description:

Job Title: Principal Database Engineer

The Purpose of This Role

• As part of the Green Meadows program within the Fidelity Center for Applied Technology (FCAT), the candidate will be part of a team which is focused on building a modern brokerage platform. This platform will be completely on the cloud and will provide various new additional & improved features to the end customer.

• We are looking for a highly motivated Database Engineer to be part of our brokerage platform DBA team. In this role you will bring your technology expertise, design, and administration skills to create unique state-of-the-art database systems to build our brokerage platform. You have a passion for technology tempered by a level-headed approach to problem solving and broad experience in diverse technologies. You will work on all phases of projects, from design to deployment into production along with the team of Architects, Analysts, Developers and SREs.

The Value You Deliver

• Design, configure and monitor very large-scale database systems including distributed SQL, NoSQL and in memory databases. Working in tandem with Architects, database administrators, data engineers across the organization.

The Skills that are Key to this role

Technical / Behavioral

• Expertise in Distributed SQL and NoSQL Databases.

• Hands-on experience in Cockroach DB.

• Experience in MongoDB is preferred.

• Knowledge and experience in installing, configuring, and upgrading Cockroach DB, as well as general administration.

• Sound knowledge in architecture of cockroach DB, geo-partitioning, data replication, sharding

• Understanding of consensus algorithms (Raft / Paxos)

• Schema design, performance tuning, query optimization, backup solutions (Physical and Logical)

• Proficient in Performance Tuning.

• Debugging skills and the ability to troubleshoot methodically, identifying, and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues.

• Scripting/automation tooling (bash/python and Ansible) experience is a must.

• Experienced in CI/CD, DevOps using tools like Udeploy, JIRA, Confluence, Jenkins, Git, liquibase.

• Experience in Datadog and integration with ServiceNow.

• Cross-functional training in NoSQL, Site Reliability Engineering and DevOps methodologies are encouraged.

• Knowledge in working of REST APIs, ability to read documentation and make calls to read or write data using API is a plus.

• Experience in containerization technologies such as ECS and Docker

The Skills that are Good to Have for this role

• Must have worked on trending cloud solutions (AWS/Azure /GCP) – AWS preferred.

• Experience in AWS EC2, CFT, Route53, RDS.

• Experience or subject knowledge in Redis and Elasticsearch.

• Clear understanding of query planning

• Excellent interpersonal and communication skills in both oral and written English

• Adept at version control tools GIT Stash, build tools like Maven.

• Experience in working with different kinds of hosted infrastructure.

• Ability to learn new concepts and technologies in strict timelines.

• Must be adaptable in a changing environment and be effective in many different business settings.

• Experience with cloud data warehousing and data lake solutions is a plus.

How Your Work Impacts the Organization

At Fidelity, we are focused on making our financial expertise broadly accessible and effective in helping people live the lives they want— from the 23 million people investing their life savings, to the 20,000 businesses managing their employee benefits programs, to the10,000 advisors and institutions needing innovative technology solutions to invest their clients’ money. To do this well, as a privately held company, we place a high degree of value in nurturing a work environment that attracts the best talent and reflects our commitment to being an employer of choice.

Underneath this stable and trusted brand is one of the most interesting innovation practices you never heard of - The Fidelity Center of Applied Technology (‘FCAT”).  FCAT is a centralized function whose mandate is to catalyze innovation across the firm.  Our FCAT teams prototype and pilot new businesses and capabilities that continue to distinguish our brand as the best customer experience in the financial services industry.  These teams focus on exploring big industry game-changing technologies such as crypto currencies, artificial intelligence, virtual/augmented reality & cloud computing.  Additionally, FCAT’s world class research team identifies trends and works with partners across the innovation ecosystem to “bring the outside in.”  We collaborate with MIT, Harvard, Stanford and other academic institutions, and partner with Accelerators, Start Ups and other industry leaders to drive new ideas and innovation practices across the firm.

The Expertise We’re Looking For

• 10+ years of DBA experience

• Bachelor's degree in computer science or any other discipline

• AWS Solutions Architect certification is preferable.

Location: Chennai

Shift timings: 11:00 AM - 8:00 PM

Certifications:

Category: