Sr Software Engineer - DBA

Summary:

The purpose of this role is to support the databases and ensure their performance, availability and security. The Data Administrator will provide timely and quality database design, development, maintenance, and problem resolution services for internal and external customers.   They will manage highly resilient corporate and cloud database infrastructure utilized by GHX DaaS/SaaS solutions. The role has a direct impact on the GHX Customer Experience in supporting customers to handle their supply chain.

Responsibilities:

The Database Engineer will work with various operational and development teams to plan, design and implement and support core database functionality that meets company initiatives with respect to performance, scalability, reliability, and adherence to operational policies and principles.  Specific responsibilities include:

• Administration and management of GHX databases, including:
  • Backup and recovery
  • Monitoring of data database capacity and performance
  • Security and data access management
  • Installations, upgrades, and patching
  • Fail over server management
• Development and engineering of GHX databases (in collaboration with architects and software developers), including:
• Performance tuning
• Logical to physical data model implementation
• Release Management/Continuous Integration
• Reporting and metrics development, analysis and presentation
• Safeguard the company's data, tools and information systems by adhering to Operational and Security policies and procedures throughout lifecycle of service delivery.
• 24/7 monitoring, on-call support and troubleshooting database issues, provide operational feedback to development and release teams.
• Evaluating and recommending upgrades and new database tools and technologies as appropriate for the enterprise.
• Provide guidance and assistance to junior database engineers
• Implement and maintain automated processes using standardized shell scripting tools.
• Develop database engineering standards and practices for the secure operation of databases between our cloud environment, customer environments and third party IaaS vendors/provider.

Qualifications:

• IT education (a bachelor's degree in computer science, Information Technology, or a related field) or equivalent experience
• 8-10+ years of experience in database management.
• Certifications (ie AWS, Azure, Microsoft, Oracle).
• In depth knowledge of two RDBMS and/or NoSQL platforms (ie Oracle, MSSQL, PostgreSQL, MySQL, MongoDB, ElasticSearch) with familiarity and the ability to support additional platforms at a basic level
• Demonstrated practical implementations of hybrid and public cloud deployments
• Exposure to Data Warehouses, Data Lakes, Big Data, ETL/OLTP/OLAP, MDM, AI, ML
• Leading and mentoring a support organization involved in implementation projects
• Proven ability to manage databases in a high transaction/high availability environment
• Proficient in wait-based performance tuning techniques, with the ability to identify, analyze, and optimize database performance by addressing specific wait events (e.g., I/O waits, lock waits, network waits)
• Experience with horizontal scaling and high availability technologies/concepts (ie Oracle RAC & Dataguard, SQL Server ‘Always On’ & Availability Groups, MongoDB Replicaion & Sharding, AWS Regions & Availability Zones)
• Hands on experience with UNIX, Linux, or Windows operating systems in a physical and/or virtual environment
• Experience working with project managers/scrum masters to implement new projects and resolve issues
• Liaising directly with customers of an IT organization
• Exposure to ITIL / ITSM / Managed Services / DevOps / SOA operational models
• Very strong ANSI SQL (PL/SQL, T-SQL) development skills
• Knowledge of higher-level languages (Java, C++, Python)

Competencies:

• Good analytical troubleshooting skills and a positive pragmatic approach
• Self-Motivated
• Attention to detail
• Excellent communication skills
• Team player who lives our Company Values (Collaborate, Innovate, Inspire and Grow)
• Fluent in English
• Willingness to travel