Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

MY SQL DBA

Expired Job

US IT Solution Folsom , CA 95630

Posted 2 months ago

Hi,

Please help me with the below role, Very URGENT

Client - Power School Group

Location: Folsom, CA

Length: 6 months

More of a DBA than just an Admin. Client is Power School Group in Folsom, Ca.

Really need someone who can interview in person..but will take someone who can interview over phone or even SKYPE. Good communication skills are a must.

JD-

Need someone asap.

MySQL Administration and Maintenance

Plan, design, deploy database systems, including base definition, structure, documentation, requirements gathering, preparing operational guidelines, and securing data.
Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation
Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure
Act as liaison with customers on all new MySQL based projects
Validate designed applications
Analyze and determine information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities
Research and evaluate alternatives and recommend solutions for business issues
Engineer and create ad-hoc reports utilizing various data sources
Maintain current knowledge of relevant technologies
Participate in all major application/database enhancements and fine tune the systems for optimal performance

Responsibilities:

Install, configure, and maintain MySQL multi-level Master-Slave replication
Install, configure, and maintain MYSQL Multimaster Group and Galera replication
Optimize and tune MySQL database performance
Continually improve monitoring, perform database capacity and usage planning
Write and maintain scripts to automate routine DB tasks
Troubleshoot database-related application performance issues
Ensure security and data integrity of all MySQL instances
Perform routine, periodic and proactive DB maintenance
Provide on-call support of MySQL databases
Implement tools to automate database operation and monitoring
Implement database Backup and Monitoring solutions
Test restore(master), recovery(point-in-time), replication
Test cluster/multi-master failover and disaster recovery
Implement, document and maintain database roles and security
Research and evaluate alternatives and recommend solutions for business issues
Create capacity planning reports based on historical data trends and projected data growth
Maintain current knowledge of relevant technologies

Qualifications
3-5+ years of experience in administering MySQL database, replication, tuning, backup and recovery
Experience with MySQL Group replication and Galera replication is a plus
Must be highly proficient in backup, recovery, replication, performance tuning, and proactive monitoring
Strong Expertise in building, maintaining, supporting, troubleshooting, tuning, and monitoring production MySQL database servers
Strong Knowledge with database architecture design, including data partitioning and application partitioning is a plus
Solid Team player with a positive attitude and team spirit can work alone and with others
Ability to mentor team members.
Communicates well (oral and written) with customers and management
Degree in Computer Science or equivalent



See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Devops Hosting Manager

Powerschool

Posted 4 days ago

VIEW JOBS 11/13/2018 12:00:00 AM 2019-02-11T00:00 Responsibilities: * Lead, instruct, support and coach individual team members to create and maintain an innovative, friendly and challenging work environment * Implement a culture of personal development and growth amongst personnel * Analyze issues occurring on any owned system as well as performing CI/CD tasks locally * Orchestrate the provisioning, load balancing, dynamic configuration, monitoring and spend optimization of application stack in alignment with modern cloud platforms (Azure and AWS). * Define, implement and maintain information security best practices for all production systems that run our custom applications * Define and automate release train pipelines and environments, build resilient systems and create repeatable (automated) processes. * Responsible for the development and implementation of infrastructure as code (IAC). * Responsible for further development and improving the operation of our established CI/CD pipeline. * Define long term operations strategy leveraging cutting edge technologies. * Partner with operations teams and solve ongoing technical issues with automation tools * Build and implement tooling to perform automated synthetic monitors to perform health checks on our web-based application stack. * Partner with Engineering teams and develop setups to that quality gates are reached with high maturity levels. Requirements/Qualifications: * Experience managing a team with remote members; including hiring, retaining, managing performance and developing skill set of direct reports * Experience in collaborating with engineer and QA teams supporting high volume web applications * Previous Technology team management experience, especially in automation * 5+ years of experience scaling large web applications * Strong background with AWS or Azure cloud technologies * Scripting skills (Node.js, Python, Ruby, Perl, etc.) * Configuration management and automation experience (Ansible, Chef, or Puppet preferred) * Continuous integration (Jenkins or CircleCI preferred) * Cloud Monitoring tools (Nagios, Cacti, CloudWatch, Gnaglia, etc.) * Log management tools (Splunk, ELK experience a plus) * NoSQL and SQL databases (DynamoDB, Aurora, Redshift, MySQL, etc.) * An understanding of AWS Lambda, AWS API Gateway, and serverless technologies * Containerized deployment such as Kubernetes or Docker * History of building productive and successful Dev/IT teams and developing talent Powerschool Folsom CA

MY SQL DBA

Expired Job

US IT Solution