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
Didn't find what you're looking for? Search again!
Loading more jobs...