SQL Database Administrator

**Your team responsibilities**
- Administration and maintenance of DB Systems and related Microsoft Azure Cloud VMs.
- Planning and execution of On-Prem to Cloud database migration.
- Maintain database performance across the production, beta and development services.
- Implement backup strategies for the SQL Server Infrastructure.
- Power shell scripting and automation of time consuming/manual DBA tasks and critical project deliveries. Ensure optimum and quality deliveries.
- 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.
- Planning, implementation and troubleshooting of AG/DAG setup
- Determine and document DB policies, procedures and standards.
- Ensure Change process, required run books and scripts for the executions.
- Support for table partitioning, effective index design, stats policy and data archiving
- Working on Database Encryption, Compression and other advanced features
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.

**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 MS SQL Certified ( with more than 5 years’ of experience - for Associate position and 7+ years - for Senior Associate )
- 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.
- Min 1+ years of experience with Cloud Infrastructure and Fundamental Cloud certification.
- Power shell and SQL scripting
- SQL management and monitoring tools.
- Table Partitioning and Index designing
- Database Encryption, Compression
- Architecture design principles
- 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 al