ESSENTIAL JOB DUTIES/RESPONSIBILITIES:
- Active in all phases of system development; planning and analysis, design, development, and testing.
Install, configure, upgrade MySQL & MS SQL instances
Cloud Migration experience is a plus
Ensure performance, security, and availability of databases
Prepare documentations and specifications
Handle common database procedures, such as backup, security, recovery, BAU and reviewing code, working with developers in fine tuning the code
Profile server resource usage, optimize and tweak as necessary
Collaborate with other team members and stakeholders
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
Knowledge of monitoring tools similar to DPA (Solarwinds) & MySQL Enterprise Monitor.
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 on 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
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 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.
Other duties as assigned and modified at manager’s discretion
KNOWLEDGE, SKILLS AND ABILITIES:
Strong interpersonal and communication skills, to include listening, verbal and written skills.
Excellent time management skills and the ability to work under time pressure and handle multiple projects at a time.
Problem resolution experience requires strong analytical skills, sound judgment and ability to work effectively with client and other technical staff.
Familiar with HIPAA data guidelines and requirements for securing PHI data
Fluent in English.
EDUCATION AND EXPERIENCE CRITERIA:
Bachelor’s degree in Management Information System, Computer Science or Engineering, OR additional experience above the minimum will be considered in lieu of the required education on a year-for-year basis required
Three (3) to five (5) years of designing databases using Microsoft SQL Server and MySQL in a professional team
Necessary expertise in all facets of SQL Server Enterprise (2014 and earlier)
High Availability, Integration Services, Reporting Services, Analysis Services
Hands-on experience creating all key database objects – Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions, Dynamic SQL
Design and development of databases (SQL, MySQL, etc.), tables, distributed views, stored procedures, reports
Understanding of backup and recovery concepts and master/slave replication for both MSSQL and MySQL server
SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, MySQL Workbench
Experience with VLDBs and Reporting Data Sets, OLTP and OLAP a plus
AWS Experience preferred