Vacancy caducado!
The Senior Database Reliability Engineer examines, validates, automates and tests database systems and middleware to ensure that developed products and services are scalable and reliable. This role performs advanced performance troubleshooting and configuration on the database tier. This engineer is the primary contact for the delivering performant and scalable database architectures. The Database Reliability Engineer position works in a central team of Database Engineers and Administrators supporting DBMS for DTSS development teams and customers. Primary focus will be the support of RDBMS for customer internet sites and applications including Mobile. Key responsibilities include Cloud (AWS) data migrations, upgrades, installations, optimization and tuning, scripting/programming, data loads, ETL, automation, security management(Encryption), backup and recovery, issue troubleshooting, advanced replication implementation, Disaster Recovery and High Availability designs. Additional tasks as assigned. The ideal candidate will have excellent technical expertise in relevant state of the art relational database systems, technologies, and design. Responsibilities:
- Leads and completes tasks independently, with attention to detail and while under pressure. Work with team in a collaborative environment
- Excellent judgment, problem resolution, negotiation, and decision-making skills as well as the ability to work under continual deadline pressure.
- Identifies, analyzes, and drives problems to resolution, handling complex issues simultaneously while effectively communicating across teams
- Effectively communicates technical actions and expectations to the appropriate audience
- Delivers customer service excellence by identifying appropriate technical solutions, and meeting/exceeding service expectations
- Requires strong Python skills with a database focus
- Required strong experience with at least one of the following RDBMS: MariaDB/MySQL, Oracle, SQL Server
- Solid shell(bash, powershell) scripting experience using Python
- Multiple years of experience with database automation/ETL techniques
- 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.
- Associate's Degree in Computer Science, Mathematics
- Python, database and automation are a required must.
- Bachelor's Degree Computer Science
- Participate in OrangePeople monthly team meetings, and participate in team-building efforts.
- Contribute to OrangePeople technical discussions, peer reviews, etc.
- Contribute content and collaborate via the OP-Wiki/Knowledge Base.
- Provide status reports to OP Account Management as requested.
Vacancy caducado!