Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :-
PG :-
No of position :- ( )
Post :- 29th Jan 2021
Here is the job detail:
Job Title: MySQL Developer
Location: Remote
Duration: 12 Months +
Responsibilities:
The Database Engineer will be responsible for analyzing business requests and developing/programming
stored procedures, complex report structures, and performing database design using various database
tools, within SQL Server and MySQL. Emphasis will be placed on defining the database migration process
from the development system all the way to production as well as maintaining a secure and accurate data
environment, and ensuring proper access to Reporting Services.
ESSENTIAL JOB DUTIES/RESPONSIBILITIES:
need a senior (10+ years SQL/MySQL) MySQL Developer with in-depth experience with SQL/MySQL development/Migration experience
Active in all phases of system development; planning and analysis, design, development, and
testing.
Provides architectural/database technical expertise to team concerning methods, procedures,
and standards to be used during design and development phases.
Maintains application performance and scalability; focus on performance tuning SQL queries,
table design, indexing, query plan analysis and SQL refactoring.
Develops and maintains technical documentation and operational procedures for areas of
responsibility.
Investigates and fixes defects; pre and post-release.
Worked with DDL/DML auditing (3rd party or native tools).
Implements and maintains at rest or in-transit database encryption methodologies based of
HIPAA requirements/needs.
Prepares and deploys complex schema updates, data migration and ETL scripts.
Follows and contributes to team standards and utilizes industry best practices.
Works closely with the DBA to help ensure the proper health of the database system.
Other responsibilities may include:
Helps develop new database code, and improve existing database code.
Automates operational / maintenance tasks.
Identifies useful and new database features; discusses with the existing database team and
implements them.
Assists Engineers on efficient use of database technologies and features.
Takes code ownership of areas like loading data from external systems through SSIS,
Procedural Logic, and understanding of core relational concepts.
Modularizes database features.
Assists in performance tuning and make optimization suggestions to the team.
Takes part in code reviews and offers up solutions to problems, with reasoning to back up the
proposed solution.