Your team responsibilities
- Understanding of pages, extent, index tree structure, partitioning, temporal tables
- Support for table partitioning, effective index design, stats policy and data archiving
- Working on database encryption, compression and other advanced features
- Planning, implementation and troubleshooting of AG/DAG setup
- Performance troubleshooting; high cpu usage, memory and thread exhaustion
- Very large database index and stats maintenance
- Always on replication support across global regions
- Excellent deep dive troubleshooting skills corelating DMVs with Sentry/SCOM
- Administration and maintenance of DB Systems and related Microsoft Azure Cloud VMs
- Planning and execution of On-Prem to Cloud database migration
- Handling of database backups, restore and recovery scenarios
- Troubleshoot P1/MI incidents and find the RCA, permanent resolution to ensure maximum uptime and database performance stability
- Proactively manage and maintain security standards and controls
- Proactive database review to optimize and simplify architecture and performance
- Manage SQL Database Security
- Performs capacity planning
- Work on alerts fine tuning and ensure effective monitoring dashboards and customized database alerts
- Patching of SQL Server and Cloud VM instances
- Support for database operations, projects and Engineering deliveries
- Reviews, analyzes, evaluates, and recommends new/existing technologies that might increase productivity, reduce down time, or improve the quality of work related to SQL server systems
- Establish and maintain Microsoft SQL Database architecture best practices, including procedures, guides, templates, and relevant documentation
- 24X5 Database Operation Shift support including weekend on-call support and handling of database request tickets and alerts
- Planning and execution of SQL Server migration and upgrade
- Support and collaborate with Infrastructure, application and development teams
- Determine and document DB policies, procedures and standards
- Ensure Change process, required run books and scripts for the executions
- Ensure SLA's & operational KPI's are met, working as necessary with internal and external support functions when major incidents occur
Want more jobs like this?
Get Data and Analytics jobs in Mumbai, India delivered to your inbox every week.
What we will offer you:
At MSCI, we provide competitive benefits programs in every region in which we do business. While our benefits plans vary in availability in our different locations, we offer a broad range of benefits that are part of the value you receive as a MSCI employee. Wherever you are with us, you will find benefits that can help ensure your health and well-being and contribute to your financial security.
Your skills and experience that will help you excel
- A university graduate and cloud/sql certifications (with 7-10 years relational database experience)
- Experience should include DB design, capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies, database upgrade, migration, patching, tracing, SQL native tools, SQL Always On, replication.
- Experience in transact-sql and shell scripting (Windows/Linux) for automation and sql build process
- Familiarity with monitoring tools such as SCOM, Sentry, PagerDuty, Grafana
- Fundamental knowledge of Devops, Terraform, Linux OS
- Familiarity with cloud sql technologies technology (AWS/Azure/GCP) such as PaaS and CloudSQL.
- Min 3+ years of experience with Cloud Infrastructure and Fundamental Cloud certification.
- SQL management and monitoring tools.
- Excellent communication skills and good problem solver
- Hands on experience with DB standards
- Must be a self-starter with a strong attention to detail.
- Ability to process information logically
- Ability to plan, organize and coordinate work assignments
- Ability to communicate technical information effectively
- Ability to establish and maintain effective working relationships with others
- Ability to assess future information needs so that the databases can evolve in an appropriate manner.
How we'll support you
- Coaching, support and encouragement from experts in your team
- Access to a wide range of learning opportunities to support your growth and development
- Customizable learning journeys to help you navigate your professional development
- Transparent performance-based compensation schemes
- Employee Resource Groups: MSCI Pride, Black Leadership Network, Women's Leadership Forum, Women in Tech, Asian Support Network, All Abilities, Hola! MSCI and Climate Action Group.
About MSCI and our teams
MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process.
Our values define the working environment we strive to create. We are inclusive, we champion bold ideas, we always pursue excellence, and always act with integrity. Personal accountability and responsibility are key to success, and we always work as a team to remain client centric.
At MSCI diversity is at our core and inclusion defines our culture. Our people are empowered to maximize their potential in an environment where all individuals are respected and encouraged to bring their authentic selves to work. We work, learn and grow together and we are committed to hiring and promoting qualified women, ethnic minorities and members of the LGBT+ community candidates, who have historically been underrepresented in financial services.
To learn more about life at MSCI please visit https://careers.msci.com or follow us on LinkedIn, Twitter, Glassdoor.
To all recruitment agencies: MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes.
MSCI Inc. is an equal opportunity employer committed to diversifying its workforce. It is the policy of the Firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected pregnancy/maternity leave), veteran status, or any other characteristic protected by law.