Job Description :
MySQL Database Engineer (DevOps)
Job #:19-00033
Position Type:Right to Hire
Location:Shelton , CT
Job Description
Must thrive on working with all aspects of MySQL, Microsoft SQL Server and Mongo database development and support in a cloud/3 tier/customer hosted enterprise application environment.
At least 4 years of professional experience working with software development engineering groups as well as in production support environments.
The expectation is for this position to function within a DevOps culture providing in-depth database experience, working with latest versions of MySQL, SQL Server (MSSQL) and/or Mongo and cloud technologies. You must be able to see opportunities where others see challenges.
Build. Deploy. Bridge. Grow.
You will be part of the E-commerce Database team.
Responsibilities
Plan and conduct structured testing of database designs to confirm functionality and performance, optimize and tune database schemas, stored procedures, triggers, dynamic queries, and work with developers to implement complete solutions.
Develop and maintain database integrity, security, HA, DR planning.
Design and implement DB deployment automation and automation of routine DB administration tasks using DevOps automation technologies.
Experience with AWS technical essentials such as RDS, EC2, S3, security and networking.
Translate business and product requirements into system requirements, work closely with PM, SME, developers to design, implement database sub systems.
Actively participate in the requirements specification process with project teams to help define technical requirements, scope, and limitations.
Maintain and implement database change control, release process for all production and non-production environments.
Provide innovative leadership for ongoing daily and monthly activities including database maintenance, performance tuning, parameter tuning
Plan and implement ongoing monthly and quarterly maintenance activities including patching cycles, upgrade cycles, security and auditing cycles
Perform daily database administration tasks including monitoring, troubleshooting, and remediation activities
Ability to work in a in a global team, interacting/coordinating with colleagues across the world to ensure highest levels of service. Must be willing to assume on-call support as needed on off business hours and weekends.
Communicate clearly in coordinating with infra IT teams and support groups to troubleshoot and resolve database issues and escalations, or to perform builds and deployments.
Maintaining and contributing to internal team-knowledge documents/runbooks and SMTD and DB development based on policies, guidelines and standards.
Qualifications
A candidate must be a self-motivated, great team player, able to work independently, and willing and able to align with project management's priorities.
Extensive background with Linux/AWS MySQL 5.6 and/or SQL Server 2012-2017
4 years DBA/DBE experience in the following areas:
Design and administrating MySQL design, implementation, migration, maintenance, and high-availability/disaster recovery operations
Administering MSSQL Active-Active, Active-Passive Cluster, Peer to peer replication, transactional replication and/or online reorg/reindexing.
Knowledge of internal structure of indexes, statistics and system information schemas.
Proficient in performance tuning and optimization using native monitoring and troubleshooting tools.
Experience with large database batch jobs, data transformations, T-SQL, stored procedures, triggers, database partitioning, log shipping, SSIS, and data encryption.
Performance tuning using MSSQL database partitioning, both instance and SQL statement level tuning and/or ability to setup oracle partitioning
On online / offline reorg / re-indexing, Database backups, restores / recovery
HA and DR including Log shipping, mirroring and Always-On technologies, with emphasis on work experience with Windows OS
Using backup/recovery tools
SQL mail experience, including setting up and scripting alerts
Experience with source control systems, database versioning and release processes.
Excellent analytical and problem solving skills.
Strong verbal and written communication skills with ability to clearly articulating.
Preferred/optional qualifications
Database schema design experience, and very knowledgeable in database design/implementation best practices
3 years' experience in Mongo 2.6 and above database including replica set knowledge
Setting up authentication and encryption on Mongo database
Working experience on Linux and shell scripting
Monitoring, backup, restore and DR experience
AWS certification is a plus.
.Net, C# and Java programming languages is a plus.