Specialist - Database Administrator

About Omnicom Global Solutions

Omnicom Global Solutions is an integral part of Omnicom Group, a leading global marketing and corporate communications company. Omnicom’s branded networks and numerous specialty firms provide advertising and communications services to over 5,000 clients in more than 70 countries.

Omnicom Global Solutions India plays a key role for our group companies and global agencies by providing stellar products and services in the areas of Creative Services, Technology, Marketing Science, Media Services, Market Research and Business Support Services

The DBA will have overall responsibility for the uptime of our platform databases. You will work closely with Engineers and QAs and DevOps to help design, build and maintain a highly performant database architecture. You will be responsible for defining, producing and maintaining key database metrics.

Work location - Bangalore

Work Timings - 2pm-11pm

Roles and Responsibilities:

• Responsible for the uptime and performance of the database infrastructure
• Capacity planning - ensuring storage is sufficient for future needs
• Performance tuning - providing advice to Engineers to ensure schemas and

queries are designed to support low latency

• Monitoring - ensure databases are monitored 24x7 and preventative action is taken to remedy any detected issues
• Contribute to output from slow running performance tests to suggest improvements
• Installing and applying upgrades and patches, ensuring databases are up to date and adhere our upgrade policies
• Ensuring replication is in sync
• Providing appropriate documentation for key business databases, including details of the underlying infrastructure and configuration settings
• Planning and implementing backup, recovery and high availability of PostgreSQL databases
• Configure and maintain resources on AWS
• Contribute to the data retention and archiving policy
• Maintain infrastructure using Terraform, Ansible, Kubernetes (helm) and Jenkins
• Implement monitoring and automation where needed to proactively prevent issues and improve uptime
• Ensure infrastructure adheres to the company’s security requirements
• Participate in on-call rotation to provide 24/7 support of hosting infrastructure

Use ticket management system such as Jira to manage work priorities

This may be the right role for you if you have.

• 10 years+ of RDBMS, with good working knowledge of PostgreSQL
• In-depth knowledge of query optimizing techniques to assist with performance and scalability
• Technical diagnostic expertise including database failure investigation, reproduction, and resolution skills
• Experience with database administration in cloud environments (AWS)
• Deep understanding of the Linux operating system, with Ubuntu experience a plus
• Understanding of Java and Hibernate
• Strong understanding of hosting and resource management (CPU, memory, storage, security, networking, I/O etc.)
• Hands-on experience with configuring and maintaining resources on AWS
• Knowledge of networking fundamentals
• Experience with and a strong understanding of security best practices
• Strong familiarity with Java/Spring Boot and PostgreSQL database stack
• Experience with Atlassian tooling including Jira and Confluence
• Strong written and verbal communication skills
• A degree in Computer Science, or a related subject is beneficial