*Title:* My SQL with Aurora
*Location: * Bristol, CT
Skills: MySQL in AWS , shell scripting, data security,user
authentication,authorization.
Description:
Responsibilities
Provision AWS Aurora MySQL instances instances, both in clustered and
non-clustered
configurations
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures, such as upgrade, backup, recovery,
migration,
etc.
Profile server resource usage, optimize and tweak as necessary
Collaborate with other team members and stakeholders
Estimate MySQL database capacities; develop methods for monitoring
database
capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring
and proactive
intervention, reducing any need downtime.
Develop Stored Procedures and Database Triggers in support of application
development.
Participate in application development projects and be responsible for
the database
architecture and design.
Participate in the creation of development, staging, and production
database instances,
and the migration from one environment to another.
Responsible for developer SQL code review to ensure queries are optimized
and tuned
to perform efficiently prior to production release.
Participate in a 24×7 support rotation.
Support complex web-based applications.
Demonstrated ability with infrastructure/DB automation tools such as
GitHub, Terraform,
Ansible, or similar software.
Qualifications
5+ years of experience writing database code in MySQL databases
Experience with a code library tool such as GitHub
Experience with databases in a Linux environment
Experience with MySQL in AWS
Working knowledge of data security, and user authentication and
authorization.
5-7 years of relevant work experience.
Must have strong analytical, verbal and written communication skills.
Must have experience in Mysql database architecture, logical and physical
design,
automation, documentation, installs, shell scripting, PL/ SQL programming,
catalog
navigation, query tuning, system tuning, resource contention analysis,
backup and
recovery, standby, replication, etc.
Must have strong knowledge of Linux.
Strong understanding of command line and server administration.
Knowledge of shell scripting (e.g., Bash, Perl).
Knowledge of MySQL features, such as its event scheduler
Ability to plan resource requirements from high level specifications
Knowledge of limitations in MySQL and their workarounds in contrast to
other popular
relational databases
--
*Thanks and Regards,*
*RAYAPUREDDY HARSHA DEEPAK*
*Aqua Information Systems Inc.*
*300 N Pottstown Pike, Suite # 130*
*Exton, PA 19341*
*Direct:
215-666-6868*
*Fax:
215-600-1617*
*GTalk: HARSHA DEEPAK*