SENIOR DATABASE ENGINEER

Posted by BAMM

Dallas, TX

Permanent

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.