Database Administrator 4 (689029)

State of Georgia•Atlanta, GA

11d•Remote

About The Position

The Database Administrator 4 role provides operational support for databases from development to mission-critical production implementations in both On-Prem and AWS Cloud environments. This position involves coordinating, designing, and configuring database structures and communication links across multiple database platforms to ensure high availability and minimal downtime. The administrator will independently analyze, solve, and correct issues in real-time, providing resolution for database-related incidents and requests. Responsibilities also include implementing database performance metrics, monitoring database performance (memory, CPU), assisting developers with query tuning and schema refinement, and analyzing existing systems to recommend appropriate technologies for high availability, disaster recovery, and high performance. The role requires performing switchover and failover activities, planning and implementing database migrations from On-prem to AWS EC2, creating and managing policies for S3 buckets, analyzing archive requirements, and implementing data archival processes. Defining backup and recovery strategies using Idera SQLSafe or Native SQL Server Backup/recovery, performing full database/PTR recoveries, and ensuring proper database security standards are followed in collaboration with application owners/developers are also key duties. Additionally, the administrator will apply patches and upgrades to databases regularly for security compliance, and develop/maintain documentation on database inventory and capacity utilization. Participation in on-call rotations for after-hours support, including scheduled maintenance, application deployments, and hardware/software upgrades, is expected.

Requirements

Bachelor’s degree in computer science or related field from an accredited college or university.
A minimum of 10 years of experience in support of a MS SQL Server database management system.
Expertise in/hands-on experience working with Microsoft SQL Server 2019 (with working knowledge or previous administration of SQL 2012-SQL 2016 and Windows Server 2012+).
2+ years hands-on AWS experience, including knowledge of Amazon RDS, Amazon Migration Services, and database replication across multiple AWS regions.
Hands-on experience designing and implementing highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering, and Availability Groups.
Hands-on experience with SQL Server patching and upgrades.
Experience with developing scripts for SQL Server Backup, Integrity Check, and Index and Statistics Maintenance.

Nice To Haves

MCTS, MCITP, and/or MCDBA certifications are a plus.
AWS Certification and/or AWS Certified Database – Specialty is an advantage
Experience with Oracle 19c
Experience in database technologies like Oracle, MS SQL, and AWS DB services like RDS, Amazon Aurora, MySQL, and PostgreSQL.

Responsibilities

Provide operational support of databases from development to mission-critical production implementations in On-Prem and AWS Cloud environments.
Coordinate, design, and configure database structures and communication links across multiple database platforms to ensure high availability and minimal downtime.
Independently analyze, solve, and correct issues in real time, providing problem resolution database-related incidents and requests.
Implement database performance metrics measurements to track and analyze database growth.
Monitor the database (performance, memory, CPU) and assist developers with complex query tuning and schema refinement to increase efficiency in all systems.
Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, disaster recovery and/or high performance.
Perform switchover and failover activities.
Plan and implement homogeneous/heterogeneous migrations of databases from On-prem to AWS EC2.
Create and manage policies for S3 buckets.
Analyze archive requirements and implement data archival processes.
Define backup and recovery strategies using Idera SQLSafe or Native SQL Server Backup/recovery.
Perform Full database/PTR recoveries per application requirements.
Work with respective Application owners/developers to ensure proper database security standards are being followed.
Apply patches and upgrades on the databases in regular intervals as per the security compliance.
Develop and maintain documentation on Database inventory and Capacity Utilization of the resources.
Participate in on-call rotations. (After-hours work includes scheduled maintenance, supporting application deployment, and hardware/software upgrades).