DevOps Senior DBA

Company: Broadcom
Company: Broadcom
Location: IND-Bangalore Electronic City S2
Commitment: Full time
Posted on: 2023-09-08 05:55
Please Note:1. If you are a first time user, please create your candidate login account before you apply for a job. (Click Sign In > Create Account)2. If you already have a Candidate Account, please Sign-In before you apply.Job Description:This position is to work in the FinTech area of Broadcom.  Our division provides electronic payments and banking solutions in SaaS using AI/ML to determine risk.  This position is for a Senior Database Administrator who will be a subject matter expert in all aspects of our PostgreSQL environment from cleaning up inefficient SQL/ORM logic, to digging into performance issues to optimizing our redundancy and monitoring capabilities. This candidate needs to be comfortable with being a resource for Operations and Engineering to provide guidance on leveraging datastore solutions to meet the needs of the organization.ResponsibilitiesManage all aspects of the database lifecycle. Setup, installation, patching, upgrades, backups, and support for PostgreSQL and MongoDB database management systemsProvide monitoring, performance, and tuning of the database management systems.Works in partnership with development resources to code, test, and implement database solutions according to the best standardCreate database server installation scripts leverage scripting and automation technologies to improve the speed of delivery using available tools such as GIT, BASH, Ansible, and Python scriptingPerformance tuning on backup/recovery issues and archive systems management software.Perform scheduled maintenance and support release deployment activities after hours.Participate in an on-call rotation. Willingness to participate in escalated issues as requiredRequirementsBS Degree in Computer Science or related fields7+ years experience with large-scale PostgreSQL environments, preferably multi-region and/or global5+ years experience troubleshooting Database performance and scalability issues (identifying inefficient queries, indexes, configurations, infrastructure, etc)Experienced in the use of Patroni clustersExpert with PostgreSQL and MongoDB. Can develop stored procedures, database triggers, and other database-related activities in support of application developmentAbility to proactively identify, troubleshoot, and resolve  database system issuesExperienced at performing developer SQL code review to ensure queries are optimized and tuned to perform efficiently.Demonstrated knowledge in designing and managing high-availability environments.   Has had exposure to cloud architecture and Data PlatformsLinux OS knowledge and ability to automate tasks using GIT, Bash, Ansible or PythonBroadcom is proud to be an equal opportunity employer.  We will consider qualified applicants without regard to race, color, creed, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability status, medical condition, pregnancy, protected veteran status or any other characteristic protected by federal, state, or local law.  We will also consider qualified applicants with arrest and conviction records consistent with local law.If you are located outside USA, please be sure to fill out a home address as this will be used for future correspondence.
View Original Job Posting