6+ months

Open for C2C, 1099, W2

Location: Remote

This position is looking for a highly motivated individual DBA with strong decision-making capability that addresses complex issues. You will also be learning new and exciting AWS processes as we embrace our journey to the cloud.  In addition, you will learn additional database platforms which will expand your skills in database administration, performance tuning, and Cloud Computing.

Duties

• Assist in daily administration activities including setup, configuration, and monitoring of databases to ensure backups, availability and performance are all maintained to the highest standards.

• Monitor and work the JIRA ticket queue for requests to make schema changes, and security changes, execute scripts against the databases, and refresh non-production databases.

• Advise application development and support teams on process bottlenecks and provide database tuning to ensure optimal performance.

• Assist the support staff to troubleshoot SQL and any other database errors.

• Provide on-call support for the Oracle, Microsoft SQL Server and Aurora (MySQL/PostgreSQL) production and non-production databases.

• Report weekly to management about abnormalities and critical issues; provide root cause analysis and recommendations; work with infrastructure team, application team, and/or other teams for problem resolutions, following the escalation path if needed.

• Tuning, troubleshooting, and on-call production support for database environments deployed in multi-AZ AWS environments both on the EC2 and RDS/Aurora platforms.

Desired Skills:

• Deploying or migrating databases into AWS (ec2 or RDS) or any hands-on experience working with AWS or other public cloud providers a distinct advantage.

• Highly proficient in one or more of these RDBMS technologies:

• MS SQL Server

• AWS RDS/Aurora (MySQL)

• PostgreSQL

• Oracle

• Working knowledge of one or more database high availability scenarios such as:

• AWS Multi-AZ database deployments

• MS SQL Server Always on Availability Groups

• Oracle Dataguard

• Knowledge of one or more database data replication tools such as:

• MS SQL Server transactional replication

• Oracle Golden Gate

• AWS DMS/DMT

• Unix/Linux general administration skills and/or bash/python/PowerShell scripting a distinct advantage

• Knowledge of ANSI SQL Language (SELECT, INSERT, UPDATE, DELETE, JOIN, WHERE, etc…).

• Strong analytical, communication both written and verbal and quality control skills.

• Ability to manage multiple tasks with different deadlines. Detail-oriented, self-motivated, and uses sound judgment.

• A team player who works well with others.

• Desire to learn and improve your skills.