AddressMicrosoft Advertising is an online advertising platform, where advertisers bid to display brief ads, service offers, product listings and videos to web users. Our data-enabled technology platform, encompassing Invest, Monetize, and Curate, optimize return on investment for both buyers and sellers, while maintaining a commitment to an open marketplace and empowering the open web globally.
As a Database Admin, you will operate and support our diverse Data Platform. This platform consists of RDBMS, Data Warehouse, NoSQL and Key Value Stores in an all Linux environment.
This growing team consists of curious, passionate, talented technologists who enjoy working on complex, large scale data stores. Our team members thrive in a learning and teaching environment. Each team member is encouraged to explore solutions and efficiencies to support, optimize, and maintain our systems. We are enthusiastic about automation and optimization.
Your primary responsibilities will involve supporting and enhancing data stores for extremely intricate, high-availability, low-latency, business-critical real-time systems. This will entail utilizing contemporary open-source tools and architectural approaches, working closely with other highly skilled engineering teams, honing your problem-solving abilities in complex scenarios, and becoming proficient in managing large-scale data stores.
We anticipate exponential growth in data and transactions on our platform and so we are seeking engineers who are excited about this opportunity and would love to:
- Work on large-scale, distributed systems
- Learn new technologies, tools and applications
- You should be willing to relocate to Bengaluru and flexible to work 24 * 7.
Your primary responsibilities will involve support, upgrades, troubleshooting, performance tuning, maintenance and automation. This will entail utilizing contemporary open-source tools and architectural approaches, working closely with other highly skilled engineering teams, honing your problem-solving abilities in complex scenarios and becoming proficient in managing large-scale data stores.
Responsibilities
- Ensuring performance, security, and availability of databases
- Performing database procedures, such as upgrades, backup, recovery and migrations with zero/minimum downtime
- Administering user access privileges
- Performing database backups and restores
- Deploying database DDL changes
- Tracking and resolving database related incidents and requests within SLA
- Communicating with international team members and stakeholders
- Launching of database instances
- Performing configuration changes on database systems
- Coding scripts to automate and optimize operational processes
- Escalating production issues to senior engineers
- Preparing documentation for standard operating procedures
- Following standard processes for change control, incidents and maintenance
- Effective with time management and ability to manage priority tasks and requests
- Providing production support with rotational shifts and participating in on call rotation
- Embrace Microsoft culture and values
Qualifications
Required
- 4-8 years of strong experience of database administration with MySQL and/or PostgreSQL
- Experience in troubleshooting and resolving issues with backup and restore operations, user access, data replication, connectivity and database performance
- Experience in performance tuning, SQL query optimization and related monitoring and troubleshooting tools
- Experience troubleshooting system issues with Linux operating systems
- 2 years of experience with scripting languages such as Unix shell, Python, Perl
- Good interpersonal, written and verbal communication skills
- Good technical documentation skills to create standard operating procedures
- Ability to effectively communicate with international teams in multiple locations
- Ability to work with multiple database technologies
Additional or Preferred Qualifications
- Experience with column-oriented DBMS such as Vertica
- Experience with key-value stores such as Aerospike, Redis
- Understanding of code versioning tools such as git
- Understanding of configuration management tools such as Puppet or Chef
