What are the responsibilities and job description for the C2C Onsite Job in AZ USA :: DBA/MYSQL DBA :: Phoenix, Arizona (5 Days Onsite Per Week) position at Analytics Solutions?
Job Details
Role - DBA/MYSQL DBA
Location - Phoenix, Arizona (5 Days Onsite Per Week)
Key Skills - MYSQL , Postgres and certification of Google Cloud Platform
Points to focus on :
- Strong experience in MySQL administration, Innodb cluster setup, upgrades, patching.
- Expertise is MySQL performance tuning
- Experience in Google Cloud Platform big query, spanner cloud sql
- Proficient in Shell Scripting
Contract C2C Job
Job Description
Job Roles and responsibilities:
Function as member of an agile team by contributing to software builds through consistent development practices (tools, common components, and documentation)
Participate in code reviews and automated testing
Debug basic software components and identify code defects for remediation
Enable the deployment, support, and monitoring of software across test, integration, and production environments
Automate deployments in test or production environments
Automatically scale applications based on demand projections
Architect, design, develop and maintain enterprise capabilities and systems.
Collaborate with team/s in agile environment on creating, evolving, and maintaining engineering excellence principles related to Code, Code reviews, Testing methodologies (Unit, Integration etc.,) and defect management
Developing prototypes applying visualization and other techniques to fast-track concepts.
Qualifications expected:
experience with relational database (RDBMS) administration, development, and tuning - specifically MySQL and Singlestore
experience with database support of OLTP and OLAP systems in a large dev and prod environment
experience with database development and support of Massive Parallel Processing (MPP) systems, HA and DR
experience in analytical and columnar databases and supporting multiple application teams(columnar Database like Jethro)
experience in resolving data ingestion issues, performance issues and day-to-day support
responsible for Linux Infrastructure administration , DBMS upgrades and shell scripting
experience with transforming logical data architectures into physical data designs
experience with Big Data tools, including Apache, Hadoop, Hive, and Spark distributed framework
experience with Public cloud platform (Google Cloud Platform, AWS, ..) optimization, enabling managed and serverless services
Managed MySQL 5.6, 5.7 and 8.0.35 latest versions along with Single Store and Jethro Databases
Optimized complex SQL queries
Worked on setting up MySQL High availability clusters like InnoDB cluster setup.
Developed programs by integrating SQL with shell script and Python.
Worked on Privileged Access management, Identity Management and Active Directory services on Big data Platform.
Administered, supported and monitored over 100 database systems by proactively resolving database issues and maintaining servers.
Performed capacity planning to deploy and configure database systems, develop and manage database objects.
Opened various SR tickets and other discussions with vendors to resolve critical issues/bugs.
Performed version upgrades on Jethro, SingleStore, MySQL and Yellow brick.
Managed backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application and SQL Tuning and Security Administration.
Performed Database installations, upgrades and patches for vulnerability remediation.
Clone databases from production to create working environments for development/test.
