Job title: Database Administrator
Job type: Permanent
Emp type: Full-time
Skills: PostgreSQL Oracle Linux Microsoft MySQL SQL Server
Salary type: Annual
Salary: USD $135,000.00
Location: Remote
Job published: 03/15/2022
Job ID: 32505
Contact email: kiarra@epsiworx.com

Job Description

 

Database Administrator

Responsible for monitoring and uptime of all production databases and estimating Microsoft SQL or PostgreSQL database capacities, developing methods for monitoring database capacity and usage.

Must-Have

• 3 years of experience working with PostgreSQL or Microsoft SQL Server • 3 years of experience designing and deploying PostgreSQL databases on Cloud platforms such as

AWS and Azure • Bachelor's Degree or combination of education and experience

Duties and Responsibilities

Essential Duties

• Responsible for the monitoring and uptime of all production databases • Estimate Microsoft SQL or PostgreSQL database capacities; develop methods for monitoring

database capacity and usage. • Lead efforts to develop and improve procedures for automated monitoring and proactive

intervention, reducing any needed downtime. • Set database usage standards with developers. • Manage schema updates and code-driven DB changes with developers. Participate in application

development projects and be responsible for database architecture and design. • Participate in the creation of development, staging, and production database instances and the

migration from one environment to another. • Diagnose and troubleshoot database errors.

Other Duties:

• Recommend and implement emerging database technologies. • Create and manage database reports, visualizations, and dashboards. • Recommend optimizations to existing application queries. • Provide oversight and manage MS SQL Server, AWS cloud-native RDBMS, and NoSQL DBs for

new product lines • Be a part of rotating on-call schedules. • Support complex web-based applications. • Perform other duties as assigned.

Qualifications

Required Skills

• Minimum 3 years of experience working with PostgreSQL or Microsoft SQL Server • Three years of experience as a PostgreSQL or Microsoft SQL database administrator designing

and deploying PostgreSQL databases on Cloud platforms such as AWS and Azure • Experience with AWS and Azure RDS offerings and support

 

 

• Experience with backups, restores, and recovery models • Three years of expert experience performing database performance analysis, system, and

statement SQL tuning. • Advanced knowledge of database security, backup and recovery, and performance monitoring

standards • Ability to work in the US for a Government Contractor

Desired

• Understanding of relational and dimensional data modeling • PowerShell and Unix shell scripting skills • Experience with Linux or Windows Server environments • Extensive experience with additional database technologies (MySQL, MS SQL, PostgreSQL

Oracle, MongoDB) • Have extensive AWS and Azure RDS experience • Experience with NoSQL technologies

Education

Required - Bachelor's Degree in an applicable discipline or a combination of experience and education will be considered

Desired: Advanced Degree in an applicable discipline a plus

Certification(s), Licenses Any Applicable Certifications a plus

Years of experience in a similar role Required - 3 + years Desired - 5 + years