SRE/DevOps DBA

Company: Fiserv
Location: Sacramento
Posted on: May 15, 2022

Job Description:

Every day, Client - devices handle the core credit card and point-of-sale processing for hundreds of thousands of merchants. Behind the scenes, we operate a cloud platform providing processing, storage and collaboration for merchants, application developers, service providers and our merchants' customers.To support all of this, we have a team of specialist engineers dedicated to ensuring our systems remain operational, safe and secure.As a - SRE/DevOps DBA at Clover Network you can look forward to:

• Working closely with the Engineering and Development teams based in multiple geographic locations on upcoming feature rollouts
• Perform regular database schema changes with no downtime
• Design and rollout database sharding, create new database clusters/shards for support of customer data growth. Perform and manage migrations of customer data between shards
• Solve performance issues and drive optimizations
• Automate recurring DBA tasks
• Manage production incidents and mitigations
• Monitor database environment to maintain high availability and proactively identify and tackle issues
• Work with and educate our Engineering teams to make good schema design choices and write efficient queries
• Monitor and improve our backup solution to ensure that our customers' data is always secure
• Influence peer efficiency by staying on top of the industry, as well as contribute to the industry on behalf of Clover
• Maintain database systems, update software versions
• Create reports, documentation, operating manuals, runbooks including routine tasks and processes
• Track and apply changes to database objects and data transformations in testing and production environments
• Maintain database continuous integration, delivery, and deployment efforts in support of DevOps initiatives
• Leverage standard platforms and cloud technologies to improve efficiency and scalability of data & services
• Apply industry standard security principles and best practices We're looking for a SRE/DevOps DBA to help with our complex database environment. This role is key to help maintain the high reliability and performance of our application as well as assist in development of emerging changes. This is a sharded database environment which is constantly growing. We operate in multiple cloud and native hardware locations while expanding to more. We are looking for a hardworking and experienced DBA with DevOps and SRE experience, expert knowledge in database administration and scripting and a great temperament to fit into the team.
  • Work closely with the Engineering and Development teams based in multiple regions
  • Perform regular database schema changes with no downtime
  • Perform and manage migrations of customer data between shards
  • Create new database clusters/shards for support of customer data growth
  • Solve performance issues and suggest optimizations
  • Automate recurring DBA tasks
  • Be part of DBA team on-call (when on rotation)
  • Monitor database environment to maintain high availability and proactively identify and tackle issues
  • Work with and educate our Engineering teams to make good schema design choices and write efficient
  • queries
  • Monitor and improve our backup solution to ensure that our customers' data is always secure Influence peer efficiency by staying on top of the industry, as well as contribute to the industry on behalf of Clover
  • Maintain database systems, update software versions
  • Manage access privileges.
  • Restore encrypted backups for Development team Contribute to database designs for new product features and capabilities
  • Create reports, documentation, operating manuals including routine tasks and processes
  • Track and apply changes to database objects and data transformations in testing and production environments
  • Maintain database continuous integration, delivery, and deployment efforts in support of DevOps initiatives
  • Leverage open source platforms and cloud technologies to improve efficiency and scalability of data
  • services
  • Apply industry standard security principles and best practices
  • Perform addition duties as needed Basic Qualifications for Consideration:
    • 5+ years of proven ability with MySQL architecture, replication, sharding, monitoring, troubleshooting and backups.
    • 5+ years of DevOps or SRE experience
    • Extensive experience with teraform and puppet
    • Affinity for automation and strong use of a scripting language
    • Working knowledge with AWS/GCP database technologies like Aurora, DynamoDB, Snowflake, CloudSQL etc will be a plus
    • Experience working with MySQL in sharded environment is a plus
    • Experience working with ProxySQL and Maxscale is a plus
    • Excellent verbal and written communication skills including interpersonal skills
    • Experience and ability to architect entire solution, and interconnected systems
    • Ability to coordinate technical efforts across teams, influence technical direction
    • Prioritize and deliver results effectively on concurrent projects in fast-paced team-oriented environment
    • Highly motivated, well organized, and detail oriented.
    • Strong analytical and problem-solving skills.
    • Proven track record of analyzing and solving complex data issues.
    • Query tuning, optimization, and monitoring in enterprise environment.
    • Root cause analysis of performance and integrity issues.
    • Data analytics and reporting using complex SQL queries. Preferred Skills, Experience, and EducationDesirable skills: MYSQL, Linux Admin (CentOS), Python, Puppet (or Chef), MySQL / PostGreSQL Admin, RDBMS / SQL / DDL / DML, Terraform, Encryption/certs/security, TCP/IP, Monitoring: DataDog/ Grafana, YAML / XML, ELK Stack, Git / GitHub / Gitlab Admin, Bash / Shell / Java, Yum/RPM, Docker, Kubernetes, GCP/AWS, DNS, LDAP

Keywords: Fiserv, Sacramento , SRE/DevOps DBA, Other , Sacramento, California