SENIOR DATABASE ENGINEER

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.