Descripción Detallada2022-07-05T10:52:31+00:00

Título :Aurora/Postgres Database Architect

Localización :Remoto

Descripción del puesto :

 

A global financial services provider of certification, training, and learning management solutions, has an opening for an AWS Aurora Database Architect/DBA.

This position will be part of the  group, will report to the VP of Technology, and will be responsible for our database, reporting, and analytics environment, assisting in creating and implementing our data and analytics roadmap.

 

Participate in migrating our RDS/SQL Server databases to Aurora/Postgres

Working with Product Management and Technology to implement, maintain, and enhance platform databases in our AWS Cloud environment.

Support the business and operations group via data queries, data updates, and reporting activities.

Verify and enhance security and compliance governance of the Xvoucher data

ecosystem at the application, system, and environment levels.

 

Job Description

We´re looking for a database architect/DBA to participate in our RDS/MSSQL to

Aurora/Postgres migration and ongoing maintenance, enhancement, and security of the database environment.

The Aurora architect/DBA will possess strong Postgres database maintenance, administration, operations, and design experience and skills. The Aurora DBA will be responsible for ensuring the performance, availability, and security of clusters of Aurora instances within AWS. This position also requires experience with AWS RDS/MSSQL Server for the purposes of assisting with the migration of the current database environment to Aurora. Also experience in working with the tools and processes inherent to a continuous delivery environment. In addition, this position will require business support for reporting and analytics and participation in the roadmap for data analytics and services.

The successful candidate will be a seasoned database technologist with extensive knowledge and experience in supporting mission-critical, scalable systems. This role requires good communication skills, working with members of Product Management, Technology, and Business stakeholders. Successful candidates will have a comprehensive knowledge and experience with industry best practices in Postgres database maintenance, administration, and design; and a track record of providing high-quality, reliable service in a timely and effective manner.

 

Responsibilities

Working closely with DevOps and our migration partner, provision Aurora/Postgres

instances in the  AWS environment for Production and Lower environments.

Maintain configuration of Aurora instances including replication setup, parameter

settings and identification of appropriate instance types/sizes.

Ensure performance, security, and availability of Aurora databases.

Recommend and implement performance tuning solutions, such as indexing and

partitioning

Handle common database procedures, such as upgrade, backup, recovery, and

migration.

Profile server resource usage, optimize and tweak as necessary.

Monitor production Aurora database(s), identifying emerging data-related issues,

including system-level and SQL-level performance and database storage utilization,

performing tuning and initiating proactive mitigating measures as appropriate; provides data-related incident response; and coordinates with others as necessary.

Maintain Aurora database monitoring tools and alerts and develop new monitoring and alerting capabilities as needed.

Respond quickly and effectively to production issues, troubleshooting solutions, and taking responsibility for seeing those solutions through resolution. Identify root cause and corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database.

Review/deploy data-manipulation (DML) and data-definition (DDL) changes as needed.

Perform table maintenance as needed for business requirements.

Perform data cleanup in staging and production environments upon request.

Perform access management for authorized users.

Review and execute new queries as needed to support business requirements.

Perform point-in-time database restorations as needed.

Stay current and continually increase expertise in database design, maintenance, administration, monitoring, tuning, continuous deployment, and AWS technologies.

Skills and Qualifications

Strong proficiency in supporting, administrating, troubleshooting, and tuning of Postgres databases

 

Requirements

Experience in administering on-premise/cloud based multi user environments with

expertise in planning, designing, building, and implementing complex database systems.

Experience as a DBA with AWS cloud databases (Aurora/RDS PostgreSQL)

5+ years experience as a DBA with PostgreSQL

3+ years experience as a DBA with Microsoft SQL Server

Experience with migrating on-prem databases to AWS cloud (specifically to Aurora/RDS PostgreSQL)

Experience with the automated pipeline for infrastructure implementation (specifically with Cloud-formation, Ansible, python)

Experience with database day-2 support activities

Experience with mid or large-size data management

Solid knowledge of SQL and scripting

Experience working in an Agile/Scrum development process

Experience with data performance and/or security optimizations

Experience building and administering production databases

Experience interacting with customers, resolving database engine any system/ infrastructure-related issues and providing guidance on systems architecture, data model, and SQL query reviews as needed

Familiarity with Amazon Web Services and/or Cloud Computing

Familiarity with AWS Aurora and RDS

Excellent communication skills

BS degree in Computer Science, Data, or a related subject

Desired Knowledge of New Relic.