Senior Associate - SQL Server DBA

• 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

• 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.

What we offer you

• Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing.

• Flexible working arrangements, advanced technology, and collaborative workspaces.

• A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results.

• A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients.

• Global Orientation program to kickstart your journey, followed by access to our Learning@MSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development.

• Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles.

• We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola! MSCI, Pride & Allies, Women in Tech, and Women’s Leadership Forum.

At MSCI we are passionate about what we do, and we are inspired by our purpose – to power better investment decisions. You’ll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry.

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.

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 parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistance@msci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries.

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.

Note on recruitment scams

We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com