Specialist - Database Administrator
- Omnicom Media Group
- 10 - 14 years
- Bengaluru
- 29 days ago
- Email to a friend
- Report this job
Job Description
About Omnicom Global Solutions
Omnicom Global Solutions is an integral part of Omnicom Group, a leading global marketing and corporate communications company. Omnicoms 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 companys 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
Job Classification
Industry: Film / Music / EntertainmentFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: Omnicom Media GroupLocation(s): Bengaluru
Keyskills: resource management kubernetes stack confluence hosting hibernate resolution ansible java postgresql linux writing jenkins communication skills jira rdbms ubuntu query verbal communication atlassian database administration spring boot performance t investigation terraform aws
Similar positions
Omnicom Media Group
At Annalect, we work with clients to develop data driven marketing strategies, powered by a connected system of technology, tools, consultants and digital activation. Drawing from the vast resources of our parent company Omnicom and spanning the globe in a variety of industry verticals, we are the d...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in