Senior Database Engineer

<div class="container-3Gm1a"><b>Overview</b><br><div><p>Microsoft Advertising is an online advertising platform where advertisers bid to display ads, service offers, product listings, and videos to web users. Our data-enabled technology platform optimizes ROI for buyers and sellers while maintaining an open marketplace globally. <br> <br>As a Business Applications Engineer (IC4) in Database Operations, you will lead initiatives and support our diverse Data Platform consisting of RDBMS, NoSQL, ClickHouse, and Azure database services in a Linux environment. This senior role requires architect-level expertise in database design, data modeling, schema optimization, and capacity planning. You will drive automation initiatives, implement Infrastructure as Code, and ensure CI/CD for database deployments. <br><br>You will also partner with product management, stakeholders, and engineering teams to identify and address critical gaps with low-code/no-code solutions. Enhancement of production services by configuring settings utilizing low-code/no-code solutions to meet and exceed stakeholder needs is also part of the role. You will lead the development and delivery of training sessions and materials on the capabilities of low-code/no-code solutions and system features and proactively tailor content to meet user needs. You are expected to optimize continuous delivery by designing and implementing automated workflows for continuous delivery and monitoring. Leading research initiatives on emerging trends and innovations in the low-code/no-code solution industry and to leverage expertise to implement and drive improvements in customer experience, and to mentor others in evaluating technology trends and drive cross-organizational innovation is part of the requirement. <strong>You should be willing to relocate to Bengaluru and be flexible to work in rotational shifts (24x7). </strong></p></div><br><br><b>Responsibilities</b><br><div><div><ul style="list-style-type: disc;"><li><p><span>Architect and design scalable, secure, and high-performance database solutions</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Perform advanced data modeling, schema optimization, and capacity planning</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Lead automation initiatives for operational processes using scripting and Infrastructure as Code</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Implement CI/CD pipelines for database deployments and upgrades</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span><span>Ensure performance, security, and availability of databases across RDBMS, NoSQL, and </span><span>ClickHouse</span></span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Manage Azure database services including Azure SQL Database, Cosmos DB, and Data Explorer</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Perform upgrades, backups, recovery, and migrations with minimal downtime</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Troubleshoot and resolve complex database-related incidents within SLA</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Collaborate with international teams and stakeholders on architecture and design decisions</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Mentor junior engineers and promote best practices in database operations</span><span> </span></p></li></ul></div></div><div><div><ul style="list-style-type: disc;"><li><p><span><span>Prepare and </span><span>maintain</span><span> documentation for architecture, SOPs, and operational guidelines</span></span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span>Drive compliance with security and regulatory standards</span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span><span>Participate in on-call rotation and provide production support for critical systems</span><span>.</span></span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span><span>Evaluate new tools, platforms, and updates within the low-code/no-code solution industry and </span><span>provide</span><span> recommendations on adopting </span><span>new solutions</span><span> that improve efficiency, scalability, and functionality of the development process.</span></span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span><span>Design application solutions by using advanced configurations </span><span>established</span><span> in low-code/no-code platforms (e.g., Power Automate) to create customized and scalable solutions that address business requirements</span></span><span> </span></p></li></ul></div><div><ul style="list-style-type: disc;"><li><p><span><span>Partner with stakeholders to synthesize and integrate </span><span>comprehensive</span><span> understanding of business </span><span>objectives</span><span> into program requirements and technical specifications. </span></span><span> </span></p></li></ul></div></div><br><br><b>Qualifications</b><br><div><div><p>Required Qualifications </p></div><div><ul style="list-style-type: disc;"><li><p>8-11 years of experience in database administration and architecture with RDBMS (MySQL, PostgreSQL) </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Deep expertise in NoSQL and ClickHouse, including design and optimization </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Strong experience with Azure database services (Azure SQL, Cosmos DB, Data Explorer) </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Proven ability in database design, data modeling, and schema optimization </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Experience in performance tuning, query optimization, and troubleshooting complex issues </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Proficiency in scripting languages (Shell, Python, Perl) for automation </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Hands-on experience with CI/CD pipelines and Infrastructure as Code for database deployments </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Excellent communication and leadership skills to mentor and guide teams </p></li><li><strong>You should be willing to relocate to Bengaluru and be flexible to work in rotational shifts (24x7). </strong></li></ul></div><div><p>Preferred Qualifications </p></div><div><ul style="list-style-type: disc;"><li><p>Experience with distributed systems and high-availability architectures </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Knowledge of key-value stores such as Redis or Aerospike </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Familiarity with version control tools (Git) and configuration management tools (Puppet, Chef) </p></li></ul></div></div><div><div><ul style="list-style-type: disc;"><li><p>Understanding of security compliance and regulatory requirements for data platforms </p></li></ul></div><div><ul style="list-style-type: disc;"><li><p>Exposure to DevOps tools and practices for database operations </p></li></ul></div></div> <br><p>This position will be open for a minimum of 5 days, with applications accepted on an ongoing basis until the position is filled.</p><br><hr><br><p>Microsoft is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship, color, family or medical care leave, gender identity or expression, genetic information, immigration status, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran or military status, race, ethnicity, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable local laws, regulations and ordinances. If you need assistance with religious accommodations and/or a reasonable accommodation due to a disability during the application process, read more about <a href="https://careers.microsoft.com/v2/global/en/accessibility.html"><b><u>requesting accommodations.</u></b></a></p> </div>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...