Database Designer (Engineering)

As Database Designer (Engineering) you will be responsible forfacilitating the development of the future-state and ensuring its effective adoption. They will spend the majority of their time making application changes to improve database performance, scalability, reliability, delivering foundational database solutions and best practices for our backend engineering teams.This role will also identify enterprise business drivers, and recommend solutions for improvement by developing strategies aligning IT to the business.

MAJOR RESPONSIBILITIES:

Project Planning:

• Leads or may assist with consulting in short- and long-term project planning efforts with team members, clients and other IT groups.

• Develops cost/time estimates.

• Documents discussion and agreements.

• Participates in projects that require testing and produces metrics and samples for further analysis.

Business & Technical Requirements:

• Works with business analysts and clients to understand business needs.

• Assists with determining requirements impact on existing architecture, work processes and database systems.

• Works with impacted areas to ensure proper communication / review of requirements and integration.

Design & Development:

• Involved in analysis, design, development, and documents database systems to meet business requirements.

• Providing database expertise to engineering teams through code reviews, pairing and training to help deliver optimal database designs and queries

• Coordinates design of subsystems and integration with larger database systems.

• Translates logical data models into database designs.

• Assists in the establishment of database system flows.

• Develops and maintains enterprise data documentation and metadata models.

• Codes, edits, and installs stored procedures and functions for accessing, maintaining, and populating databases

Architecture:

• Provides input to technology planning within a functional area.

• Implements solutions consistent within the current context of the overall architecture.

Database Performance & Administration:

• Monitors utilization for capacity planning.

• Troubleshoots and resolves application (ex., SQL) performance issues.

• Monitors, analyzes database performance and calibrates DBMS parameters so that the database is tuned for optimal performance.

• Maintains development, production, and multiple testing environments.

• Performs upgrades of databases, adding new structures, schemas, tables or elements.

• Provides use of data access tools and techniques to enable information access by business users.

• Assists in the installation, configuration, and maintaining of the database management systems software.

• Implements database backup and recovery procedures.

Database Security & Support:

• Controls privileges and permissions to database users.

• Assures that appropriate information security is applied in all tasks.

• Provides production support / database access 24 hrs x 7 days a week (on a standby basis)

• Conducts Level 3 support.

• Troubleshoots databases accessibility, availability or operability problems.

• Determines the appropriate course of actions for fixing problems, identifies and mitigates risks, and implements solutions.

• Escalates/communicates issues when necessary.

• Responsible for Problem and Major Incident tickets.

Policies, Procedures, and Standards:

• Assist administrative and engineering teams to establish systems environment standards.

• May work with auditors, security groups, and data owners to make sure of governance, regulations, and compliance to policies and procedures.

• Assists with defining procedures for database access to different environments.

• Maintains database operating procedures and documentation.

RESEARCH:

• Researches and evaluates emerging technology, industry and market trends to assist in project development and/or operational support activities.

• Provides recommendations based on business relevance, appropriate timing and deployment.

TOOL SELECTION:

• Identifies the tools and components used for a project from the approved enterprise toolset.

FINANCE:

• Recommends expenditures based on the size, scope, and cost of hardware and software components.

• Assists in developing business cases

CHANGE MANAGEMENT:

• Recommends changes that impact strategic business direction.

• Supports change management initiatives.

TECHNICAL LEADERSHIP:

• Develops, motivates, and directs staff to create a team environment.

• Coaches and mentors team members.

• Recommends training programs targeting specific areas of improvement.

QUALIFICATIONS:

• Degree in Information Technology, Information Systems or equivalent discipline.

• At least 7-10 years of relevant experience in Database design/operations.

• Hands-on experience in designing/reviewing, developing/optimising/refactoring, and implementing new database schema/model that meets the business requirement with optimized DB performance.

• Specialized in DB performance tuning, and DB infrastructure capacity/ high availability planning for very large and critical database systems.

• Subject matter expert on database technologies such as MS SQL Server and some other RDBMS MySQL, PostgreSQL.

• Subject matter expert in database designs by recommending DB best practices to the application development team.

• Experience in building database projects for on-premise or cloud environments.

• Able to create complex functions, scripts, stored procedures and triggers to support application development.

• Provide database expertise to engineering teams through code reviews, pairing and training to help deliver optimal database designs and queries.

• Create and maintain architecture and systems documentation.

• Build and maintain data pipelines from internal and external databases and SaaS applications.

Good-to-have:

• Hands-on experience in cloud DB Infrastructure (AWS / MS Azure), DevOps, CI/CD deployments is an added advantage.

• Hands-on experience in NoSQL database design, development and implementation.

• Technical expertise in network, security, and application development

Example Projects:

• Identify problematic database patterns in application workloads and implement/suggest solutions.

• Implementing building blocks to efficiently load, analyze and migrate data.

• Analyzing tables and optimizing them by adding indexes, generating separate tables, or removing unnecessary columns.

• Improve application-side database load-balancing implementations.