Similar Jobs
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 Technology