Job Description

:

Job Title \xe2\x80\x93 Lead - Database Administrator The Purpose of This Role Application Lead - DBA role is a horizontal Production Database Support team under Enterprise Infrastructure in Fidelity\xe2\x80\x99s Technology Services. This team supports various databases to manage WI / HCG critical applications for the business. WI / HCG Database Administration Support group provides database services related to the Oracle infrastructure for multiple client facing applications. Production Support which includes 7x12 on call support, Database Infrastructure Support, performance monitoring, 1st level performance troubleshooting, Risk/Audit compliance and Non-Prod database refreshes. Database and Oracle Application Maintenance includes Oracle Database upgrades, Database reorganizations, Security Patching, Application Upgrades. The Value You Deliver Database Administrator is core member of Application Database Support team working on Linux Servers and Oracle/Postgres databases mainly to ensure stability and availability for PWI critical applications. DBA should be able to collaborate with multiple teams to,

• Providing database application life cycle support.
• Database design, development and implementation.
• Supporting Non-Production and Production environments.
• Recommending solutions on database and application architecture.
• Maintaining database security controls and availability.
• Supporting application tuning.
• Managing database and server compliance
• Ensuring data security
• Providing high availability solutions
• Try out new technologies to adapt

The Skills that are Key to this role Technical / Behavioral Database designing and configuring in any UNIX environment. Should possess strong skillset in trouble shooting

• Oracle Database Standalone/ RAC
• Replication technologies
• PostgreSQL Database Management

Should possess strong knowledge in Oracle Database Administration

• User management
• Space management
• Performance tuning
• SQL tuning
• Backup and Recovery
• Disaster Recovery Management
• RAC with ASM
• Flashback Technologies
• Data Masking
• Postgres DBA knowledge
  • Database management skills of data administration, web connectivity/managing connections, physical structure, and overall architecture and database analysis v12 above.
  • Responsible for backup, recovery and upgrading of postgres databases. ETL and data-warehouse design experience.
  • Proficient with major PostgreSQL procedural languages viz, PL/PgSQL as well some Oracle SQL-PL/SQL.
  • Configuring Postgres Streaming Replication, Logical replication, BARMAN, EFM and Load balancing.
  • Managing monitoring tools for better performance like PGbadger

• Should have knowledge in Configuring., Monitoring and Administering through OEM
• Oracle Database
• GoldenGate
• ASM
• Oracle Performance Management
• Middle Tier
• Being proactive in maintenance activities and security management.
• Open to adapt new technologies.
• Should have strong relationship management skills.
• Should have knowledge in ITIL process.
• Having knowledge in EXADATA would be an advantage.
• Should be able to be part of solutions and problem management.
• Provide 12x7 support and ensure that all critical database problems are resolved in a timely manner
• Should have knowledge in GoldenGate replication
• Configuring and administration
• Managing all kinds of replication
• Heterogeneous replication
• Should have strong knowledge on Unix scripting.
• Possess knowledge in UDeploy
• Having knowledge in DevOps model
• Having knowledge in No-SQL databases
• Being responsible and taking ownership.
• Being open to the challenges coming up.
• Excellent written and verbal communication
• Excellent problem solving and decision-making skills
• Ability to work effectively with onshore and offshore partners and team members
• Be the promoter of change, continuously drive innovation leading by example
• Must have a flexible attitude and be able to comfortably accommodate change

The Skills that are Good To Have for this role

• Good understanding on Replication Technologies
• Good understanding on Cloud Technologies and Relational Data Services
• Good understanding on DevOps tools (Udeploy & Ansible)
• Good understanding on OpenSource databases concepts

How Your Work Impacts the Organization You would be able to contribute in maintaining stability of our databases by upkeeping infrastructure uptime through appropriate security patches, upgrades and database monitoring, managing the stakeholder\xe2\x80\x99s deliverables, being a mentor for group of DBA\xe2\x80\x99s on technology front and especially managing the performance of databases to meet the service timelines. Being a change agent to adapt to new technologies. The Expertise We\xe2\x80\x99re Looking For

• 6+ years of IT experience
• Engineering Graduate

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

Certifications:

At Fidelity, building a better financial future\xe2\x80\x94 for everyone\xe2\x80\x94 is our mission. For the last 75+ years, our privately-held company has remained committed to supporting our clients throughout their lifelong financial journeys. Our formula is simple: we support our team, and they support our customers. That culture begins with our employees, whose personal and professional growth is key to our collective success. In keeping with that legacy, our privately-held company offers associates career stability and security, while at the same time encouraging your professional exploration and growth. At Fidelity India, we are proud to continue that legacy. With offices in Bangalore and Chennai, our Indian branch is now celebrating 20 years as a Global Capability Center. To find out more, visit India.Fidelity.com, or our global site at FidelityCareers.com. Fidelity Investments is an equal opportunity employer, and whenever possible we accommodate applicants with disabilities who need adjustments to complete the application or interview process. Please email us at@accommodations@fmr.com or call 800-835-5099 for more information