Database Engineer architects, develops, implements and manages complex databases supporting business needs on a global basis. The incumbent operates independently on most assignments, under general guidelines and objectives.
Job Responsibilities:
Works and partners with Program Developers, Agile Program Manager (APM) and Digital Product Managers (DPM), developing, deploying and maintaining database solutions utilizing various database technologies.
Performs database object development and promotion to support program initiatives.
Performs regular performance monitoring and analysis.
Completes database scripting and or programming tasks using various languages.
Responsible for database backups and restores along with masking of NPI data. Ensures database security
Captures system specifications and translates them into database artifacts. These typically include design specifications, source code DML DDL development and utilization of extended RDBMS product features.
Collaborates with senior database peers and programs to ensure standards are kept in accordance with database architecture principles and modeling best practices.
Maintains schema design utilizing data models and standardized scripting methods. Builds database objects derived from modeling. Programs objects such as procedures, functions, and triggers to meet application objectives and application performance.
Collaborates with developers and end users to ensure that all database DDL, DML is tested adequately. Communicates any identified issues to developers and senior database engineers. Works with ATS to resolve related tasks.
Tracks and communicates issues to senior peers and APM/DPM for assistance with resolution.
Deploys methods to streamline existing processes
Documents new or existing processes.
High proficiency in the theoretical/ practical application of database best practices, methods, & techniques
Extensive experience in administering, developing and maintaining databases in one or more of the following database technologies. SQL Server, DB2 UDB, MongoDB, Snowflake
Broad knowledge of database development, monitoring, and management related tools, solarwinds preferred.
Strong modeling, schema design, scripting and programming skills. Erwin preferred.
Broad knowledge of database technology trends and database technology areas.
Excellent interpersonal & communication skills with a teamwork focus. Good tasks management abilities with an attention to detail. Is customer service oriented and operates with a sense of urgency to maintain expected service levels. Excellent analytical and problem solving abilities
Working Conditions/Environment & Physical Demands:
- Normal office environment
- May require 24 hour on call availability.
- May require flexible hours to interact in different time zones
Disclaimer
Incumbent may be asked
to perform other duties as required.
- Required knowledge & skills would typically be acquired through a Bachelor’s degree in computer science or related field with 2 - 4 years of related experience OR Master’s degree in computer science or related field with 0 – 2 years of related experience.