Senior Data Engineer

Job Description:

Senior Data Engineer

The Role

The Fidelity Institutional Technology, Database Center of Excellence (COE), requires a highly competent and highly motivated Senior Database Administrator with strong technical skills to support challenging mission critical database platforms. This position would provide an excellent opportunity to work on leading database technologies like Oracle, Postgres, Cockroach,NoSQL, Snowflake etc. It is a great place to experience & learn end to end DBA service capabilities!

This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned. Provides enormous opportunity to learn cutting edge technologies like machine learning!

The Expertise and Skills You Bring

Primary Responsibilities:

• 5+ experience in providing Database design, solutioning and providing database engineering support to microservices/Data as a service API development team using SQL, PL/SQL, Java, Python and NodeJS.
• 2+Experience with cloud databases platforms (AWS/Azure/Oracle OCI certification is helpful), on both Linux and Windows environments.
• 2+ Experience in Container technologies like Docker and Kubernetes
• 3+ experience in Oracle Database Administration / Performance Engineering / Resiliency Engineering and Replication Engineering across multiple platforms -- Linux and Engineered systems.
• Experience managing systems using infrastructure as code tools (IAM, ARM, Terraform, Chef)
• Experience in modern observability tools (DataDog, Prometheus, Splunk, Grafana,etc)
• Experience on CI/CD process, tools, testing frameworks and practices (GitHub, Jenkins, Udeploy and Jmeter)
• 1+ experience in DB performance for other RDBMS/NOsql/Distributed database platforms (Postgres, Snowflake, Cassandra, MS SQL server, Cockroach etc) across multiple platforms -- Linux and Engineered systems.
• Designing and implementing highly resilient and performing Oracle database platforms, using distributed database technologies.
• Interface with agile development squads, enterprise teams for Systems Administrators, Cyber Security and Capacity Planning groups as and when situation demands
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
• Self-motivated with strong team, interpersonal and communication skills
• Write clear, concise, well organized technical documentation to maintain standards and procedures

• Designing and implementing highly resilient and performing cloud database platforms, using distributed database technologies.
• Perform applications database administration (Oracle/Postgres/Cockroach) services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support & Engineering.
• Proactively monitor databases servers and respond to any alerts.
• Provide database development support in all phases of SDLC and agile experience is preferred including logical and physical data model review, SQL performance, Data injection etc.
• Interface with agile development squad, enterprise teams for Systems Administrators, Cyber Security and Capacity Planning groups as and when situation demands.
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds.
• Should have strong time management skills with willingness and ability to handle multiple projects/initiatives at the same time.
• Self-motivated with strong team, interpersonal and communication skills!
• Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients.
• Write clear, concise, well organized technical documentation to maintain standards and procedures.