Job Title : Database Administrator
The Purpose of This Role
Hired associate would be responsible for providing end to end support for the backend databases of Fidelity. The associate in this role would work towards providing stability in the environment, ensure databases and services are up and running always, ensure compliance of databases with respect to the latest security patches and maintain TLM support for Fidelity databases.
The Value you Deliver
Primary Responsibilities
Install and configure new MS SQL Servers 2016/Oracle.
Manage environment on SQL MI, MySQL, Postgres on Azure
Manage Devops Deployment pipelines
Day to day support of multiple MS SQL Server (Production & Non-production)
Incident resolution & plan and deploy database changes
High Availability and Disaster Recovery setup experience with MS SQL Server
Ready to work in afternoon shift of 11am to 8pm
Participation in production On-Call(12x7) on rotation
The Skills that are Key to this role
Solid knowledge of MS SQL Server 2016 or higher version on Windows 2012 administration
Knowledge of MS SQL Server backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
Knowledge of SQL Server tools ( Profiler, SSMS, PerfMon, DMVs, SSIS, SSRS & System procs)
Excellent problem analysis and creative solution-building skills
Strong technical, teamwork and partnering skills
Willingness to learn other RDBMS – MySQL
Good on cloud concepts
Good hand on experience on SQL MI, Azure/Oracle
Experience on Cockroach DB/Aerospike/Yugabyte would be added advantage
The Expertise we are looking for:
5+ Years of Experience
Should have a strong understanding MS SQL 2014 and above, Azure SQL MI
Should have a strong understanding on AWS cloud like EC2, S3, CFT, EBS, AWS CLI
Good exposure or hands on experience with DevOps tools would be added advantage
Excellent communication skills
How Your Work Impacts the Organization
You would be able to contribute in maintaining stability of our end points by upkeeping infrastructure uptime through structured software, distribution and patch management mechanism thereby helping associates to perform their day to day tasks seamlessly
Location: Bangalore
Shift timings: 11:00am – 8:00pm
Certifications:Category:Information TechnologySimilar Jobs
What We Do
At Fidelity, our goal is to make financial expertise broadly accessible and effective in helping people live the lives they want. We do this by focusing on a diverse set of customers: - from 23 million people investing their life savings, to 20,000 businesses managing their employee benefits to 10,000 advisors needing innovative technology to invest their clients’ money. We offer investment management, retirement planning, portfolio guidance, brokerage, and many other financial products.
Privately held for nearly 70 years, we’ve always believed by providing investors with access to the information and expertise, we can help them achieve better results. That’s been our approach- innovative yet personal, compassionate yet responsible, grounded by a tireless work ethic—it is the heart of the Fidelity way.
