DevOps Engineer (Amazon Web Services Database Administrator)

Sacramento, CA, US • Posted 6 hours ago • Updated 6 hours ago

Contract Independent

Contract W2

Contract Corp To Corp

On-site

CCS Global Tech

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Job Details

Skills

DevOps
UI
Information Technology
Network
Microsoft
Tier 1
Recruiting
Training
Partnership
Communication
Access Control
Encryption
Servers
Dashboard
Mainframe
Data Integrity
Documentation
JCL
Statistics
RACF
IBM DB2
Microsoft Visio
Disaster Recovery
Backup Administration
Recovery
Testing
Database Performance Tuning
Regulatory Compliance
Test Plans
Status Reports
Performance Tuning
Application Support
FOCUS
Design Documentation
AWS Database Migration Service
Collaboration
SQL
Remote Desktop Services
Backup
Change Management
SAP BASIS
System Administration
Amazon EC2
Amazon RDS
RDBMS
Amazon ElastiCache
Amazon S3
Amazon Lambda
Amazon VPC
Virtual Private Cloud
Web Applications
Firewall
Data Architecture
Database Administration
Microsoft SQL Server
PostgreSQL
Hardening
SAFE
Cyber Security
Database Security
Auditing
Editing
Management
Terraform
Amazon Kinesis
Identity Management
Amazon SQS
Migration
Cloud Computing
People Skills
Leadership
Amazon Web Services
Database
Replication
Data Modeling
Oracle Linux

Summary

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.

we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.

We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.

If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

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 Rubrik's 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

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.

Key Staff-Specific Responsibilities

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 EC2's.
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.

Mandatory Skills:

Five (5) years of FTE experience in complex technology implementations in a product-centric environment.
Possess a bachelor's 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.

Desirable Skills:

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10290999
Position Id: 2026-6749
Posted 6 hours ago

Company Info

About CCS Global Tech

Headquartered in Poway, California and eight international offices, CCS Global Tech is a Certified Minority Business Enterprise (MBE) and a leading provider of enterprise solutions. We provide solutions that cover the full business spectrum from application development, data warehouse software, real time data warehousing, business analysis software, and web-based application development. Our clients span the globe and benefit from our comprehensive support capabilities.

Our tools and technical expertise have repetitively proven to reduce the time and costs associated with software and custom solution development. CCS Global Tech begins each project with quality analysis and business due diligence in order to deliver quality solutions for our clients. Our team of international talent asks critical questions that illuminate the fine details of the project scope. Once we have a clear and comprehensive view of the objectives sought, we set to work to bring your vision to life.

We have a complementary matrix of skills and talents across multiple platforms that allow us to identify, target and bridge technical gaps. Regardless of the size and scope of your business application, data warehouse initiative, or enterprise-wide project, our team supports service, technical capabilities and cost effective solutions that are unmatched by our competition. We focus on delivering state-of-the-art technology, application development, warehousing and support to our clients. With the scope and flexibility to optimize development schedules and products to fit any budget requirements, CCS Global Tech is aptly positioned to not only meet unique, strategic IT objectives of diverse organization, but also complement organizational goals.

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.