Senior Cloud Database Administrator

$118,976 - $118,976/Yr

Esri - State College, PA

Full-time - Mid Level

State College, PA

Professional, Scientific, and Technical Services

About the position

The position involves maintaining and administering highly-available cloud databases in a 24/7 environment. The role requires collaboration with a skilled team of database administrators and developers on multiple high-profile projects, focusing on ensuring database security, availability, and performance.

Responsibilities

• Create, maintain, and administer cloud databases in a highly-available 24/7 environment
• Ensure databases are highly secure, available, and recoverable
• Proactively monitor and tune databases for maximum performance
• Install, configure, patch, and upgrade database software
• Create documentation around impact analysis of changes
• Create performance indicators to locate and correct problems
• Handle seamless failover and recovery
• Manage monitoring and alerting for performance and uptime
• Provide database technical support for application development teams
• Oversee upgrades to application databases for new releases

Requirements

• 5+ years of experience in database administration with strong replication and high availability knowledge with MySQL/PostgreSQL
• Knowledge of NoSQL cloud databases such as AWS DynamoDB, MongoDB, Cassandra
• Ability to work in a DevOps mode
• Ability to handle multiple read instances
• Strong performance tuning skills in a large database environment serving millions of users
• Ability to run trace reports and analyze results, then recommend options for problem resolution
• Expertise in running and administrating databases in a cloud environment
• Storage and capacity planning
• Bachelor's in computer science or related field

Nice-to-haves

• Understanding of cloud computing platforms such as AWS and Azure
• Knowledge of DevOps tools such as Terraform and Puppet/Chef
• Experience with cloud database services such as SQL Azure DB and RDS Aurora/MySQL/PostgreSQL

Benefits

• Medical, dental, vision insurance for employees and their families
• 401(k) and profit-sharing programs
• Minimum accrual of 80 hours of vacation leave
• Twelve paid holidays throughout the calendar year
• Opportunities for personal and professional growth