SME - Logical DBA, MySQL

Job Summary

This individual contributor is responsible for the design, configuration, build, implementation, maintenance, and performance of critical database systems, to ensure the availability and consistent performance of our corporate applications. In additional, they are responsible for ensuring adherence to IT policies and standards including security practices. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills. This position requires the individual to be able to handle large databases with high degree of complexity and non-uniformity at an enterprise corporate level.

Key Responsibilities

Performs physical database management system design and build to support application development teams with application database needs in their development lifecycle. This person will translate logical data model designs into physical designs and assist with deployment and security configuration. This individual will be the primary development database point of contact. They will serve as a liaison to database administration production support teams and serve as an escalation point for incident management for databases assigned. Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating and assigning resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks, as appropriate; and recognizing and capitalizing on improvement opportunities. Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others and managers; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback. As part of the IT Engineering job family, this position is responsible for leveraging DEVOPS, and both Waterfall and Agile practices, to design, develop, and deliver resilient, secure, multi-channel, high-volume, high-transaction, on/off-premise, cloud-based solutions. Supports the review of team deliverables. Provides some recommendations and input on options, risks, costs, and benefits for systems designs. Collaborates with team members to develop project support plans, schedules, and assignments. Translates business and functional requirements into technical specifications that support integrated and sustainable designs for designated infrastructure systems by partnering with Business Analysts to understand business needs and functional specifications. Serves as a liaison with business partners, Solutions, and enterprise architects to define and understand target strategies. Collaborates with counterparts in various IT Teams (e.g., database, operations, technical support) throughout system development and implementation. Develops and modifies solutions by identifying technical solutions to business problems. Provides consultation and technical advice on IT infrastructure planning, engineering, and architecture for assigned systems by assessing the implications of IT strategies on infrastructure capabilities. Reviews and makes changes to technical specifications and documentation. Collaborates with IT teams and key business partners to troubleshoot complex systems and provides solutions, as appropriate. Evaluates existing systems to make recommendations on resources required to maintain service levels. Evaluates new service options, identifies issues and impacts, and provides recommendations on feasibility and ROI. Collaborates with architects and software engineers to ensure functional specifications are converted into flexible, scalable, and maintainable designs. Verifies system designs adhere to company architecture standards. Drives physical database architecture design for new initiatives. Leads the implementation of assigned enterprise infrastructure systems to ensure successful deployment and operation by developing and documenting detailed standards (e.g., guidelines, processes, procedures) for the introduction and maintenance of services.

Skill Requirements

Two (2) years experience working with an IT Infrastructure Library (ITIL) framework. Two (2) years experience with other database technology such as DB2 LUW, Sybase, Teradata, Datacom, Oracle Two (2) years scripting experience using UNIX/Linux scripting languages. Two (2) years scripting experience using PowerShell scripting languages. Two (2) years experience writing technical documentation in an infrastructure development environment. One (1) years coding experience with one or more programming languages. One (1) year of work experience in a role requiring interaction with senior leadership (e.g., Director level and above) Two (2) years experience working with IT vendors. Three (4) years experience with Database Design, Engineering, Implementation and Operations Three (3) years experience with job design, Controlling and scheduling & Automation Two (2) years experience IT Service Management Process (Incidents, Change Management etc.) Two (2) years experience with Microsoft Office tools Two (2) years experience working with operating system and client/server utilities. Two (2) years experience working with configuration management software. Two (2) years experience in the design and implementation of complex middleware infrastructure solutions. Two (2) years experience working with load balancing technologies. Two (2) years of experience building technology solutions to meet corporate or industry IT Policies and regulatory requirements. Two (2) years experience in the design and implementation of complex data infrastructure solutions. One (1) year experience working on cross-functional project teams Three (3) years experience working in a large matrixed organization.

Other Requirements