DevOps Engineer (Amazon Web Services Database Administrator)California Creative Solutions Inc. • Sacramento, California, USA
DevOps Engineer (Amazon Web Services Database Administrator)
California Creative Solutions Inc. • Sacramento, California, USA
[job_card.variable_days_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]Review / create / update Visio diagrams for existing / new SQL on-premises SQL in cloud and AWS RDS infrastructure. Create / document / implement disaster recovery strategy for 24x7 production (on premises / cloud) including backups / restores recovery procedures testing validity checks status reports and email alerts to minimize downtime. Perform systems / database tuning analysis and implement enhancements for performance optimization. Advise / work closely with development teams on DB-related issues / activities. Perform activities using best practices in compliance with IT standards / procedures and audit requirements (reliability quality security). Review / create / update test plan documents as needed. Define / review / document / adhere to maintenance procedures security standards auditing policies best practices and standards for SQL on-premises / AWS DB infrastructure. Provide 24x7 on-call support for mission-critical systems. Provide written weekly reports to supervisor on project / activity status. Prepare monthly status reports (accomplishments upcoming activities assigned projects list related issues). Attend DHCS Unit staff meetings and discuss project status. Provide expert-level database administration performance tuning and application support for a critical enterprise environment. This role will focus on AWS accounts and environments to host SQL Database EC2s. Design document and create an AWS configuration to allow centralized database monitoring and management across all of DHCS 40 AWS accounts in support of tiered applications with a database backend (e.g. AWS configurations including but not limited to Virtual Private Cloud (VPC) Security Groups EC2s RDS Database parameter groups and IAM roles). Plan create document and perform a process to migrate SQL databases to serverless cloud platforms using database conversion tools such as AWS Database Migration Services and Schema conversion tool. Collaborate with development teams to migrate SQL databases to serverless cloud platforms such as AWS RDS. Work with DHCS AWS Rubrik team to create and document backup policies and plans for applications focusing on databases. Create and document configurations for monitoring tools such as Idera CloudWatch and DataDog to monitor and alert on cloud database activities. Create document and implement a plan to monitor latency issues between on-premise and cloud connections related to database operations and make recommendations for improved performance. Create AWS server and firewall configuration requests and attend infrastructure change management meetings as necessary in support of database operations upgrades and migrations to DHCS AWS cloud. Five (5) years of FTE experience in complex technology implementations in a product-centric environment. Possess a bachelors degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for year basis. Five (5) years of FTE hands-on experience with System Administration and databases and AWS services using AWS Management Console and services including Amazon EC2 (Elastic Cloud computing) Amazon RDS (Relational Database Services) Amazon ElastiCache Amazon S3 (Simple Storage Service) Amazon Lambda Amazon VPC (Virtual Private Cloud) Web Application Firewall Identity Access Managment (IAM) Roles User Management Compute Instance Management and Cloudwatch). Five (5) years of FTE data architecture and database administration expertise on MS SQL server Postgres and AWS cloud databases. Five (5) years of FTE hands-on experience in providing solutions to optimize database performance and create performance benchmarks of the system and improve standards. Five (5) years of FTE experience with database hardening server configuration for security to ensure that databases are safe and secure against cybersecurity threats. Five (5) years of FTE experience in enforcing database security policies and audit logging mechanisms. Four (4) years of FTE experience of editing deploying and managing AWS resources using AWS CloudFormation and Terraform. Experience with Amazon cloud-native services and architecture configurations (i.e. Amazon Cognito Amazon SNS (Simple Notification Service) Amazon Kinesis Amazon Inspector Amazon Auto-scaling Amazon IAM (Identity and Access Management) Dynamo DB Amazon SQS (Simple Queue Service) AWS Athena Amazon Managed Images (AMI) and CodeCatalyst). Experience with large migration projects to cloud. Experience demonstrating strong technical and people skills to liaison between technical business and leadership teams. Possession of an AWS Database Specialty certification. The state will consider other types of certificates. Six (6) points will be given for every twelve (12) months of experience for a maximum of thirty (30) points. Experience with data replication data sharing & data modeling.
Project Task and Deliverables :
- Implement Data Dog as a monitoring solution for SQL databases and servers : Change SQL database backups from native SQL backups with maintenance plans to Rubriks backup solution in AWS using the Rubrik Agent and SLAs.
- Test and Document Rubrik Agent SQL Backup Standards : Test and document backup and restoration standards to ensure data integrity and availability.
- Secure and Encrypt SQL Production Databases at Rest : Implement and enforce database security protocols including access controls and encryption on production SQL Databases.
- Migrate SQL Databases to AWS Cloud : Migrate SQL Databases from on-premises data center to AWS cloud data center
- Standardize AWS Cloud database access configurations : Review and standardize the implementation of AWS security groups for connection to SQL for the enterprise and individual applications.
- Implement Data Dog as a monitoring solution for SQL databases and servers : Monitor resource utilization using DataDog and AWS CloudWatch and optimize resources.
- Implement DataBase monitoring for AWS Cloud data center : Implement database monitoring in AWS to monitor outages and performance issues and create alerts and dashboards.
- Document legacy Db2 jobs : Documentation of legacy Db2 administrative jobs for mainframe applications including detailed Job Control Language (JCL) and job schedules for recurring database maintenance tasks such as statistics collection reorganization and image copy operations. Supports database integrity performance optimization and compliance with operational standards.
- Perform Db2 Imagecopy Recovery and Data Integrity Analysis : Document and complete Db2 Imagecopy and Recovery procedures with validated integrity reports and documentation confirming data availability and compliance with recovery standards.
- Document JCL and job schedules for regular statistics reorganization and image copies. : Deliverable : Perform Security audits and RacF security cleanup on DB2 application databases.
Roles / Responsibilities :
General Services
Key Staff-Specific Responsibilities
Mandatory Skills :
Desirable Skills :
Key Skills
Fashion Retail,CSS,HTML,Banking & Finance,Health And Safety Management
Employment Type : Full Time
Experience : years
Vacancy : 1
[job_alerts.create_a_job]
DevOps Engineer Amazon Web Services Database Administrator • Sacramento, California, USA
[internal_linking.similar_jobs]
Aptos, "serif"; font-size : 11pt"> JOB DESCRIPTION NOTE-Candidates from the healthcare domain / industry will be given first preferenc...[show_more]
Lead Technical Product Manager - EADP - Service Platform - PCS.Degree not a dealbreaker for this role.Cloud provider, AWS certifications nice to have, not required.
Need experience working with a pl...[show_more]
The Physician Informatics Executive supports the VA's Federal EHR deployment and advances clinical informatics initiatives to improve care delivery and patient outcomes.
This position requires deep ...[show_more]
Part-time Research Study Personnel (Pay up to $790 / wk.Due to demand, we are now accepting applications for personnel to participate in our local in-person and nationwide remote research studies.Thi...[show_more]
We're hiring a Platform Engineer IV with deep expertise in Windows Administration and enterprise application support.This role supports mission-critical environments and tools like IBM FileNet and ...[show_more]
To be eligible to enlist in the U.Navy, candidates must be between the ages of 18-34.At any given moment, hundreds of complex networked computer systems are operating in tandem to keep ships and su...[show_more]
At 21st Century Home Health Services (21HHS).With more than 600 employees, we are the largest home health agency in San Francisco and the fastest-growing in the Bay Area.
Today, we care for more tha...[show_more]
A leading enterprise open-source technology provider is seeking a Principal Consultant to deliver and implement Red Hat solutions in North America.
The role encompasses both on-site and remote proje...[show_more]
Customs and Border Protection Officer (CBPO) .Customs and Border Protection (CBP) offers those interested in a career in law enforcement an exceptional opportunity to work with an elite team of...[show_more]
Description : Summary As a AWS Cloud Engineer at Gainwell, you can contribute your skills as we harness ...[show_more]
The DevOps Engineer I will specialize in the creation, testing, and implementation of Azure supporting infrastructure at Trimark.
They are the technical professional responsible for the planning, de...[show_more]
A leading global real estate firm is seeking a Senior Data Center Manager to oversee hyperscale and critical environment operations.
This remote role involves strategic leadership and mentorship, ac...[show_more]
Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.
You will help influence brand decisions on se...[show_more]
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.
We guarantee 15-25 hours per week with an hourly pay of bet...[show_more]
This position is for individuals who want to develop a side income stream while still working full time.You will test different small-scale remote opportunities, learn what works, and grow what pro...[show_more]
Physical Therapist for a travel job in Rancho Murieta, California.Job Description & Requirements.When it comes to finding the perfect locums assignment, sometimes it is all about who you know.CompH...[show_more]
Remote Opportunity : Link Posting Marketing Rep (No Experience Needed!) Are you self-driven, reliable, and ready to earn from anywhere? We’re looking for motivated individuals to jo...[show_more]
Founded in 2016, Rhombus is on a mission to make the world a safer place with our centralized platform that combines intelligent cameras, sensors, and AI analytics to help organizations improve saf...[show_more]
AWS Cloud Engineer
Apptad Inc • Gold River, CA, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
Product Manager
Sunrise Systems • Sacramento, California, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Physician Informatics Executive
Oracle • Sacramento, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Online Data Collection Specialist (Hiring Immediately)
Maxion Research • Penryn, California, US
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Senior Windows Administator / Platform Engineer IV
Hudson Manpower • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_30]
Information Technology Professional
U.S. Navy • Lincoln, CA, US
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Part Time / Weekend Physical Therapist Case Manager : Home Health
21st Century Home Health Services Inc • Lincoln, CA, United States
[job_card.part_time]
[last_updated.last_updated_30] • [promoted]
Principal Telco Consultant – Remote / On-site Delivery
Red Hat, Inc. • Sacramento, CA, United States
[filters.remote]
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Customs and Border Protection Officer
U.S. Customs and Border Protection • Penryn, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Advisor Cloud Engineer
V R Della Infotech Inc • Gold River, CA, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_variable_days]
DevOps Engineer 1
Trimark Associates • Folsom, CA, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Hyperscale Data Center Operations Leader (Remote)
Jones Lang LaSalle Incorporated • Sacramento, CA, US
[filters.remote]
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Complete Online Surveys For Cash (Up to $25 / per)
Earn Haus • Elk Grove, CA, US
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Work From Home - Online Product Support - $45 per hour
GL1 • Elk Grove, California
[filters.remote]
[job_card.part_time] +1
[last_updated.last_updated_30] • [promoted]
Remote Side Hustle Developer
Finance Buzz • Wheatland, California, US
[filters.remote]
[job_card.full_time] +1
[last_updated.last_updated_variable_days] • [promoted]
Travel Physical Therapist - $2,800 per week
CompHealth • Sloughhouse, CA, United States
[job_card.permanent]
[last_updated.last_updated_1_day] • [promoted]
Work from Home
HomeJobFinder • Wheatland, CA
[filters.remote]
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Cloud Ops Engineer
Rhombus • Sacramento, CA, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]