Blackhawk Network - Newark, NJ
posted 3 months ago
As a Database Administrator Specialist at Steneral Consulting, you will play a crucial role in delivering high-quality database administration services to our Application Development Teams. This hybrid position, based in Newark, NJ, requires you to be within a 60-90 minute driving distance. Your primary responsibilities will include the provisioning, configuration, maintenance, and optimization of Amazon Redshift, Aurora PostgreSQL, and DocumentDB databases using Infrastructure as Code (IaC) tools such as AWS CloudFormation and Terraform. You will collaborate closely with IT teams to assess the database infrastructure, identify areas for improvement, and implement effective solutions to ensure optimal performance and reliability. In this role, you will need to have in-depth knowledge of Amazon Redshift, DocumentDB, and Aurora PostgreSQL database administration, including installation, configuration, and maintenance. Strong analytical and problem-solving skills are essential, as you will be required to diagnose and resolve complex database issues. Excellent communication and interpersonal skills are also necessary, as you will interact with internal teams to ensure smooth operations. You will be responsible for developing Infrastructure as Code for provisioning, configurations, and maintenance of the databases according to best practices and requirements. Proficiency in scripting with Python, AWS Lambda, and Step Functions is required. Additionally, you will develop and implement backup and recovery strategies to safeguard critical data and minimize downtime. Optimizing database performance through query tuning, index optimization, and database schema refinement will also be part of your responsibilities. Experience with monitoring and logging tools, particularly AWS CloudWatch, is a must. You will provide technical support and troubleshooting assistance for database-related issues and incidents, and develop and implement high availability and disaster recovery solutions. Furthermore, you will utilize CI/CD pipelines and tools like Jenkins to provision databases and develop solutions for developer self-service. Documenting database configurations, procedures, and troubleshooting steps for knowledge sharing and future reference will be essential to your role.