What are the responsibilities and job description for the SENIOR DATABASE ENGINEER position at BAMM?
ABOUT THE POSITION:
The client is looking for a dynamic, enthusiastic Database Engineer with extensive knowledge of cloud-based databases. The role, located in Plano, Texas, will be responsible for the oversight of all the databases within the client's information technology environments, both on-prem and cloud.
KEY RESPONSIBILITIES:
- Design, implement and maintain cloud-based databases (AWS Aurora PostgreSQL & MySQL)
- Analyze existing database systems and recommend improvements.
- Build and maintain the automation scripts for the installation, management, configuration, monitoring, upgrading, and patching of data infrastructure, amongst others, all within a context of enabling self-service services.
- Assisting application development & data services teams in designing new database programs that meet the organization's data storage needs.
- Monitoring databases and related systems to ensure optimized performance & cost savings opportunities.
- Performing debugging procedures on database scripts and programs, as well as resolving conflicts.
- Mentoring database administrators and providing them with SME support.
- Adhering to best practices in securely storing, backing up, and archiving data.
- Documenting processes related to database design, configuration, and performance.
- Keeping abreast of developments and best practices in database engineering.
- Support of existing data platforms teams, as needed, and be an escalation contact.
- Work with IT Manager to establish database security structures for SOX compliance and Auditing.
- Perform and plan major version upgrades, design and implement effective monitoring of enterprise systems, and tune systems using experience and deep knowledge of area.
- Foresee risks and communicate and mitigate those before problems arise.
- Plan and manage technical projects involving other teams and communicate technology effectively to non-technical associates and management.
- Recognize and understand technology impacts within the business.
- Provide technical input to solution development plans and concept documents.
- Contribute to technical research on new technologies, processes or procedures and document technical designs and procedures for team library.
- Configure and administer Oracle & SQL Server database servers is considered a plus.
- Project management experience a plus.
- Performs additional projects/duties as assigned.
OTHER RESPONSIBILITIES:
- Interacts with the other teams within the Digital Infrastructure organization, the Spend Management Organization, Managed Infrastructure Services provider (onshore and offshore), and various contracted IT resources.
- Meets frequently with various business units and stakeholder to assess and evaluate information technology needs.
- Must be able to build relationships with technology and business teams across the company. A strong and outgoing personality is a MUST for this position.
- Interacts routinely with vendors, service providers, consultants/advisors, cloud service providers and professional organizations.
JOB REQUIREMENTS:
- Bachelor's degree in Computer Science, Information Technology, Management Information Systems, Business or related field AND 7 years of relevant experience OR an equivalent combination of education and experience.
- Experience with on-prem and cloud architectures.
- Experience with database high availability concepts and methodologies.
- Demonstrated ability troubleshooting, configuring, and administering Databases on-prem and DBaaS.
- Experience in scripting in any language, preferably python or bash.
- Demonstrated ability with automation with any tools, preferably using Ansible and Terraform.
- Demonstrated ability with GitHub/GitLab, CI/CD Pipelines, DevOps methodologies & DB Source Version Control tools such as Liquibase.
- Demonstrated ability to implement new technologies effectively and demonstrated quality and effectiveness in work documentation and organization.
- Demonstrated strong and effective verbal, written, and interpersonal communication skills.
- Experience with PostgreSQL monitoring and performance tuning tools
- Proficiency in SQL Tuning and experience with writing queries and stored procedures.
- Ability to translate complex technical information across all levels of the organization.
- Ability to multitask; team player with a focus on results and fostering a partnership with business units.
- Strong, proven problem-solving skills and ability to identify, analyze, and resolve problems, driving solutions through to completion.
- Familiarity with NoSQL Databases and Data Lake technologies is a plus.