Database Administrator

Summary

Join Simple Technology Solutions as a Database Administrator and contribute to our team's success in providing exceptional solutions to our Federal Government clients. This role requires a Bachelor's degree or equivalent experience, a minimum of 5 years of relevant experience, and the ability to obtain a Bureau of Prisons security clearance. You will be responsible for database administration, automation development, and collaboration with various teams. We offer a flexible work environment and a culture that prioritizes employee well-being. The position involves managing and maintaining databases, developing automations, and ensuring data security and performance. We are committed to equal employment opportunity and offer a supportive and collaborative work environment.

Requirements

• Bachelor's of Science Degree or Information Systems or equivalent experience is required
• US Citizenship
• Database Administrator with experience with PostgreSQL on AWS
• Experience with mission critical, complex environments, high availability and data security regulations for FISMA high environment
• Experience conducting database administration activities such as user account management, database maintenance, updates, data migration, data backups, data security, performance tuning, and upgrades as needed
• Experience with maintenance of data replication solutions
• Experience developing database automations and trusted language extensions
• Experience establishing and maintaining of security and integrity controls
• Collaborate with client technical staff, key partners, developers, product and program management
• Work in an Agile Environment and support multiple agile teams
• Manage and appropriately escalate data related, risks, issues, and challenges
• Address any issues related to database data, security and performance
• Must be able to work the hours of 8am-5pm Eastern Time regardless of your home location

Responsibilities

• Provide database administration to include but not limited to: database details, database tuning, database query performance analysis, database replication, database schema updates, database backups, database user management, and database reporting of an Amazon Aurora PostgreSQL databases
• Develop automations with Cloud Formation and Lambda to provide consistent and repeatable provisioning, deployments, replication, and reporting
• Work on administration of the Development, Training, and Production databases and support application deployments that may or may not involve schema updates throughout the environments
• Application of activity and data modeling, transaction/workflow analysis, internal control and risk analysis
• Utilize modern business methods and performance measurement techniques
• Provide technical direction to personnel performing systems analysis and system/ subsystem development tasks
• Coordinate and perform logical and physical systems design
• Review and prepare system documents and specifications
• Prepare reports, studies, and documentation, deliver presentations, and participate in meetings
• Be prepared to provide sound advice as to prioritizing projects or tasks and when to delay
• Change and Configuration Management best practices
• Enforce quality standards for engineered solutions and promote continuous improvement

Preferred Qualifications

• Experience with AWS native tools, Relational Database Service (RDS), and Amazon Aurora Global Databases
• Experience developing and maintaining infrastructure as code using AWS Cloud Formation (CFN)
• Experience developing and maintaining lambda functions written in Python
• Experience with mainframe modernization

Benefits

Flexibility to help them thrive personally and professionally