Job Details

Job Overview

Provide functional and/or technical expertise to plan, analyze, define and support the delivery of future functional and technical capabilities for an application or group of applications. Assist in facilitating impact assessment efforts and in producing and reviewing estimates for client work requests.

Database Administration

Administer over 30 AWS RDS databases running Oracle, PostgreSQL, MSFT SQL Server, and MySQL in multiple AWS accounts. Perform many related database functions across one or more teams or clients, including account management, AWS Data Migration Services (DMS) design and implementation for inter-database synchronization, backup/recovery, disaster recovery testing, and configuration management. Manage database management systems (DBMS) on AWS and provide input for modification of procedures and documentation used for problem resolution and day-to-day maintenance.

Advanced AWS RDS Experience

• Deploying multi-AZ RDS systems with high performance
• Performance tuning with AWS Performance Insights
• Integrating Oracle Enterprise Manager for performance monitoring
• Designing AWS Data Migration Services jobs for data synch between databases
• Database Encryption at rest and in transit
• Configuring the parameter groups
• Managing IP traffic using a security group
• Auditing the database log files
• Maintenance and management activities
• Planning backup and recovery strategies
• User management
• Monitoring the database

Skills

• Relational Database Management System (RDBMS)
• AWS Relational Database Service (RDS)
• Oracle Database Administration
• PostgreSQL Administration
• AWS Database Migration Service (DMS)