noun_529702_ccPage 1GroupPage 1Page 1Page 1
Skip to main content

Database Engineer

  • R0007244
  • Miami / South Florida — Corporate Office
  • May 31, 2019

Apply to Job

Job Description
The Database Engineer will be responsible for responsible for ensuring the performance, availability, and security of MySQL & MSSQL server instances. The Database Engineer will also be responsible for orchestrating upgrades, backups, BAU and database migration to cloud. The Engineer will also work in tandem with the other teams, preparing documentations and specifications as required.

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

Additional Job Description

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

Apply to Job