Open Priority Position : AWS DBA Requirement (Remote)
Sanyam Kumar
Location: Durham, NC. Zip code: 27709 Raleigh (Remote)
Note: we need folks who are predominantly with DBA / SQL expertise on AWS domain
Best way to reach me : sany...@alphasilicon.us
Scope
Maintain a standard, reusable and effective Database Operations which include but are not limited to Discovery, Analysis, Review of misconfiguration/ performance / scalability issues, and Development of fixes, Recommending Solutions and Best-Practices, Acceleration of feedback and solution delivery through analysis, identification, addressing systemic root cause(s) to avoid or eliminate anti-patterns or other code-smells
Key Deliverables-Cloud Ops Database Administration
- Disaster recovery: Ensure that geo-replicated backups and geo[1]redundant database system clusters are set up and configured as needed. Recover the database cluster in an unlikely event while ensuring SLAs are met
Backup, recovery, and validation: Shared responsibility in the cloud. The vendor will handle configuration and execution tasks, while the DBA is responsible for adjusting the backup routines and schedule to meet application needs and validation
Monitoring: Enabling monitoring of critical DB indicators such as CPU and memory utilization, disk I/O, Long run SQLs, DB Health, Database events, Deadlocks etc. Make use of Performance Insights, Enhanced Monitoring, CloudWatch to get insights on the DB activity. Act when these events occur
Performance Tuning: Tune DB engine parameters to meet Application Use Case and yield maximum performance. Fine tuning DB schema and queries to minimize query time. Table defragmentation, re-indexing and modifying database structure, etc
Prod Data Fix: Fixing inconsistency in Production databases causing application outage/performance degradation. Database Availability: Ensuring cluster is set for automatic failover and can handle an AZ failure.
System patching and maintenance: Regular maintenance as needed for critical security and system availability updates as planned on or before the deadline date of Releases.
System provisioning: Provisioning database system and allocate compute, memory, and storage resources to workloads.
Capacity planning: Continuous collaboration with application development and end users to forecast system usage and resource requirements. Adjust the cloud service tiers to accommodate required capacity growth.
Debugging: Collaborates with application development to identify/reproduce and remediate issues in lower environments, and then promote to production.
Automation: Working with infrastructure-as-code; Terraform and/or CloudFormation as applicable to the application.
Recommendations: DBA recommends areas where applications can improve their implementations to avoid or eliminate anti-patterns which are the root cause of systemic/underlying issues.
Key Deliverables-Cloud Ops Infrastructure Defect Remediation
- Backlog Assignment: Receive defect remediation request by Cisco product owner through Jira board(s) and/or CDETS (Cisco Defect Tracking System)
Discovery: Engage with CPXE teams to understand the requirements; engage with cross-functional teams to understand impacts, dependencies, and functional requirements; define timelines and acceptance criteria in Jira board(s) and/or CDETS.
Analysis: Analyze requirements and document the functional solution/design
Solution review: Supplier will obtain sign off from CPXE CloudOps teams for the proposed solution upon review
Development: Complete the design and develop the solution to effect defect remediation (supplier manages the solution execution while Cisco is responsible for implementation into its environments via an internal change management process)
Solution validation (acceptance): Supplier to complete validation by having the Cisco Product owner review and accept the implementation work for defect remediation. If any additional documentation or materials are developed with the defect remediation, such as solution documentation, knowledge transfer or training materials will be reviewed with Cisco for acceptance during this step
Updates: Update the status of the request in the Jira board(s) and/or CDETS and attach applicable enclosures, viz. logs, comments, documentation
Prepare for next request submitted through Jira board(s) and/or CDETS
DBs in scope
- AWS Aurora
- AWS RDS
- AWS Redshift
- AWS Dynamos DB
|
Connect us on Linkedin |
|