Full job description
Microsoft Advertising seeks a senior Business Applications Engineer (IC4) in Database Operations to lead initiatives and support a diverse Data Platform including RDBMS, NoSQL, ClickHouse, and Azure database services in a Linux environment. Responsibilities include architecting scalable, secure, and high-performance database solutions; advanced data modeling and schema optimization; leading automation using scripting and Infrastructure as Code; implementing CI/CD pipelines; managing Azure database services; performing upgrades, backups, recovery, and migrations; troubleshooting complex database incidents; collaborating with international teams; mentoring junior engineers; maintaining documentation; ensuring security and regulatory compliance; participating in on-call rotations; evaluating and recommending low-code/no-code solutions; designing solutions using low-code/no-code platforms; and partnering with stakeholders to align technical specifications with business objectives. Required qualifications include 8-11 years of experience with RDBMS (MySQL, PostgreSQL), expertise in NoSQL and ClickHouse, strong Azure database service experience, scripting proficiency (Shell, Python, Perl), CI/CD and Infrastructure as Code experience, and leadership skills. Willingness to relocate to Bengaluru and work rotational shifts (24x7) is required. Preferred qualifications include experience with distributed systems, key-value stores (Redis, Aerospike), version control (Git), configuration management (Puppet, Chef), security compliance knowledge, and DevOps exposure.
What you'll do
- Architect and design scalable, secure, and high-performance database solutions
- Perform advanced data modeling, schema optimization, and capacity planning
- Lead automation initiatives for operational processes using scripting and Infrastructure as Code
- Implement CI/CD pipelines for database deployments and upgrades
- Ensure performance, security, and availability of databases across RDBMS, NoSQL, and ClickHouse
- Manage Azure database services including Azure SQL Database, Cosmos DB, and Data Explorer
- Perform upgrades, backups, recovery, and migrations with minimal downtime
- Troubleshoot and resolve complex database-related incidents within SLA
- Collaborate with international teams and stakeholders on architecture and design decisions
- Mentor junior engineers and promote best practices in database operations
- Prepare and maintain documentation for architecture, SOPs, and operational guidelines
- Drive compliance with security and regulatory standards
- Participate in on-call rotation and provide production support for critical systems
- Evaluate new tools, platforms, and updates within the low-code/no-code solution industry and provide recommendations
- Design application solutions using advanced configurations in low-code/no-code platforms (e.g., Power Automate)
- Partner with stakeholders to integrate business objectives into program requirements and technical specifications
Requirements
- 8-11 years of experience in database administration and architecture with RDBMS (MySQL, PostgreSQL)
- Deep expertise in NoSQL and ClickHouse, including design and optimization
- Strong experience with Azure database services (Azure SQL, Cosmos DB, Data Explorer)
- Proven ability in database design, data modeling, and schema optimization
- Experience in performance tuning, query optimization, and troubleshooting complex issues
- Proficiency in scripting languages (Shell, Python, Perl) for automation
- Hands-on experience with CI/CD pipelines and Infrastructure as Code for database deployments
- Excellent communication and leadership skills to mentor and guide teams
- Willingness to relocate to Bengaluru and work in rotational shifts (24x7)
- Preferred: Experience with distributed systems and high-availability architectures
- Preferred: Knowledge of key-value stores such as Redis or Aerospike
- Preferred: Familiarity with version control tools (Git) and configuration management tools (Puppet, Chef)
- Preferred: Understanding of security compliance and regulatory requirements for data platforms
- Preferred: Exposure to DevOps tools and practices for database operations
Tech stack
RDBMSMySQLPostgreSQLNoSQLClickHouseAzure SQL DatabaseCosmos DBData ExplorerLinuxShell scriptingPythonPerlCI/CDInfrastructure as CodePower AutomateRedisAerospikeGitPuppetChefDevOps