At MercuryGate, every solution we create is designed to be Smarter, Faster and Better than any other technology in the marketplace. These same attributes apply to our dedicated team members, whose expertise have made MercuryGate an industry leader in transportation management systems.
Our company is searching for an experienced and hands-on Senior Cloud Database Engineer to join our talented team. Your central responsibility in this role will be to create, manage, and optimize database systems within MercuryGate's SaaS Enterprise. In this role you will be responsible for the creation of new database systems, database migrations to the public cloud, as well as proactive and reactive tuning and optimization of new and existing database systems.
This is an exciting opportunity to assist us in our goal of migrating our full SaaS solutions to the public cloud! You will also support our second phase application refactoring and migration away from Oracle.
This opportunity can be 100% remote.
- Provide production support, solutions and expertise for hybrid and Cloud deployed Database Platforms
- Ability to troubleshoot difficult issues quickly, deliver RCA and resolve in a 24x7 production environment
- Build new DB servers, monitor backups, perform archive restores
- Data refreshes from production to other environments such as QA/UAT
- Database performance diagnostics and application query tuning
- Database major version upgrades and database migrations to AWS (staging, preparing,tuning and executing) using GoldenGate
- Participating in the planning and executions cloud migration project milestones
- Evaluating and advising our development organization on application schema changes
- Design and implement effective database solutions and models to store and retrieve company data
- Examine and identify database structural necessities by evaluating client operations, applications, and programming
- Assess database implementation procedures to ensure they comply with internal and external regulations
- Oversee the migration of data from legacy systems to new solutions
- Monitor the system performance by performing regular tests, troubleshooting, and integrating new features
- Recommend solutions to improve new and existing database systems
- Educate staff members through training, individual support, and document creation
Requirements
- Bachelor’s degree in Computer Science, Computer Engineering, or relevant field
- Expertise in Oracle as well as deploying database solutions in public cloud space like AWS, Azure, GCP
- 5+ years developing critical platform infrastructure
- 3+ years of production experience supporting cloud database platforms
- Oracle OEM, RAC, 12c, 18c, 19c, ASM, Data Guard, Golden Gate
- Expertise in Oracle and cloud-based Database solutions
- Experience with cloud migrations\transformations
- Experience with running databases on the Linux OS
- Experienced managing databases at scale (100s of databases)
- Expertise in shell scripting
- Experience in providing Database Architecture guidance
- Experience in database recovery processes
- Experience using tools to automate database tasks, Infrastructure as code, CI/CD
- Experienced in performance tuning
- Excellent organizational and analytical abilities.
- Outstanding problem solver
- Ability to work off hours/weekends as required for maintenance
Nice to Have:
- Python or Java programming experience
- Experience running Oracle on Windows OS
- AWS certification(s)
Benefits
At MercuryGate, we not only value what you do for the organization, we also value your happiness, health, and time!
- Flexible Time Off (take what you need, when you need it), additional paid time off for Bereavement, Jury Duty, Community Service and 8 paid Holidays
- 401(k) company match - Traditional and Roth 401(k) options administered by Fidelity Investments; enrollment starts on your first day
- Choice of medical plans with Cigna, coverage beginning the first day of employment
- Health Savings Account (HSA)
- Dental, Vision, Life and Accidental Death amp; Dismemberment Coverage, Short Term Disability, Long Term Disability
- Supplemental benefits including Voluntary Life Insurance, ADamp;D, Identity Theft, and Group Accident amp; Specified Disease