Job Description - Senior Associate - SQL Server DBA (2300018G)
Job Number: 2300018G
Requisition Title : Senior Associate - SQL Server DBA
Description :
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
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.
Job : Technology
Primary Location : India-Maharashtra-Pune
Job Profile : Senior Associate
Time Type : Full Time
Department : Technology Services
Job Posting : Aug 26, 2024, 1:30:00 PM
