What are the responsibilities and job description for the Database Admin position at Pyramid Consulting, Inc?
Job Description
Immediate need for a talented Database Admin with experience in the Information Technology. This is a Full Time opportunity with long-term potential and is located in Celebration, FL. Please review the job description below.
Key Responsibilities:
Our client is a leading Information Technology and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
#DEL
Immediate need for a talented Database Admin with experience in the Information Technology. This is a Full Time opportunity with long-term potential and is located in Celebration, FL. Please review the job description below.
Key Responsibilities:
- Required strong experience with MariaDB/MySQL on-premise, AWS RDS(MySQL, Aurora, MariaDB), AWS EC2, MySQL and/or Oracle, and/or SQL Server
- Solid shell(bash, powershell) scripting experience (Python and Ruby a plus)
- Experience with using AWS EC2, RDS, Aurora, AWS DMS a must.
- Knowledge of different replication and clustering strategies and experience setting up replication between 2 or more hosts across Regions and DataCenters.
- Architect and implement Security Compliance across all data platforms. PCI, PII
- Experience setting up highly-available solutions for load balancing, connection pooling, and query partitioning (knowledge of change data capture implementations a plus).
- Performance tuning skills; understanding of SQL Execution Plans
- Ability to proactively identify, troubleshoot and resolve live database systems issues
- Experience with automating tasks, deployments, and patching
- Experience with monitoring database/system performance using Enterprise monitoring tools such as AppDynamics, Datadog, NewRelic
- Strategies for performant and non-impactful backup/restore of high-volume live site DB's
- SQL development experience for stored procedures/functions/extensions, ETL and OLAP data loads
- Degree in computer science/information systems, engineering or related field preferred; or a corresponding number of years' experience in technical operations or software engineering.
- 4 or more years of experience with relational database management systems with a focus on MariaDB or MySQL.
- 2-4 years' experience with configuration, troubleshooting, performance tuning, and security procedures; experience with Linux
- 2 or more years of IT operational experience supporting media, e-commerce, gaming or online businesses in a 24X7 production environment
- Expertise in relational database administration including configuration, implementation, data modeling, maintenance, redundancy/HA, security, troubleshooting/performance tuning, upgrades, database, data and server migrations, SQL.
- Expertise in configuring, implementing and supporting high availability redundancy strategies on systems including replication, clustering, log shipping, mirroring.
- Expertise in relational database design and architectural principles and methodologies
- Expertise with Disaster Recovery planning and implementation.
- Demonstrated experience with troubleshooting systems issues and effectively diagnosing problems
- Excellent Verbal and Written Communication skills at all levels of business
- Preferred Education
- Degree in computer science/information systems, engineering or related field preferred; or a corresponding number of years' experience in technical operations or software engineering.
Our client is a leading Information Technology and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.
#DEL
Recommended Skills
- 24/7 Services
- Administration
- Amazon Elastic Compute Cloud
- Amazon Relational Database Service
- Appdynamics
- Automation
Database Intern
Qorvo, Inc. -
Apopka, FL
Database Administrator
CereCore -
Titusville, FL
DATABASE ENGINEER
Phoenix Defense -
Orlando, FL