| Looking For MySQL Database Administrator || Irving, TX (Hybrid) || Contract at Irving, Texas, USA |
| Email: [email protected] |
|
From: dhamodharan, smartitframe [email protected] Reply to: [email protected] Hi All, Greetings from Smart IT Frame, Hope you are doing well!!! Smart IT Frame specializes in enabling you with your most critical line of resources. Whether its for permanent staffing, contract staffing, contract-to-hire or executive search, we understand the importance of delivering the most suitable talent; on time and within budget. With our Core focus in emerging technologies, we have provided global technology workforce solutions in North America, Canada & India. We take pride in delivering specialized talent, superior performance, and seamless execution to meet the challenging business needs of customers worldwide. Job Title: MySQL Database Administrator Location: Irving, TX (Hybrid) Contract Top skills required: MySQL Database administration MongoDB GCP Required Skills MySQL DB Administration, Mongo DB Administration Additional technical skills: Ansible, Terraform, AWS, Cloud SQL, GitHub, PMM Orchestrator Job Description: Installation, configuration and Database Administration, user management, Database upgrade and migration, Database performance monitoring/tuning and SQL tuning, Troubleshooting database issues. Database backup and restore, ProxySQL settings/configurations, Troubleshooting database and application performance issues. Setup/configuration of database replication and troubleshooting, Setup HA databases for Disaster recovery and failover/failback to Support DR activities, Support multiple Database environments like dev, qa, stage, beta, prod, archive, DR, HA, Setting up database monitoring, Review and deployment of database scripts(DMLs/DDLs) , Write Unix scripts and DB scripts , Refresh lower environments from prod, Provide support to incidents and create RCA , Provide on call support as per rotation cycle. Tungsten replication: Installation, setup/configuration of multi-master replication and maintenance MongoDB DBA with following skills: Build/Configure Mongo replication and sharding Implement appropriate indexes for performance improvement Perform fine-tune configurations on MongoDB and servers for performance improvement Implement optimal backup and recovery Understand and optimize query performance Create and publish database health checks to monitoring systems to identify slow queries; replication lags; node failures; index usage patterns; CPU usage; memory usage; locks; number of connections and any other relevant parameters Evaluate, plan and perform the DB upgrades Maintenance during release/outage etc. Drive best practices for backups, replication, and health checks Design and implement Disaster Recovery plans & High Availability solutions and recommendations Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any Automate the process of deploying DB changes/repetetive tasks so that we can support this for a new build/patch/hotfix. HAVE SKILLS: MySQL DBA with these skills Database setup/upgrade/migration , Backup/recovery, Query Optimization/Performance tuning FERRED/ADDED ADVANTAGE : GCP (preferred) or any cloud Skill , Automation tools (Ansible, Terraform)" Job summary 1. MySQL DBA with following skills: Installation, configuration and Database Administration, user management, Database upgrade and migration, Database performance monitoring/tuning and SQL tuning, Troubleshooting database issues. Database backup and restore, ProxySQL settings/configurations, Troubleshooting database and application performance issues. Setup/configuration of database replication and troubleshooting, Setup HA databases for Disaster recovery and failover/failback to Su 3.Experience 7to10Yrs Roles & Responsibilities . MySQL DBA with following skills: Installation, configuration and Database Administration, user management, Database upgrade and migration, Database performance monitoring/tuning and SQL tuning, Troubleshooting database issues. Database backup and restore, ProxySQL settings/configurations, Troubleshooting database and application performance issues. Setup/configuration of database replication and troubleshooting, Setup HA databases for Disaster recovery and failover/failback to Support DR activities, Support multiple Database environments like dev, qa, stage, beta, prod, archive, DR, HA, Setting up database monitoring, Review and deployment of database scripts(DMLs/DDLs) , Write Unix scripts and DB scripts , Refresh lower environments from prod, Provide support to incidents and create RCA , Provide on call support as per rotation cycle. Tungsten replication: Installation, setup/configuration of multi-master replication and maintenance 2. MongoDB DBA with following skills: Build/Configure Mongo replication and sharding Implement appropriate indexes for performance improvement Perform fine-tune configurations on MongoDB and servers for performance improvement Implement optimal backup and recovery Understand and optimize query performance Create and publish database health checks to monitoring systems to identify slow queries replication lags node failures index usage patterns CPU usage memory usage locks number of connections and any other relevant parameters Evaluate, plan and perform the DB upgrades Maintenance during release/outage etc. Drive best practices for backups, replication, and health checks Design and implement Disaster Recovery plans & High Availability solutions and recommendations Work closely with the application team to understand what changes are coming in a build/patch/hotfix, do an impact analysis, fine-tune the queries if any Keywords: quality analyst database information technology Texas |
| [email protected] View All |
| 10:33 PM 04-Oct-23 |