World Wide Technology · 4 hours ago

Senior Database Administrator

United States

Contract

Remote

Senior Level

5+ years exp

Maximize your interview chances

HardwareNetwork Hardware

Comp. & Benefits

Insider Connection @World Wide Technology

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Responsible for ensuring the performance, availability, and security of clusters of Aurora instances within AWS and SQL Server on-premises

Maintain configuration of Aurora instances including replication setup, parameter settings and identification of appropriate instance types/sizes.

Ensure performance, security, and availability of SQL Server/Aurora databases.

Recommend and implement performance tuning solutions, such as indexing and partitioning

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

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

Manage on-premises SQL servers and AWS RDS SQL/Aurora instance.

Manage and administer AWS Redshift from Security, performance and backup/recovery perspective

Serve as a mentor to team members by demonstrating alternate techniques, reviewing code, and strengthening skills

Must be able to interact well with multiple priorities in an extremely dynamic environment, initiating necessary tasks and ensuring complete follow up

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL ServerMySQL-AuroraAWS RDSDatabase AdministrationQuery TuningDeadlocks ResolutionDatabase RecoveryRelational Database ConceptsNoSQLJiraGithub

Required

5+ Years’ Experience writing complex queries and understanding execution plan of the queries.

5+ Years’ Experience on Query Tunning

3+ Years’ Experience in resolving Deadlocks, Blockings after reviewing the queries and provide recommendations.

Strong proficiency in supporting, administrating, troubleshooting, and tuning of SQL Server/ MySQL - Aurora databases with a demonstrated thorough knowledge of MySQL.

AWS Databases like Aurora MySQL and DynamoDB

SQL server with high availability and disaster recovery

Database Recovery and DR

Experience with Relational database concepts and NoSQL

Experience with Jira

Experience with database build process (Github)