Oracle & MySQL & Maria DB DBA (Database Operations Engineer) - Farmington, Connecticut
Role:
Database Operations Engineer (Oracle & MySQL & Maria DB DBA)Location:
Farmington, Connecticut (Hybrid, 1 or 2 days in a Month)Duration:
Long Term Mandatory Skills:
Shell scripting.
Design and Implementation of Oracle Databases(9i,10g,12c,19c) & MySQL(5.
7,8.
0)/MariaDB(10.
3) OS :
Windows Server 2012 to 2019, Linux(CentOS, RHEL) Advanced configuration and Troubleshooting Analysis of technical issues and permanent fix/solution Database upgrades Database Patching Implementation of RAC Implementation of ASM Implementation of Data Guard for database failover between Data centre and DR site, perform switchover /failover activities.
Troubleshooting of cluster failures, ASM disk group's failures and DR related problem etc.
Adding and resizing of ASM disk groups.
Work on issues that couldn't be resolved by L2 team.
Formulating Backup and Recovery strategies.
Database upgrades/migrations.
Install and configure Oracle enterprise manager Grid control.
Formulating Backup and Recovery strategies Physical and Logical database designing Design for CPU, memory, and storage capacity requirements.
Design security policy and audit plan Database recoveries and identifying and fixing database corruption Designing database for High Availability Designing a Strategy to Maintain and Manage Databases Work on the performance issues related to Clustering, Create logical diagrams to figure out the loop pools in the database designs and functionality.
SQL tuning and optimization Administering Basic and Advanced replication Administer a VLDB Transport data across platforms DB-Related Software Evaluation Administer 3rd Party DBA Tools Facilitate Training/Education Roles and
Responsibilities:
L3 Responsibility:
Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
Conduct SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
Work on Writing custom stored procedures, SQl queries , Powershell scripts , Linux Shell Scripts, views, and triggers based on requirements for DB maintenance and automate tasks.
Work on writing technical and RCA(Root Cause Analysis) documentation.
Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
work on performance tuning like provide suggestions to create indexes and tune stored procedures.
Troubleshoot recurring problems and fix them permanently.
Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site.
Cross-training to support SQL in terms of maintenance of physical database structures and associated hardware, network, and system configurations.
Provides hands-on technical expertise, provides senior-level technical guidance to team members.
Troubleshooting DB - Crash Database security patch application.
Manage and troubleshoot the L3 tasks independently Monitor/Manage all DB Clusters Create, Build, and up-gradation of Databases Oracle & MySQL & Maria DB DBA (Database Operations Engineer) - Farmington, Connecticut Recommended Skills Architecture Automation Backup Capacity Planning Cent Os Change Advisory Estimated Salary: $20 to $28 per hour based on qualifications.
Database Operations Engineer (Oracle & MySQL & Maria DB DBA)Location:
Farmington, Connecticut (Hybrid, 1 or 2 days in a Month)Duration:
Long Term Mandatory Skills:
Shell scripting.
Design and Implementation of Oracle Databases(9i,10g,12c,19c) & MySQL(5.
7,8.
0)/MariaDB(10.
3) OS :
Windows Server 2012 to 2019, Linux(CentOS, RHEL) Advanced configuration and Troubleshooting Analysis of technical issues and permanent fix/solution Database upgrades Database Patching Implementation of RAC Implementation of ASM Implementation of Data Guard for database failover between Data centre and DR site, perform switchover /failover activities.
Troubleshooting of cluster failures, ASM disk group's failures and DR related problem etc.
Adding and resizing of ASM disk groups.
Work on issues that couldn't be resolved by L2 team.
Formulating Backup and Recovery strategies.
Database upgrades/migrations.
Install and configure Oracle enterprise manager Grid control.
Formulating Backup and Recovery strategies Physical and Logical database designing Design for CPU, memory, and storage capacity requirements.
Design security policy and audit plan Database recoveries and identifying and fixing database corruption Designing database for High Availability Designing a Strategy to Maintain and Manage Databases Work on the performance issues related to Clustering, Create logical diagrams to figure out the loop pools in the database designs and functionality.
SQL tuning and optimization Administering Basic and Advanced replication Administer a VLDB Transport data across platforms DB-Related Software Evaluation Administer 3rd Party DBA Tools Facilitate Training/Education Roles and
Responsibilities:
L3 Responsibility:
Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
Conduct SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
Work on Writing custom stored procedures, SQl queries , Powershell scripts , Linux Shell Scripts, views, and triggers based on requirements for DB maintenance and automate tasks.
Work on writing technical and RCA(Root Cause Analysis) documentation.
Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
work on performance tuning like provide suggestions to create indexes and tune stored procedures.
Troubleshoot recurring problems and fix them permanently.
Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site.
Cross-training to support SQL in terms of maintenance of physical database structures and associated hardware, network, and system configurations.
Provides hands-on technical expertise, provides senior-level technical guidance to team members.
Troubleshooting DB - Crash Database security patch application.
Manage and troubleshoot the L3 tasks independently Monitor/Manage all DB Clusters Create, Build, and up-gradation of Databases Oracle & MySQL & Maria DB DBA (Database Operations Engineer) - Farmington, Connecticut Recommended Skills Architecture Automation Backup Capacity Planning Cent Os Change Advisory Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
